I've got a document that we use for raising purchase orders, which adds up multiple form fields, adds GST and calculates totals, subtotals and the grand total of each field.
I was initially having issues with it working, but then realised I had to set all the calculation fields in the correct order. Which worked perfectly, at first.
My issue is, that after a month or two of use, this form breaks and stops adding up correctly, and the field calculation order is all over the place.
Problem fixed when I re-order them, which is easy enough. But i'm wondering if anyone might know why this is happening and if I can prevent it?
I am using Acrobat X Pro, and this form is read and filled in using either the same or Acrobat DC.
How does you change the calculation order?
I go in here and fix the field calculation order.
This is an example of the field calculations when they are in the correct order (I dont have an example from when its broken right now, i've just fixed it again today. But they just go totally out of order.)
This sequence repeats all the way up to 10 and then calculates the grand totals.
This is the correct way.
May be someone with Adobe Acrobat changes the form.
Save a backup of the form and use a copy of the backup.
That was my first thought too, but the original is kept on our quality management system and it is unable to be saved over/overwritten. So even if someone did mess with it, they couldn't save the changes.
When the form is used, they will take a copy of the original and fill it out etc.. But the original is the one that the calculations are breaking on.
I am at my wits end with figuring out what is causing it.
Check the modification date of the original.
Done that too. March 5th, last time I fixed it. I am the desktop publisher in my company, so the only one accessing this document.
This type of thing does not change on its own. Either someone changed it (maybe even unknowingly by opening the file in a non-compliant PDF viewer of some kind), or there's a script in the file that's changing it.
That's why it is so weird, it is possible I suppose, but unlikely as managers (who are sending/using the document) are using company assigned phones, laptops etc.. With acrobat installed/default for pdfs.
My only other thought is that this could possibly have to do with acrobat updating?
I'm suspecting the phones, as they tend to have all kinds of non-standard applications and also to save the files automatically. Is this file shared on a central location where you all access it from? If so, I would recommend setting it (and the folder where it's located) as read-only.
It is shared on the company network, which is run through paradigm 3 and that's the only way to update/change a document in the folder. So you cannot save over a document in there or manually move a document to the folder, but you can take a copy to use, which is then filled out, saved elsewhere and sent off. (I hope that made sense!)
Can you share the form?
I can attach a copy when I am back at work next week, don't have a copy with me at home.
Acrobat X is the worst version of Acrobat, from memory there was a bug in the order of calculation but it has been fixed, make sure to use the latest version available: 10.1.16
(Help menu : Check for updates)
It certainly is, it is the only version I have access to at the moment though unfortunately, I'm hoping to try and get DC company wide, which would be ideal.
I will have a look at the version when I am back in the office, I had thought it may be an updating issue? Either that it isn't updating, or somehow the updates are messing with the calculation order?
The form has been working again for a month, and now field calculations all out of order again, with seemingly no reason.
the GST is now calculating wrong, even with the same data inputted. I'll attach a screenshot of what I mean.
I have attached the copy that is having the issue, if anyone is interested in having a look to see what might be going wrong?
Why does you use many fields at the same place?
e.g. Total CostRow1 and 2Total CostRow1
Subtotal1 and 2Subtotal1
Depending on the item, the price may be entered as either including or excluding GST. But I need both figures to be present regardless. This was the only way I could figure out how to have both figures calculate without seperating the form up.
I do feel like it may be a round-about way of doing it. I am sure there is a more simple way of getting the same result without the large number of fields, but I am not sure how. (still VERY new to scripts!)
It is a very roundabout way of doing it. A much better option is to use a single field with a custom calculation script to determine which value to show. It will make it much easier to spot errors, too.
I thought as much. I'm still very new to using scripts in general. Only managed to figure this one out from looking through forums like this one until I got the result I needed, ha!
Do you know of anywhere that I can look up how to use a single field with a custon calculation script at all? Would be great to learn more about this! Especially if its helpful with spotting errors, I seem to be having quite a few issues with that.. ha!