Where you have multiple price breaks for a stock item, you can import the price breaks to create or update the Payable Contracts.
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 Payable Price Contracts for more information about importing Payable Contracts.
Add multiple Price Breaks for a Stock item
The columns that you will need to populate in the spreadsheet to import are:
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.
|
Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com. Thank you. We love to hear from you! |