---
title: "MS Dynamics BC PostedSales Invoice Lines -> D365 Sales Invoice Detail Add/Update"
description: "MS Dynamics D365 PostedSales Invoice Lines -> CRM Invoice Detail Add/Upd"
keywords: "MS Dynamics BC PostedSales Invoice Lines D365 Sales Invoice Detail"
url: "https://myrapidi.com/wiki/ms_dynamics_d365_postedsales_invoice_lines_d365_sales_invoice_detail_add_update"
locale: "en"
published: "2024-04-24T10:57:25Z"
modified: "2024-04-30T10:28:09Z"
---

This transfer will transfer new and updated MS Dynamics Business Central Posted Sales Invoice lines into D365 Invoice Detail. All mappings are either 1:1 or additional lookups have been created. However, there are specific mappings where you have more than 1 option to map the indicated fields:

1. Sales\_Unit\_of\_Measure -\>uomid

| **Business Central Field** | **D365 Sales Field** |
| --- | --- |
| ##LSLOOKUP('UOM'+'#REVERSE',"Sales\_Unit\_of\_Measure") | uomid |
| ##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid') | uomid |

_Note: In Business Central, the Sales\_Unit\_of\_Measure is a pre-defined picklist which will allow you to use only the available options. In D365 Sales, uomid is a GUID field and a 1:1 mapping is not possible._

  - Formula ##LSLOOKUP('UOM'+'#REVERSE',"Sales\_Unit\_of\_Measure") where the uomid is retrieved from an existing lookup table called UOM. This data is provided by a separate transfer which updates the link storage/lookup table called UOM.
  - Formula ##DBLOOKUP('DESTDS','uom','name','Primary Unit','uomid') where one lookup is made on the destination system in order to retrieve the uomid.