Symptom
No Journal Entry is created for the Warehouse Confirmation XXX (where XXX is the Warehouse Confirmation ID) and an Exception is raised.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Purchase Requests and Orders Work Center.
- Go to the Purchase Orders View and find ID YYY (where YYY is the Purchase Order ID).
- Open it and go to tab Document Flow.
- Click on Extended View and then on Anchor for Inbound Delivery ZZZ (where ZZZ is the Inbound Delivery ID).
- Go to the Inbound Delivery Document Flow and check Warehouse Order AAA (where AAA is the Warehouse Order ID).
- Click on Anchor Document.
- Find warehouse confirmation XXX.
There is no Journal Entry created, it is missing. However a Journal Entry is expected to be created here.
Cause
- In this case Warehouse Confirmations are not posted due to the Purchase Order Line Items having a zero Net Price.
- Whenever Purchase Order Line Items have a zero Net Price, the system does not allow the addition of Landed Costs.
- Due to zero Landed Costs, the clearing has not been performed. As per the actual system behavior, if Landed Costs are zero, ByDesign does not support a clearing. Due to this, no Journal Entry is created for the Warehouse Confirmations.
- Whenever a Landed Cost is created in the Header Level, the system will distribute it to all Purchase Order Line Items. Currently, a Landed Cost Entry with a zero amount gets created for the zero Price Items, and the system throws an Exception. The distribution should still use the Item net value as a basis, so a zero value Purchase Order Line Item should not get any Landed Costs assigned. For this issue in future versions of ByDesign we will implement a validation at the Purchase Order Level to avoid the inconsistency.
Resolution
To avoid this issue, please just do the following:
- Create a Landed Cost for Purchase Order Line Item Level instead of creating the Landed Cost in the Header Level (for Prices and Cost).
Keywords
journal entry, warehouse confirmation, zero net price, purchase order line items, landed cost, clearing, dump, backend correction, inconsistency, validation, purchase order level, header level , KBA , AP-ACC-PUR , Purchase Ledger Account , Problem
Product
SAP Business ByDesign all versions