Reconciliation data - example
In this example, shipping material account SMA1 is used. This SMA is dedicated to external business partner PSP1 and includes packaging item transactions from your organization to customer CUST1 and from PSP1 to your organization.
Both your organization and PSP1 register their own packaging item transactions. The internal (your own) and external (PSP1's) packaging item transaction records must be kept in sync. For this purpose, PSP1's records are uploaded to the External Packaging Item Transactions (whinr1116m000) session. This is done through the external EXM application.
The balance of your packaging item transaction records, which is maintained in the Packaging Item Transactions (whinr1115m000) session, can be reconciled with the external records.
For this purpose, reconciliation data that is based on the internal and the external packaging item transaction records is generated in the Generate Reconciliation Data of Packaging Items (whinr1217m000) session. The resulting reconciliation data is displayed in the Reconciliation Data of Packaging Item Transactions (whinr1117m000) session.
In the Packaging Item Reconciliation Based on field of the Inventory Reporting Parameters (whinr0100s000) session, the reconciliation period set to Year/Week. Consequently, to generate reconciliation data, the internal and external packaging item transactions are grouped by week.
Internal packaging item transactions in the Packaging Item Transactions (whinr1115m000) session
| Transaction date | Type | Item | Quantity | Balance | SMA | Business partner | Description |
|---|---|---|---|---|---|---|---|
| yyyy-06-15 | Receipt | BOX1 | 100 | 100 | SMA1 | PSP1 | Your organization receives 100 empty boxes from PSP1. |
| yyyy-06-17 | Issue | BOX1 | 50 | 50 | SMA1 | CUST1 | Your organization ships goods packed in 50 boxes to customer CUST1. |
| yyyy-06-25 | Issue | BOX1 | 50 | 0 | SMA1 | CUST1 | Your organization ships goods packed in 50 boxes to customer CUST1. |
| yyyy-06-29 | Receipt | BOX1 | 48 | 48 | SMA1 | PSP1 | Your organization receives 48 empty boxes from PSP1. |
External packaging item transactions in the External Packaging Item Transactions (whinr1116m000) session
For PSP1, this transaction data is sent to LN through the external application Automotive Exchange Export Manager (EXM).
| Transaction date | Type | Item | Quantity | Balance | SMA | Business partner | Description |
|---|---|---|---|---|---|---|---|
| yyyy-06-15 | Issue | BOX1 | 100 | -100 | SMA1 | PSP1 | PSP1 sends 100 empty boxes to your organization. |
| yyyy-06-17 | Receipt | BOX1 | 50 | -50 | CUST1 |
CUST1 returns 50 boxes to PSP1. The return flow from CUST1 to PSP1 is outside SMA1. |
|
| yyyy-06-27 | Receipt | BOX1 | 26 | -24 | CUST1 |
CUST1 returns 26 boxes to the PSP. The return flow from CUST1 to PSP1 is outside SMA1. |
|
| yyyy-06-29 | Issue | BOX1 | 50 | -74 | SMA1 | PSP1 | PSP1 sends 50 empty boxes to your organization. |
Resulting reconciliation data in the Reconciliation Data of Packaging Item Transactions (whinr1117m000) session
For SMA1, packaging item BOX1, this reconciliation data is generated:
| RP | Tr dt | Origin | Corr | Type | Qty | T int | T ext | Diff | R qty |
|---|---|---|---|---|---|---|---|---|---|
| yyyy-24 | yyyy-06-15 | Internal | Receipt | 100 | 50 | 100 | 50 | ||
| yyyy-24 | yyyy-06-15 | External | Receipt | 100 | 50 | 100 | 50 | ||
| yyyy-24 | yyyy-06-17 | Internal | Issue | 50 | 50 | 100 | 50 | ||
| yyyy-24 | yyyy-06-17 | Internal | X | Inventory Adjustment | 0 | 50 | 100 | 50 | 0 |
| yyyy-25 | yyyy-06-25 | Internal | Issue | 50 | -2 | 50 | 52 | ||
| yyyy-25 | yyyy-06-29 | Internal | Receipt | 48 | -2 | 50 | 52 | ||
| yyyy-25 | yyyy-06-29 | External | Receipt | 50 | -2 | 50 | 52 | ||
| yyyy-25 | yyyy-06-29 | Internal | X | Inventory Adjustment | -2 | 50 | 52 | 1 |
| Legend | |
|---|---|
| RP |
Reconciliation period. In this example, the reconciliation quantity is Year/Week. Consequently, LN inserts a correction line at the end of weeks 24 and 25. In the correction line, you can leave your own balance unchanged. Or, adjust your balance by accepting PSP1's total quantity or by manually specifying a reconciliation quantity. |
| Tr dt | Transaction date |
| Corr | Correction line. |
| Origin |
|
| Type | The type of transaction. |
| Qty | The packaging item quantity of the transaction. |
| T int | Total Internal Quantity |
| T ext | Total External Quantity |
| Diff | Difference Quantity |
| R qty | Reconciliation Quantity. For week 24, the internal balance is accepted, no reconciliation quantity is specified. For week 25, a reconciliation quantity of 1 is specified, because your organization found out they received 49 boxes instead of 48 or, as PSP1 reported, 50 boxes. Consequently, your organization updates their balance to 49 for week 25. |