Symptom
Wrong G/L Account appears in the simulated Journal Entry for Supplier Invoice 'AAA'.
'AAA' refers to the Supplier Invoice ID.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Supplier Invoicing work center.
- Select the Invoices and Credit Memos sub view.
- Search for the relevant Supplier invoice 'AAA'
- Select the Edit button.
- Give View All button.
- Select the Actions button and choose Simulate Journal Entry.
- In the 'Line Items' section, observe the G/L Account "100000 - GR/IR: Clearing - Purchases in Transit (Materials/ Fixed Assets)" appearing incorrectly. Instead the G/L account should be "200000 - Unbilled Payable Opening Balance"
Note: G/L accounts numbers mentioned above is for reference purpose.
Cause
- If the Supplier Invoice get reference of the Migrated-Inbound-Delivery, then G/L-Account is derived from "Data Migration: Migration of Open Purchase Orders -> Unbilled Payables for Migrated Open Purchase Orders".
- If the Invoice does not get any reference from the Migrated-Inbound-Delivery the, G/L-Account will be derived from "Accounts Payable: In Transit -> In Transit".
Resolution
- The Supplier Invoice 'AAA' is having the reference of migrated-Inbound-Delivery : ABC for the Line Items 1 and 2, which can be referred in the Cost Distribution tab at Item Level.
- But for the Line Item 3 of Invoice, there is no reference of Migrated-Inbound-Delivery, and Item 3 has already been consumed in the another Supplier Invoice 'BBB' and consumed fully in Inbound-Delivery quantity.
- Hence G/L Account has been picked as "100000 - GR/IR: Clearing - Purchases in Transit (Materials/ Fixed Assets)" as per the Account determination configuration.
- So based on this logic system is behaving as expected.
Keywords
Wrong g/l account, Simulated journal entry, Supplier invoice, Account determination, Inbound delivery reference, Migration of purchase orders, Accounts payable, Cost distribution. , KBA , AP-ACC , Business ByDesign: Financial Accounting , Problem
Product
SAP Business ByDesign all versions
SAP Knowledge Base Article - Public