The invoices from Gateway Liquor Wholesalers will sometimes need editing to get the quantities correct before they can be added to Inventory.
If you look at the screenshot of the invoice 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 when our system sees 1/12 it will extract the quantity as 112, which is of course the wrong quantity.
To minimise the editing that's required by our clients I have created a new map that works by extracting the unit price, so just the quantities will need to be edited.
However if you want carton quantities instead then you'll need to edit the Unit Price field with the invoice's 'SUPPLIED CTN' quantity.
The map# is 01-43120
If you have a look at the image below and follow the colour coded notes with the highlighted items, you'll see what is required.
Note that depending on what products you order you may also need to add an extra line for the WET amount (listed in yellow on the invoice near the total).
Any problems please call us on 02 9007 0560