You’re offline. This is a read only version of the page.
45
Hi Team,
Kindly help on the below.
I want to get the outstanding balance for a customer for a particular period. and the below table is used for the same.
Now the balance which is in customer statement and as per below query by running rate range is not tallying. Kindly help me to get the tables.
Sql Query
SELECT SUM(AMOUNTCUR) FROM CUSTTRANSOPEN WHERE ACCOUNTNUM = 'ABCCARGO'
AND TRANSDATE BETWEEN '2022-01-01' AND '2022-09-30'
Hi Bibin TV，
If you are using finance, it is recommended that you use the standard select statement:
Before you use a variable in this table, you need to declare it first.
Share
Report
All responses (
Answers (
