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

  • 1
  • Problem
  • Updated 3 years ago
  • Solved
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.
Photo of Marilyn Long

Marilyn Long

  • 132 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Hi Marilyn,

Thank you for posting.  It sounds like Jessica and Cory are working hard to resolve this, and will be in touch via case 02139394 with any updates.

Thanks,

Jordan
Photo of Mai Yang

Mai Yang, Partner

  • 200 Points 100 badge 2x thumb

Hi Marilyn,

For the one 850 that was resent, did you also make sure to delete that item from the Import Sales History tab as well as deleting the sales order?

Photo of Marilyn Long

Marilyn Long

  • 132 Points 100 badge 2x thumb
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
Photo of Mai Yang

Mai Yang, Partner

  • 200 Points 100 badge 2x thumb
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.
Photo of Marilyn Long

Marilyn Long

  • 132 Points 100 badge 2x thumb
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

This conversation is no longer open for comments or replies.