You’re offline. This is a read only version of the page.
480
Hi,
Can anyone help me please ,I want to calculate the flowfield Balance of the table Vendor with SQL but really I didn't know how.
thnks in advance
*This post is locked for comments
Hi,
Balance (LCY) comes from the same detailed vendor ledger entry table and field name is "Amount (LCY)". you can use the same criteria to get this field amount.
Regards,
Saurabh Shah
Do you mean to have a opening balance , current balance and closing balance?
if it is like that then you need to add filter on posting date of detailed vendor ledger entry.
Let me know your details if finding any thing more.
Regards,
Saurabh Shah
Hi ,
Please find below script for your reference:
select [Vendor No_] ,SUM([Amount])as Amount,[Currency Code] , SUM([Amount (LCY)]) as LCY from [CRONUS USA, Inc_$Detailed Vendor Ledg_ Entry] group by [Vendor No_] , [Currency Code]
Here "CRONUS USA, Inc_" is the company name.
Regards,
Saurabh Shah
Hi,
Balance field of Vendor table is the sum of "Amount" field from the "Detailed Vendor Ledg. Entry" table.
Filters are Vendor number , Global dimension 1, Global dimension 2 and Currency Code.
Regards,
Saurabh Shah
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,228
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (