ERP Payables: Importing Price Contracts with multiple Price Breaks

Where you have multiple price breaks for a stock item, you can import the price breaks to create or update the Payable Contracts.

Introduction

Add multiple Price Breaks for a Stock item


Introduction

When you import Payable Contracts, you may have multiple price breaks for a Stock item, and therefore you will have separate Payable Contracts for each price break.

You can import these by adding the different price breaks to the stock item line in your Payable Contract import spreadsheet.

Refer also to ERP Payables: Payable Price Contracts for more information about importing Payable Contracts.

  Return to Top of Page


Add multiple Price Breaks for a Stock item

 

The columns that you will need to populate in the spreadsheet to import are:

 

COLUMN Column Name

Data

 
Column A TableReference:  PayableContract  
Column B SupplierCode Your Lentune Supplier Code  
Column C ContractType StandardBuy or Specific  
Column D SupplierContractRef If provided by Supplier Note 1
Column L StockCode Your Lentune Stock Code Note 2
Column M SupplierStockCode As provided by Supplier

Note 2

Column R Price Price as provided by Supplier Note 3
Column S DiscountPercent Discount as provided by Supplier Note 3
Column T MinimumOrderQuantity Can be 0 Note 4
Column U Netprice Nett Buy Price Note 3
Column V Break1 Price Break1 Minimum Order Quantity Note 4
Column W Price1 Price Break1 Nett Buy Price Note 4
Column X Break2 Price Break2 Minimum Order Quantity Note 4
Column Y Price2 Price Break2 Nett Buy Price Note 4
Column Z

Break3

Price Break3 Minimum Order Quantity Note 4
Column AA Price3 Price Break3 Nett Buy Price Note 4
Column AB EffectiveDate If provided by Supplier Note 5

Column AC

ExpiryDate If provided by Supplier Note 5

 

Other columns may be used if required in your system, e.g. Project Code, Branch Code, Department Code, etc.

TIP: The order of columns is not important. If the column has a heading it will be recognised and imported, and if the heading is blank, that column will not be imported.

Column Notes:

Note 1: Column D. SupplierContractRef. If the Supplier provides a Supplier Contract Ref, this is noted at the foot of a Purchase Order so you can see that there may be some special pricing for that item. It could be useful if you have a specific Payable Contract for a specific customer or project.

Note 2: Columns L & M: StockCode & SupplierStockCode.

The import process matches the Lentune Stock code, Column L from the spreadsheet, to the Stock item in the database, and if found will import the record.

If the Lentune Stock Code is not populated in Column L of the spreadsheet, the process will search the database for a Stock Item that has a Supplier's Stock code that matches the Supplier Stock code in Column M of the spreadsheet, and if found, will import the record.

NB: If neither the Lentune Stock Code nor Supplier Stock Code can be matched to a Stock item in the database, the Payable Contract will not be imported.

Note 3: Columns R & S: Price & Discount %: The supplier may provide only a Price. Or they might provide a Price and Discount%. If the latter is the case, you can import these separately, or calculate the net price and import that as the Price.
Alternatively, the Supplier may provide only the Net price which you would place in Column R and leave Column S blank.

Note 4: Column T: Minimum Order Quantity and V to AA: Price Breaks

Instead of having separate lines for each price break level for each different quantity of an item, you can add additional columns that will create Payable Contracts for each of these price breaks.

Note 5: Column AB: Effective Date, Column AC: Expiry Date

These columns are not mandatory, but should definitely be populated if known. Where your Supplier provides a price file that is due to start or expire on specific future dates, these columns can then be copied to your spreadsheet in these columns.

By populating the fields for Effective Date in your import file and using Expiry Date in your existing Payable Contracts, you are able to import new Payable contracts in advance and avoid having to import all files at the date that the new contracts will apply.

If the existing Payable contracts have an Expiry date, then they will cease to be used at that date.

  Return to Top of Page


Was this helpful? If you require further assistance, or would like to contact us about this article, please email us at support@lentune.com.

Thank you. Your feedback is appreciated.

Last updated: 21 June 2022