Product Information
SAP Business One GL Account Determinations for Implementation Consultants
After many years of talking about updating this guide I finally found the time to complete version 3.0 of SAP Business One GL Account Determinations for Implementation Consultants. This guide is meant for SAP Business One Partners that are doing implementations in the United States and Canada.
When I first started doing SAP Business One implementations as a US partner in 2004, I really struggled to guide my customers in setting up their GL Determinations correctly. I quickly learned how GL Determinations worked but not having the accounting background, I lacked the accounting reasoning for how and why each account was and should be used. I remember having conversations with my client’s accountants about setting up GL determinations but not having all the answers to the questions they were asking me. The biggest question I could not answer then was “Where will this account be used in SAP Business One?”
When I joined SAP as a Solution Adviser in 2006 I vowed I would find the documentation and find these answers for my Partners. Well I never found the documentation to the level of detail I was looking for, so I decided to write my own. That was in 2008 and the current release of SAP Business One was Release 8.8. One of the key things of that guide, and still today in the current version, is what I call the Tab Details tables. For each Tab of the GL Determinations setup I have created a table that list every GL Determination account used across the US/CA localizations and a Description, Drawer, Property, and in which Documents the account could/would be used.
Version 3.0 marks the 11th version of the document that has been updated with corrections, more clarity and new features that have impacted GL Determinations since the first release. In version 3.0 , the first since SAP Business One release 8.82 and 2012 there are over 25 pages of new material, with the most significant updates centered around GL Advance Determinations Rules and Resources which came in releases 9.0 and 9.1 respectively.
If you have questions or corrections please let me know and I will publish updates and corrections as required during 2019.
SAP Business One GL Account Determinations for Implementation Consultants v 3.0
thanks
Dan Love
North American SAP Business One Solution Advisor
Great! ... Thanks so much dear Dan
Hi Dan,
Please may you send through an update link for this document. Its no longer available.
Regards,
Tich
Hi Dan,
Could you please share the link again?
Thank you.
Best Regards,
Nagarajan
Hi Dan,
I think we are missing the "Realized Conversion Diff. Gain/Loss".
It's a bit challenging how to explain this to our customers who are used to manual bookkeeping or who has no concept of system currency from their legacy ERPs.
Thank you.
Eric
The link to the file is broke. I remember that I downloaded this file before and it was GREAT, it explained everything in great detail. If it would be possible to have the link restored and/or the updated document, that would be awesome.
Hi Dan
From what I see, from the above messages, this is a very good article. However link is broken.
Would you be so kind to share the updated link?
Thank you very much
Carlos Oliveira
Dear Mr. Dan Love,
I have a confuse about the document, please help me to understand more about it.
Follow your document, you suggest to use COGS account for Landed cost alloc. account and this account is not a clearing account.
But in the case the stock is zero. The entry will be Dedit COGS/ Credit COGS. Is it suitable for this kind account about accounting.
Please help me explain why do you don't use a clearing account here.