Microsoft Knowledge Base Wiki

Consider the following scenario.  You have installed the Microsoft Dynamics Adapter to integrate data from Microsoft Dynamics CRM 4.0 into Microsoft Dynamcis GP 10.0.  You apply a manual line item discount in Microsoft Dynamics CRM 4.0.  Microsoft Dynamics CRM 4.0 applies that discount to the line total in the extended price field.  The extended price field is mapped to the markdown field in Microsoft Dynamics GP 10.0.  The markdown field is associated with each item, so the markdown is taken on all items.  The total value of the markdown is multiplied by the number of items you have on the order.

Microsoft Dynamics CRM 4.0 applies the discount to the line total and Microsoft Dynamics GP 10.0 applies the markdown to the item price.  This causes the item price in GP to be incorrect when a line item has a quantity greater than 1.

Update the Order to Sales Order map with the following steps:

1. Open the Microsoft Dynamics CRM Adapter for Microsoft Dynamics GP 10.0.
2. Expand Maps, and then click Order to Sales Order.
3. In the Order to Sales Order map expand Sales Order, expand Sales Order Lines, expand Item, expand Line Discount, and then expand Amount.
4. Edit the mapping in the Value field with the following:

=If(GreaterThan(All Order DetailsOrder ProductQuantity, 0), Round(Divide(All Order DetailsOrder ProductManual DiscountValue, All Order DetailsOrder ProductQuantity), 2), 0)

Note: If you use a decimal place value other than 2 in Microsoft Dynamics GP then enter the applicable value instead of 2 when you edit the map.

    5. Click Activate, and then click Save.

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.