Skip to main content

Notifications

Business Central forum
Answered

AP Postings with multiple line items to same GL

Posted on by 10

We are trying to post AP invoices with coding similar to following example:

We received a bill for telephone expense totaling $500 - for 3 different phone lines. We would like to separate the charges by phone line for reconciliation purposes. 

We would post the AP invoice as such:

DR. Telephone Expense $140 (phone line #1)

DR. Telephone Expense $200 (phone line #2)

DR. Telephone Expense $160 (phone line #3)

         CR. Accounts Payable $500

Once this is posted and we navigate to the Telephone Expense GL the entry only shows as a total of

DR. Telephone Expense $500.

Is there anyway to change the entry from combining itself? We've encountered the same issue with AR Sales Invoices. 

Categories:
  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,590 on at
    RE: AP Postings with multiple line items to same GL

    You can make use "Additional Grouping Identifier" in Invoice Posting Buffer  to populate the line no and group based on it.

    Create below 2 subscriber function , one for AR and one for AP

    codeunit 50110 "Subscriber Codeunit"
    {
    //For AR Posting
    [EventSubscriber(ObjectType::Table,Database::"Invoice Post. Buffer",'OnAfterInvPostBufferPrepareSales','', true, true)]
    procedure GroupSalesBuffer(var InvoicePostBuffer: Record "Invoice Post. Buffer";
    var
    SalesLine: Record "Sales Line")
    begin
    InvoicePostBuffer."Additional Grouping Identifier" :=
    format(SalesLine."Line No.", 0, 2);
    end;

    //For AP Posting
    [EventSubscriber(ObjectType::Table,Database::"Invoice Post. Buffer",'OnAfterInvPostBufferPreparePurchase','', true, true)]
    procedure GroupPurchBuffer(var InvoicePostBuffer:Record "Invoice Post. Buffer";
    var
    PurchaseLine: Record "Purchase Line")
    begin
    InvoicePostBuffer."Additional Grouping Identifier" :=
    format(PurchaseLine."Line No.", 0, 2);
    end;


    }
  • LTaranoff Profile Picture
    LTaranoff 10 on at
    RE: AP Postings with multiple line items to same GL

    Thank you - do you have any information on the customization required until wave 2 is released?

  • LTaranoff Profile Picture
    LTaranoff 10 on at
    RE: AP Postings with multiple line items to same GL

    Thank you - this only seems to work if your dimensions are different for each line item - which isn't always the case.

  • jcastro Profile Picture
    jcastro 2,245 on at
    RE: AP Postings with multiple line items to same GL

    If you use the dimensions feature the GL Entries created should be split, so that might help you.

  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,590 on at
    RE: AP Postings with multiple line items to same GL

    This feature to split per line will be released in Release Wave 2

    https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/carry-line-descriptions-general-ledger-entries-when-posting

    If you need it now , you need to customize a bit for the posting process to group per line.

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,502 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Featured topics

Product updates

Dynamics 365 release plans