We have a problem with a batch of Wal-Mart 940's sent to our 3PL, CaseStack.

Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.
The community moderator provided the following reason for archiving:
Old

We have a problem with a batch of Wal-Mart 940's sent to our 3PL, CaseStack. The Wal-Mart 850's were imported and are sitting as SO's in Dyn GP with correct quantities. When they were sent as a batch of 940's to CaseStack they had zero quantities on all line items. SPS support tried to resend one 850 but of course it failed because GP recognized it had already created a SO in GP even though I had deleted it. Any ideas. txs Marilyn Long Variety Pet Foods.

Yes I did not know to do it but Jessica at SPS Commerce knew. I think ProcessLogic writes info to several of the GP SQL tables that must not get updated when you delete the SO. At least that was the only thing I could think of which would cause it to recognize the duplicate import. It might read the Void table. txs for response. mll

Have you tried resending a 940 to see why the quantities were 0? Were the correct quantity fields populated with values? What is the quantity source set to in your B2B company setup window under the Warehouse Default Values section (Microsoft Dynamics GP>>Tools>>Setup>>Sales>>B2B Logic)? That may help in resolving why it may have been sent with a 0 instead of the correct value.

I think setup looks right and the same as always. We have been doing these uploads weekly for 4 years or so this has never happened before. Something weird did happen when I was importing the 850's. I put in my normal date coded batch ID but when I actually did import the batch ID was changed to a string of numbers which meant nothing to me. When I tried to open SO's it said that batch was in use. I restarted then batch was in recovery window which I processed. I then brought up a few orders and they looked fine ran an analysis of them and total units and dollars looked reasonable. So I assumed all was well. The only thing I think could have happened is when SO's came in ProcessLogic wrote something in some SQL table which indicated these were already invoiced so left zero quantities. Doesn't really make sense but nothing else does either. Maybe there was power glitch in FTP but I have checked actual PO's to SO's and they look fine. We may never know the answer but my fear is will be manually invoicing all those PO's in SPS Commerce and that will be a nightmare. Thank you for ideas and have a wonderful 4th. mll