web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor Invoice Data no...
Finance | Project Operations, Human Resources, ...
Unanswered

Vendor Invoice Data not showing after inbound integration

(2) ShareShare
ReportReport
Posted on by BrookTadesse 51
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
I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,722 Most Valuable Professional on at
    Your entity is for invoice lines, while you're looking at journal headers. Are you sure that the header should be automatically created and it'll use the journal ID from the line?
     
    Also, that you don't see the record in a form doesn't necessarily mean that it doesn't exist. It may be filtered out from a form by a filter or join. Use the table browser to check whether the record is in the table.
  • BrookTadesse Profile Picture
    BrookTadesse 51 on at
    Martin, thanks for the response. I have verified that the batch jobs in the headers are automatically created by writing into the lines entity. I Don't see any records when looking in the table browser: 
     
  • Martin Dráb Profile Picture
    Martin Dráb 237,722 Most Valuable Professional on at
    You said that you got no error. But did the import told you that a record was created? Ideally, show us a screenshot of the result.
  • BrookTadesse Profile Picture
    BrookTadesse 51 on at
    Trying to post this JSON to this URL (again no error message but no records found in D365): 
     

    {"RemittanceAddressLocationId": "0000776809",

    "RemittanceAddressDescription": "MAZAK CORPORATION",

    "RemittanceAddressStreet": "10950 GREENBEND BLVD",

    "RemittanceAddressCity": "HOUSTON",

    "RemittanceAddressState": "TX",

    "RemittanceAddressZipCode": "770674461",

    "RemittanceAddressCountryISOCode": "US",

    "Currency": "USD",

    "Invoice": "776809145",

    "Company": "mc",

    "CashDiscountAmount": 0,

    "Credit": 0,

    "RemittanceAddressLatitude": 0,

    "RemittanceAddressLongitude": 0,

    "ImportedSalesTax": 0,

    "ExchRate": 100,

    "ExchRateSecond": 0,

    "Tax1099Fields": 0,

    "ReportingCurrencyExchRate": 100,

    "PostingProfile":"",

    "Listcode":"IncludeNot",

    "AccountDisplayValue":"0123456-01-01-123-",

    "AccountType":"Ledger",

    "TermsOfPayment":"DUE",

    "TransactionType":"Vend",

    "Voucher":"AP0123456",

    "Approved":"YES",

    "OffsetAccountType":"Ledger",

    "OverrideSalesTax":"No",

    "GSTHSTTaxType":"None",

    "AssetTransType":"None",

    "IsWithholdingTaxCalculate":"No",

    "TypeOfOperation":"Blank",

    "ITMCostArea":"Shipment",

    "dataAreaId": "mc",

    "OffsetCompany": "mc",

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

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

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

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

    "Date": "2025-04-14T00:00:00Z",

    "InvoiceDate": "2025-04-14T00:00:00Z",

    "DueDate": "2025-04-14T00:00:00Z",

    "LineNumber": '1'

    }

     

    https://mazak-fo-test7d2327f71cf0e7c9devaos.axcloud.dynamics.com/data/VendInvoiceJournalLines

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 687 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 535 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 403 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans