How to do Basic Calculations?

New Here ,
Mar 22, 2021 Mar 22, 2021

Copy link to clipboard

Copied

Hello,

 

I have invoices here that I'm trying to stamp. Typically when I stamp these, I have to put down the amount that we actually pay (total - discount). 

 

The issue is that these invoices are for the full amount and do not take into consideration the 2% discount. This leads me having to go through hundreds of invoices and manually calculate the discounted total to record on the stamp. I've tried doing form calculations but have had no luck as Adobe does not recognize the total amounts as "Fields" so I cannot simply do a field calculation. Any ideas on how to do this faster? A simple script that can take a value on a page and automatically apply the discount to a different field?

 

Thank you in advance!

TOPICS
Edit and convert PDFs, General troubleshooting, How to, JavaScript, PDF forms, Scan documents and OCR

Views

79

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 22, 2021 Mar 22, 2021

Copy link to clipboard

Copied

Hi Christian,

 

Would you be able to share an example of that PDF?

 

This may be achieved with some JavaScript or in combination with some of Acrobat's built-in features.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 22, 2021 Mar 22, 2021

Copy link to clipboard

Copied

Hello,

 

I've attached a sample invoice.

 

On this one, the total on the bottom is 274.95. The amount that would be stamped would be 269.45 (274.958*.98) to account for the discount. 

 

Thanks again!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Most Valuable Participant ,
Mar 22, 2021 Mar 22, 2021

Copy link to clipboard

Copied

LATEST

This can be done using a script, but it's not simple, since we're dealing with static text.
If the files all follow the same pattern then it should be possible, though, but will require the development of a custom-made script. If you're interested I could create it for you, for a fee. You can contact me privately via [try6767 at gmail.com] to discuss it further.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines