Community

Creating a rule in FC 12 Document Definition that Divides Amount with Quantity in Invoice Table

Written by Mahmoud Mostafa

January 30, 2024 13:24
3

How can I create a rule that divides Amount value with Quantity to get unit price in Invoice table, Please Share the script for this case.

Was this article helpful?

0 out of 0 found this helpful

Comments

3 comments

Tatiana Dyu

February 02, 2024 09:44
Hello, you can create a script rule to calculate the unit price. Details about setting up the rule can be found in https://help.abbyy.com/en-us/flexicapture/12/distributed_administrator/rule_script/

A sample script in C# is below, but please note you may need to adjust it based on your settings and requirements.

double quantity = double.Parse( Context.Field( "Quantity" ).Text );
double totalPriceNetto = double.Parse( Context.Field( "TotalPriceNetto" ).Text );
double unitPrice = totalPriceNetto/quantity;
Context.Field( "UnitPrice" ).Text = unitPrice.ToString();

Thank you.
0
Mahmoud Mostafa

February 04, 2024 13:42
Hello , i tried a similar script that multiple two columns as shown in the below script:

double NetQuantity = double.Parse( Context.Field( "Quantity" ).Text );
double NetWeight = double.Parse( Context.Field( "Unit_weight" ).Text );
NetQuantity = NetQuantity*NetWeight;
Context.Field( "Quantity" ).Text = NetQuantity.ToString();

but there is issue as shown in attachment,please advise how to solve it

0
Tatiana Dyu

February 05, 2024 07:49
Hello, I am afraid we will need your project and some sample for further investigation. I have created a support ticket, my colleagues will reach out to you shortly. Thank you.

0

Please sign in to leave a comment.