2,985
Hello Experts,
How to calculate the posted payment journal using SQL joins.
The query output should give the exact report data.
Multiple querying on the custtrans , not giving the exact output.
Hello Experts,
How to calculate the original amount , payment amount and cash discount in customer posted payment journal.
Hi Gunjan,
I am looking for the customer payment current amount, cash discount taken specific to the customer.
It's the standard customer posted payment journal report, where I should show all the data using SQL query.
Hi Pravasti,
Are you looking for total amount in a posted payment journal? Or are you looking for the total payment amount for a particular customer?
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
231,994
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
