Update Payable Contracts from your Price Information Management System (PIMS)

Update Payable Contracts from your Price Information Management System and adjust prices for Payable Stock Buying and Selling unit.

Introduction

Stock Manager Settings

Edit Payable Stock Buying and Selling Units

Approve new Price Batch from your Supplier

Update Prices from National Price File

Introduction

Where you have different quantities for the Buying unit and Selling unit amounts for a Stock item, the purchase price must be converted for the appropriate unit size when you update the prices from your Price Information Management System.

This process updates the Payable Contract prices to that for the appropriate Selling unit.

  Return to Top of Page

Stock Manager Settings

To access your Price Information Management System, these fields need to be set in the Stock Manager.

To check and update your settings:

• Go to Settings > Stock Manager. 
• Use Lentune price file: This field should be checked.
• Price file api url: This will show the unique url to your Price Information Management System.
• Make new stock when importing: This field should be checked.
• Click Save to save any changes.

   Return to Top of Page

Edit Payable Stock Buying and Selling Units

In any Stock item where the Buying and Selling units are different, you must set the number of Buying units and Selling units. This indicates that you may have to buy, say, 100 units to get the price you want to buy at, and you might sell in lots of 5 units to your customers.

This step is a one-time task for each particular Stock item, and prices will then be converted correctly for the unit numbers when you approve and update new Price Files that your Supplier has uploaded to your Price File database.

• Go to Stock > Stock Details.
• Select the item to check and update.
• Go to the Supplier Codes tab.
• Double click the item.

In the Edit Payable Stock screen > Buying and selling links section:

• Buying unit: Enter the number of units that the item is bought in, e.g. 100.
• Buying unit description: Enter the unit description, e.g. each, box, pack, etc.
• Selling units: Enter the number of units that the item is sold in, e.g. 5.
• Click Save and close.

   Return to Top of Page

Approve new Price Batch from your Supplier

This is done in the Price file database. 

Please refer to Wholesaler Guide to Approve a Pending Batch to see how to do this.

  Return to Top of Page

Update Prices from National Price File

Run this process to update the prices on your Payable Contracts for Stock Items and also to convert prices from the Buying unit to the Selling unit where applicable.

To do this:

• Go to Stock > Update Prices from National Price File.
• National Supplier: Select the Supplier whose prices you wish to update.
• Restrict update if less percent: You can determine not to update Stock items if the percentage change is less than a certain percentage. Usually this will be 100. 
• Restrict update if more percent: You can determine not to update Stock items if the percentage change is more than a certain percentage. Usually this will be 100.
• Click Update.

   Return to Top of Page