Advanced GL Account Determination in SAP Business One 9.0

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.

GL Account Determination in SAP Business One 9.0
Activating Advanced GL Account Determination

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.

GL Account Determination in SAP Business One 9.0
Setup path of Advance GL Account determination

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.

GL Account Determination in SAP Business One 9.0
GL Account Determination in Warehouse in SAP Business One 9.0

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.

GL Account Determination in SAP Business One 9.0
GL Account determination in Item Level is converted into Rules of New Advanced GL account determination
GL Account Determination in SAP Business One 9.0
Journal Entries in SAP Business One 9.0

Connect your SAP B1 ERP with eCommerce/marketplace/CRM and improve your business process! 

SAPB1-integration-with-ecommerce

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

Search

On Key

Related Posts

APPSeCONNECT is now a completely new entity headquartered in the US! 🇺🇸