Small and medium business | Business Central, N...

Getting the GL Account from Purchase Lines AL

(0) Share

Report

Posted on by Romryan

Hi all,

I need to get the GL account from each of the existing purchase lines that have TYPE item. With this GL account, I will be able to sum the amount per GL Account.

Any idea in AL?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 98,026 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, no GL Account is included on the Item Master. But if you want to get Purch. Account in General Posting Setup, you can get Gen. Bus. Posting Group in Vendor master, and get Gen. Prod. Posting Group in Item Master, then using these two data, you can get the GL account here.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

As Yun noted, I would create a Jet Report to search all Posted Purchase Invoices and report back only those Invoices with Type = Item and then show the Vendors - Gen. Bus. Posting Group and the Items Gen. Prod. Posting Group on the line. Then take the combination and lookup the General Posting Setup for the Purchase Account and show the G/L Account value.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No