Tracelink University ## Breadcrumb 1. [Home](/) 2. [Resources](/resources/resource-center) 3. [TraceLink University](/resources/tracelink-university) # Posted sales invoice inbound Link Action Transactions - [Download PDF](/node/627991/pdf) - [Share](#) - [ LinkedIn ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.tracelink.com/resources/tracelink-university/posted-sales-invoice-inbound-link-action-transactions&title=Posted sales invoice inbound Link Action Transactions&summary=The Link Action Posted Sales Invoice in an ERP system records the details of a completed sales transaction. &source=TraceLink "LinkedIn") - [ Facebook ](https://www.facebook.com/share.php?u=https://www.tracelink.com/resources/tracelink-university/posted-sales-invoice-inbound-link-action-transactions&t=Posted sales invoice inbound Link Action Transactions "Facebook") - [ Mail ](mailto:?subject=Posted sales invoice inbound Link Action Transactions+|+TraceLink&body=https://www.tracelink.com/resources/tracelink-university/posted-sales-invoice-inbound-link-action-transactions "Mail") - [ Twitter ](https://twitter.com/intent/tweet?text=Posted sales invoice inbound Link Action Transactions https://www.tracelink.com/resources/tracelink-university/posted-sales-invoice-inbound-link-action-transactions&via=TraceLink "Twitter") #### Table of contents The Link Action Posted Sales Invoice in an ERP system records the details of a completed sales transaction. Posted sales invoice serves as a formal billing document issued by the seller to the customer, confirming the sale of goods or services and requesting payment. ## MS Dynamics Business Central ERP The following are the MS Dynamics Business Central ERP attributes that are mapped with the Canonical attributes and their output path. - **Transform Name**: - STD\_MSDynamics\_Business\_PostedSalesInvoice\_IB [![Closed](/sites/default/files/tech_comms/mpl/Skins/Default/Stylesheets/Images/transparent.gif)Guidelines](#) MS Dynamics Field Input Element Mapped Canonical Path Target Output Element Mapping Rules @odata.context – – – @odata.etag – – – id – – – number `data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList` b2bTransactionIdentifierValue Where b2bTransactionIdentifierType= INVOICE externalDocumentNumber `data/messageBody/canonicalInvoiceHeader/transactionReferenceIdentifierList` b2bTransactionIdentifierValue Hard code "PURCHASEORDER" to target instance of transactionReferenceIdentifierList invoiceDate `data/messageBody/canonicalInvoiceHeader/invoiceDates` `data/messageBody/canonicalnvoiceHeader / transactionReferenceIdentifierList` dateValue transactionDate where dateType= "INVOICE" where b2bTransactionIdentifierType = INVOICE postingDate – – – dueDate – – – promisedPayDate – – – customerPurchaseOrderReference – – – customerId – – – customerNumber `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue where companyIdentifierType = COMPANYID customerName `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation` businessName – billToName `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation` businessName – billToCustomerId – – – billToCustomerNumber `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue where companyIdentifierType = COMPANYID shipToName `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation` businessName – shipToContact `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/companyLocationContactInformation` contactName – sellToAddressLine1 – – – sellToAddressLine2 – – – sellToCity – – – sellToCountry – – – sellToState – – – sellToPostCode – – – billToAddressLine1 `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` address1 – billToAddressLine2 `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` address2 – billToCity `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` city – billToCountry `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` country – billToState `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` state – billToPostCode `data/messageBody/canonicalInvoiceHeader/billToBusinessInformation/address` postalCode – shipToAddressLine1 `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address` address1 – shipToAddressLine2 `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address` address2 – shipToCity `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address ` city – shipToCountry `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address` country – shipToState `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address` state – shipToPostCode `data/messageBody/canonicalInvoiceHeader/shipToLocationInformation/address ` postalCode – currencyId – – – shortcutDimension1Code – – – shortcutDimension2Code – – – currencyCode `data/messageBody/canonicalInvoiceHeader/invoiceCurrency` currencyCode – orderId – – – orderNumber `data/messageBody/canonicalInvocieHeader/transactionReferenceIdentifierList` b2bTransactionIdentifierValue Hard code "ORDERNUMBER" to target instance of transactionReferenceIdentifierList paymentTermsId – – – shipmentMethodId – – – salesperson – – – disputeStatusId – – – disputeStatus – – – pricesIncludeTax – – – remainingAmount – – – discountAmount `data/messageBody/canonicalInvoiceHeader/creditsAndCharges` creditChargeAmount Where creditChargeType= DISCOUNT discountAppliedBeforeTax – – – totalAmountExcludingTax – – – totalTaxAmount – – – totalAmountIncludingTax – – – status – – – lastModifiedDateTime – – – phoneNumber – – – email – – – shipToAddressLine1 `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` address1 – shipToAddressLine2 `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` address2 – shipToCity `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` city – shipToCountry `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` country – shipToState `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` state – shipToPostCode `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/address` postalCode – customerNumber `data/messageBody/canonicalInvoiceHeader/remitToBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue where companyIdentifierType = COMPANYSITEID customer – @odata.etag – – – id – – – number `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue where companyIdentifierType = COMPANYID displayName `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation` businessName – type – – – addressLine1 `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` address1 – addressLine2 `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` address2 – city `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` city – state `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` country – country `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` state – postalCode `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/address` postalCode – phoneNumber `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation` contactPhone – email `data/messageBody/canonicalInvoiceHeader/customerBusinessInformation/companyLocationContactInformation` contactEmail – website – – – salespersonCode – – – balanceDue – – – creditLimit – – – taxLiable – – – taxAreaId – – – taxAreaDisplayName – – – taxRegistrationNumber – – – currencyId – – – currencyCode – – – paymentTermsId – – – shipmentMethodId – – – paymentMethodId – – – blocked – – – lastModifiedDateTime – – – currency – – – dimensionValue – – – paymentTerm – @odata.etag – – – id – – – code `data/messageBody/canonicalInvoiceHeader/termsOfPayment` paymentTermCode – displayName – – – dueDateCalculation – – – discountDateCalculation – – – discountPercent `data/messageBody/canonicalInvoiceHeader/termsOfPayment` termsOfPaymentPercent – calculateDiscountOnCreditMemos – – – lastModifiedDateTime – – – shipmentMethod – – – dimensionSetLines – @odata.etag – – – id – – – code – – – consolidationCode – – – parentId – – – parentType – – – displayName – – – valueId – – – valueCode – – – valueConsolidationCode – – – valueDisplayName – – – salesInvoiceLines – – @odata.etag – – – id – – – documentId – – – sequence `data/messageBody/canonicalInvoiceItemDetails` lineItemNumber – itemId – – – accountId – – – lineType – ITEM Hard Code to ITEM lineObjectNumber `data/messageBody/canonicalInvoiceItemDetails/productCodesIdentifiers` productCodeValue productCodeType=VENDOR description `data|messageBody/canonicalInvoiceItemDetails/productItemInformation` productDescription Add Same Value in productName field too description2 – – – unitOfMeasureId – – – unitOfMeasureCode `data/messageBody/canonicalInvoiceItemDetails/additionalItemInformation data/messageBody/canonicalInvoiceItemDetails/itemQuantity ` unitOfMeasure Only Each and Case are allowed quantity `data/messageBody/canonicalInvoiceItemDetails/itemQuantity` quantityValue quantityType = INVOICE unitPrice `data/messageBody/canonicalInvoiceItemDetails/invoicePricing` pricingAmount where pricingType=UNIT discountAmount `data/messageBody/canonicalInvoiceItemDetails/creditsAndCharges` creditChargeAmount where creditChargeType= DISCOUNT discountPercent `data/messageBody/canonicalInvoiceItemDetails/creditsAndCharges` creditChargePercentRate – discountAppliedBeforeTax – – – amountExcludingTax – – – taxCode – – – taxPercent – – – totalTaxAmount – – – amountIncludingTax – – – invoiceDiscountAllocation – – – netAmount `data/messageBody/canonicalInvoiceItemDetails/invoicePricing` pricingAmount where pricingType=NET netTaxAmount – – – netAmountIncludingTax `data/messageBody/canonicalInvoiceItemDetails/invoicePricing` pricingAmount where pricingType=TOTAL shipmentDate – – – itemVariantId – – – locationId – – – vendor @odata.context – – – id `data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation/mpcCompanyLocationIdentifierList` companyIdentifierValue companyIdentifierType=COMPANYID systemVersion – – – timestamp – – – name – – – displayName `data/messageBody/canonicalInvoiceHeader/supplierBusinessInformation` businessName – businessProfileId – – – systemCreatedAt – – – systemCreatedBy – – – systemModifiedAt – – – systemModifiedBy – – – ![](/sites/default/files/tech_comms/mpl/Content/Resources/Images/global_images/note_tip_24x24.png) Review TraceLink's [API: Terms of Use](https://www.tracelink.com/legal-and-trust/api-terms-of-use) #### Table of contents ##### Related Content [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-idoc) ##### Forecast plan (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-idoc) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-x12) ##### Forecast plan (X12) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with upstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-x12) [ ![Related content](https://www.tracelink.com/sites/default/files/2024-09/cloud.svg) ](/resources/tracelink-university/forecast-plan-response-idoc) ##### Forecast plan response (IDoc) Forecasting APIs allow companies to exchange data about anticipated product demand and supply availability with downstream supply chain Partners without giving these Partners access to their serialization system of record. [View More](/resources/tracelink-university/forecast-plan-response-idoc)