• Registered: 12/05/2015
  • Posts: 9

Topic: Sales Order Entry

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

2 Reply by deep97 (edited by deep97 12/20/2015 04:09:25 pm)

  • Registered: 12/05/2015
  • Posts: 9

Re: Sales Order Entry

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";

to

    $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";

   
    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.stock_id";

3 Reply by apmuthu (edited by apmuthu 12/21/2015 03:36:53 am)

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

Re: Sales Order Entry

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.

apmuthu's Website

  • Registered: 12/05/2015
  • Posts: 9

Re: Sales Order Entry

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

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

Re: Sales Order Entry

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.

apmuthu's Website