Dynamics Community Forum Thread Details

Hello I am looking for guidance about what to do and where to look for data that we are mapping from an EDI translator into the VendInvoiceJournalLines entity in our test system. I am wandering if there are some required fields that we are not sending over? We do do not get any failures on the integration but we don't see the data, which we expect to be in the form of a non-posted invoice journal in this staging entity: LedgerJournalTable9

below are the feilds for the entity VendInvoiceJournalLines

{

"@odata.etag": "W/\"JzEsNTY0NDQzMDg2NzswLDA7MCwwOzAsMCc=\"",

"dataAreaId": "mc",

~~"JournalBatchNumber": "JB-0093769",~~

"LineNumber": 2,

"AccountDisplayValue": "7206005-01-21-200-",

"InvoiceDeclarationId": "",

"CashDiscountAmount": 0,

"UUID": "",

"OffsetFinTagDisplayValue": "",

"PostingProfile": "",

"Listcode": "IncludeNot",

"OffsetDefaultDimensionDisplayValue": "",

"ReportingCurrencyExchRate": 100,

"PaymId": "",

"AccountType": "Ledger",

"TermsOfPayment": "DUE",

"RemittanceAddressStreet": "",

"RemittanceAddressDistrictName": "",

"ExchRateSecond": 0,

"TransactionType": "Vend",

"ChineseVoucher": "",

"Tax1099Fields": 0,

"MethodOfPayment": "",

"ChineseVoucherType": "",

"AssetId": "",

"RemittanceAddressCity": "",

"ExchRate": 100,

"Document": "",

"Description": "",

"RemittanceAddressState": "",

"RemittanceAddressZipCode": "",

"Invoice": "776809365",

"DeliveryDate": "1900-01-01T12:00:00Z",

"RemittanceAddressCounty": "",

"Date": "2025-09-07T12:00:00Z",

"RemittanceAddressLocationId": "",

"Voucher": "AP0119915",

"ApproverNumber": "",

"Approved": "Yes",

"CashDiscount": "",

"TaxExemptNumber": "",

"Currency": "USD",

"ItemWithholdingTaxGroupCode": "",

"OffsetAccountType": "Ledger",

"InvoiceDate": "2025-09-06T12:00:00Z",

"BankAccountId": "",

"RemittanceAddressCountryISOCode": "",

"CashDiscountDate": "1900-01-01T12:00:00Z",

"Debit": 27.86,

"ImportedSalesTax": 0,

"OffsetCompany": "MC",

"DueDate": "2025-09-06T12:00:00Z",

"OverrideSalesTax": "No",

"RemittanceAddressTimeZone": null,

"RemittanceAddressDescription": "",

"Credit": 0,

"GSTHSTTaxType": "None",

"AssetTransType": "None",

"Company": "MC",

"RemittanceAddressValidFrom": "1900-01-01T00:00:00Z",

"CustVendBankAccountId": "",

"IsWithholdingTaxCalculate": "No",

"RemittanceAddressValidTo": "1900-01-01T00:00:00Z",

"OffsetAccountDisplayValue": "",

"SalesTaxGroup": "",

"DefaultDimensionDisplayValue": "",

"RemittanceAddressLatitude": 0,

"SalesTaxCode": "",

"FullPrimaryRemittanceAddress": "",

"ItemSalesTaxGroup": "",

"RemittanceAddressCountry": "",

"FinTagDisplayValue": "",

"OffsetTransactionText": "",

"TypeOfOperation": "Blank",

"BookId": "",

"PaymentSpecification": "",

"RemittanceAddressLongitude": 0,

"ITMCostTypeId": "",

"ITMCostArea": "Shipment"

Categories:

Dynamics 365 Finance

Community site session details

Vendor Invoice Data not showing after inbound integration

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates