red1.org Forum Index red1.org
Nihili est - in vita priore ego imperator romanus fui
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

BOM Modeler Module Development
Goto page Previous  1, 2, 3, 4
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> Steel Manufacturer Project
View previous topic :: View next topic  
Author Message
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1753
Location: Kuala Lumpur, Malaysia

PostPosted: Mon Jun 26, 2006 1:39 pm    Post subject: Reply with quote

I forgot to tell u that u must be in Consolidated mode to get the <C> button to work, as in that mode u can see the formula behind hilites.

About currency u can put in the conversion rates first. I will look into programming so that if it detect a non USD rate it will look up and convert to USD and show only USD in BOM Modeler. Later we make extension to show the IDR besides it, under a new column.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1753
Location: Kuala Lumpur, Malaysia

PostPosted: Mon Jun 26, 2006 1:58 pm    Post subject: Reply with quote

I also read the BP_Production_planning.pdf and in the box 'MR Requirement via Method Sheet' there are details or headings for such a report':

- Sleeve Control(Qty and Size)
- Scrap / Alloy Info
- Sand / Coat
- Anchor
- Locator
- Pattern Material
- Grinding Material
- Machining Material
- Resource (i.e. people)

Pls advice the report format so that i can do this right away to prove one benifit of the BOM Modeler.
Off hand i will advice that u create Product Category for your raw materials according to the Categories stated above. So that in the report, we sub-heading them according to their Product Category.
This report merely display again the BOMFlatView but only the dark blue (raw materials) lines, and we put a print screen button for fast local printing.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Usman
Regular


Joined: 12 Jan 2006
Posts: 97
Location: Indonesia

PostPosted: Mon Jun 26, 2006 3:36 pm    Post subject: Reply with quote

yes, we need mentioned module, but only after clear out BOM & estimation part.
Back to top
View user's profile Send private message Yahoo Messenger
Usman
Regular


Joined: 12 Jan 2006
Posts: 97
Location: Indonesia

PostPosted: Mon Jun 26, 2006 4:00 pm    Post subject: Reply with quote

Don't know how yr <C> button works, but when I try to change P_NetWt & P_ReturnWt, It can not refresh casting(net) & casting(scrap) value.
Also after importing vendor (about 1400 records) and purchased product (7500 records) BOM responsivesness is slowing down.


Last edited by Usman on Wed Jun 28, 2006 11:26 am; edited 1 time in total
Back to top
View user's profile Send private message Yahoo Messenger
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1753
Location: Kuala Lumpur, Malaysia

PostPosted: Wed Jun 28, 2006 10:21 am    Post subject: Reply with quote

Now the BOM has http://red1.org/barn/medan/bom_structured.htm view.

The BOM View works in 2 modes - Tree, and Consolidated. For the <C> above, it has to be in the Consolidated mode.

For the structured view to work u have to create the Estimates again. This tree view comes on only after saving the Estimate.

U need some changes to your DB so run the following codes:
Code:
CREATE OR REPLACE VIEW P_ESTBOMFLAT_V ( M_PRODUCT_BOM_ID,
M_PRODUCT_ID, M_PRODUCTBOM_ID, PARENTPRODUCTNAME, PRODUCTNAME,
BOMQTY, CURC, PRICELIST, UOM,
PRODCODE, ISBOM, ISACTIVE, TAB,
SEQ ) AS SELECT bom.M_Product_BOM_ID, bom.M_PRODUCT_ID, bom.M_PRODUCTBOM_ID, par.Name, ch.Name, bom.BOMQty,
 c.ISO_CODE, CASE WHEN bom.PriceList>0 THEN bom.PriceList ELSE pri.PriceList END AS PriceList,
  u.Name, bom.ProdCode, ch.IsBOM,bom.IsActive, bom.TAB, bom.SEQ
FROM P_EST_BOM bom
  INNER JOIN M_Product ch ON (ch.M_Product_ID = bom.M_ProductBOM_ID)
  INNER JOIN M_Product par ON (par.M_Product_ID = bom.M_Product_ID)
  INNER JOIN M_Product_PO po ON (po.M_Product_ID = bom.M_ProductBOM_ID)
  INNER JOIN C_Currency c ON (po.C_Currency_ID = c.C_Currency_ID)
  INNER JOIN M_ProductPrice pri ON (pri.M_Product_ID = bom.M_ProductBOM_ID AND pri.M_PriceList_Version_ID = '104')
  INNER JOIN C_UOM u ON (u.C_UOM_ID = ch.C_UOM_ID)
and add 2 fields in your P_Est_BOM and P_BOMFlatView first -
Code:
ALTER TABLE P_EST_BOM
 ADD TAB INTEGER DEFAULT 0;
 ADD SEQ INTEGER DEFAULT 0;
ALTER TABLE P_BOMFlatView
 ADD TAB INTEGER DEFAULT 0;
 ADD SEQ INTEGER DEFAULT 0;
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Usman
Regular


Joined: 12 Jan 2006
Posts: 97
Location: Indonesia

PostPosted: Wed Jun 28, 2006 11:17 am    Post subject: Reply with quote

hv CVS updated, and Tables altered, also I delete records from these tables :
P_BOMFlatView, P_BOMFORMULA, P_ESTIMATE, P_EST_BOM

When I 1.Get GA-M, still Ok, but when 2631 and 2.Save then it hit error.
Here is error log from eclipse console :

EVERE: Servlet.service() for servlet controller2 threw exception
java.lang.Error: Unresolved compilation problems:
The method put(Object, Object) in the type Hashtable is not applicable for the arguments (String, int)
The method put(Object, Object) in the type Hashtable is not applicable for the arguments (String, int)

at shopfloor.tools.ModelBOM.structuredView(ModelBOM.java:692)
Back to top
View user's profile Send private message Yahoo Messenger
red1
Site Admin


Joined: 06 Jul 2004
Posts: 1753
Location: Kuala Lumpur, Malaysia

PostPosted: Wed Jun 28, 2006 11:26 am    Post subject: Reply with quote

Switch to Java 5.

>In Eclipse u go to Properties of the Project, and click on Java Compiler menu line.
>Change the Compiler compliance level to 5.0
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Usman
Regular


Joined: 12 Jan 2006
Posts: 97
Location: Indonesia

PostPosted: Tue Jul 04, 2006 12:04 pm    Post subject: Reply with quote

red1, we didn't find new update so far.
Pls. post yr progress.
I sent U our official letter and look forward to hear your respon.
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    red1.org Forum Index -> Steel Manufacturer Project All times are GMT + 8 Hours
Goto page Previous  1, 2, 3, 4
Page 4 of 4

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group