red1.org

[red1]

Ok,
(1) I see the formula example u gave, will think about programming that.

(2) no problem will try to open the lock so that all items can be formula. (DONE - sent BOMFlatView.vm to CVS - red1)

Is (3) due to (1)? If can multi formula, then ok?

(4) I notice that bug too, seemed to due to too much to refresh in the internal list. Will always be ok once edit BQ once or twice. Will solve that after solving (1) first.

[Usman]

more comment :
5. From the view I cannot differentiate which one has formula and which is not.

[red1]

Usman, i think we can solve the phantom product (or virtual pricings) this way: (this also picks up from your ideas about a separate table so i m going to consolidate into a strategic framework)

1) Use a two table structure basis i.e. Product + SalesOrder

a) Product is for BOM and Price information. They will be used only for pricing the raw materials and not the phantom or virtual pricings. But their IDs has to be present, i.e. Overhead but they are made as non-BOM and await the second table info. We already have a P_BOMFlat_V on the product base.

b) 2nd table basis which is Sales Order is the receipient of the BOM info. When we wana assign the new pricings that is not of inventory material importance, they wont be manipulated in the Product table anymore but here in the Order. This shall have its own Order_V to store such virtual pricings.

2) Order pricing formula (similar concept to the legacy estimation module) shall combine from both V tables to form a combined one for the BOMFlatViewer.

3) Formula window shall be using the Order_V instead of BOM_V. When the prices are fixed they are written to the Order instead of the Product tables which only store BQ info as to derive the true inventory value.

Pls tell me what u think, as i m now figuring out how to go about it and start to create the programs and views.

[red1]

after some thinking the above may take some more time to plan out, and meanwhile from what we have done and your last advice yesterday, i getting the idea to finish it in a reusing of the FlatView table.

That means we reuse the table for separate "table" for the virtual BOMs.

We will dupe the FlatView structure to another record where the ID should say that its a copy of the FlatView and be used for changing its elements and the total price derived.

Thus the Formula window shuld look like the FlatView (so its actually a flatView behind the FlatView - with a small 'f')

The way it works is that when we click on the "C" it opens up another flatView for that element, and we pick which BOM is it taking from just like in the earlier FlatView. But this time the BOM List limits to its own FlatView elements. It shall write this new table to P_BOMFlatView set. U can then change the BQs and its percentages within this flatView. Pls confirm if u need "+","-". Pls explain a bit more about why and how u use divide.

[red1]

After discussions via YM, we have agreed to use the ProductBOM as template and dupe them into Est_BOM as etimation calculations. In the ProductBOM all BQs/Prices for ghosts or non-raw items are left as zero.

We are calling the raw materials as blue and those are non-blue. Except for root is the master BOM i.e. GA-M.

The Est_BOM shall take the GA-M and modify further its BQs and save it as a GA-M2209 for example.

Thus the BOMFlatView shall have an extra button for Get and change in Save:

Get = Template | Cache | Estimate

Save = Cache | Estimate

The FlatView is in the Estimate mode as it wont save back to ProductBOM but the Est_BOM

In Estimate mode, the user shall modify all the BQs of the raws, and enter formulas for the ghosts and recalculate the total price.

We still use the same Formula window can change the BQ and Price but this time the Price panel is the repeat flatView with checkbox to get which item is to be "+" and just allow a % against the final value.

[red1]

This is to create the Estimation Table that will dupe from the Product_BOM each time we work on a product:

[red1]

The GET / SAVE part shall be more automated:

NEW ESTIMATE - < - select BOM - > GET:Template | Save:Estimate

........ ESTIMATE - < - select BOM - > Get: Estimate | Save:Cache | Get:Cache | Save:Estimate

Hopefully this is intuitive. the 2 saves:estimates call the same routine.

The procedure is that when the user first want to create a new estimate he shuld go to NEW ESTIMATE select from pull down click on Get:Template and Save:Estimate rite away.

Then at ESTIMATE only resume the work. Edit it and SAVE:CACHE.

Finally finishing then SAVE:Estimate.

To redo work on same estimate then Get:Cache

[Usman]

for the test case, u can use the GA-M2209 & GA-M2631 bom i sent to uu, try to replicate them and set it in this est_bom.
send me the datadump as soon as you have it done.

[red1]

The latest is http://red1.org/barn/medan/bomx.htm and http://red1.org/barn/medan/bomf.htm .

The codes and vms are sent to CVS. Now the system uses the ProductBOM as template and extract out for copies to be modified during OC.

First choose the product i.e. GA-M, press 1.Get and input its code i.e. 2209, then press 2.Save.

Then save C work with the Cache. At each ghost element u can press 'c' formula pop-up to refer the price to a number of elements. All checked will be added up. U can apply percent to each element u choose.

Pls inform if this concept is correct first. The returning price is still not finished yet but the whole setup works. So pls setup a complete case. U have to set your DB with the following SQL

[Usman]

I try to create 2 estimation from GA-M template : GA-M2631 & GA-MTest.
However I cannot change the BQ for both GA-M2631 & GA-MTest, so practically GA-M, GA-M2631, GA-MTest all have the same price, which is not as expected.

Also when I try to click on formula button for P_Technical_risk, this error message appear :

ORA-00904: "P_BF_ESTKEY": invalid identifier

[red1]

Usman, i managed to change all the Estimates to different prices. Anyway i notice a different bug which is solved.

pls get source from CVS again. I have made the Save C (cache) much faster after correcting loop mistake in the jdbc.

Whenenever u change a BQ that has many similar occurence, change only the first occurence i.e. the first Velocet item if changed to 0.1 from 0.00648 then u have to do this:

1) calc BQ
2) SAVE
3) GET
to see if all Velocet is changed to 0.1 (this rule means that similar occurences of a particular child's BQ must become same)

I also tested with a higher parent BQ change, and its reflected after SAVE and GET.

If this still happens pls give me your exact BQ change position.

btw pls add this field to your DB

[Usman]

Yes, I can change and save BQ now.
I think we need to add BQ column between check box and % in the formula window.

Following is the example case :
P_Technical_risk

Direct Cost......................P_Moulding...................................1.0........788.78674........1.0 Each............USD788.78674.....v..........1* 100%
Direct Cost......................P_Fettling......................................1.0........189.10434........1.0 Each............USD189.10434.....v..........1 * 100%
casting(net)/GMS-06....casting(nonreturn)/GMS-06...1.0........0.08574345.......3340.0 Each.....USD286.38312.....v..5465 * 100%

v = checked line
bold char = BQ reference, default is 1 (one)

[red1]

No need the above cos we can do Formula in Consolidated mode where the Gross Weight shall be present in that line.

Check Consolidated and Get the view again before going for Formula Window.

Now i have finished the codes to update the price reference to the Est_BOM.

But u have to change your view in DB by running this

[Usman]

I change structure of GA-M, the changes is :
* Added P_NetWt & P_ReturnWt as direct child of GA-M
* Casting (Scrap)/GMS-06 now non-BOM and using formula
* P_Casting/Casting (net) BQ refer to P_NetWt
* P_Casting/Casting (Scrap) BQ refer to P_ReturnWt
* P_Heat_Treatment/HT_Weight BQ refer to P_NetWt

issue :
* If I change P_NetWt or P_ReturnWt BQ, other BQ formula refer to them cannot automatically change.
* Wrong price value for Casting (Scrap)

Here is the the data dump :

http://www.red1.org/barn/medan/ExpDat21062006.jar

[red1]

There is still some small bugs i got to trace out. Once done i will inform here and u can try again.
At the moment the formula doesnt auto update yet. Cos i need to stabilise the logic first. So u need to go into the formula to Save again.

I will review this later once its more stable and i get more feedback of other behaviour, as the codes can be messy to tinkle too much for one or two matters only.

U must be aware that we are trying something new here, which is risky as lots to test and many other parts hasnt come in yet. So we avoid cosmetic or friendliness issues for the time being. Lets get all the logic and pricings correct. Force and POC as a total picture. Then we put in all the screws. Thats the rite discipline.

I will review latest feedback once i finish off Tag-Serial Setup.

Now its more stable . pls try again...take from CVS the latest. See what works and what dont.. more info will help

[Usman]

Wrong price value or calculation still there, it happens when I click on formula button of P_Casting/casting (scrap) > select P_ReturnWt for BQ Reference > SAVE > RETURN > calc BQ. ( previous steps I assign P_ReturnWt to 2125)

Then, I check grand total at the bottom it comes up USD 641072.75, which is wrong.

I also need delete child feature urgently, the purpose is to provide flexibility when we want to modify BOM structure such as when i use GA-M template to construct GA-M2209, i need to delete all machining cost since GA-M2209 have no maching process, also casting material is GAS-06 which is different with the GA-M template (GMS-06).

[red1]

Was still correcting the same bugs. Just CVS again. Shuld be ok in Formula saving to all items related.

[Usman]

Updated yr last code, but Error is still there...

[red1]

I have DBRestore your DB and tested last nite and still cannot see the same error figure u have. I got USD 611571.4 for GA-M2631. All formulas inside are as u said u did.

All changes seems reflected well in a smaller case test.

Can u give exact steps using your DB u gave me, i.e. formulas and changes so that i can replicate the same error figure u got?

btw make sure the total is from only the IsBOM or darker blue lines. Thus make sure that the lowest rank childs are not IsBOM.

I m now doing the BOM EDIT page where u can DELETE (deActivate) lines that u dont need, and also check the IsBOM status.

[Usman]

yr value USD 611571.4 (hunred thousand ) for GA-M2631 is also wrong, the correct one is USD 6323,373. (only thousand).
i think the bug is in the Casting (scrap) calculation.

[red1]

In the table, Casting(Scrap) shows 28.638311 X 2125.0 Each = USD60,856.41 Looks like the price of 28.6 for each kilo of scrap is too high and wrong. I check your other scrap price its 0.08574345. So is that the cause? And to resolve is put that rite price? Then its not a bug, but GIGO matter.

Yesterday i have done the http://red1.org/barn/medan/BOMdelete.htm which only makes IsActive either 'Y' or 'N' as the proper way to delete things in Compiere. This screen also shows u the IsBOM value for your reference. We can make this screen show more things as it has space for that.

U have to edit your DB to get the IsActive field included (wont remove your Estimated work)

[Usman]

CVS is down, I cannot get yr new code.
Pls. send me latest code.

[red1]

Sometimes its down for extshh. Try later, as we dont want to unsynch the codes. Or u can create a new CVS but as anonymous user (no password) and protocol is pserver.

I still cannot synch to CVS so i will try tomorrow. If still cannot i post the source to barn/medan pls dont replace it in your Eclipse project. Import it as a new project and disconnect the Team share and delete its CVS entries. If u mixup with the present CVS project will confuse later.

Now the BOM has http://compiere.red1.org/bom_formula_hilite.htm . U have to view in Consolidated mode.

(Finally i manage to solve the extssh CVS connection for developers. U have to discard your location and then recreate but leave the password blank so that it ask u again and then u keyin and it works!)

BOM Formula Copy just done. When u created a new Estimate, u can select another Estimate and copy its formulas! Then GET C again in Consolidated mode to see the formulas. U have to go in each to save to get its values.

[red1]

Now u can Refresh All Formulas by clicking on <C> button. This is really useful when used with Copy formula. Saves u time for repeating the formulas on new Estimate.

After <C>, u press on BQ button to recalculate totals and grandtotal price. Then press Save C as usual.

Already CVSed the codes.

[Usman]

updated yr CVS, however the <C> button is un-ciick able (grey out).
As mentioned in other topic, I already imported Vendor & Purchased Product Data.
Now I moving to next POC step which is link our real purchased product (price list in IDR) in the BOM Structure.
The first issue come out is currency problem, since pricing in BOM is using USD I can not add any BOM child using currency other than USD.

For the example case :

Moulding_WglasVelocet_Combi
|---waterglass -----> to be replace with WATER GLASS @ 330 KG (search key = P-WB109.01)

try this using my newest datadump "ExpDat.jar" in barn/medan.