Stock Item Supplier

Question

Hello, 
 We have a Purchase Order layout that I'm trying to configure to use the Stock Item Supplier Code (From Stock Item details > supplies tab). The issue I'm having is getting this to show the correct stock item supplier code if there are multiple suppliers against a product. 
 
 I've tried a huge variety of joins but this comes across different issues (I.e. it changing to child outer joins, adding multiple keys, etc) and I'm not too sure why. 
 
 I understand why I'm having the issue of it not pulling the correct stock code because the tables are currently linked from POPOrderReturnLine > Stock Item > StockItemSuppliers. This obviously means it doesn't know which supplier to associate it with but is there a specific table and field should I link the StockItemSupplier table too? 
 
 Thank you in advance.

Toby · Accepted Answer

the supplier stock code is already provided in a field called supplierpartref in the poporderreturnline table. if you buy from one of the stock item suppliers it automatically populates with the Supplier Stock Code from the stockitemsuppliers table. 
 you also should not join the poporderreturnlines table to the stockittem table via the item code. you should do a parent outer to the POPStandarditemlink, from there to the StockItem table. The item code on a popline could be an additional charge code as well.

Sage 200 UKI

Stock Item Supplier

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING