The invoices from Novocastrian Wholesale Liquor will at times need editing to get the quantities correct when you're using a line item map so they can be added to inventory.
If you look at the 1st screenshot below you can see that there are 2 columns for the supplied quantities (Cartons & Units) so this causes an issue as we can only extract the one because they haven't told us in a separate column how many units are in a case. The other problem is that we cannot extract the fraction format, so for example when our system sees 1/12 it will extract the quantity as 112 and 2/6 will extract as 26, which is of course the wrong quantity. So because the way our system calculates a unit price is by taking the whole line amount price and dividing it by this incorrect quantity, the unit price will also be incorrect. This means that some editing will be required, so I have created a special map that will extract the unit price and all the quantities as 1, this way only the quantities will need to be edited.
The map# to use is 01-45391 and when you apply the map it will show an incorrect total and incorrect quantities (as the 1st image below shows), but that's OK because when the quantities are changed from the InTray it will total correctly. If you have a look at the 2nd image below it explains what the invoice quantities mean, then you just need to edit the quantities and save it.