SAP Knowledge Base Article - Public

3692261 - Wrong G/L account in simulated Journal Entry for Supplier Invoice

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

  1. Go to the Supplier Invoicing work center.
  2. Select the Invoices and Credit Memos sub view.
  3. Search for the relevant Supplier invoice 'AAA' 
  4. Select the Edit button.
  5. Give View All button.
  6. Select the Actions button and choose Simulate Journal Entry.
  7. 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