Skip to Content
Product Information
Author's profile photo Dan Love

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

 

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Cristian Julian Cedeño Guzman
      Cristian Julian Cedeño Guzman

      Great! ... Thanks so much dear Dan

      Author's profile photo Tichaona Gaza
      Tichaona Gaza

      Hi Dan,

      Please may you send through an update link for this document. Its no longer available.

      Regards,

      Tich

      Author's profile photo Nagarajan K
      Nagarajan K

      Hi Dan,

      Could you please share the link again?

      Thank you.

      Best Regards,

      Nagarajan

      Author's profile photo Eric Alo
      Eric Alo

      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

      Author's profile photo Ramon Ramirez
      Ramon Ramirez

      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.

       

      Author's profile photo Carlos Oliveira
      Carlos Oliveira

      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

       

      Author's profile photo Xuan Anh Dao Tran
      Xuan Anh Dao Tran

      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.