You’re offline. This is a read only version of the page.
A new employee posted a whole series of invoices by checking the drop ship box instead of allocating (100 Plus). Any ideas of the best way to fix this as the Inventory has not been relieved and the System has posted to the drop ship account.
Any help you can provide is appreciated.
*This post is locked for comments
Hi Tom,
The scenario you described is very interesting indeed. However, the cost that drops in when the item is allocated is not based on costing method, it is simply the Current Cost from the item card.
I tried your scenario and my transaction used the accounts I had designated as Inventory and Cost of Goods Sold, rather than the inventory offset account.
You're right about the errant entry, there shouldn't be any inventory/cogs entry. It handles the quantities correctly, but sends incorrect information to the general ledger. The stock status report is correct, but good luck reconciling it to the GL.
Drop ship returns have been wrong for ages, but I honestly never ran in to this side of the equation.
Thank you very much for sharing this information with us.
Kind regards,
Leslie
Thanks Richard but I don’t think returns work because the first invoice was marked as drop ship the inventory qty is still there. If I do a return I have doubled the qty and then if I copy the original invoice with no drop ship my Inventory qty is still overstated. I think Inventory Adjustment is the way to go.
On an interesting side note (at least to me) if you post a drop ship Invoice that has not had a PO drop ship process completed (in this case nothing) there would be zero costs attached to that Invoice. So far so good. If you enter an order and allow the system to allocate because you have items in stock a cost is attached to that line based on whatever costing method you use. If you then check the drop ship box and post that cost will be debited as a cost of goods sold and the credit will be the inventory offset account. They qty still remains in inventory in this scenario as well. One of those entries can’t be right and personally I think it is the later.
Leslie's suggestion is good. If you don't have many invoices, you could generate returns. It would provide a better audit trail
Thanks Leslie for your reponse. I thought of that, I guess we should use the COGS accounts as the Invoicces came in with zero cost. No problem getting the data out as I worked for Wennsoft for 10 years which means I am great at Crystal reports, lol.
Hi Tom,
To get your inventory in balance, I think the easiest thing to do may be to use integration manager and import an inventory adjustment. You would use the SOP history line table as your source file and then put in whatever filtering parameters make sense so that you can isolated the documents incorrectly posted.
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (