Dynamics 365 CommunityForums Finance forum Get Debit amount, Cred...

Suggested answer

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

(2) Share

Report

Report

Posted on by Hisham Alsayed

723

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

Thanks,

H

Attachments

All responses Img

All responses (4)

Answers Img

Answers (0)

Hisham Alsayed 723 on at

Like (0)

Report

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

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
Suggested answer

rajborad 97 on at

Like (0)

Report

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

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
Hisham Alsayed 723 on at

Like (0)

Report

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

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
Suggested answer

Mohamed Amine Mahmoudi 3,684 User Group Leader on at

Like (0)

Report

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

Hi @Hisham,

there a field AmounCur

if AmountCur < 0 then Credit else Debit

Best regards,

Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Leaderboard

Andre Arnaud de Cal... 283,176 Super User

Martin Dráb 222,727 Super User

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans