Symptom
You may encounter issues related to the Advanced G/L Account Determination function under Administration → System Initialization → Company Details → Basic Initialization tab.
Solution
Consider the following information when dealing with an issue related to Advanced G/L Account Determination in SAP Business One:
If you are working in a company database where the Enable Advanced G/L Account Determination option is not selected, then the scenarios described in this SAP Note may not be suitable for you.
Prerequisites:
Consider and verify all of the following information when dealing with an issue related to Advanced G/L Account Determination in SAP Business One:
- Conduct all testing in a test database obtained from the productive environment.
- Obtain the approval from the company's accountant before defining or updating any information in the productive environment.
- Check whether there is any of the following defined/present, which might have an impact, especially in case of seemingly "random" issues:
- User-Defined Fields (UDF) and Formatted searches (FMS) in SAP Business One or modifications in the Transaction Notification code of the database, which are a common root cause of unexpected behavior (with or without any error displayed), and the latter of which is out of our support scope. Consult SAP Note 2079411 for the details to be verified and on how to remove them.
- Data Ownership for any of the relevant non-superusers. To rule out its impact, from the SAP Business One Main Menu, choose Administration → System Initialization → General Settings, and on the BP tab, deselect the Enable Data Ownership checkbox for the non-superusers. Note that this setting is not relevant for superusers. Check the defined G/L accounts in Administration → Setup → General → User Defaults.
- Test if the issue is present when using professional user license with full authorizations.
- For further information, refer to the referenced SAP Notes.
- Contact SAP Business One Support regarding database inconsistencies that are not perfectly resolved after having followed the instructions provided in this SAP Note.
Ensure that you provide the following information when submitting a support incident regarding Advanced G/L Account Determination:
- The SAP Business One version, localization, and patch level or feature package in which the issue has occurred.
- If the issue is reproducible in a standard SAP Business One demo database.
- Check whether the same issue can be reproduced by adding the document anew in the latest patch of the current version.
- In your testing, try to rule out the impact of UDF's, as mentioned in the previous section. If they do seem to have an impact, first consult all the dedicated sections of this SAP Note.
- A screenshot of a sample marketing document with the unexpected G/L account and its journal entry, the error message displayed (if any), and all the details that may be necessary to define the advanced rule (such as item group, item code, warehouse code, business partner (BP) group, BP code, BP type, ship-to country/region, UDF fields in use etc. that are relevant as per advanced criteria).
- Details of the steps needed to reproduce the issue, including screenshots of the following setup windows, whichever are relevant:
- Administration → Setup → Financials → G/L Account Determination → G/L Account Determination → Sales/Purchasing/General/Inventory tab and the General/Tax subtab for the relevant Period Selection where the relevant G/L accounts can be seen.
- Administration → Setup → Financials → G/L Account Determination → Advanced button for the relevant Period where the rules settings can be seen: all advanced criteria and G/L accounts.
- Item Master Data → General tab → Advanced Rule Type setting for the involved item(s).
- Details of the Expected and the Actual results/behavior.
- Results of any query that might have been run.
For detail: 3040377 - Troubleshooting - Advanced G/L Account Determination - SAP for Me
