Does anyone have some thoughts on best practices f...
# general
m
Does anyone have some thoughts on best practices for dealing with receiving variances on transfer orders from NetSuite to Amazon FBA? We use a Celigo flow which posts automatic item receipts against transfer orders that we send. Because Amazon is Amazon, we often get over and under-receipts from what we sent. Currently, to our knowledge, NetSuite doesn’t have a function for over-receiving transfer orders and in the events of under-receipts, we don’t currently know how to close out the quantities that didn’t get received so they no longer show up as “in-transit”. Obviously, we don’t want to change the quantity fulfilled in our transfer orders because we want what we sent to leave our inventory, not more or less, but we need a good way to account for the pick-ups and losses of units when Amazon receives them.
m
If you'd like to over-receive an item, Setup -> Accounting Preferences -> 'ALLOW OVERAGE ON ITEM RECEIPTS'
If they submitted a receipt for 110 items when your transfer order was for 100, you can allow for the additional receipt because you know that they're likely going to claw it back later through an inventory adjustment of some sort
Going to think out aloud for the next part - For the under-receipt, I'd propose 'flagging' the transaction through a checkbox but also creating an item receipt into a 'lost' location. If you happen to receive a receipt in the future but get an error that the transaction is closed/locked, you'd have some manual clean up in front of you.