You’re offline. This is a read only version of the page.
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.
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
Share
Report
All responses (
Answers (
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;}
This feature to split per line will be released in Release Wave 2
If you need it now , you need to customize a bit for the posting process to group per line.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,900
Super User 2024 Season 2
#2
Martin Dráb
229,297
Most Valuable Professional
#3
nmaenpaa
101,156