 |
red1.org Nihili est - in vita priore ego imperator romanus fui
|
| View previous topic :: View next topic |
| Author |
Message |
red1 Site Admin
Joined: 06 Jul 2004 Posts: 1753 Location: Kuala Lumpur, Malaysia
|
Posted: Mon Jun 26, 2006 1:39 pm Post subject: |
|
|
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 |
|
 |
red1 Site Admin
Joined: 06 Jul 2004 Posts: 1753 Location: Kuala Lumpur, Malaysia
|
Posted: Mon Jun 26, 2006 1:58 pm Post subject: |
|
|
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 |
|
 |
Usman Regular
Joined: 12 Jan 2006 Posts: 97 Location: Indonesia
|
Posted: Mon Jun 26, 2006 3:36 pm Post subject: |
|
|
| yes, we need mentioned module, but only after clear out BOM & estimation part. |
|
| Back to top |
|
 |
Usman Regular
Joined: 12 Jan 2006 Posts: 97 Location: Indonesia
|
Posted: Mon Jun 26, 2006 4:00 pm Post subject: |
|
|
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 |
|
 |
red1 Site Admin
Joined: 06 Jul 2004 Posts: 1753 Location: Kuala Lumpur, Malaysia
|
Posted: Wed Jun 28, 2006 10:21 am Post subject: |
|
|
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 |
|
 |
Usman Regular
Joined: 12 Jan 2006 Posts: 97 Location: Indonesia
|
Posted: Wed Jun 28, 2006 11:17 am Post subject: |
|
|
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 |
|
 |
red1 Site Admin
Joined: 06 Jul 2004 Posts: 1753 Location: Kuala Lumpur, Malaysia
|
Posted: Wed Jun 28, 2006 11:26 am Post subject: |
|
|
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 |
|
 |
Usman Regular
Joined: 12 Jan 2006 Posts: 97 Location: Indonesia
|
Posted: Tue Jul 04, 2006 12:04 pm Post subject: |
|
|
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 |
|
 |
|
|
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
|