Tag Archives: Salesforce data import troubleshooting

How to Fix Restricted Picklist Import Errors in Salesforce Sage ERP Integration

While working on a Salesforce and Sage ERP integration, I encountered a common yet critical issue related to picklist values during data import. In Sage ERP, when fetching records for a picklist field, the system sometimes returns the sequence value (1, 2, 3, etc.) instead of the actual label such as Active or Inactive. This… Read More »

How to Import Sage 100 Non-Inventory & Temporary Items in Salesforce

How to Import Non-Inventory / Temporary (Product) Items Smoothly into Salesforce When integrating Sage 100 with Salesforce, handling item codes that start with an asterisk (*) can be challenging. These “*products” behave differently from standard inventory items and often cause import failures for Order or Quote Line records during integration. This blog explains why this… Read More »