Posting data to business central

Kayode Ogidan 60 Reputation points
2024-06-24T17:12:37.7066667+00:00

Hello, @Harishga I am working on posting data to Business Central. There are two destinations for the posting of the data

In this screenshot, the page, Purchase Invoices is pulling data from the Purchase Header table, the link between the purchase header and the Purchase Lines is the invoice ID I can get from individual invoices per CSV file. So to post the data in one run for both the header and files, I split this into two phases.

Phase one: Get the data from the CSV files, perform initial data cleansing and extraction, and load it into a temporary table in Business Central. The posting is at a purchase invoice line level This already works.

Phase Two: Get the data from the temporary table and post it to the final header and line tables. I have created web services containing OData URLs in Business Central, and I have referenced them to the final Purchase Header and Purchase Lines table. How do I post data to the Purchases Invoices page? Am I to post to the table it self so the Purchase Invoices page can reference the table? or use a page API that will be posting to the Page itself? Also, another thing is the No. field is autogenerated based on row inserts, do I have to specify this in my code for the page API or leave it out as it is an auto-generated field by Business Central? Please advise as always. Thank you!
Screenshot 2024-06-24 130035

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,561 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kiran P 1,805 Reputation points Microsoft Vendor
    2024-06-25T06:13:42.54+00:00

    Hi Kayode Ogidan,

    Thank you for reaching out to us on the Microsoft Q&A forum.

    This topic is currently not supported in the Q&A forums.

    I recommend initiating a new discussion through the https://community.dynamics.com/

    Moderators are readily available there to assist you and provide guidance.

    Please don't forget to Accept helpful answer and close this thread.

    0 comments No comments