Four common scenarios of consignment inventory:
Vendor Owned Inventory - use for handling the consignment sale for consignor
Vendor owned Inventory
1) Create Location for separate the inventory that belongs to vendors (e.g. Z0-Consign)
2) Create a G/L account for the location. It can have a specific consignment inventory account in the balance sheet, (e.g. 13198, 13199)
3) The inventory posting setup is then defined to have the expected inventory value on a separate consignment inventory account in the balance sheet.
For Example:
Balance Sheet Account (Setup in Inventory Posting Setup) - G/L Account 13199 Consign-In, 13198 Consign-In (Interim)
P&L Account (Setup In General Posting Setup) - The Invt. Accrual Account (Interim) to be same as the Inventory Account for Consign-In (Interim).
4) Transactions
4.1 Goods received from Vendor
Create Purchase Order and post the Receipt for the quantity.
The G/L to be posted as below, there are not affected on the Balance Sheet.
Process | Transaction | Dr. | Cr. | |
---|---|---|---|---|
Post Purchase Receipt (100pcs) | Post Receipt | Entry 1 | Inventory (Interim) G/L A/C: 2161 G/L account according to Inventory Posting Setup | Inventory Accrual (Interim) G/L A/C: 2161 G/L account according to General Posting Setup |
4.2 Post Purchase Invoice to the Vendor when you sold the item. (i.e. Post Purchase Invoice for the sales quantity.)
Process | Transaction | Entry No | Dr. | Cr. |
---|---|---|---|---|
Post Purchase Invoice for the Sales Quantity (10 pcs) | Post Invoice | 3474/3475 | Inventory Accrual Account (Interim) G/L A/C: 2161 G/L account according to General Posting Setup | Inventory Account (Interim) G/L A/C: 2161 G/L account according to Inventory Posting Setup |
3476/3477 | Inventory G/L A/C: 2120 G/L account according to Inventory Posting Setup | Direct Cost Applied G/L A/C: 7190 G/L account according to General Posting Setup | ||
3478/3479 | Purchase G/L A/C: 7110 G/L account according to General Posting Setup | Account Payable G/L A/C: 5410 G/L account according to Vendor Posting Setup |