Explanation of Fields & Requirements
Field Description & Explanation Presence
SUMMARY LEVEL
Vendor / DUNS Number Suppliers using the 5010 invoice module (registered with us in July 2016 or later), enter your company's 13-digit DUNS number. Clients prior to July 2016 enter your 5-digit Loblaws vendor number. Mandatory
Credit Note Number The number of the credit note. Do not enter the original invoice number or Loblaws will reject it. Mandatory
Reference/Invoice Number The original invoice number or a reference number. Mandatory
Department Number The 2-difit department number. Optional
Credit Note Date &mnsp; Mandatory
Return Date The date on which the item was returned. Mandatory
Store Number The 5-digit store number. Mandatory
* Taxes: If you are crediting taxes on the items then you must also put them at summary level. Do not use GST and PST when you have HST and vice versa.
Total GST Must always be positive. * Conditional
Total PST Must always be positive. * Conditional
Total HST Must always be positive. * Conditional
Total Amount The total invoice amount, including taxes and allowances. Mandatory
Confirmation Request Check the box if you want to receive the confirmation that the invoice has been processed by FSI. Charges apply. Optional
DETAIL LEVEL
Product ID The product's 14-digit code (case, upc, etc...) Mandatory
Description The description of your product. Mandatory
Quantity Must always be positive. Can have a decimal ONLY if sold by kilos. Mandatory
Price Always a positive amount. Mandatory
UOM The unit of measure of the product. Mandatory
Pack Quantity If you sell by the unit, enter "1." Mandatory
* Taxes: If you are crediting taxes on the items then you must also put them at summary level. Do not use GST and PST when you have HST and vice versa.
GST Must always be positive. * Conditional
PST Must always be positive. * Conditional
HST Must always be positive. * Conditional
ALLOWANCE LINE
Optional segment. Only used if you have to send an allowance for a previous charge.
Indicator Indicates that it's an allowance. Mandatory
Type Choose the type of allowance from the drop-down list. Mandatory
Amount The amount of the allowance. Do not put a minus sign in front of allowances. Mandatory