Metcash/IBA E-Commerce Marketplace

6 | Metcash HOST Supplier Comms Setup

This article covers a step-by-step guide to configuring the Metcash/ALM Supplier Comm link in Backoffice. The Supplier Communication component allows Operators to send and receive orders through an electronic medium. Operators have the ability to do the following: Retrieve Pricebook documents and process them in SupplierItem and SupplerItemPromo tables in the sytem; Retrieve promotion documents and process them in as Promotions in the system; Retrieve invoice documents and process as PO/Electronic Invoices in the system; Send Purchase Orders to Metcash.

This article covers a step-by-step guide to configuring the Metcash/ALM Supplier Comm link in Backoffice.

The Supplier Communication component allows Operators to send and receive orders through an electronic medium.

Operators have the ability to do the following: Retrieve Pricebook documents and process them in SupplierItem and SupplerItemPromo tables in the sytem; Retrieve promotion documents and process them in as Promotions in the system; Retrieve invoice documents and process as PO/Electronic Invoices in the system; Send Purchase Orders to Metcash.

The process of adding required Supplier and other details are described in this article.

 

Prerequisites

  • To access Suppler Comms Settings; the applicable Operator privileges will need to be enabled:
    • Operator Maintenance 'General' Tab
      • System Setup: 'Maintain Supplier Comms' flag

Supplier Comms Setup

Step-by-Step Guide

  1. In BackOffice, Navigate to System Setup in the side menu panel.
  2. Select the Supplier Comms option which will open a new Supplier Communications Tab
  3. From the header, click on the 'Add Supplier Comms' button which will open a New Communication Link
  4. Fill in the required details of the supplier

 

Field

Description

Supplier

  • This is the supplier Name that is linked to the Supplier Communication Link

Venue

  • This is the Venue that the Communication is for

Receive Store

  • This is the receive Store that the Communication is for

Link Name

  • This is the Name of the Supplier Communication Link

External DLL Name

  • This is the name of the External DLL that the Supplier Comms uses

Class Name

  • Set the Class Name as Metcash Link
    • Metcash Link P.O. is a concept of Bepoz creating a Purchase Order and sending it through the supplier communications - or Supplier Comms

Send Mode

  • Select a mode on how you would like the supplier comm to send a PO

Receive Mode

  • Select a mode on how you would like the supplier comm to receive a PO

Price File

  • Price File mode is for settings to retrieve Metcash Host and Promo files.

Settings

  • Settings mode will store new fields required for the interface

 

  • N.B  It is mandatory that you have the details from the supplier: Service URL, Customer No, B2B Account and Password
  • From the drop-down menu select a Supplier; a prompt will appear:

            

  • If Yes is selected, the system will auto-fill the Link Name; if No is selected, a Link Name will need to be entered
  • Select the external DDL called 'Supcomanz'
  • Select the class name 'Metcash Link' 
  • This will display another prompt as given below:

            

  • Select Yes to set the default setting for Metcash Link
  • Below is a sample setup:

            

 

Send Order Fields

 

Fields

Description

Local Path

  • This is the Local path where the export will save to

File Spec

  • This is the file extension name the exported file
Last Sent Date
  • The date of the P.O was last sent
Last Sent P.O.
  • Name of the P.O that was last sent
Auto Send Unsent P.Os
  • If ticked it will automatically send all unsent PO's

==============TABLE====================

        

 

Receive Invoice Fields

 

Fields

Description

Local Path
  • This is the Local path where the import will save to
File Spec
  • This is the file extension name the imported file
Update Bar Codes
  • If barcodes are in the import file Flag this option to update the barcodes
Last Recv Dates
  • The date of the P.O was last received
Last Recv P.O.
  • The name of the last import received

Archive Dir

  • The location of the archived files
Auto Receive Invoice
  • If ticked, it will automatically receive invoice from the archive files
Use Invoice Price
  • If ticked, when PriceBook product price differs from Invoice price, it forces to take Invoice Price, otherwise take Pricebook price
Do not match on Cost Change %
  • This is the percentage that a products price is multiplied by to get the Points required to purchase the product.

       

 

Price File Field

 

Fields Descriptions
Local Path
  • This is the Local path where the import will save to
File Spec
  • This is the file extension name the imported file
Last Recv Date
  • The date of the Price File was last received
Last Price File
  • The name of the last imported Price File
Auto Receive Price File 
  • If ticked, it will automatically receive the Price File from the archive file
Auto Receive Promos
  • If ticked, the promotions will be imported automatically with the price file if contained within the same file

Settings

 

Field Description
State
  • Allows the operator to select the State from the drop-down list
Business Pillar
  • Allows the operator to select the business pillar from the drop-down list
Application Code
  • Allows the operator to select the Application Code from the drop-down list
Promotion Store
  • Allows the operator to select the Store for the Venue chosen Venue from the drop-down list or set as default as All Stores
Zone Number
  • This is a filter used when importing promotions from Metcash Host. Only match products for promotions that have matching Zone Numbers. Leaving it blank will match all Zone Numbers.
List All Files
  • Displays all files in a list
Used Only Local Files
  • Displays only used local files only.
Import Finished Promos
  • Allows the operator to import finished promotions

 


Scheduled Job Configuration

  • Scheduled Job will have the ability to automatically update the PriceBook with the latest copy of the Metcash host file on a schedule.
  • The Products/Promotions import workflow requires additional steps because files are retrieved via a Web Service Interface from Metcash.
  • Complete the following steps to set up the Scheduled Job for retrieving Product Files:
    1. Navigate to System Setup and select Scheduled Jobs 
    2. Select the Add Job button and a new Job Maintenance window will open 
    3. There are a number of credentials that need to input and they include:
      1. Job Name: Give the Job a relevant name 
      2. Job Type: External DLL 
      3. DLL Name: Jobscandata.Dll 
      4. ClassName: Metcash Host Scan Data
      5. Additional configuration options may be selected if desired; e.g., Venue(s), Run Missed Jobs, Chained Job, etc.
    4. Set up a Schedule or Schedules for the when the Job will run automatically
    5. Configure the Job Options as follows:
      • Select the Supplier Comms in the Metcash Comm drop-down list; this will display a list that has been created from the Supplier Comms
    6. Click OK to save the Scheduled Job

  • After re-opening the Job and selecting 'Run Now!', SmartController will show that the Job has Started and then will show when the Job has Finished OK; alternatively, this will occur per the Job's Schedule