red1.org

red1 · Posted: Fri Jun 10, 2005 11:35 am Post subject: Final Nightly Files

ExpDat_09.jar, and ILF_customers.csv, and X_* javas was posted last nite.
This morning i updated ILF.xls, as i left out sumtin which Trifon told me. XML2ADHandler.java i deleted as i did a mistake, tot that tablename is in error, but Trifon told me that "Business Partner " has a space after, so i revert my code and thus its not a bug as i tot, and no need to post that.

red1 · Posted: Tue Jun 14, 2005 6:52 pm Post subject:

Latest change advice and files from Trifon has been imported and incorporated into my instance and i exported as ExpDat_14.jar. Sent there together with ILF.xls and Hutzler.druid.

red1 · Posted: Tue Jun 21, 2005 6:45 am Post subject:

last nite's build sent is http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_20.jar

1) Org: Gourmac removed
2) Sales Order has Detail Row sub-tab
3) POC of Batch Print BOL
(Pls do POC testing in GardenWorld which has some test data in shipment)

red1 · Posted: Tue Jun 21, 2005 9:19 am Post subject:

Just uploaded a Morning Build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_21.jar

which

1) Removed seq390 from ImportCustomer ILF

2) Structurally better BOL PrintFormat for the Batch Print test.
(Where details refresh properly by putting them into the content area)

red1 · Posted: Wed Jun 22, 2005 8:42 pm Post subject:

Just sent a nightly build that has incorporated the latest druid changes via XML2AD and AlterTable
1) Package.FreightRule
2) SalesOrder.SalesComm
3) SalesOrderLine.SalesComm

Also applied the XML2AD>View to put the fields into the Package and Sales Order window.

http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_22.jar

trifon · Posted: Thu Jun 23, 2005 12:10 am Post subject:

red1 · Posted: Thu Jun 23, 2005 7:27 am Post subject:

Trifon,
I sent that jar again, toh i dont see any change in size.
I also sent up http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ViewPkgSO.xml that has the window changes. We can add this into the overall ViewTest.xml too later.

trifon · Posted: Thu Jun 23, 2005 4:00 pm Post subject:

red1 · Posted: Fri Jun 24, 2005 12:58 pm Post subject:

Sent http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_24.jar
which has SalesRep_ID in the I_Bpartner table.
Done via XML2ad and AlterTable.
For Rich to retry import Vendors.

red1 · Posted: Wed Jun 29, 2005 6:08 pm Post subject:

252d latest developer's kit:
Wink

1) 252d Source http://red1.org/barn/HutzlerCompiereUSA/sources/red1/C-252d.zip (45Mb)
2) 252d Binary http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip (28Mb)
3) DB dump as progressed till latest note in 252 Client Setup. http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_29.jar (2Mb)

Trifon can just double check that ILFs are in order.
Rich may reimport all his data. We resume as the way we were in 251g.
Report any mishaps in the 252d Client Setup thread.

I will call it a day till tomorrow morning, where i will glance over the battlefield galactica of the SalesComm, Freight and BOL.

red1 · Posted: Sun Jul 03, 2005 12:59 am Post subject:

latest 252d http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_03.jar

1) Package>FreightRule (Prepaid, Collect, Prepaid&Add)

2) Sliding Ruleset / SlidingTable / SlidingRule

TODO GenerateModel, MSlidingTable/Rule, then compile for binary.

red1 · Posted: Tue Jul 05, 2005 11:57 pm Post subject:

Rich,

U can collect the latest http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_05.jar

http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

It incorporate latest ViewTest/xml in the DB and sources from Trifon in the binary.

red1 · Posted: Wed Jul 06, 2005 7:42 pm Post subject:

We have uploaded the latest http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_06.jar

Pls find that the SlidingTable is under the Sales Marketing menu, before Commissions and they have been preset to the Hutzler and Progressus rules.

Pls also confirm that the Sales OrderLine has Sales Commissions that look up this SlidingTable to return the Percent Factor that multiply with LineNetAmt. It has been tested to return as expected under previous stated specs.

The BOL Batch Print is also preset. U can go into GardenWorld to try it. The watermark is just a gif file that we will tune and instruct how to install as an attachment.

The Freight Callout from InvoiceLine to Freight Rules tracking all shipments from that invoice as defined in Packages is understood and involves a lengthy Callout that is modular and shall be plugged in when ready.

These features are proven at framework and further adjustments can be done where needed.

red1 · Posted: Mon Jul 11, 2005 2:55 pm Post subject:

Here are the latest build of ExpDat, Binary:

http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_11.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Login as GardenAdmin to essentially examine and test the accounting consequence of InvoiceDiscount under Sales Order.

Also give further instructions on how to tweak the window-fields.

The XML2AD is not finely tuned and requires time to handle properly.

Still i spend some time testing the setting of Invoice Discount, Total Discount and summing of amts, seems ok.
I still left the CommFactor, my time exhausted more on proving the field detailings. We need confirmation that things are in the right direction before mopping up.
Next i have to hurry on the Freight. Try to make it by tonight and post for Rich to sight if the concept is correct.

I also posted the main java source i amended::
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/CalloutOrder.java http://red1.org/barn/HutzlerCompiereUSA/sources/red1/MOrderLine.java

riche · Senior Joined: 16 Dec 2004 Posts: 386

The latest dump did not have the field ITTYP & PACKC created in the I_Product table and were also missing from the product ILF.

Also, please remove HQ org (& warehouse) and create warehouses for Hutzler & Progressus orgs.

-Rich

red1 · Posted: Tue Jul 12, 2005 2:55 pm Post subject:

Both matters above done.

red1 · Posted: Wed Jul 13, 2005 12:44 am Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_13.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Resolve as per feedback to Rich's comment.

*Updated again the above to include the FreightRule amt update at invoiceline that originates from SO > Shipment that is for Customer that has FCR as Fix (can change to any name), and has FrieghtAmts in Shipment

red1 · Posted: Thu Jul 14, 2005 6:44 pm Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_14.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

FreightCostRule added 'H' FS & Handling, logic included. Tested OK.

red1 · Posted: Fri Jul 15, 2005 3:02 am Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_15.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Included Trifon's :

1) java source

2) ILFs

3) Druid, ViewTest, AlterTable

Done GenerateModel to recreate all X_* files.

red1 · Posted: Sat Jul 16, 2005 2:56 pm Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_16.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Work done is
>as Trifon's tasks thread.
>GenerateModel.

TESTED:
InvoiceLine populate of FCR for both A and H with Description.
InfoBPartner Window's arrangement with data.

red1 · Posted: Mon Jul 18, 2005 1:16 am Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_18.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Patched up CalloutOrder class that didnt handle null values in ItemDiscount and ItemPrice.

Compiere somehow still got old ADUser error. Resolved again in new ExpDat.

This code was patched in:
UPDATE C_ElementValue SET AD_Org_ID=0
WHERE AD_Client_ID= 1000000;

Updated again expdat tonight 10pm local time, that has FCR in BOL.

red1 · Posted: Wed Jul 20, 2005 3:48 am Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_20.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Done with latest ILFs from Trifon.

Implemented I_BPartner XML2AD and View.

Posted again.
DONE as stated in latest RED'1 TODO thread.
Reverted ImportBPartner to set FCR, ShipperID, Comment, etc into BPartner as before and BPartnerLocation.

red1 · Posted: Fri Jul 22, 2005 8:27 pm Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_22.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

I have done my TODO as discussed this morning with Rich (1, 6a,b,d,e, 7 and 9) 9 also has 2 bugs that is now solved.

Also did Trifon's Data.xml, View, Druid.. ImportBPartner and MBPartnerLocation.

red1 · Posted: Sun Jul 24, 2005 10:52 pm Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_24.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

incorporatd latest from Trifon.

set OrgID in ValidCombination window to refer to all Orgs instead of just trx Orgs.

resolved error in code of ImportBPartner.java. Committed a fresh binary, so pls collect Compiere_C252.zip again

red1 · Posted: Tue Jul 26, 2005 7:06 pm Post subject:

latest build http://red1.org/barn/HutzlerCompiereUSA/sources/red1/ExpDat_26.jar
http://red1.org/barn/HutzlerCompiereUSA/sources/red1/Compiere_C252.zip

Imported ILF for AR again.
Modified PrintFormat to be more proven for handling BOL:
- Softer lines
- Details rows made way for right column
- Freight Rule appearing on right side