How to Create API with Header and line data & Auto-Posting APIs in Business Central

-

 1. Creating a Custom API Page

  • Define PageType = API

  • Required API properties (APIPublisher, APIGroup, APIVersion, EntityName, etc.)

  • Create Purchase Order header API

  • Add subpage for lines













API: https://api.businesscentral.dynamics.com/v2.0/<EnvironmentName>/api/<APIPublisher>/<APIgroup>/v2.0/companies(<CompanyId>)/purchaseorderapis?$filter=no eq 'PR-ORD-0017869'&$expand=purchaseorderlineapis

Method: GET

Response: Get header and line response.
























3. Creating an API to Post Purchase Orders

  • Business scenario: Convert PO → Posted Purchase Invoice

  • Create global function with [serviceEnabled].

API:
https://api.businesscentral.dynamics.com/v2.0/<EnvironmentName>/api/<APIPublisher>/<APIgroup>/v2.0/companies(<CompanyId>)/purchaseorderapis(<systemidfrompurchaseheader>)/Microsoft.NAV.Createpurchaseinvoice

Method: post

    [ServiceEnabled]
    [Scope('Cloud')]
    procedure Createpurchaseinvoice(): Text
    var
        PostedInvNo: Code[20];
    begin
        PostedInvNo := CreateInvoiceFromPO(Rec."No.");
        exit('Posted Doc No. ' + PostedInvNo);
    end;

procedure CreateInvoiceFromPO(PONo: Code[20]): Code[20]
    var
        PurchHeader: Record "Purchase Header";
        PurchPost: Codeunit "Purch.-Post";
        PostedInv: Record "Purch. Inv. Header";
    begin
        if not PurchHeader.Get(PurchHeader."Document Type"::Order, PONo) then
            Error('Purchase Order %1 not found.', PONo);

        UpdateQtyToInvoice(PurchHeader);
        PurchHeader.Invoice := true;
        PurchHeader.Modify();

        PurchPost.Run(PurchHeader);

        PostedInv.Reset();
        PostedInv.SetRange("Order No.", PONo);
        if PostedInv.FindLast() then
            exit(PostedInv."No.")
        else
            Error('No posted invoice created for %1', PONo);
    end;




This way you can easily post order.

Thank you
Dharmendra Chavda

Comments

Post a Comment

Popular posts from this blog

Run a Dynamics 365 Plugin from JavaScript on Button Click

-
Image
Trigger a Dynamics 365 Plugin from JavaScript on Button Click In Dynamics 365, plugins usually run when system events happen — like creating, updating, or deleting a record. But in some cases, you might want to run a plugin only when the user clicks a button on a form. This blog will guide you step by step on how to trigger a Dynamics 365 plugin from JavaScript using a Custom Action and a Plugin. Steps to call a plugin from JavaScript   Create a Custom Action Open Advanced Settings → Solutions (or open the specific solution where you want to add the action). Click New in the top menu. Choose Automation → Process. From the process types, pick Action — use an Action when you want to call plugins or custom logic from JavaScript, workflows, or Power Automate. Once you click on Action a Quick Create Process form will open and fill details. After that below form is open and you can update process argument as below. And Activate process. 2. Register the Plugin on the Acti...
Read more

Power Apps Portal: How to Display Tooltips on a Form

-
Image
In this article, I will explain how to display tooltips in a Power Apps Portal (Power Pages) form . Tooltips are a simple yet powerful way to improve user experience in Power Apps Portal (Power Pages) . In this post, I’ll explain how to display tooltips on portal forms using Dataverse field descriptions . 🧩 What is a Tooltip? A tooltip is shown when a user hovers over a field label. In Power Pages, this tooltip comes directly from the Description property of a Dataverse column. Step 1: Add Descriptions to Dataverse Columns. I used an existing Dataverse table named Order and added descriptions to the required columns.  These descriptions will be used as tooltip text in the portal. Step 2: Update the Main Form Open the Order Main Form Add the required fields Save and publish the form Step 3: Configure Basic Form and Web Page Create or update a Basic Form that uses the Order Main Form Attach the Basic Form to a Web Page in the portal Step 4: Enable Tooltips on the Basic ...
Read more

Document Attachment with Item Journal Table in Business Central

-
Image
Business Central already provides the Document Attachment framework, but sometimes you need to extend it to work with additional tables. In this blog, I’ll show you how I extended the Document Attachment functionality to support the Item Journal Line table. By the end, you’ll be able to attach documents (like invoices, PDFs, or scanned files) directly to item journal lines and view them from the journal page. Step 1: Extend the Document Type First, extend the Document Type in the Document Attachment table to include a new option for Item Journal . This makes it possible to tag an attachment specifically for an item journal line. enumextension 50500 "Attachment Dc" extends "Attachment Document Type" {     value ( 50500 ; "Item Journal" )     {         Caption = 'Item Journal' ;     } } Step 2: Add Template Name and Batch Name Fields The standard Document Attachment table doesn’t store the  Template Name  and ...
Read more