Plus and minus...
May. 5th, 2014 11:24 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
alexpgpUntil recently, my experience with Word fields was pretty limited, but then I ran across "formula" fields, which can be used in table cells, providing some basic spreadsheet capability. In my invoice documents, particularly those that arrive in un-OCRable PDF format, this capability can save a lot of effort by automagically multiplying number of article times article price to get a line item amount. This not only eases the work, but in cases where a number can have two (or more) possible interpretations (depending on graphical "noise," 6, 8, and 9 are easily confused), it can help the translator figure out the right number.
Where things get sticky, however, is when a PDF contains an error, i.e., the numbers in a column do not add up to what is shown as the total. You can't just put the correct total in and ignore what is in the source document, because that incorrect number may be something the originator is now relying on (not for any nefarious reason, but simply because the originator believes the number to be correct), but you do get a fine opportunity to look good by rendering the incorrect total and then footnoting it appropriately (although there is a risk that, somewhere along the line, it's you who has made the mistake).
Life is not simple.
I just thought I'd pass that along as I struggle with invoicing.
Cheers...
Where things get sticky, however, is when a PDF contains an error, i.e., the numbers in a column do not add up to what is shown as the total. You can't just put the correct total in and ignore what is in the source document, because that incorrect number may be something the originator is now relying on (not for any nefarious reason, but simply because the originator believes the number to be correct), but you do get a fine opportunity to look good by rendering the incorrect total and then footnoting it appropriately (although there is a risk that, somewhere along the line, it's you who has made the mistake).
Life is not simple.
I just thought I'd pass that along as I struggle with invoicing.
Cheers...
