QUESTION:
What fields do I need to populate when importing Opportunity Line Items (linking Products to Opportunities)?
ANSWER:
Using MassEffect, the following fields need to be mapped in the Opportunity Line Item table in INSERT mode:
- Opportunity ID
- PricebookEntryID
- Sales Price
- Quantity
NOTE: DO NOT map anything to the Total Price field, this is auto-populated based on Sales Price and quantity. Mapping to this field also will result in the following error:
- 2008-06-18T12:43:26-06:00,,"",,Insert,,,,," Message: field integrity exception: UnitPrice (only one of unit price or total price may be specified) Status code: 48"