GL Account Determination in SAP Business One 9.0 enables us to customize financial accounts’ mapping (determination) with various business transactions such that the financials module gets automatically updated upon manipulation of various documents in SAP Business One 9.0. Previously we could set the determination rules per “Warehouse”, “Item Group”, and “Item”, and it had to be done through the corresponding interfaces. But now in SAP Business One 9.0, with the introduction of Advanced GL Account Determination, we’ll able to extend the account mapping to some more dimensions named – “BP Groups”, “Ship to country”, and “Ship to state” besides the previous mentioned dimensions. Apart from GL Account mapping extensibility to more dimensions, now the determination rules can be setup through a central interface instead of different interfaces.
On activation of the option for Advanced GL Account Determination the existing GL account mappings will be migrated to the new centralized structure for determination rules. So the old account determinations in item master data, item groups, and warehouse will be completely removed.
Multiple account determination on transactions can be conflicting sometimes, so priorities are there to avoid determination conflicts, and in SAP Business One 9.0 we’ll able to customized the determination priorities too. There are two types of priorities in the new GL account determination structure –primary and secondary. The primary priority can be setup in “Determination Criteria” and the secondary priority can be setup in the “Advanced G/L Account Determination Rules” by changing the row position of the rules.
Why do we need this?
If we need to segregate some accounts (like Revenue Account) as per various dimensions (like Customer Group) of our business then this Advanced GL Account Determination will be useful for us, or else we can simply keep ourselves limited to the basic account determination. This features in SAP B1 is optional, even after enabling it.
Connect your SAP B1 ERP with eCommerce/marketplace/CRM and improve your business process!
You may also like:
Ad-Hoc Analysis on SAP Business One Data through Dynamic Reports- Free Trial
Pre Packaged Reports for SAP Business One- Take a Tour
