Share
ReportHi 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?
You’re offline. This is a read only version of the page.
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?
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
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
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (