Revenue account determination
14 likes8,005 views
1) Revenue account determination integrates sales (SD) and financial (FI) accounting by determining the appropriate revenue accounts during billing based on configuration. 2) The configuration is done using condition techniques to define account determination tables based on fields like sales organization, distribution channel, account assignment group, and account key. Access sequences and account determination types are also defined. 3) An account determination procedure is assigned to billing types which uses the defined tables and keys to determine the correct revenue account during invoice creation in FI.
Revenue account determination
- 1. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 1 Revenue Account Determination is integration between SD and FI. The integration between FI- SD happens through Account determination. It is at the time of billing when the actual integration will reflect from SD to FI. Once the billing is done the invoice is automatically created in FI (Doc.type is RV). Configuration Steps: Revenue Account Determination is configured based on condition technique. Path:SPRO > S&D > Basic Functions> Account assignment/Costing > Revenue Account Determination As seen in the above screen shot we have 6 configuration steps to configure Revenue Account Determination. 1. Check Master Data Relevant For Account Assignment:
- 2. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 2 As seen in the screen shot check master data relevant for account assignment we have 2 activities to perform i.e. material account assignment groups and customers account assignment groups. First double click on materials account assignment groups. Double click on customer account assignment groups These account assignment groups even we can maintain in master data itself if we want. And these account assignment groups are pre-requisites to configure account assignment group. 2. Define dependencies of Revenue Account Determination:
- 3. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 3 Well try to create new conditions tables for our practice purpose. If we want we can use the standard ones which are given by SAP. Double click on Account determination: Create tables The user defined table number should be 500 and above. Give Table number above 500. Up to 500 is used by the SAP Give table number 620 and press enter. It will take field selection screen where we need to select the field combination we want.
- 4. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 4 Afterselectingfieldsclickongenerate icon .Thenitwill aswhetherto generate the table, click on yes and save in local object. The tables which we have defined are: 620: Sales org. /Distr. Chl/AcctAssgGr/AcctAsgnmt/Acct key 621: Sales org./Plant/Acct key Afterdefiningthe tablesinnextstepwe are goingtodefine accesssequence andaccountdetermination types. 3. Define Access Sequence and Account Determination Types: Double click on Maintain access sequences for account determination. Go to new entries and maintain access sequence. In our case it is SOFI. Select defined access sequencesanddouble clickonaccesses.Here we are going to maintain the tables which we defined in previous step.
- 5. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 5 Aftermaintainingthe tablesclick on each table and double click on Fields for doing field assignment and save. All accesssequencesare savedinworkbenchrequest.Workbenchrequestare nothingbutcrossclient.If we save in one client it will be saved across all clients. Double clickonDefine accountdeterminationtypes,clickonnew entries and maintain condition types. Afterdefiningconditiontypes,Inthe nextstepwe are goingtodefine and assignaccountdetermination procedure.
- 6. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 6 4. Define and Assign Account Determination Procedure: Double click on Define account determination procedure, click on new entries and maintain Account determination procedure. Select our Account determination procedure and double click on control data and maintain the assign the condition table.
- 7. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 7 Q. How system knows whether the condition type is with controlling or without controlling? A. Systemidentifiesbasedonthe requirement field. If requirement is 3 then it is without controlling and if the requirement is 2 then it is with controlling. After defining account determination procedure it should be assigned to the billing type. Double clickonassignaccount determinationprocedure andassignAccount determinationprocedureto the billing type.
- 8. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 8 5. Define and Assign Account Keys: If we want to maintain new account keys, double click on define account key. Well use account keys which are provided by the SAP. Andto assignthe account keys,double clickonassignaccountkeysandselectourpricingprocedure and assign the account keys to the respective condition types.
- 9. REVENUE ACCOUNT DETERMINATION By Srinivasulu Algaskhanpet (Sr. SAP SD Consultant) Page 9 After assigning Account keys to respective conditions types, assign G/L accounts. 6. Assign G/L Accounts: Click on Assign G/L Accounts. The Screen system displays is: Double click on the table combination for which we want to assign G/L accounts. System will to us to next screen where we need to assign G/L accounts to the combination of: Application + CType + Chart of Accounts + Sales Orgzn + Dch + AccKey