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 PSP1. 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	Internal The transaction originates from your packaging item transaction records registered in the Packaging Item Transactions (whinr1115m000) session. External The transaction originates from PSP1's records registered in the External Packaging Item Transactions (whinr1116m000) session.
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.