7 | Supplier Price Book

This article covers the Supplier Price Book and how they are managed through Scheduled Jobs. The Supplier Price Book contains all the prices of Products that are provided by individual Suppliers; as such it onl y applies if using a Supplier that supports Price Book files. Some examples of the Suppliers that support a Price Book file are as follows: ILG, LMG, and IBA.

This article covers the Supplier Price Book and how they are managed through Scheduled Jobs.

The Supplier Price Book contains all the prices of Products that are provided by individual Suppliers; as such it only applies if using a Supplier that supports Price Book files.

Some examples of the Suppliers that support a Price Book file are as follows: ILG, LMG, and IBA.

Prerequisites

To access Supplier Pricebook Settings, the applicable Operator Privileges will need to be enabled:

Operator Maintenance 'General' Tab

System Setup: " Maintain Scheduled Jobs" Flag

Operator Maintenance 'Stock Control' Tab

All "Purchasing and Receiving" Flags

Price Book Scheduled Jobs

Scheduled Jobs are automated processes that can be created and run at certain times of the day
In relation to Supplier Price Books, Prices will first need to be imported into the local BackOffice database which can be achieved through the creation and running of a Scheduled Job

Creating Scheduled Jobs

To import Supplier Prices through a Scheduled Job, follow the steps below:

Run BackOffice and Login
Navigate to System Setup and then select Scheduled Job
Select the Add Job Function and the Job Maintenance window will then appear

Each individual Supplier has its own configuration options within the Job Maintenance window and are detailed in the table below:

Supplier	Job Options	Visuals
ILG	ClassName: ILG Pricebook File Server URL: Supplied by ILG Remote Directory: Supplied by ILG Username: Supplied by ILG Password: Supplied by ILG Customer Number: Supplied by ILG File Spec: The name of the file including the file type extension Local Path: The local directory location of the Product file Supplier: Select the ILG supplier as configured in the local Bepoz database Venue: The respective Venue in which the import Products will be applied to
LMG	Class Name: LMG Product File LMG VenueID: This is supplied by LMG Path for Liqourfiles: This is where the Liqourfile should be put and where the Scandata file will be created Liquorfile Suffix: Typically Bepoz Liquourfiles are named something like PRODUCT_BEPOZ.TXT In this case, the Suffix is BEPOZ although LMG may name them something else Supplier: Select the LMG supplier as configured in the local Bepoz database This is used when creating the Supplier Item entries in the Supplier Price Book
IBA (ALM)	ClassName: IBA Product File IBA UserID: This is supplied by IBA IBA Password: This is supplied by IBA IBA State: NSW, VIC, etc. Supplier: Select the IBA (or ALM) supplier as configured in the local Bepoz database This is used when creating the Supplier Item entries in the Supplier Price Book

Running Scheduled Jobs

Depending on the Scheduled Job that is created, they can be set to run at certain times of the day
Within the Schedules section of the Job Maintenance Window, select the Add Button
From here, the Operator can select the designated times in which the Job will be run

For Price Book Jobs, it's recommended to check for the Monthly Pricebook daily so scheduling the Job to run every day at a specific time or at Startup is suggested

After the Schedule Configurations have been completed, press the Run Now Button

Selecting this button will immediately run the Job

When a Scheduled Job is initiated, Smart Controller will display the results of the run Job/s

In this example, the results of the ILG PriceBook Job shows that Products have been successfully imported

Stock Control - Supplier Price Book

To view the Imported Pricebook in BackOffice, navigate to the Stock Control component on the sidebar, expand, and select Supplier Price Book which will open the Supplier PriceBook Tab
The list can be filtered to a specific Supplier by using the Supplier drop-down or alternatively leave as 'All Suppliers'

Linking Products

Information Imported, matched, and contained in the Pricebook through the Scheduled Job will include the Product Long Name, Item Volume, CaseQty, CostEachEx, and Barcode
Products in the local Bepoz database will be matched & linked with Products in the Pricebook based on the Local Products' Barcode_1
Other data from the Pricebook file will be matched with data in Bepoz such as Product ID being equivalent to the ItemCode in Bepoz, UnitSize equivalent to UnitName, etc.
If Products from the Pricebook are not matched/linked with Products in the Database they can be linked manually using the Set Local Product button
To manually link a Local Product from the Imported Price Book, follow the steps below:

From the Supplier Price Book Menu, highlight the desired Supplier Product that will require a manual link and select Set Local Product button
Select by double-clicking the local Product that will be linked with the Supplier Product
Select the Size from the list to complete the process

Linked Products with non-matching configurations will display an error message to the Operator
This ensures that local Products are linked and updated with the correct Supplier Products

Suspect Match Report

The Suspect Match Report is a feature that can be accessed in the Supplier Price Book
This Report identifies Supplier Products that have been linked with an incorrect and unmatching configuration to Local Products
Matched Configurations can include

Product Sizes
Base Sizes
Case Quantities
Pricing Changes
Volume Settings

7 | Supplier Price Book

Supplier

Job Options

Visuals