1 Reply by dkshukla

(9 replies, posted in Report Bugs here)

I had also get error in issuing items to work order. Following error message for your reference,
I am using Mysql server version 5.0.27
please check and rectify the bug

Issue Items to Work Order

DATABASE ERROR : The work order issue could not be added
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2', '2007/05/04', 'DEF', 1)' at line 2
sql that failed was : INSERT INTO 0_wo_issues (workorder_id, reference, issue_date, loc_code, workcentre_id) VALUES (, '2', '2007/05/04', 'DEF', 1)

Go to forum: Report Bugs here

2 Reply by dkshukla

(9 replies, posted in Report Bugs here)

admin wrote:

There seems to be a problem with joins in version 5.0.12 of MySQL. Look at this topic, https://frontaccounting.com/punbb/viewtopic.php?id=13
This SQL statement is inside the file
/manufacturing/includes/db/work_order_requirements_db.inc in a function called get_wo_requirements:

function get_wo_requirements($woid)
{
    $sql = "SELECT ".TB_PREF."wo_requirements.*, ".TB_PREF."stock_master.description,
        ".TB_PREF."stock_master.mb_flag, 
        ".TB_PREF."locations.location_name, 
        ".TB_PREF."workcentres.name AS WorkCentreDescription FROM 
        ".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres INNER JOIN ".TB_PREF."stock_master ON 
        ".TB_PREF."wo_requirements.stock_id = ".TB_PREF."stock_master.stock_id 
        WHERE workorder_id=$woid
        AND ".TB_PREF."locations.loc_code = ".TB_PREF."wo_requirements.loc_code
        AND ".TB_PREF."workcentres.id=CAST(workcentre AS UNSIGNED)";    

    return db_query($sql, "The work order requirements could not be retrieved");    
}

Put parentheses around the FROM tables

....... FROM (".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres) 
INNER JOIN ".TB_PREF."stock_master ON .......

Please report if this helps!
New edited files with JOIN's from multiple tables will be put on the CVS on Sourceforge.

/includes/db/manufacturing_db.inc
/manufacturing/includes/db/work_order_requirements_db.inc

Admin

With new codes there is no error.
Thanks
shukla

Go to forum: Report Bugs here

3 Reply by dkshukla

(9 replies, posted in Report Bugs here)

i am using my-sql version 5.0.27

Go to forum: Report Bugs here

4 Reply by dkshukla

(3 replies, posted in Report Bugs here)

For example sale invoice shows total amount 150 GBP and customer balance statement is showing  US$ 298.81 (home currency is US$ and exchange rate is 2)
customer balance should  be US$ 300 in place of 298.81 either it may be due to exchange rate accuracy, i don't know from where exchange rate has been taken.please check it may not be bug
shukla

Go to forum: Report Bugs here

5 Reply by dkshukla

(4 replies, posted in Wish List)

Hello friends
I will want to share my practical experience about problem of service industry and solution to handle it.
Mostly service industry doing annual maintenance contract to provide fixed no of visits for preventive maintinence during contract period and also visit on call basis. To keep track of all contract and managing people to execute these contracts is very difficult. I have not found any ideal solution for such type of requirement.
Recently I had think to use webERP for such requirement in different way. You may also find my approach helpful to develop better solution.
Case No-1
One customer is having 500 branches under one control office,customer wants that on every month each branch should be visited and there must be a more than 20 days difference in each visit. after completing montly visit bill will be submit to control office alongwith service report.

Solution

1- I have treated one branch contract as a item and created 500 such serialised controlled items.
2- I have created whole contract of 500 branch as a item (kit)
3- Enter the BOM of above kit item i.e 500 seperate branches, no of visit is treated as item qty. Now i can generate a sakes order of whole contract (500 branch) kit item. It will explode all branch details ,qty ,price , tax etc
4- I have make our technician as supplier
5- I will generate purchase order to our technician for making visit to branches, I could also put estimated cost of expenses of branch visit.
6- after completing visit to customer our technician will submit service report alongwith actual expense report, i will receive all this against issued p.o
7- Now I have service report of visited branch in our inventory.
8- now I can generate invoice against previously generated sales order.
9- if any vist not completed then it will be list of back ordered
all reports related to pending visits, expenses in executing visits, payment, invoicing will be availabe as usual, such type of manipulation will helpful to handle service related controls till dedicated solution not available.
I will hope that developer of Frontaccounting will use this idea to make refined solution for service industry.

Go to forum: Wish List

6 Topic by dkshukla

(3 replies, posted in Report Bugs here)

Dear Admin
I had observed an error i.e amount difference in between invoice and customer balance report. Please check and fix bug

Go to forum: Report Bugs here

7 Reply by dkshukla

(9 replies, posted in Report Bugs here)

I had also also found error to get details of work order. error details given below. I am using latest checked out codes from CVS
--------------------------------------------------------------------------------------------------------------------
Work Order # 8
#     Reference     Type     Manufactured Item     Into Location     Date     Quantity
8     8     Assemble     001 - ABCD    PLACE     24/05/2007     1
This work order is closed.

Work Order Requirements
DATABASE ERROR : The work order requirements could not be retrieved
error code : 1054
error message : Unknown column '0_wo_requirements.stock_id' in 'on clause'
sql that failed was : SELECT 0_wo_requirements.*, 0_stock_master.description, 0_stock_master.mb_flag, 0_locations.location_name, 0_workcentres.name AS WorkCentreDescription FROM 0_wo_requirements, 0_locations, 0_workcentres INNER JOIN 0_stock_master ON 0_wo_requirements.stock_id = 0_stock_master.stock_id WHERE workorder_id=8 AND 0_locations.loc_code = 0_wo_requirements.loc_code AND 0_workcentres.id=CAST(workcentre AS UNSIGNED)

Go to forum: Report Bugs here

8 Topic by dkshukla

(4 replies, posted in Manufactoring)

Dear Admin
I will want to share some of my real life manufacturing experience, It may help you to improve application and it's usefulness.
Ideal Inventory Management For Electronic Products Manufacturing Industry
There must be following types of items

   1. Basic raw material component – are used to make sub assemblies, assemblies and finished products, these items are not having BOM (Bill of material)
   2. Sub assemblies – are manufactured items having BOM,
   3. Assemblies – are manufactured items having BOM,
   4. Finished goods – Items ready to sale having BOM
   5. Kits – are having BOM. Purpose of this types of item is to make entry fast.during issue and receipt.

Issuing of Component for Production
There are different types of situations for issuing and receipt of material
Issue of material

   1. Kit Issue of component for making PCB
   2. Kit issue for making assemblies
   3. Kit issue for making complete products
   4. issue of consumeable items like solder wire, wire, cables, sleeves, fastners etc
   5. issue of other materials
   6. issue of tools, test equipments etc
   7. issue of returnable material
   8. issue of component for servicing
   9. issue of material for job work
  10. issue of returnable material for outside factory

Receipt of material

   1. Recipt of assembled PCB against issue s.no.1
   2. Recipt of assemblies against issue s.no.2
   3. Receipt of finished goods from production floor against issue s.no.3
   4. Receipt of tools, test equipments against issue s.no.6
   5. Recipt of returnable material against issue s.no.7
   6. Recipt of material for job work against issue s.no.9 (after conversion)
   7. Recipt of returnable material from outside factory against issue s.no.10

Manufacturing Process
First step is creating work order for manufacturing product with target date of finishing work order
Second step is to material requirement planing, during this step one should know the total material requirement as per BOM x qty produced
There must be provision to reserve required qty for that job and shortage is calculated on the basis of material available.
Now on the basis of shortage one can float inquiry to suppliers for material purchase.
After receiving offers from suppliers one can make comparative statements for making purchase decision
there must be provision for approval of rates from higher authority before issuing purchase order to supplier
after proper rates and qty approval only p.o could be issued
after receiving material in stock against p.o material status for particular job will updated.
There must be provision to issue of material only against particular work order.There must be provisin to issue some extra material against that particular work order for repairing/ replacement of defective parts. Hence it will keep track of inventory and it's costing on production floor.
I will hope you will find this discussion useful for future development.

Go to forum: Manufactoring

9 Topic by dkshukla

(4 replies, posted in Reporting)

I am not able to find out where is the printing option of purchase order,If some one know then please let us know.

Go to forum: Reporting