Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / AP Postings with multi...
Business Central forum

AP Postings with multiple line items to same GL

(0) ShareShare
ReportReport
Posted on by LTaranoff 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:
Purchasing
  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,594 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,594 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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans