How do you change the cost of a drop shipped item AFTER it has been fulfilled.

Follow

Jason

• March 16, 2016 05:57

Here is the scenario:

1. A drop ship PO is created with a cost for SKU A of X based on the external inventory set for that SKU.
2. The PO is submitted to the vendor and the item is shipped and tracking number is imported against the PO, effectively completing the purchase order and fulfilling the retail order.
3. An invoice is then received that lists a different price for SKU A of Y.

How can you resolve that pricing discrepancy as there is no local inventory lot to simply update the cost on?

0

• 

  Quan Vu

  • March 17, 2016 00:26

  Hi Jason,

  You're still able to modify the unit cost on POs after they've turned to "Complete" status. You may also modify the unit cost for the external inventory in the PIM.

  Let me know if this will work for your reporting needs.

  0

  Comment actions Permalink
• 

  Jason

  • March 22, 2016 05:46

  Thanks for the comment Quan. We did a fair amount of testing on this, and I not believe changing the cost on a PO that has already been completed changes the COGS for that item that comes across in the reporting. It's like that cost is logged for the "external lot" as soon as the PO is completed, and changing that cost does not come across in the reporting module.

  I'm not 100% sure on this, as it has been a few months since I tested, but I'm high 90s. I can test this again if you guys need me to.

  0

  Comment actions Permalink
• 

  Quan Vu

  • April 29, 2016 22:01

  Hi Jason, sorry for the delay in getting back to you. I just did some testing using the PO Line Item data source and I can confirm the change in unit cost on Dropship POs will update in the Reporting tool as well. Which data source are you using?

  0

  Comment actions Permalink
• 

  Jason

  • April 29, 2016 22:35

  We're using the Item Fulfillment data source. Let me do some more testing on our end, I was pretty confident in what we found, but with the delay in reporting it can be a bit of a pain.

  0

  Comment actions Permalink
• 

  Quan Vu

  • May 02, 2016 21:46

  Hi Jason, I'm going to create a ticket for this and contact you via ticket.

  0

  Comment actions Permalink

Please sign in to leave a comment.