FrontAccounting forum — Sales Order Entry

Re: Sales Order Entry

null@example.com (apmuthu) — Tue, 22 Dec 2015 16:42:59 +0000

This is implementable using the Bin Location workaround shown in the wiki. This uses the long_description field to store delimited information parsed out when needed.

Re: Sales Order Entry

null@example.com (deep97) — Tue, 22 Dec 2015 01:45:40 +0000

Muthu Ji, I understand. but these days most of products have readable barcode.
this can be kept for foreign table. but for for UPS code and ISBN. there is no space. If one more table is added with all extra codes it will make this software more better. Also related item thing is also missing right.
Regards

Re: Sales Order Entry

null@example.com (apmuthu) — Mon, 21 Dec 2015 03:31:41 +0000

When you enter foreign item code, the quantity you enter for it will be the number of units of the main item that will be used for billing. The foreign item code represents a means of bulk billing (qty > 1) or alias billing name (qty = 1).

Your suggestion for grouping items dropdown box by stock_id instead of by item_code would mean that the user must remember the stock_id for each item_code wanted which may not be feasible. The replacement of the i.description with s.description will render both descriptions the same and would make for ambiguity in selection.

Re: Sales Order Entry

null@example.com (deep97) — Sun, 20 Dec 2015 16:08:02 +0000

Any idea, do i need new table or change the code in ui_lists.in

$sql = "SELECT i.item_code, i.description, c.description, count(*)>1 as kit,
i.inactive, if(count(*)>1, '0', s.editable) as editable
FROM
".TB_PREF."stock_master s,
".TB_PREF."item_codes i
LEFT JOIN
".TB_PREF."stock_category c
ON i.category_id=c.category_id
WHERE i.stock_id=s.stock_id";

if ($type == 'local') { // exclude foreign codes
$sql .= " AND !i.is_foreign";
} elseif ($type == 'kits') { // sales kits
$sql .= " AND !i.is_foreign AND i.item_code!=i.stock_id";
}
$sql .= " AND !i.inactive AND !s.inactive AND !s.no_sale";
$sql .= " GROUP BY i.item_code";

$sql = "SELECT i.item_code, s.description, c.description, count(*)>1 as kit,
i.inactive, if(count(*)>1, '0', s.editable) as editable
FROM
".TB_PREF."stock_master s,
".TB_PREF."item_codes i
LEFT JOIN
".TB_PREF."stock_category c
ON i.category_id=c.category_id
WHERE i.stock_id=s.stock_id";

Sales Order Entry

null@example.com (deep97) — Sun, 20 Dec 2015 03:48:33 +0000

Hi I am trying to get some knowledge of FA.

I enter two foreign extra codes for a product. If i do so and then going to Sales Order Entry in Item Description I am get each product two time. If I enter foreign code one time it shows one time only.

So do we need new table to enter Manufacturer Code and UPC for product.

regards