Receiving and Balancing Connect Logistics Invoices
RECEIVING AND BALANCING CONNECT LOGISTICS INVOICES IN BARNET LITE
To import and reconcile Connect Logistics invoices in Barnet, you’ll use the Traditional Format with GST (.ord file). Because this file is not easily readable, you will also need the PDF version of the invoice to confirm totals such as GST and deposit.
Note: If you experience balancing issues related to SKU setup, refer to the knowledge base article "Setup for Receiving AB Invoices." You may find using the .csv file with GST format helpful for troubleshooting.
Step 1: Retrieve Invoice from Liquor Connect
Log in to liquorconnect.com.
Navigate to Ordering>Closed/Final Closed.
Click the Web ID# of the invoice you want to import.
Before exporting, check for product substitutions:
Sort by Status to highlight any products in yellow (Status S). These are substitute CSPCs.
Add these substitute CSPC numbers to the Alt Barcode/SKU table in <Product Maintenance> before importing the invoice.
Step 2: Export the .ord File
Click “Export”.
Select Traditional Export with GST.
Save the .ord file to your Downloads folder. (You may wish to move it to a designated folder for better organization.)
The .ord file is not human-readable, but if opened in Notepad, you will see raw product data.
Step 3: Retrieve the PDF Invoice (for Balancing)
Go to Downloads>Invoices.
Click the invoice to open the PDF version.
You may save it or use it for reference.
The Invoice Number is located in the top-right corner.
The Total with GST and Deposit is found in the bottom-right corner of the last page.
Step 4: Import the Invoice into Barnet
In Barnet, go to Inventory>Receiving Invoices.
Click “Add Receiving” in the top-right corner then select the Vendor (Connect)
On the Receiving page, click “Order Details” to add Vendor Invoice # then Import
Click “Browse” to locate and select your .ord file.
Wait a moment for the system to process. Once the file name and product count display, click “Import”.
Step 5: New Product Setup (if applicable)
If the invoice includes new SKUs, a setup window will appear:
Details such as CSPC, barcode, product name, Units per Case, Units per Pack, and Deposit will autofill from the Connect price list.
You must manually select:
Product Category
Unit of Measure (UOM)/Size
You may also:
Shorten or adjust the product name for shelf labels.
Set custom pricing if desired.
Hover over product names to see full descriptions.
Step 6: Confirm and Save Invoice
Once all SKUs are confirmed or created:
Review the Order Total and Deposit Total against the PDF.
GST discrepancies of a few cents are common due to rounding.
Deposit must match exactly.
To save:
Click Actions>Save to finalize the invoice. Before the Invoice saves you will be asked to confirm that you want to update your costs in Product Maintenance according to the invoice. Generally, it is best practice to click Apply to update the costs. If you are receiving an old invoice you may want to uncheck certain items or unselect all or click Cancel instead to not update any costs.
Troubleshooting
If Deposit Totals Don’t Match:
Some SKUs may be missing:
Correct Deposit values
Accurate Units per Case/Pack
Proper Single item flags
If GST Is Significantly Off:
GST is controlled by Category Settings in <Product Maintenance>.
Common issues include:
Incorrect categorization of non-alcoholic items
Errors with the Liquor Connect Order Charge SKU
How to Troubleshoot Effectively:
Compare the Barnet Receiving screen against the Connect CSV invoice.
Export Barnet Receiving to Excel and compare side-by-side using formulas (if comfortable with Excel).
If discrepancies are found:
Update product information in <Product Maintenance>.
Delete the Receiving entry.
Re-import the corrected invoice to ensure clean and accurate future imports.
Last updated