Dynamics Community Forum Thread Details

Managing goods in 3PL

we are selling goods to customer but then warehouse them in our 3PL for them until the need it.

Following is the - rough - outline of the process

Order is processed as a sales order
Customer pays for the goods
1. Order invoiced
2. Ledger adjusted
Goods get shipped off
1. Transfer to 3PL warehouse
2. Goods in this warehouse cannot be included in the general ledger / inventory account as they are sitting in warehouse at $0
Customers orders goods to be shipped out of 3PL AND normal warehouse
1. Goods shipped out of 3PL warehouse
2. Storage fees to be charged

The problem points are - that I have identified so far

How do I transfer the goods from WHS to WHS 3PL without creating a journal entry?
How can I maintain the average cost / price per units based on previous history without including the items sitting in 3PL (if 3PL is included, they would be shipped for a 2^nd time when dispatched and the sales prices would be diluted as these are shipped at $0)
The customer (corporate) wants invoices per shipment from 3PL to the location / store the shipment is sent to. – How do I invoice without creating a ledger entry (this is a service we provide)

In my mind we should be able to

a) create a 3PL warehouse in Dynamics

b) remove any items stored in that 3PL from the ledger - we only need stock keeping records

a) allow only storage, packaging & freight charges (and other cost) in the 3PL

Would this be the correct thought process? And how do we achieve this?

Edit: moved to another forum

Categories:

Quick Links

Leaderboard