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?