DBD: Reselling Client Owned Inventory
This workflow defines how to resell client owned inventory, repay your customer, and ensure the general ledger, inventory and sales reports are updated correctly.
Setup
-
Add "Customer Ship-To" with same tax code as warehouse.
Note: Use this Ship-To for issuing credits ONLY!
- Use same Product Code on ALL items for this client (ensures GL and report accuracy).
- Consider using new Product Code that represents this reselling program.
- Recommend designated warehouse location is used for this resale program.
Buying Inventory
It’s strongly recommended that this inventory goes to a separate warehouse to isolate and maximize reporting capabilities.
- Create Sales Order for items, ship to 9001 warehouses (standard).
- Receive into "Inventory w/AP Invoice" (standard).
- Invoice Sales Order to bill customer (standard). Initial Tax is charged.
-
2 Step Inventory Adjustment:
a. Use (*) Asterisk in "Reference Number field" to prevent GL adjustment.
b. Adjust full quantity out of the 9001 warehouses.
c. Adjust full quantity into NEW distributor owned warehouse (#’d 8999 or below).
d. Verify Cost equals sell (prevents commission calculation).
Releasing Inventory
- Enter requisition to location.
- Invoice requisitions – "Desired Tax is charged based on Ship-To."
-
General Ledger auto activity:
a. Credit to revenue – Debit AR.
b. Credit NEW Inventory and Debit COS.
Credit memo
Gather the information need to credit the client.
- Issue Credit memo using "New Customer Ship-To (w/matching tax code)."
- Entered current months reimbursement. Initial Tax is credited.
- Last screen of credit memo - General Ledger.
-
Add two additional GL posting records to:
a. Credit to Cost of Goods account.
b. Debit to NEW Inventory account.
When the credit memo is issued and MATCHES the monthly activity, the net result is a ZERO balance to the new Inventory account.