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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Customer Transactions Entity

(0) ShareShare
ReportReport
Posted on by 177

Hi there, I got an requirement to create a new Data entity for Customer Transactions. I have added all the fields as per the requirement but couldn't able to add the Balance Transaction Currency and Balance Local Currency fields from CustTrans form. I have created 2  Real Unmapped fields and tried to add similar logic what was there in CustTrans table for those fields. But, when exporting the values are coming as null. Please find the details mentioned below and suggest accordingly.

path : Accounts Receivable > All Customer > Select Customer > Transactions

I need to capture the Balance Transaction currency and Balance Local Currency fields as mentioned below

pastedimage1651732310529v1.png

These two fields are Display methods in CustTrans Table. I need to fetch these values in my new Data Entity. The logic i tried for the same is mentioned below in the Entity's Postload().

pastedimage1651732486089v2.png

  • The above logic is returning me null values but in the form i can see the values.
  • Please suggest what i need to change so fetch the values as per Customer Transactions Form
  • remainAmountCur() and remainAmountMST() methods are present in CustTrans Table and those are the methods behind those fields in the form which i need to fetch in Data Entity

Thanks,

Prem

I have the same question (0)
  • Martin Dráb Profile Picture
    237,882 Most Valuable Professional on at

    Use the debugger to find out where your code fails. First of all, do you have any data in your custTrans variable?

  • PK69 Profile Picture
    177 on at

    Hi Martin, yes custTrans  is the variable of CustTrans Table and we have data in that Table.  When i debugging the code, it is processing as per the flow only. It passes through CustTrans table first and then to CustVendTransData class and there the calculation logic was present and it calls variables from CustVendTrans Map. When i open that CustVendTrans Map in table browser there is  no data. please suggest where to check

  • Martin Dráb Profile Picture
    237,882 Most Valuable Professional on at

    Please check whether your code assigns values to those CNLGCMBalance* fields. If it does, your problem is somewhere else. If it doesn't, debug one of those functions, such as remainAmountCur(), to find out why it returns zero.

    Maps don't store any data. They are used for writing common logic, e.g. you can use CustVendTrans in your code and then use it for either CustTrans or VendTrans.

    Note that I don't understand what you mean by "it is processing as per the flow only".

  • AnithaEswaran Profile Picture
    2,032 on at

    Hi Prem,

    Can you try a simple job and initiate CustTrans to check if this method returns a value.

    This would help you to troubleshoot your issue.

  • PK69 Profile Picture
    177 on at

    Hi Anitha, i have tried with the job and custtrans.remainAmountCur() is  returning 0 only.

  • AnithaEswaran Profile Picture
    2,032 on at

    Can you try this statement in the job directly

    Initialise CustTransBuffer;

    return CustTransBuffer.transData().remainAmountCur();

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans