1 Topic by apmuthu (edited by apmuthu 11/26/2014 08:09:45 am)

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

Topic: Invoicing auto fill of price broken? [SOLVED]

Set up an item and fill in retail and wholesale prices (wholesale price is set as base value) and customer default is retail pricing.
Now enter a direct invoice and choose the item. The price before tax does not get auto filled (FF 33 and IE 6).

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!

apmuthu's Website

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

Re: Invoicing auto fill of price broken? [SOLVED]

Auto population of Price before Tax will happen only if Setup => Display Setup => Show Item Codes is checked.

apmuthu's Website

3 Reply by apmuthu (edited by apmuthu 11/26/2014 05:48:05 pm)

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

Re: Invoicing auto fill of price broken? [SOLVED]

All prices in the #_prices table have only the stock_id references. If we put in new prices with item_code as the stock_id which is different from the original stock_id, then the Price before Tax in the Direct Invoice gets populated correctly!. But prices added/edited thru' FA in the Items => Sales Pricing form will bear only the stock_id.

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!

apmuthu's Website