SAP B1 Troubleshooting – G/L Account is Missing Error in A/R Invoice

Troubleshooting A/R Invoice Errors: Fixing the G/L Account Issue

Error Description

When attempting to create an A/R Invoice for a customer in SAP Business One, you may encounter the error message “G/L Account is Missing.” This error typically appears during the process of adding the document, preventing its completion.

Root Cause

The “G/L Account is Missing” error occurs due to one of the following reasons:

1. The G/L Account mapping for the item or warehouse is missing.
2. The G/L Account is not available in the A/R Invoice document at the row level.

To resolve this issue, we need to verify and update the G/L Account determination settings and document-specific mappings.

Solution

Step 1: Verify G/L Account Determination

Ensure that the Revenue Account is mapped correctly in the relevant setup areas.

1. Navigate to: Administration > Setup > Financials > G/L Account Determination > G/L Account Determination.
2. Check the following mappings:
   • Warehouse Setup: Ensure the G/L Account mapping is correct.
   • Item Group Setup: Verify the Revenue Account assigned to the item group.
   • Advanced G/L Account Determination: Confirm specific account assignments based on rules or conditions.

Check the same in Item Group as well as warehouse setup.Step 2: Verify G/L Account at the Row Level

If the G/L Account determination settings are correct, check the G/L Account column at the row level in the A/R Invoice document.

1. Open the A/R Invoice document.
2. Ensure the G/L Account column is visible. Use the Form Settings to enable it if necessary:
   • Go to View > Form Settings and ensure the G/L Account column is checked.

Step 3: Assign the Revenue Account

If the G/L Account column is empty at the row level:

1. Select the appropriate Revenue Account from the dropdown list in the G/L Account column.
2. After selecting the Revenue Account, proceed to add the A/R Invoice document.

Step 4: Post the Document

Once the G/L Account is updated:

1. Click Add to post the A/R Invoice document.
2. The document should now be successfully posted without errors.

The “G/L Account is Missing” error can be easily resolved by verifying and updating the G/L Account mappings and assignments. Regularly reviewing the setup configurations for items, warehouses, and advanced G/L Account determinations can help prevent such issues in the future. By following the above steps, you can efficiently address and resolve this common error in SAP Business One.

If you have any questions or face additional issues, feel free to engage in for expert advice and peer support.

By following these guidelines, you can quickly restore access to SAP Business One and minimize downtime.