web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer Opening Balan...
Microsoft Dynamics AX (Archived)

Customer Opening Balance, Debit and Credit

(0) ShareShare
ReportReport
Posted on by ThivaKar 931

Hi All,

Would someone please explain me how is the Customer Opening Balance is calculated?

In which Table Opening Balance , debit and credit amounts are stored?

I have a issue in customer balance report. The Closing Balance is calculated as Opening Balance + Debit - Credit.

If i understood how the Opening Balance , Debit and Credit are calculated for a customer, it will be really helpfull.

Does the closing balance should match the sum of the AmountMST in the CUSTTRANS Table.?

Please give me some idea about this.

Thanks,

Rusty

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Rusty,

    The data that is shown in the customer balance list report comes from the CustProvisionalBalanceTmp table.

    That's a temporary table that is calculated at runtime.

    Additional details on how the balance is calculated can be found in the CustBalanceList class, which is doing the calculation once the report is run.

    Best regards,

    Ludwig

  • Brandon Wiese Profile Picture
    Brandon Wiese 17,788 on at

    The current balance for a customer account is always the sum of AmountMST in table CustTrans for that customer.  The balance at the end of any transaction date is the sum of all transactions on/before that date.

  • ThivaKar Profile Picture
    ThivaKar 931 on at

    Hi,

    Thanks for the heads up! Now, it makes sense after i checked the CustProvisionalBalanceDP class.

    I have a small doubt here. We run the report by selecting BillingClassfication (F-CRN,F-INV).

    There is sum of AmountMST which is 73929.12 in the CustTrans Table for

    CustTrans.CustBillingClassification = 0 and sum of AmountMST which is 189929.12 CustTrans.CustBillingClassification = recid(F-CRN) and sum of AmountMST which is -23928.12 CustTrans.CustBillingClassification = recid(F-INV).

    My doubt is,

    1. there shouldn't be any AmountMST for CustTrans.CustBillingClassification = 0 ?

    2. from where the CustBillingClassification records are inserted in CustTrans?

    Please Help.

  • ThivaKar Profile Picture
    ThivaKar 931 on at

    We have Transactions for few of the customers without  Billing Classiffication.(CustTrans.CustBillingClassification = 0)

    Should these transaction be included for the Customer Closing Balance?

  • ThivaKar Profile Picture
    ThivaKar 931 on at

    Hi Crispin,

    If i understood correctly ,then I have to customize the Contract class to include these transactions? right?

  • ThivaKar Profile Picture
    ThivaKar 931 on at

    Hi,

    In the DP Class, Only for the two different postings, Free text invoice(F-INV) and credit notes(F-CRN) are calculated as i see.

    The buffer brings CustTrans.CustBillingClassification = 0 records, but it is not calculated. Only these two are calculated and it generates in report

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans