• From: USA, TX, Houston
  • Registered: 06/05/2013
  • Posts: 46

Topic: Item numbers specific to customers

Have a situation where a client has there item number for a product but there customers have a different item number and they need to be able to look it up either way.  Issue is they have 3000 different costumers and they need the list of product numbers specific to each customer show up in the item drop down on the sales orders as well as there own internal item number.

Example, company has item number 1234 but for customer 1 there item number is abcd, customer 2 is 4xyz, and customer 3 is 987cba. My client needs to be able to select the customer in the sales screen and either search or see only the items numbers for that specific customer as well as the client's own internal item number.

Any idea of how to make this work or will I need to do a custom code work?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Item numbers specific to customers

Different Item Codes in FA and in the Vendor supplies are available for matching along with appropriate unit conversion factors. On the Customer side, the FA Item code holds and there is no mapping available. You will have to make a custom module/extension for it with a table that stores FA_Item_Code/Stock_ID, Customer_ID/Debtor_Master_ID, Customer_Item_ID, Customer_Unit(if different), Unit_Conversion_Factor(if different unit).

apmuthu's Website