Finance | Project Operations, Human Resources, ...

Get Debit amount, Credit amount and balance amount for customer statement

(1) Share

Report

Posted on by Hisham Alsayed

756

Hi everyone,
Any idea how can i get debit amount, credit amount , balance amount from Custtrans/custtransopen tables using X++

Thanks,

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,811 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Hisham,

there a field AmounCur

if AmountCur < 0 then Credit else Debit

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Hisham Alsayed 756 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

Thanks for your reply i understand now but do you have x++ for that or try it in real case and what about the balance amount how can i get it?

Thanks,

Hisham

Was this reply helpful? Yes No
Suggested answer

Raj Borad 1,578 on at

Like (0)

Report
Copy link

Link copied!

Hi Hisham,

Here is your answer.

Pls, mark the reply as a verified answer.

AmountMST credit = 0,debit = 0,balance = 0;
CustTrans custTrans;
while Select custTrans where custTrans.AccountNum == "AsPerYourRequirement" // customer account
{
   if(custTrans.SettleAmountMST > 0)
   {
       credit += custTrans.AmountMST;
   }
   else
   {
       debit += custTrans.AmountMST;
   }
}
// Total credit and debit of Customer
balance = credit - debit;

Thank you,

Raj D Borad

Was this reply helpful? Yes No
Hisham Alsayed 756 on at

Like (0)

Report
Copy link

Link copied!

Hi Raj,

Many thanks on your reply, let me try it and will update you for balance is it credit - debit or debit - credit because customer natural account is debit i need to ensure from this part

Also, why do you settlementamountmst and do not use AmountCur

did you use or try this code before

Thanks

H

Was this reply helpful? Yes No