Search options (Page 194 of 247)

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:

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!

Updated the Wiki with the stock_id and item_code table relationships.

Item Coding:

• Any combination of numbers and letter is fine as long as it is in the Item Short Label field (item_code / stock_id)

• The table item_codes is used to store normal items (stock_id = item_code)

• It is also used to store foreign items (stock_id need not be the same as item_code), a flag for is_foreign is set

• In any case, the id field should be unique and will be an auto generated unsigned integer value

• The combination of stock_id and item_code should be unique

• item_code and stock_id are VARCHAR(20)

• Vendor and PO searches are by item_code and warehouse lookups use stock_id

• Hence "stock_id" is "our" inventory code and "item_code" is for "vendor/account" based reference.

• All bought out items come into foreign items type with their own UPC/EAN/ISBN type numbering

• All items must first be entered as Normal Items and then assign them as foreign items if needed.

• Foreign Item's data cannot be entered if it does not exist as a normal item in the table.

• Apart from the item_codes table, the item_code field is used in Goods Receipt Notes (grn_items) and in the purch_order_details tables.

• Hence item_code is limited to the accounting side. Definitely your vendors are not going to understand your own item references (stock_id). Hence you need to use their reference numbers (item_code) when interacting with them. Although your stock_id referencing may be similar to those from your vendors, yours may/can have some prefixed characters to denote the vendor you are referring to, to alleviate the condition when the same part number straddles across vendors possibly denoting even eniterly different items.

• Please note that there is no reference to any stock_id where item_code is used except in the item_codes lookup table.

FA comes with Each and Hours as Units of Measure.
The following will add common Units of Measure:

INSERT INTO `0_item_units` (`abbr`,`name`,`decimals`,`inactive`) VALUES
('pc','Pieces',0,0),
('lb','Pounds',0,0),
('kg','Kgs',0,0),
('cwt','CentWt',0,0),
('gm','Grams',0,0),
('ltr','Litres',0,0),
('gal','Gallons',1,0),
('km','Kilometres',0,0),
('mtr','Metres',0,0),
('cm','Centimetres',0,0),
('ctn','Cartons',0,0),
('box','Boxes',0,0),
('ctr','Containers',0,0),
('brl','Barrels',0,0),
('drm','Drums',0,0),
('ton','Tons',2,0);

Replace the Company prefix for the table in the above statement to suit your install or append it to your CoA sql file before company creation.

On 2014-11-13, a commit was made with the following title:
Javascript now works with multiple classes on elements.
This is erroneous as

It has since been corrected by the author in his github repo along with other missing replacements.

Please revert the commit or update it with the authors corrected files.