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
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
Please mark the answers verified if you satisfied with the answers or your problem got resolved.
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.
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?
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)..
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
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.
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
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 ?
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
Why don't you want to show the actual amount?
Martin Dráb
372
Most Valuable Professional
Abhilash Warrier
291
Saalim Ansari
209