133
Hi,
In the vendTrans table, both debit and credit are stored in amountCur.
Example:
Debit: -10 and -20, which means that it's on the left side.
Credit: 50 (this is on the right side)
When I add all the debit, it also includes the credit: 50, which gives the total -80.
How should I compute the debit (-30) only?
Thanks!!
*This post is locked for comments
Hello Marykate,
AX usually calculates debit values as positive numbers and credit values as negative numbers.
The negative debit amounts of -10 and -20 are actually credits that add to the existing -50 credit that you have resulting in a total of -80.
What is the issue with the -30 and what do you want to calculate and where exactly (in the AX client, Excel, AOT tables, ... )?
Would be great if you could clarify.
Many thanks and best regards,
Ludwig
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
Share
Report
All responses (
Answers (