EDI Interfaces
for Bunnings/Coles/Bilo/Tradelink
-
DEVELOPED
EDI Link for Bunnings
This program allows Bunnings invoices in Vision to be exported to an EDI file for processing by Bunnings eClient.
News & Events
EDI Interfaces
for Bunnings/Coles/Bilo/Tradelink
-
DEVELOPED
EDI Link for
Bunnings
This program allows Bunnings invoices in Vision to be exported to an EDI file
for processing by Bunnings eClient.
Process Scenario:
Upon demand, a process is run that will extract all Bunnings sales transactions
(Invoices and Credits) that have not been previously processed from the Vision
database. A transfer file is then created for these transactions as per Bunnings
specifications.An option for combined freight charges and exclusion of selected
credits is also available.
The files will be created in a disk folder nominated in the EDI Sysfile. The Bunnings eClient programme accesses the contents of the nominated folder, processes the files and transfers them to another folder.
Process Control:
This program then logs whether a particular Bunnings Sales transaction has been
processed, and update this status upon completion of the file being created and
checked. For each run, a Run Number is maintained and an Audit list showing Run
Number, date and Time is stored.
EDI Link for
Coles/Bilo
This program allows Coles/Bilo invoices in Vision to be exported to an EDI file
for processing by Coles/Bilo EDI software.
Process Scenario:
Upon demand, the Supplier will extract from their Sybiz Vision transactions
database all Coles/Bilo sales transactions (Invoices and Credits) that have not
been previously processed. Rebate credits can be excluded from the files based
on the reference prefix that is defined in the EDI system table. The delivery
reference will also be included in the header record.
For each Transaction, a separate comma-delimited file will be created with a filename as INVOICE.DAT. The file contains multiple records being a Header, one or more Details, and a Summary as defined in the attached table.
The files will be created in a disk folder nominated in the EDI Sysfile to be set up for separate administration by the Supplier. The LeadTec program accesses the contents of the nominated folder, processes the files and transfers them to another folder to ensure the files cannot be processed twice.
Process Control:
The program will log whether a particular Coles/Bilo Sales transaction has been
processed, and update this status upon completion of the Haxxxxxxxx file being
created and checked.
For each run, a Run Number is maintained and print an Audit list showing Run Number, date and Time. To allow multiple invoice runs on any day, each run uses the date and time of the previous run and extracts all invoices/credits processed in Vision since that point in time. A field on each customer record in Vision denotes whether the customer is to be included in the invoice selection. It is important that each workstation and the server have the correct date and time to ensure the process point is accurate.
The EDI system table holds details that are specific to Coles/Bilo including:
Trading Partner ID
Invoice Type
Credit Type
As invoice references are unique in Vision, all invoice numbers will be unique in the EDI file. A field on the Customer is used to store the Buyer Code.
For More Information Contact:
C.S. Packages
Tel: (Int) + 61 + 7
3381 0888
Fax: (Int) + 61 + 7 3105 7465
Copyright © 1997 by C.S. Packages. All rights reserved.
Revised:
24 Sep 2008 08:16:41 +1100.