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 / 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
I have the same question (0)
  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,600 on at

    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.

  • jcastro Profile Picture
    jcastro 2,245 on at

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

  • LTaranoff Profile Picture
    LTaranoff 10 on at

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

  • LTaranoff Profile Picture
    LTaranoff 10 on at

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

  • Suggested answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,600 on at

    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;


    }

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 > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans