Dynamics Community Forum Thread Details

Consignment inventory, sales, refunds, returns, etc.?

Our company uses a third party POS and inventory application for managing our retail items. But we currently manage our consignment items manually through tracking spreadsheets for the billing process. I have read a few threads pertaining to handling consignment items in GP but nothing that 100% fits our needs. And I haven't run across many third party VAR's that offer consignment add-on modules for GP.

Here is what we are looking to accomplish:

1) A consignment item comes into GP, as imported from our POS/inventory app. It would be added to the GP inventory module with the appropriate data values.

2) The consignment item sells, as imported from our POS/inventory app. This would presumably create a SOP document in GP that we would send to the vendor as a request for billing.

3) When the vendor invoice arrives for payment we would need to enter this into GP as a PM invoice. It would be nice to have some line item matching function, similar to how we can line item match a PM invoice based on a POP document. We might not be billed for all items that sold by the vendor. And the unbilled consignment sales per vendor is a key part of our internal reconciliation process.

4) If a customer brings back a consignment item for refund then this item comes back into GP, as imported from our POS/inventory app. It would be re-added to the GP inventory module with the appropriate data values.

5) If we return a consignment item back to the vendor for credit then I assume this would be accomplished similar to #2. Except the imported transaction from our POS/inventory app would generate a SOP refund document that we would send to the vendor as a request for credit.

6) When the vendor credit document arrives we would like some line item matching function to tag the items to generate the PM credit in GP. Once again, this would be part of our internal reconciliation process, in how we track uncredited consignment returns per vendor.

Any suggestions? Items #3 and #6 seem to be potential show-stoppers that I am having trouble getting my head around...

Quick Links