This workaround will cause lookup clashes when the item_code of one item matches the stock_id of another item.
Hence all lookups must be based only on the stock_id in the js/ajax code that auto populates the Price before Tax field in the Direct Invoice form even for foreign items having a different value for the item_code than it's stock_id!
]]>Have any recent changes broken this functionality?
The Foreign Codes Wiki page states:
No need to have each item in stock_master also in item_codes, but uncheck the Edit Description for the Items.
Is this still valid or does it need some clarification? Creating a new item automatically creates a record in both item_codes and stock_master tables. It also creates entries for the item for all the currently available warehouse locations in the loc_stock table!
How do we add in the item_code during Item creation (stock_id=item_code during creation) to be different from the stock_id?
Also where is the UPC/EAN code entered during Item creation? It is quote common to have stock_id (internel ref), item_code (suppliers ref) and UPC/EAN (barcoding) for each item - how is this achieved for new Item creation?
In the current Foreign Item entry form, the quantity field is mandatory - it should be able to accept 0 as the default!
]]>