Technical Articles
Posting Product Sales to Specific GL Accounts in Business ByDesign
Part of my role as a Cloud ERP Specialist is to help partners find solutions to specific customer requests. One that happens very often is the need for sales of products or product categories to be posted to specific GL Accounts in the Chart of Accounts.
The default position in ByD that is created if you chose to copy an SAP supplied Chart of Accounts is this.
ByD has 4 Sales Account Determination Groups, and you will find them in the Fine Tune Activity “Charts of Accounts, Financial Reporting Structures, Account Determination”.
In the subsection “Account Determination Groups” navigate to the “Groups for Materials”
You can see I have added a new group for Boilers on the Right Hand Side (it must start with a”Z”).
You will need a new group for each distinct GL Code you want to post to.
Now you need to create your new GL Code in your chart of accounts, ensure it is in the correct account type (REVGAN – Revenues or gains).
Next edit Account Determination for Sales
Here you should create an entry in the revenues tab. In the materials column find the entries you have just created and assign them to the appropriate new GL Code you have added to your CoA. You will need to create a Customer AND material combination line for each of your customer account determination groups and your material codes. If your GL account isn’t here, its probably because you have not assigned it to the type “Revenue or Gains”.
Now head to the product master record and change the valuation data to use the correct Account Determination Code.
Test this by simply creating and posting a manual invoice, you should see the revenue post go to the new GL Account.
I hope you find this useful!
Please like and comment, and if you like follow me on LinkedIn
John Meadows – Cloud ERP Specialist
Hi John,
This is great information and exactly what I was looking for in terms of posting revenue. Now I want to post COGS in the same manner and struggling to figure out how to do that. My COGS accounts mirror my Revenue accounts but I see that COGS is now under Material Consumption.
Any direction you can provide is appreciated.
Thank you,
Teresa Sellar
Hi Theresa
COGS is more difficult to manage, since you may have different reasons for material consumption and the account determination profile may not cater for all scenarios.
maybe send me the documentation of what you want john.meadows@sap.com
John