Zero Item Quantity on Sales Order after Import Sales Creation

  • 0
  • 1
  • Article
  • Updated 5 years ago
  • (Edited)
A common issue that customers see after 'Creating' a Sales Order through SPS for GP Sales Import is that they have a line item created with zero (0) quantity instead of the quantity sent in by the customer. 

The most common cause of this issue is that the purchase order being imported/created (850) has a Unit of Measure (UOM) that is not valid in the Great Plains system.  The line item will be created but since the UOM cannot be found the quantity is set to 0 on the line item.

To resolve this, the incoming purchase order should be examined, raw text file, to determine what the UOM was for that line item.  If you are unfamiliar with viewing the raw data file contact SPS Commerce for assistance. 

Once the UOM is found on the raw purchase order file compare that value to the valid UOM values for that item in Great Plains.  The list of UOM values in Great Plains can be viewed by going into Item Maintenance in Great Plains, pulling up the line item in question, and clicking on the U of M Schedule ID zoom button on the window.  This will list the valid UOM values for this item.  If the UOM from the 850 file is not on that list then you need to add a translation for that UOM to the correct Great Plains UOM. 

To setup the translation for this customer/item/UOM combination open the Customer Maintenance window, select the customer for this order, open up the EDI Information window and then select the XReference button at the bottom of the window. 

For more information on setting up Cross Reference values click here!
Photo of FAQ


  • 9,380 Points 5k badge 2x thumb

Posted 5 years ago

  • 0
  • 1

Be the first to post a reply!