In this blog, we will be discussing about the error encountered in the Import for Sales Order Line Items, where the line items have zero/negative in quantity in Sage, but we receive error stating “Quantity cannot be zero/negative” while importing data in Salesforce.
Read more: GUMU™ for Salesforce – Sage ERP Integration
In your Sage ERP if you have created an Order with a line item and while adding the quantity you have entered negative quantity (based on your settings in the ERP) and then you accept the Sales Order.
Later, you want that Order to be imported along with its other details from your Sage ERP to your respective Salesforce Org. But it failed during the import and while checking the logs of the order entity you will see the below log description:
Description- “Can’t save order products with zero quantity: Quantity”
The problem is comparatively not so immense, but in a standard Salesforce Order object, the validation rule doesn’t allow the Quantity of an Line Item to be zero/negative. Hence, while importing the Sales Orders from Sage ERP to Salesforce the validation of Order object is applied.
For accepting the zero/negative line items from your Sage to Salesforce you have to enable the zero/negative quantity, following are the steps to enable.
From Setup, enter Order Settings in the “Quick Find” box, then select “Order Settings”.
- Make sure that Enable Orders is checked.
- Along with it Enable Zero Quantity/ Enable Negative Quantity is also marked checked.
- Save your changes.
If Enable Negative Quantity is disabled, your Sales team can not add Order Products with negative quantities.
We hope you may find this blog resourceful and helpful.
Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner, as a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.
Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration for Sage X3, Sage 100 and Sage 300. We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, Custom App development and Technical Support to business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow.
Greytrix GUMU™ integration for Sage ERP – Salesforce is a 5-star rated app listed on Salesforce AppExchange.
For more information, please contact us at firstname.lastname@example.org. We will be glad to assist you.