Link Suppliers and Stock Items from PIMS to Lentune

When you update Stock Prices from PIMS to Lentune, there must be a connection between the Supplier codes and the Stock Codes between the two systems.

In many cases, you may be updating Stock from a pending batch. However, you can also update a few items that you may have updated in PIMS either manually or from a Discount Group Markup.

These are the links that need to be in place to match suppliers and stock codes between your two systems.

Supplier Code Link

In the Payables > Supplier Accounts menu, select the Lentune Supplier you want to link to a PIMS supplier. In our example, we are using Supplier Code P1424, Description ABC Test Supplier.

In the Details column on the left hand side, scroll down to the National supplier field, and search for the PIMS code for this Supplier, e.g. P1424 New Test Supplier.

• Select the code you want, then click Save.

Stock Code Link

In PIMS, your Stock code has a Supplier Stock Code. In our example, we're looking at stock item 333WIDGET. This Stock Item belongs to Supplier P1424.

• In Lentune, in the Stock > Stock Details menu, select the Stock Item and go to the Pricing tab.
• In the Preferred Supplier field in the Supplier / buying details section, select the supplier.
• Now go to the Supplier Codes tab, and in the Add supplier stock link section on the right hand side, select the Supplier, and enter the Supplier Stock code from PIMS.
• Click Add supplier link.

Now the link appears on the left hand side.

When Pims prices change, and you run the Update Prices from PIMS, these links allow the Stock pricing to be updated to your Lentune database.

 Return to Top of Page