Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Changing value in factBox Pan in invoice

(0) ShareShare
ReportReport
Posted on by 3,110

changinging-value-in-factboxpane.png

Dear Experts,

How can i change values in FactBox pan on invoices Form as shown in the above image. Please show your valuable views.

Best Regards,

Shabir Ahmad

  • Jay Barot Profile Picture
    1,502 on at
    RE: Changing value in factBox Pan in invoice

    Please mark the answers verified if you satisfied with the answers or your problem got resolved.

  • Suggested answer
    Jay Barot Profile Picture
    1,502 on at
    RE: Changing value in factBox Pan in invoice

    Hi Shabir,

    You can change the values in the factbox as these values are calculated values from your data in tables. In your case data is coming from vendinvoiceinfotable table and PurchTotal class (in class methods are written get the desired values for each field) is used for factbox.  

    I hope your doubt is clear. As Nikolas has suggested, do not try to change anything through job.

  • Suggested answer
    nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: Changing value in factBox Pan in invoice

    Anyway, here's how to fulfill your requirement.

    First, you need to find out where are the definitions of the FactBoxes that you want to change.

    You can find them in the main form definition, in Parts. There are three parts:

    Once you find the parts, go to AOT - Parts - Form parts and locate the part definitions. In the definition you see property "Form" which tells which AOT form it's using. Then find that form in AOT, find the field that you want to change and change property NoOfDecimals to 0.

    That would show it without decimals. But if you want to show "123.00" instead of "123.22" even when the amount is 123.22 you might need to develop a display method that changes the number for you. But I honestly can't understand why you would like to show wrong information on the FactBox. You should either show the actual decimals, or no decimals. Showing wrong decimals is wrong in my opinion. I suggest to check with the customer if they really want to show wrong data or a rounded value.

    If you need more detailed help, could you share the AOT name of the form that you shared in your first screenshot?

  • nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: Changing value in factBox Pan in invoice

    No, you should not attempt to update any data with a job.

    Your requirement only concerns how the data is displayed in this one place (as far as I understand, correct me if I'm wrong)..

  • Shabir Ahmad Profile Picture
    3,110 on at
    RE: Changing value in factBox Pan in invoice

    Hi Michal Krejza,

    So you mean to say, i should write code in the job and that job changes the amount??

    Best Regards,

    Shabir Ahmad

  • Suggested answer
    Michal Krejza Profile Picture
    on at
    RE: Changing value in factBox Pan in invoice

    Hi Shabir,

    In general you can achieve this by rounding setup on Currencies and on Sales tax code. But I assume you want to change amounts only on this particular FactBox - in this case you have to customize it. There's no other standard MS solution.

  • Shabir Ahmad Profile Picture
    3,110 on at
    RE: Changing value in factBox Pan in invoice

    Hi Michal krejza,

    I want to change only numbers after . Point for example if it is 11.3400 I need 11.0000 this is my requirement.

    Best regards,

    Shabir Ahmad

  • Michal Krejza Profile Picture
    on at
    RE: Changing value in factBox Pan in invoice

    Hi Shabir,

    I am not sure I understand correctly your requirement. Do you want to manually adjust fields in FactBox ? Or just format the number format in FactBox to not display decimal digits ? 

  • Shabir Ahmad Profile Picture
    3,110 on at
    RE: Changing value in factBox Pan in invoice

    Hi Nikolaos Mäenpää,

    I just want to show in that manner from where i could  do this. If you have any idea ??

    Best Regards,

    Shabir Ahmad

  • nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: Changing value in factBox Pan in invoice

    Why don't you want to show the actual amount?

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
Martin Dráb Profile Picture

Martin Dráb 372 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 291

#3
Saalim Ansari Profile Picture

Saalim Ansari 209

Overall leaderboard

Product updates

Dynamics 365 release plans