Download Automatic Account Assignment in SAP: Configuring Valuation and Account Determination and more Cheat Sheet Accounting in PDF only on Docsity!
Assignment
One of the advantages of an integrated system like SAP is that the system can be configured so that when a goods movement is recorded for production planning or materials management (PP/MM) purposes, the R/3 system will automatically determine the correct G/L account to post to using the type of transaction and other factors. Automatic account determination is also referred to as automatic posting and automatic account determination in the SAP R/3 system.
To configure the SAP system to make the automatic accounting postings, valuation control must be set to active. To verify this ( don’t change it! ), follow the menu path:
Materials Management Valuation and Account Assignment Account Determination Account Determination without Wizard Define Valuation Control (click clock icon )
Which will give you the following screen:
Note that the Valuation grouping code is active.
1 Create and Assign Valuation Grouping Code to Company Code
Next, we need to create a valuation grouping code for your company code. It is possible to use the same rules for account determination for different valuation areas (e.g. plants). That means that you can define the same automatic account determination rules for multiple plants. As you only have one plant in University Cellular, you will be creating a grouping code and assigning your plant to that grouping code. Follow the menu path:
Valuation grouping code active
Assignment
Materials Management Valuation and Account Assignment Account Determination Account Determination without Wizard Group Together Valuation Areas (click clock icon )
Which will produce the following screen:
Find your valuation area, which is your plant number ( ##CP ) and enter the valuation grouping
code ##VP. Click on the save icon ( ) to save this assignment.
Enter Val. grpg. Code ##VP for your valuation area (plant, ##CP)
Assignment
Double-click on the entry BSX (Inventory posting), which will produce the following pop-up window:
Enter CHFS for the Chart of accounts, then click the continue icon ( ), which will produce
the following window:
Enter CHFS for Chart of Accounts
Double-click on entry BSX
Assignment
Make the following entries:
Valuation modif.
Valuation class Account ##VP 3000 200000 ##VP 7900 200100 ##VP 7920 200200
When you have made all the entries, click on the save icon ( ), then on the back icon ( )
to return to the Maintain FI Configuration: Automatic Posting - Procedures screen.
Enter Information shown in the table below
Assignment
##VP VBR 7900 720100
##VP VBR 7920 720200
##VP ZOB 7920 720200
When you have made all the entries, click on the save icon ( ), then on the back icon ( )
to return to the Maintain FI Configuration: Automatic Posting - Procedures screen.
4 Establish Automatic Postings for Cost/Price Difference (PRD)
From the Maintain FI Configuration: Automatic Posting – Procedures screen, scroll until you find the entry PRD. Double click on this entry and enter CHFS for chart of accounts if requested to bring up the following screen:
Make entries in this screen as noted in the table below:
Make entries as indicated in the table below
Assignment
Valuation modif.
Valuation class Account ##VP 3000 760000 ##VP 7900 760100 ##VP 7920 760100
When you have made all the entries, click on the save icon ( ), then on the back icon ( )
to return to the Maintain FI Configuration: Automatic Posting - Procedures screen.
Assignment
Valuation modif.
Valuation class Account ##VP 3000 310000 ##VP 7900 310000 ##VP 7920 310000
Click on the save icon ( ), then on the exit icon ( ) until you return to the SAP Reference
IMG.
Make entries as indicated in the table below
Assignment
7 Configure price change in previous period/previous year
From help.sap.com:
In the case of a price change in the previous period or in the previous year, you must define whether the change also applies to the current period. You have two options:
The price change applies only in the previous period or previous year and does not affect the current period.
The price change also applies to the current period; the price in the current period is thus also changed automatically. If you want price changes in the previous period or previous year to also change the price in the current period, select column V.
We will set our system up so price changes carry over. This setting would make it easier to administer the system, as we wouldn’t have to worry about updating all material prices each year. To set this up, follow the menu path:
Materials Management Valuation and Account Assignment Configure Price Change in Previous Period (click clock icon )
which will bring up the following screen:
Assignment
8 Default values for invoice verification
This exercise defines the default tax codes used in invoice verification. To do this, follow the menu path:
Materials Management Logistics Invoice Verification Incoming Invoice Maintain Default Values for Tax Codes (click clock icon )
which will produce the following screen:
Click on the New entries icon ( ), which will produce the following screen:
Click on New Entries
Assignment
Enter the following information:
Company code: ##UC Tax code: XI Jurisdiction code: MI0000000 (seven 0’s)
then click on the save icon ( ) to save your entry. Click on the back icon ( ) and confirm
that your company code is now listed, then click on the back icon ( ) again to return to the
SAP Reference IMG.
9 Update Posting Keys for Invoice Verification
Next, we have to update the posting keys used in the invoice verification process. To do this, we have to follow the pulldown menu path:
System Services Table Maintenance Extended Table Maintenance
Enter Company Code ##UC Tax code XI Jurisdiction code MI
Assignment
Make the following entries in the row with your company code:
Credit Debit Credit Debit Credit Debit Credit Debit 31 21 50 40 99 89 75 70
click on save ( ) and then exit ( ) to return to the main screen.
Make the entries in the row with your company code:
