x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 14 subscribers
  • Views 512 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
JamieBates

Stock Item Supplier

SOLVED
Posted By

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.

  • +1
    verified 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.

  • 0

    Jamie,

    Within the POPOrderReturnLine table you should have a field called SupplierPartRef.  This should have the relevant data in without having to map additional tables/links.

    Regards,

*Community Hub is the new name for Sage City