Minimum Version Required: 23.01
Pre-Conditions
Communicating VIPR pricing through EDI
Legacy Front Line Zone needs to be set on Distribution Area
Legacy Front Line Zone needs to tied to Frontline Promotions
Steps
VIPR File Format:
Line number:
Description of line and related fields
Header:
PHDR00: File Name
Areas and Zones
01: Legacy Front line zones tied to distribution areas (Format = AR + ZoneID of the legacy frontline zone on the distribution area)
02: Promotion Zones tied to pricing (Format = ZN + ZoneID)
Customers:
10: CustomerID
11: Distribution Area Legacy Front line zone this customer is associated with
12: Pricing areas this customer is associated with
Frontlines:
20: Product Information
21: Pricing information associated with a specific Legacy Front line zone
Promotions:
40: Promotion/Product Line
45: Zones where this promotion applies
50: EDI Codes
51: Discount amount
54: Product ID and Unit Discount/price
Fields And Definitions
What customers are commincated through VIPR:
Customers found by below checks will be in the BudNet VIPR file:
CustomerListTempTable.CustomerID = Customers.CustomerID
Customers.AccountStatus = Active or CustomerID in CustomerIDAccountStatusChangeArr or CustomerID in CustomerIDHasInvoiceOnLastSentDateArr
Customers.CustomerType -> CustomerTypes.CustomerAccountType = 1
Customers.DistributionArea -> Areas.Location = SuppliersReports.Location.
What pricing is included in a VIPR File:
Promotions found by below checks will be in the BudNet VIPR file:
1. The PromotionsProducts or the Line Products of Promotions.Line have Inventories with VALID Inventory.SupplierProductNumEffective and TRUE Inventory.ActiveEffective.
A. Products.IncludeinSupplierReports <> Exclude.
B. Inventory.SupplierProductNumEffective<> NULL.
C. Inventory.SupplierProductNumEffective recorded in the Suppliers Products table.
D. The SuppliersProducts.Supplier of theSupplier Products in item(c.) recorded in the Suppliers Reports table with ReportType=BudNet.
E. SuppliersReports.LocationID in item (d.) = Inventory.LocationID.
F. SuppliersReports.SupplierID = Inventory.SupplierIDEffective.
2. The PromotionsZones, PromotionsChains or PromotionsCustomers enable them to buy the products.
3.The Promotions.PromotionType should be of the below four types.
A. Discount
B. Case Discount
C. Price
D. Case Price
Best Practices
Check the file to determine how to correct the issue.
Is pricing not reported correctly? Are the right zones tied to the promotion? Is the promotion Active? Does it meet the requirements outlined in fields and definitions?
Is a product not reporting? Can that customer purchase the product? Is it active? Does it meet the requirements outlined in fields and definitions?