web-erp-developers — Discussion on development of webERP

[Web-erp-developers] Re: /web-erp/ContractsList.php

[Daintree <p.d...@pa...>]

BlankThis is not yet implemented - I have tables in there to allocate costs
to contracts.
----- Original Message -----
From: Stins, Dick
To: Phil Daintree
Sent: Monday, February 02, 2004 8:08 AM
Subject: /web-erp/ContractsList.php


 Phil,

Another broken link in the script:
http://../web-erp/SuppTransGLAnalysis.php?
Not Found
The requested URL /web-erp/ContractsList.php was not found on this server.
with best regards,
Dick Stins

[Web-erp-developers] Re: vat high low zero

[Daintree <p.d...@pa...>]

Dick,

I only know about the UK, Australia and New Zealand - all 3 use two rates of
tax - of which one is 0%. In all three it depends on where the customer is
where the goods are delivered ie supplies outside the tax authority are in
every case 0%. So if the products are invoiced out of a warehouse in
Birmingham destined for Iceland then the supply is exempt from tax.
Some products like childrens clothing was zero rated, food and insurance(?)
ie 0% even when the delivery is round the corner.

So... I think that storing the tax authority against the customer branch is
the right place (as it is) - but what we need is a way to make up a matrix
of applicable rates for the tax authority depending on the product. We need
a new table which has:

TaxAuthLevelID  - Some Unique code for the table index - to be stored
against invoice line items
Tax Authority -   eg UK VAT
Level_Description  eg zero rated/taxable supplies
CategoryID   - reference to the stock category
TaxRate  - the applicable tax rate

Sherif has added some interesting extras in Open Accounting where there are
potentially two tax authorities for the same supply ... ouch! He has tax
authority groups - ie multiple taxing authorities each with different rates
applicable, that apply to different products and selling destinations. I
think this is possibly overkill for most countries - except the middle
east..

Since different Levels could apply to each line of the invoice as you say we
need to store the TaxAuthLevelID against the stock movements created. This
would be a useful key for a seperate tax report if required.

I have a requirement to get EDI up and running at least with invoices so
I'll do this first - not sure if Jeff is going to help with this or not.

I will send you the updated scripts later.

Phil
----- Original Message -----
From: "Stins, Dick" <DR...@Zi...>
To: "Daintree" <p.d...@pa...>
Sent: Monday, February 02, 2004 9:24 AM
Subject: Re: vat high low zero


> Phil,
>
> You are right. Also the location is related. It is even more complicated.
> International companies have several warehouses in several locations. Or
> sometimes one warehouse but made a deal with the tax department that some
> products are virtually located abroad, so they are allowed to reduce
import
> and export rules.
>
> In other products, I have seen very complicated solutions.
>
> I think we should start with a simplified solution.
> Just a proposal:
> - only hold the current tax rate with a start date (ofcourse I recommend
> logging historical data)
> - when the transaction has taken place before the start date, the end user
> should enter it manually (when the company is not behind with their
> accounting, there is no need to do this). Consequence: we should store the
> vat rate with the processed data (invoice line like you proposed),
otherwise
> we loose information.
> - we relate the current vat types to inventory categories
> - a tax change can have the consequence that some products move from a
high
> rate to a low rate, so we need a system to split or join (sub) categories
> for splitting the tax rate.
> - For suppliers, we should keep it like it now is: automatically or
override
> manually
>   * for the vat report I need to recognise which tax is vat or no vat.
> - since vat is related to the (virtual) location where the stock is and
the
> location where the customer is, it will be very complicated. So I have the
> next proposal for a start:
>     * location stock + product category + local vat % + abroad vat %
>     * when the customer is abroad, the end user should be able to overrule
> the automatic vat (=abroad vat  or if abroad vat is empty then local vat).
>
> We need to think very good about the categories.
> It might be wise to create special tax categories, or create subcategories
> in the functional categories so we are able to keep the functional
> categories and are also able to vary the the vat rates within the
functional
> categories through creating subcategories.
> There is also an option to add products to more than one category. One for
> functional reasons. One for tax reasons. One for local reasons. One for
> local and tax reasons.
>
> Since this all sounds very complicated, it might be for quick
implementation
> reasons not to relate categories to vat types but directly to vat types,
> with the minor consequence that tax type changes are probably harder to
> maintain.
> But I think that this disadvantage has to be proofed in practise before we
> develop very complicated software to solve this issue. Or make it an
> enhancement request to develop later.
> So when we leave the category stuff like it is, we need this:
>     * location stock + product + local vat % + abroad vat %
>     * when the customer is abroad, the end user should be able to overrule
> the automatic vat (=abroad vat  or if abroad vat is empty then local vat).
>
> Do you have any other suggestions?
> Is the abroad vat% column a good idea or is it of no use in practise?
>
> With best regards,
>
> Dick Stins
>
> ----- Original Message -----
> From: "Daintree" <p.d...@pa...>
> To: "Web-ERP Developers" <Web...@li...>;
"Stins,
> Dick" <DR...@Zi...>
> Sent: Sunday, February 01, 2004 8:11 PM
> Subject: Re: vat high low zero
>
>
> > BlankYes we need to do something here. As well as depending on the
product
> > the tax often depends on where the customer is - both factors need to be
> > taken into account and tax needs to be held at the line level ... I
think.
> > This is a more serious change and needs a little thought. Maybe the tax
> rate
> > needs to be held at the stock item level, but it would also depend on
> where
> > the customer is. There needs to be some kind of tax matrix.
> >
> > Phil
> >   ----- Original Message -----
> >   From: Stins, Dick
> >   To: Phil Daintree
> >   Sent: Monday, February 02, 2004 3:11 AM
> >   Subject: vat high low zero
> >
> >
> >   Phil,
> >
> >   I can't find how to setup VAT as needed in The Netherlands. (I guess
we
> > have to implement this)
> >
> >   In The Netherlands, we have 2 kinds of tax:
> >   insurance tax=6% for insurance companies.
> >
> >   or VAT:
> >   - high: 19% for standard
> >   - Low: 6% for food and some other basic life needs
> >   - Zero: 0% for some export services and ....
> >
> >   I guess this should be a property of a stock category.
> >
> >   The invoice should have a column with a indication of which vat type
is
> > has.
> >   It should have a total for each vat type (only when >0 ).
> >
> >   When this functionality is available, please tell me how to configure
> > web-erp, because I have not found it. (or help me to create an example
in
> my
> > demo system at: http://195.240.119.84/web-erp)
> >
> >   When this functionality is not available in web-erp:
> >   - let's brainstorm how we can implement this:
> >   * option to turn it off or on for user who do not need this?
> >   *  stock category?
> >   * the goverment forces for vat changes from time to time, so we need
to
> > know which percentage was used in the past and/or now?
> >
> >   with best regards,
> >
> >   Dick Stins
> >
> >
>
>
>

Re: [Web-erp-developers] Re: vat high low zero

[Daintree <p.d...@pa...>]

This sounds good Sherif, any insights would be good.

> 
> In OpenAccounting I've implemented a flexible taxation system :
> 
> * Invididual taxes can be defined
> * Tax groups can be defined (consisting of one or more individual 
> taxes)
> * Customers and suppliers can be assigned tax groups
> * Items have seperate tax groups which define which taxes apply to 
> them.
> * Taxes can be defined as included in the price or not.
> 
> I had to make quite a few changes for this but if you want to copy it 
> over to web-erp I'd be more than happy to give you more info on its 
> implementation.
> 
> cheers
> Sherif
> 
> > This is a multi-part message in MIME format.
> > 
> > 
> > BlankYes we need to do something here. As well as depending on the 
> product
> > the tax often depends on where the customer is - both factors need 
> to be
> > taken into account and tax needs to be held at the line level ... I 
> think.
> > This is a more serious change and needs a little thought. Maybe the 
> tax rate
> > needs to be held at the stock item level, but it would also depend 
> on where
> > the customer is. There needs to be some kind of tax matrix.
> > 
> > Phil
> >   ----- Original Message -----
> >   From: Stins, Dick
> >   To: Phil Daintree
> >   Sent: Monday, February 02, 2004 3:11 AM
> >   Subject: vat high low zero
> > 
> > 
> >   Phil,
> > 
> >   I can't find how to setup VAT as needed in The Netherlands. (I 
> guess we
> > have to implement this)
> > 
> >   In The Netherlands, we have 2 kinds of tax:
> >   insurance tax=6% for insurance companies.
> > 
> >   or VAT:
> >   - high: 19% for standard
> >   - Low: 6% for food and some other basic life needs
> >   - Zero: 0% for some export services and ....
> > 
> >   I guess this should be a property of a stock category.
> > 
> >   The invoice should have a column with a indication of which vat 
> type is
> > has.
> >   It should have a total for each vat type (only when >0 ).
> > 
> >   When this functionality is available, please tell me how to 
> configure
> > web-erp, because I have not found it. (or help me to create an 
> example in my
> > demo system at: http://195.240.119.84/web-erp)
> > 
> >   When this functionality is not available in web-erp:
> >   - let's brainstorm how we can implement this:
> >   * option to turn it off or on for user who do not need this?
> >   *  stock category?
> >   * the goverment forces for vat changes from time to time, so we 
> need to
> > know which percentage was used in the past and/or now?
> > 
> >   with best regards,
> > 
> >   Dick Stins
> > 
> > 
> > 
> 
> -- 
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 

Re: [Web-erp-developers] Re: vat high low zero

[Sherif O. <sh...@ky...>]

Phil,

In OpenAccounting I've implemented a flexible taxation system :

* Invididual taxes can be defined
* Tax groups can be defined (consisting of one or more individual 
taxes)
* Customers and suppliers can be assigned tax groups
* Items have seperate tax groups which define which taxes apply to 
them.
* Taxes can be defined as included in the price or not.

I had to make quite a few changes for this but if you want to copy it 
over to web-erp I'd be more than happy to give you more info on its 
implementation.

cheers
Sherif

> This is a multi-part message in MIME format.
> 
> 
> BlankYes we need to do something here. As well as depending on the 
product
> the tax often depends on where the customer is - both factors need 
to be
> taken into account and tax needs to be held at the line level ... I 
think.
> This is a more serious change and needs a little thought. Maybe the 
tax rate
> needs to be held at the stock item level, but it would also depend 
on where
> the customer is. There needs to be some kind of tax matrix.
> 
> Phil
>   ----- Original Message -----
>   From: Stins, Dick
>   To: Phil Daintree
>   Sent: Monday, February 02, 2004 3:11 AM
>   Subject: vat high low zero
> 
> 
>   Phil,
> 
>   I can't find how to setup VAT as needed in The Netherlands. (I 
guess we
> have to implement this)
> 
>   In The Netherlands, we have 2 kinds of tax:
>   insurance tax=6% for insurance companies.
> 
>   or VAT:
>   - high: 19% for standard
>   - Low: 6% for food and some other basic life needs
>   - Zero: 0% for some export services and ....
> 
>   I guess this should be a property of a stock category.
> 
>   The invoice should have a column with a indication of which vat 
type is
> has.
>   It should have a total for each vat type (only when >0 ).
> 
>   When this functionality is available, please tell me how to 
configure
> web-erp, because I have not found it. (or help me to create an 
example in my
> demo system at: http://195.240.119.84/web-erp)
> 
>   When this functionality is not available in web-erp:
>   - let's brainstorm how we can implement this:
>   * option to turn it off or on for user who do not need this?
>   *  stock category?
>   * the goverment forces for vat changes from time to time, so we 
need to
> know which percentage was used in the past and/or now?
> 
>   with best regards,
> 
>   Dick Stins
> 
> 
> 

-- 

[Web-erp-developers] Re: vat high low zero

[Daintree <p.d...@pa...>]

BlankYes we need to do something here. As well as depending on the product
the tax often depends on where the customer is - both factors need to be
taken into account and tax needs to be held at the line level ... I think.
This is a more serious change and needs a little thought. Maybe the tax rate
needs to be held at the stock item level, but it would also depend on where
the customer is. There needs to be some kind of tax matrix.

Phil
  ----- Original Message -----
  From: Stins, Dick
  To: Phil Daintree
  Sent: Monday, February 02, 2004 3:11 AM
  Subject: vat high low zero


  Phil,

  I can't find how to setup VAT as needed in The Netherlands. (I guess we
have to implement this)

  In The Netherlands, we have 2 kinds of tax:
  insurance tax=6% for insurance companies.

  or VAT:
  - high: 19% for standard
  - Low: 6% for food and some other basic life needs
  - Zero: 0% for some export services and ....

  I guess this should be a property of a stock category.

  The invoice should have a column with a indication of which vat type is
has.
  It should have a total for each vat type (only when >0 ).

  When this functionality is available, please tell me how to configure
web-erp, because I have not found it. (or help me to create an example in my
demo system at: http://195.240.119.84/web-erp)

  When this functionality is not available in web-erp:
  - let's brainstorm how we can implement this:
  * option to turn it off or on for user who do not need this?
  *  stock category?
  * the goverment forces for vat changes from time to time, so we need to
know which percentage was used in the past and/or now?

  with best regards,

  Dick Stins

[Web-erp-developers] Re: broken link CustomerInquiry.php

[Daintree <p.d...@pa...>]

BlankHi Dick,

This is fixed too now ... many thanks.

Phil
  ----- Original Message -----
  From: Stins, Dick
  To: Phil Daintree
  Sent: Monday, February 02, 2004 1:14 AM
  Subject: broken link CustomerInquiry.php


  Phil,

  I got a broken link at script:
  .../web-erp/CustomerInquiry.php?CustomerID=JOHNSON

  The broken link is:

.../web-erp/css/professional/images/GLTransInquiry.php?TypeID=12&TransNo=18

  Please reply a link where I can find this bug report at sourceforge or
should I report it somewhere by myself at sourceforge?

  with best regards,

  Dick Stins

[Web-erp-developers] Re: PHP Developer

[Jeff D. <jef...@ho...>]

Hey Phil.

That sounds like a good task...yes, i'd be interested in the seeing the 
format. and if you don't mind the table schema(s) that would be being used 
to retrieve the data to build the transfer.   i'll try to install your code 
tonight so i can take a look at the db myself and take a look at the overall 
functionality.

All in all it sounds like a fun challenge, and i'd definitely be interested 
in helping...what kind of time frame are you thinking about?


Thanks
Jeff


>From: Daintree <p.d...@pa...>
>Reply-To: Daintree <p.d...@pa...>
>To: Web-ERP Developers <Web...@li...>, Jeff 
>Dyke <jd...@us...>
>Subject: Re: PHP Developer
>Date: Thu, 29 Jan 2004 08:31:03 +1300
>
>Thanks for your interest Jeff,
>
>There are  a number of areas of work....
>
>EDI
>
>I was thinking that a facility to create a flat file from a purchase order
>in the format described by EANCOM's Electronic Data Interchange would 
>enable
>dispatch of EDI orders. This could be an option on the PO_PDFPurchOrder.php
>page if the supplier is defined as EDI enabled. The supplier master would
>need some additional information regarding the transport mechanism - either
>email address or ftp - server address. Additional tables would be required
>to cross reference the item codes of the system to the item code of the
>supplier. I can send you the specification of the EANCOM Orders.
>
>Similarly, the sending of EDI sales orders from a customer to be imported
>into a sales order. I figure this script will be a scheduled script running
>in the background to poll an email address and/or an ftp server's 
>directory,
>to take the files in attachments and parse them into a sales order - again 
>a
>translation table will probably be required for parts and customer 
>branches.
>If there were orders uploaded, then a customer service person is emailed -
>perhaps defined in config.php - with the new order numbers created by the
>script.
>
>This is a tricky area I think and may well be a bit of a mission. Was this
>the area you were interested in?
>
>Regards
>
>Phil
>
>----- Original Message -----
>From: "Jeff Dyke" <jd...@us...>
>To: <dai...@us...>
>Cc: <jd...@us...>
>Sent: Thursday, January 29, 2004 5:13 AM
>Subject: RE: PHP Developer
>
>
> >
> > Hello. I saw your help-wanted post and am interested. i've
> >
> > got about 4 years of solid php work(my project is posted at
> >
> > phpimageview.sourceforge.net).
> >
> >
> >
> > I enjoy working on conversion db->file and vise versa type
> >
> > tasks and have done a few.  i'd be interested in more
> >
> > information if the spot is still open.
> >
> >
> >
> > Thanks
> >
> > Jeff
> >
> >
> >
> >
> >
>

_________________________________________________________________
Let the new MSN Premium Internet Software make the most of your high-speed 
experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1

[Web-erp-developers] Fw: PHP Developer

[Daintree <p.d...@pa...>]

> Hi Jeff,
>
> No panic at all - just want to do it right really.
>
> Some more thoughts follow.....
>
> Have done a little more reading there are a number of different formats
> within EANCOM it seems that industry groups get together and decide which
> fields are appropriate and which not. The upshot is that two customers may
> well want EDI messages is slightly different formats - so we will have to
> set up a table(s) to define the message format to be used for a specific
> customer as well as customer specific branch mapping and part mapping
> tables. I think this will be as simple as
>
> EDI_BranchMapping
>
> DebtorNo - Customer Code 8 (or is it 10?) char
> BranchCode - our branch code 8 (or is it 10?)  char
> CustomerBranchCode char 20
>
> and
>
> EDI_PartMapping
>
> DebtorNo
> StockID
> CustomerStockID
>
> The tables to hold the message format particular to each customer is
another
> story - one that is yet to unfold!!
> The system will need to construct the EDI flat file from this table in
> conjunction with the data that makes up the invoice. Similarly the ORDER
> format message will have to be parsed based on the data in the ORDER
format
> definition for the customer. It will be quite tricky - but a great test!!
I
> will email you the pdf with the EANCOM general description of the ORDER
and
> INVOIC transactions tonight.
>
> Additional fields will be required in DebtorsMaster for
>
> EDIInvoices (bool) does the customer wish to receive EDI invoices
> EDIOrders (bool) does the customer wish to send EDI orders
> EDIName varchar(20)  - the EDIReference the customer uses
> EDITransport varchar(10) - email or ftp.
> EDIServer varchar(50) - email address or ftp server address
> EDIServerUserName varchar(50) ftp server username
> EDIServerPwd varchar(50) ftp server password
>
> We should make this customer EDI setup a seperate script to the normal
> customer entry screen - to avoid clutter most customers will probably not
be
> EDI ones - only the really biggies.
>
> I am thinking that the invoice printing script should have some ifs and
> another option to allow:
>
> 1. printing all invoices in the range
> 2. print only non-edi invoices in the range
> 3. print and send edi invoices in the range
> 4. print non-edi invoices and send edi invoices in the range
>
> The flat file produced using the edi invoice script would then be either
> emailed off as an attachment using html-mime-email class already in the
> system or ftp off to the customers edi server - php would have to be
> compiled with enable-ftp.
>
> Orders received as processed by the script running from cron (or some
> windows sheduler) should email the order number created to the customer
> service person - we will need a new config.php directive for the
> EDIOrders_Notify = cus...@co...; or some such. Perhaps
the
> order number should be in the subject with a blank body to save the
customer
> service person having to open the email to figure out the dispatch note to
> print.
>
> Hope this is not too gruesome as always as the extent of the requirements
> become more clear with some analysis the job gets more sizable!
>
> Phil
>
>
>
> ----- Original Message -----
> From: "Jeff Dyke" <jef...@ho...>
> To: <p.d...@pa...>;
> <Web...@li...>; <jd...@us...>
> Sent: Friday, January 30, 2004 4:44 AM
> Subject: Re: PHP Developer
>
>
> > Hey Phil.
> >
> > That sounds like a good task...yes, i'd be interested in the seeing the
> > format. and if you don't mind the table schema(s) that would be being
used
> > to retrieve the data to build the transfer.   i'll try to install your
> code
> > tonight so i can take a look at the db myself and take a look at the
> overall
> > functionality.
> >
> > All in all it sounds like a fun challenge, and i'd definitely be
> interested
> > in helping...what kind of time frame are you thinking about?
> >
> >
> > Thanks
> > Jeff
> >
> >
> > >From: Daintree <p.d...@pa...>
> > >Reply-To: Daintree <p.d...@pa...>
> > >To: Web-ERP Developers <Web...@li...>, Jeff
> > >Dyke <jd...@us...>
> > >Subject: Re: PHP Developer
> > >Date: Thu, 29 Jan 2004 08:31:03 +1300
> > >
> > >Thanks for your interest Jeff,
> > >
> > >There are  a number of areas of work....
> > >
> > >EDI
> > >
> > >I was thinking that a facility to create a flat file from a purchase
> order
> > >in the format described by EANCOM's Electronic Data Interchange would
> > >enable
> > >dispatch of EDI orders. This could be an option on the
> PO_PDFPurchOrder.php
> > >page if the supplier is defined as EDI enabled. The supplier master
would
> > >need some additional information regarding the transport mechanism -
> either
> > >email address or ftp - server address. Additional tables would be
> required
> > >to cross reference the item codes of the system to the item code of the
> > >supplier. I can send you the specification of the EANCOM Orders.
> > >
> > >Similarly, the sending of EDI sales orders from a customer to be
imported
> > >into a sales order. I figure this script will be a scheduled script
> running
> > >in the background to poll an email address and/or an ftp server's
> > >directory,
> > >to take the files in attachments and parse them into a sales order -
> again
> > >a
> > >translation table will probably be required for parts and customer
> > >branches.
> > >If there were orders uploaded, then a customer service person is
> emailed -
> > >perhaps defined in config.php - with the new order numbers created by
the
> > >script.
> > >
> > >This is a tricky area I think and may well be a bit of a mission. Was
> this
> > >the area you were interested in?
> > >
> > >Regards
> > >
> > >Phil
> > >
> > >----- Original Message -----
> > >From: "Jeff Dyke" <jd...@us...>
> > >To: <dai...@us...>
> > >Cc: <jd...@us...>
> > >Sent: Thursday, January 29, 2004 5:13 AM
> > >Subject: RE: PHP Developer
> > >
> > >
> > > >
> > > > Hello. I saw your help-wanted post and am interested. i've
> > > >
> > > > got about 4 years of solid php work(my project is posted at
> > > >
> > > > phpimageview.sourceforge.net).
> > > >
> > > >
> > > >
> > > > I enjoy working on conversion db->file and vise versa type
> > > >
> > > > tasks and have done a few.  i'd be interested in more
> > > >
> > > > information if the spot is still open.
> > > >
> > > >
> > > >
> > > > Thanks
> > > >
> > > > Jeff
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> > _________________________________________________________________
> > Let the new MSN Premium Internet Software make the most of your
high-speed
> > experience. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1
> >
> >
>

[Web-erp-developers] Re: PHP Developer

[Daintree <p.d...@pa...>]

Thanks for your interest Jeff,

There are  a number of areas of work....

EDI

I was thinking that a facility to create a flat file from a purchase order
in the format described by EANCOM's Electronic Data Interchange would enable
dispatch of EDI orders. This could be an option on the PO_PDFPurchOrder.php
page if the supplier is defined as EDI enabled. The supplier master would
need some additional information regarding the transport mechanism - either
email address or ftp - server address. Additional tables would be required
to cross reference the item codes of the system to the item code of the
supplier. I can send you the specification of the EANCOM Orders.

Similarly, the sending of EDI sales orders from a customer to be imported
into a sales order. I figure this script will be a scheduled script running
in the background to poll an email address and/or an ftp server's directory,
to take the files in attachments and parse them into a sales order - again a
translation table will probably be required for parts and customer branches.
If there were orders uploaded, then a customer service person is emailed -
perhaps defined in config.php - with the new order numbers created by the
script.

This is a tricky area I think and may well be a bit of a mission. Was this
the area you were interested in?

Regards

Phil

----- Original Message -----
From: "Jeff Dyke" <jd...@us...>
To: <dai...@us...>
Cc: <jd...@us...>
Sent: Thursday, January 29, 2004 5:13 AM
Subject: RE: PHP Developer


>
> Hello. I saw your help-wanted post and am interested. i've
>
> got about 4 years of solid php work(my project is posted at
>
> phpimageview.sourceforge.net).
>
>
>
> I enjoy working on conversion db->file and vise versa type
>
> tasks and have done a few.  i'd be interested in more
>
> information if the spot is still open.
>
>
>
> Thanks
>
> Jeff
>
>
>
>
>

[Web-erp-developers] What about a framework?

[Fabrizio B. <fab...@cr...>]

Hi to all,
I saw your project while I was looking for a good open source web erp.

I got a little question, are you using a framework for developing? If
not have you got plans about using one?

I would be very pleased if you'll try our framework MerlinWork, we could
give you all support, because web-erp is very promising.

Let me know.
Regards

-- 
Fabrizio Balliano
________

CREALABS
Viale dei Mughetti, 13/A - 10151 Torino - Italy
Tel. +39-011-735645 - Fax +39-011-735645
http://www.crealabs.it - mailto:fab...@cr...

[Web-erp-developers] WEB-ERP Spanish Version

[Wilhem G. <wgo...@ta...>]

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Two simples questions...<br>
<br>
Do you plan to build translation-interface for Spanish?<br>
Do you have a user manual or quick reference documents?<br>
<br>
I am from Guatemala, Central America, recently found your project, very
useful, if do you want can help with translate manual o program
interface to spanish version language.<br>
<br>
Best Regards,<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
<title>WilhemSig</title>
<div style="text-align: center;"><span style="font-weight: bold;">-------------------------------------------------------</span><br>
<big><big><b style="color: rgb(51, 51, 255);"><i>Wilhem Gonzalez<br>
</i></b></big></big><a href="mailto:wgo...@ta...">wgo...@ta...</a><br>
<img src="cid:par...@ta..." title="SuSE" alt=""
 style="width: 180px; height: 58px;"><img
 src="cid:par...@ta..." title="Wilhem on Linux"
 alt="Wilhem on Linux" style="width: 190px; height: 110px;"><img
 src="cid:par...@ta..." title="MySQL" alt=""
 style="width: 81px; height: 43px;"><img
 src="cid:par...@ta..." title="PHP" alt=""
 style="width: 80px; height: 15px;"><br>
<img src="cid:par...@ta..." title="Apache"
 alt="" style="width: 259px; height: 32px;"><br>
<span style="font-weight: bold;">-------------------------------------------------------</span><br>
</div>
</div>
</body>
</html>

[Web-erp-developers] Bugs PO/WO functionality

[Daintree F. <p.d...@pa...>]

Hi Sherif,

Really keen to include additional functionality you reckon is worthwhile and
fix any bugs you might find.

Phil

Re: [Web-erp-developers] Re: Web-erp database structure change request

[Daintree F. <p.d...@xt...>]

>I remember wanting to query for which
> invoices are related to a certain sales order, this currently is not
> possible. 

I think we can do this as Paul notes with:

SELECT TransNo FROM DebtorTrans WHERE Order_=$WhateverOrderNo AND Type=10;

> BTW, I just noticed that on Order Invoicing (ConfirmDispatch_Invoice.php)
> the date is not saved properly.

Will look into this later. Thanks

Phil
 

[Web-erp-developers] Stock Categories Allowed on Sales Order/Purchase Order

[Sherif O. <sh...@ky...>]

Hi Phil,

I noticed that on sales orders you only allow the addition of stock items
that are either Finished Goods ('F') or Dummy Items ('D'), but do not allow
Raw Materials ('M') or Labour ('L').

On the other hand, on purchase orders, only Finished Goods and Raw Materials
are allowed.

Is there any particular reason for these restrictions ?

Sherif

Re: [Web-erp-developers] Re: Web-erp database structure change request

[Sherif O. <sh...@ky...>]

I think Paul's idea is very good, I remember wanting to query for which
invoices are related to a certain sales order, this currently is not
possible. Completeness of information can only be a good thing. So I would
vote yes even if it requires a new table :)

BTW, I just noticed that on Order Invoicing (ConfirmDispatch_Invoice.php)
the date is not saved properly.

Sherif


----- Original Message ----- 
From: "Daintree Family" <p.d...@xt...>
To: "Web-ERP Developers" <Web...@li...>; "Paul
Clark" <PC...@al...>
Sent: Thursday, September 11, 2003 11:24 PM
Subject: [Web-erp-developers] Re: Web-erp database structure change request


> MessageHi Paul,
>
> Yeah that would be a good.
>
> There can potentially be many dispatches for the same sales order. eg an
> order for railing x and railing y. The railing x is available ex stock and
> is dispatched the same day. Invoice 123456 is appended to the order
> narrative. A week later manufacturing complete railing y and the remainder
> of the order is fulfilled from a back order off the original order. The
> dispatch is invoiced and invoice 123567 is appended to the order comment.
> The comment contains a list of all the invoices that the order was
> dispatched on.
>
> We could and do have a field in the  DebtorTrans table for the order
number
> but it is tricky going the other way. To go from the order back to
invoices
> we must create a seperate table that records invoices, orders due to the
> potentially unlimited number of invoices for a single order. Do you think
> its worth a new table?
>
> Regards
> Phil
>   ----- Original Message -----
>   From: Paul Clark
>   To: 'p.d...@xt...'
>   Sent: Thursday, September 11, 2003 4:49 AM
>   Subject: Web-erp database structure change request
>
>
>   Hi Phil;
>
>       As set out in your Contributor guidelines, I would like to make the
> following request/suggestion for a change in the underlying web-erp
database
> structure.
>
>   When invoicing a sales order, you mark the sales order as completed by
> inserting the value of 1 in the Completed field in the salesorderdetails
> table and appending the value "Inv XX", where X is the invoice number, to
> the Comments field in the salesorder table. Might I suggest the addition
of
> a InvoiceNo field (integer data type) to the salesorder table so as to
keep
> the Comments field and invoice data separate? This would aid in subsequent
> reporting on data based on the invoice number and would also allow for the
> insertion of an index on the InvoiceNo field to speed the queries.
>
>   I don't believe this would have too much effect on the web page order
> processing logic other than the obvious one that the SQL statement on line
> 338 of the ConfirmDispatch_Invoice.php would need to be altered from
>
>    $SQL = "UPDATE SalesOrders SET Comments = CONCAT(Comments,' Inv ','" .
> $InvoiceNo . "') WHERE OrderNo= " . $_SESSION['ProcessingOrder'];
>
>   to
>
>    $SQL = "UPDATE SalesOrders SET InvoiceNo =  '". $InvoiceNo . " WHERE
> OrderNo= " . $_SESSION['ProcessingOrder'];
>
>   and the appropriate Comments or InvoiceNo field would need to be
> referenced by all the other web pages where that data is displayed.
>
>   Kind regards,
>
>   Paul Clark
>   Network Administrator
>   Alco Ventures Inc.
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[Web-erp-developers] Re: Web-erp database structure change request

[Daintree F. <p.d...@xt...>]

MessageHi Paul,

Yeah that would be a good.

There can potentially be many dispatches for the same sales order. eg an
order for railing x and railing y. The railing x is available ex stock and
is dispatched the same day. Invoice 123456 is appended to the order
narrative. A week later manufacturing complete railing y and the remainder
of the order is fulfilled from a back order off the original order. The
dispatch is invoiced and invoice 123567 is appended to the order comment.
The comment contains a list of all the invoices that the order was
dispatched on.

We could and do have a field in the  DebtorTrans table for the order number
but it is tricky going the other way. To go from the order back to invoices
we must create a seperate table that records invoices, orders due to the
potentially unlimited number of invoices for a single order. Do you think
its worth a new table?

Regards
Phil
  ----- Original Message -----
  From: Paul Clark
  To: 'p.d...@xt...'
  Sent: Thursday, September 11, 2003 4:49 AM
  Subject: Web-erp database structure change request


  Hi Phil;

      As set out in your Contributor guidelines, I would like to make the
following request/suggestion for a change in the underlying web-erp database
structure.

  When invoicing a sales order, you mark the sales order as completed by
inserting the value of 1 in the Completed field in the salesorderdetails
table and appending the value "Inv XX", where X is the invoice number, to
the Comments field in the salesorder table. Might I suggest the addition of
a InvoiceNo field (integer data type) to the salesorder table so as to keep
the Comments field and invoice data separate? This would aid in subsequent
reporting on data based on the invoice number and would also allow for the
insertion of an index on the InvoiceNo field to speed the queries.

  I don't believe this would have too much effect on the web page order
processing logic other than the obvious one that the SQL statement on line
338 of the ConfirmDispatch_Invoice.php would need to be altered from

   $SQL = "UPDATE SalesOrders SET Comments = CONCAT(Comments,' Inv ','" .
$InvoiceNo . "') WHERE OrderNo= " . $_SESSION['ProcessingOrder'];

  to

   $SQL = "UPDATE SalesOrders SET InvoiceNo =  '". $InvoiceNo . " WHERE
OrderNo= " . $_SESSION['ProcessingOrder'];

  and the appropriate Comments or InvoiceNo field would need to be
referenced by all the other web pages where that data is displayed.

  Kind regards,

  Paul Clark
  Network Administrator
  Alco Ventures Inc.

Re: [Web-erp-developers] Re: Code as promised...

[Hani N. <ha...@na...>]

Hi sorry for taking so long to get back on the reports issue.

R&OS does not have good support for non-standard charsets, and it would
struggle with Arabic.

Having said that I think it will be better for you guys to continiue to use
it. Since
it seems to be the best PhP based option available.

We will just have to create separate reports for our Arabic needs. We would
need
to do that regardless of the pdf engine we use, since I it is unlikely to
find a report
engine that would be able to create decent output for both orientations
(left-to-right and
right-to-left).

(Sherif: We can worry about that we start writting reports).

Hani.


----- Original Message -----
From: "Sherif Omar" <sh...@ky...>
To: "Phil Daintree" <ph...@du...>; "Web ERP Developers"
<Web...@li...>
Sent: Wednesday, September 03, 2003 9:55 AM
Subject: Re: [Web-erp-developers] Re: Code as promised...


> ......
> ......
> Still waiting on Hani to get back about localization and R&OS
>
> Sherif
>

[Web-erp-developers] Contibutions Guidelines

[Daintree F. <p.d...@xt...>]

Men,

First cut .... all comments appreciated:

Phil

Developer Guidelines for Contributions

Contributions to webERP are encouraged - these simple procedures for doing
so are aimed at reducing the effort for other developers and co-ordinating
the efforts of all contributors:

  1.. Join the list web...@li... and inform the
list of your proposed developments to avoid overlapping effort.
  b.. Obtain the latest development scripts from CVS - see sourceforge
instructions for anonymous cvs checkout the CVS files intially then updates
daily - this only downloads any modified scripts, or update immediately
before commencing any development.
  c.. After any modifications to the scripts - email (only) the modified
scripts to dai...@so... within 12 hours of your last update from
CVS. They will be committed to CVS as soon as possible after receipt and
testing. If you wish to modify several scripts email only the scripts
modified each day for submission to CVS rather than waiting for all the
modifications to be complete. This will minimise any re-work for
modifications done on the same script by other developers.
  d.. Create any new scripts in your own time frame and submit them to
dai...@so.... They will be committed to CVS as soon as possible
after receipt and testing.
  e.. Where modifications span 10 or more scripts at the same time, request
a stay on development from other developers using the list
web...@li...
  f.. All submissions of modifications or additions should be accompanied by
an updated change.log file describing the changes to each script. This is a
chore but explains to everyone the nature of the changes made. Each entry in
the change log should state the developer name and date of the
change/addition.
  g.. Requests for modification of the database structure or fields should
be made to dai...@so...

[Web-erp-developers] Productions vs stable

[Phil D. <ph...@du...>]

Gentlemen,

Sherif's point is another good one.

I don't think it will be such a major job to get this new facelift version
stable - after having had another evening on it last night. The beauty of
the discrete script arrangements implicit in the design, together with
reliance on only the now quite mature php, means that we are unlikely to
have a flaky system that works then doesn't for reasons that are very
difficult to determine. This I believe is another serious advantage we have
over many of the commercial accounting software vendors. Stability is always
going to be better when dependencies are fewer and we are not using bleeding
edge software as the basis of the system.

My preference is to minimise the administration of the software development
process and concentrate on new functionality so far as possible. To that end
I would like to use the CVS as the current developement version and release
file archives as production/stable only when it has undergone sufficient
testing.

I am keen to encourage other people to contribute too but this does carry
with it a requirement on me to audit the quality - which in itself is time
consuming. So far we have been fortunate to have highly skilled
contributions from Sherif and Shane. I am thinking that a code of practise
with just a minimal rule set as to how contributions can be made easily and
minimise the risks and administration. I will draft something up  and get
your comments.


Phil

Re: [Web-erp-developers] Re: Code as promised...

[Sherif O. <sh...@ky...>]

Hi Phil,

I suggest that to manage stable/development versions, we have 2 streams of
code :

1 - a "stable" stream, which is well tested and in production use.

2 - a development stream where all submitted changes are put. Once a certain
development build is well tested, it will be promoted to stable.

The planned work going forward looks GREAT - Work orders will be a very very
good addition to the system. I'm sure we can handle some of the
implementation of the new features.

Still waiting on Hani to get back about localization and R&OS

Sherif

----- Original Message ----- 
From: "Phil Daintree" <ph...@du...>
To: "Web ERP Developers" <Web...@li...>; "Shane
Barnaby" <SBa...@al...>
Sent: Wednesday, September 03, 2003 8:15 AM
Subject: [Web-erp-developers] Re: Code as promised...


> Hi Shane,
>
> It looks great and I agree the overall appeal of the system has lifted
> greatly - first impressions count a whole lot.
>
> The difficulty is that with a big restrucuture like this inevitably the
risk
> is high that we introduce problems. I'm desperately keen to avoid these at
> least in the distribution files. So in the short term my focus will be on
> ensuring we do in fact have the latest files updated with the includes
> header.inc sesssion.inc etc and that all the scripts work as intended so
we
> can release a new distribution archive with the new look. Your help in
this
> would be most appreciated. If you could fire off files to me as and when
> that would be preferable to a complete zip of the whole lot otherwise its
a
> devil of a job to pick through all the files to figure out the changes. So
> if you modify a file send it off there and then so I can incorporate it
> straight away. The likelyhood of us both working on the same script at the
> same time is minimised.
>
> Sounds like there is no problem with .gifs anymore - great.
>
> The focus for me for the future is:
>
> Bug fixes and quality improvement as the major focus.
>
> Shipment costing - integrated a shipment costing system into accounts
> payable. Much of the work is done but have not got into finishing it off.
>
> Conversion to R & OS pdf.php class for the balance of the reports -
although
> this may cause some difficulty for Sherif/Hani doing the conversion to
> multi-language/localisation I understand that this class we are using has
> some problems with foreign fonts. However, the pdflib pricing is
astronmical
> in a commercial environment and part of the fun of all this is doing for
$0
> what costs USD$35k from 1st tier software companies. I am holding off on
> developing down this track while Hani works through the issues for
> localisation.
>
> Manufacturing functionality will then become a focus for me:
> Work Orders
> Work order issues of material
> Work order receipts of manufactured stock
> Labour issued to works orders - labour recovery and overhead recovery GL
> postings.
> Work orders outstanding
> Work order cost report
> Work order closing and cost updates/variance posting for usage and
> efficiency variances.
> Master production schedule maintenance
> Material requirements planning - suggested works orders and suggested
> purchase orders.
>
> In general increasing the breadth of functionality ultimately so I could
use
> it the manufacturing business I am CFO for.
>
> Things that would also be great and have large scale appeal to the
business
> community (I think) would be:
>
> 1. EDI standards compliant XML  based transactions with third parties.
This
> is an area I don't know much about although I have written a script to
send
> an order to a 3rd party warehouse for picking and packing in a format
> required by the Radio Beacon warehouse management software used by some of
> the logistics warehouse. I had some knowledge here. I guess this script
> could be adapted quite easily to sending orders to suppliers in  formats
> required by the supplier. But I am an XML dummy and have no knowledge. EDI
> is a complex area and there are a number of standards - which of course
> means there is no standard!
>
> 2. Point of Sale functionality. I have very limited knowledge here.
>
> 3. Bar coding and warehouse management functionality reading bar codes
into
> the browser window off a RF reader for picking inventory for sales orders.
> Which could interface back to the confirm_DispatchInvoice.php script
perhaps
> for automated invoicing based on quantities picked. Dispatch labels,
freight
> company interfaces for freight ticketing or charging.
>
> 4. Lot control and serialisation of inventory. I think someone is working
on
> this.
>
> 5. Customer relationship management. Call logs, specific requirements,
> rebates structure calculations etc. Incentives recording.
>
> I have been  avoiding payroll - mainly because this is so specific to the
> country and that to replicate stand alone software that is not really
meant
> for networking in a system which is all about networking and sharing of
> information seems pointless.
>
> Alco Ventures may have specific requirements and you may as well put into
> the system the functionality you need. There is far too much to do.
>
> Many ... many thanks for your contribution!
>
> Phil
>
>
> ----- Original Message -----
> From: "Shane Barnaby" <SBa...@al...>
> To: <ph...@du...>
> Sent: Wednesday, September 03, 2003 6:34 AM
> Subject: RE: Code as promised...
>
>
> > Phil,
> >
> > I'm happy that you like the overall idea. I didn't expect you to
> incorporate
> > the changes so quickly. :)
> >
> > I have been making websites 'look good' for a long time. I think your
> logic
> > is good and it is what attracted us to web-erp. I'm not an accountant.
:)
> > When you put the two together I believe the system will be functional
and
> > easy to use.
> >
> > I read in the developers section of sourceforge that there are issues
with
> > the Netscape browser. I had to warn that I didn't do much testing on the
> > changes I made when I sent the files. This was kind of a "first crack"
at
> > getting into the code for me. I had intended to test my changes further
if
> > you liked the ideas.
> >
> > As you can tell, I am new to the open source community and you may have
to
> > steer me in the right direction now and again. The use of GIF is a
habit.
> > PNG or JPG will work as well. (However, as a point of interest, I think
> the
> > LZW (GIF file format) patent expired this year. I also don't think
> > CompuServe intends on renewing the patent.) The use of the Microsoft
> > Graphics was just as place holders. (I didn't feel like drawing them at
> the
> > time :)) I never intended them for distribution.
> >
> > In answer to your comments:
> >
> > 1. I intended the image directory to be for images that will not change.
> The
> > logo.jpg would be a good example of this as you mentioned. I did not
> intend
> > the part_pics directory to change.
> >
> > 2. I always encourage segmenting the code into common directories.
Having
> a
> > directory for scripts is very common. Things have a tendency to grow
fast.
> >
> > I set myself up with a CVS tool so I can monitor the changes posted at
> > sourceforge. Now that you have posted the changes, I will tidy things up
> and
> > test with some other browsers. At Alco, we have been primarily a
Microsoft
> > shop and we are trying to change that. We have a habit of using the IE6
> > browser which can hide errors other browsers do not.
> >
> > If there is anything you would like me to focus on let me know.
> >
> > Shane Barnaby
> > Web Administrator
> > Alco Ventures Inc.
> > sba...@al...
> > www.alcoventures.com
> >
> >
> > -----Original Message-----
> > From: Phil Daintree [mailto:ph...@du...]
> > Sent: Saturday, August 30, 2003 10:55 PM
> > To: Shane Barnaby
> > Cc: web...@li...
> > Subject: Re: Code as promised...
> >
> >
> > Shane,
> >
> > This is brilliant - it really lifts the system graphically - there is a
> fair
> >
> > amount of work in there too clearly you have put in a couple of hours to
> get
> >
> > it to this point!
> >
> > It actually makes more room for the data by reducing the size of the
> header
> > and moving the copyright stuff down in the footer where it probably
> belongs.
> >
> > I guess I was minimising the work for the parser by reducing the number
of
> > includes. (he said trying to make excuses for the woeful appearance of
the
> > old version by comparison!)
> >
> > I did like the company logo on the screen - though the point is well
made
> it
> >
> > was too heavy on real estate. The logo.jpg is still required on
reports -
> > inovices statements etc. I am not sure where the logo.jpg should live -
> > wouldn't want it to depend on the theme so perhaps leave it in the root
> > directory ??
> >
> > I am amazed at what you have done with a minimal amount of additional
> > graphics.
> >
> > Is the images directory meant to replace the part_pics directory ?? But
> you
> > still refer to the part_pics directory in the config.php also have the
> > images
> > under the theme directory under css. I see the css/theme/images
directory
> > purpose but am a little confused on what the /images directory is for.
> >
> > I notice the icons are microsoft ones - I'd be keen to avoid these... I
> also
> > thought the use of .gifs was a problem - we certainly don't want any
> > legal trouble. In the meantime I changed the icons to open source ones -
I
> > am
> > completely relaxed about which ones are used except anything that lands
a
> > lawsuit on me should be avoided :-)
> >
> > Some structure to the files is appropriate, now there are getting to be
> > quite
> > a number of scripts. I was a fan of putting the whole lot in the same
> > directory so the newbie developer doesn't have to hunt down the file
he's
> > after. However, the directory includes should give the game away
adequetly
> I
> >
> > think!
> >
> > There are a number of other files that probably belong under the
includes
> > directrory ie they are never called on their own but from some other
> script.
> > config.php ?
> > class.pdf.php
> > RFC822.php
> > htmlMimeMail.php
> > mimePart.php
> > smtp.php
> > DefineCartClass.php
> > DefineJournalClass.php
> > DefinePaymentClass.php
> > DefinePOClass.php
> > DefineReceiptClass.php
> > DefineSuppAllocClass.php
> > DefineCustAllocsClass.php
> > DefineSuppTransClass.php
> > FailedLogin.php
> > Login.php
> > Logout.php
> >
> >
> > I have no problem with renaming the header.inc - session.inc and
> > HeaderTitle.inc header.inc except for the work in doing so and in
> modifying
> > all the files that refer to them !! it does make more sense the way you
> have
> >
> > it.
> >
> >
> > I LOVE the WebERP+ logo!
> >
> >
> > I have found a few bugs and will work through them:
> >
> > On some pages the footer appears at the top left of the page over the
> titles
> > -
> > supplierallocations.php I didn't look into why but it'll be simple to
fix
> > I'm
> > sure.
> >
> > The SelectItems.php table of options - that comes up when an item is
> > selected
> > - is missing some headings - again a simple one I guess.
> >
> > Clearly, I have seriously neglected the visuals on the system to date
and
> > your
> > input here looks as though its going to be fantastic. My focus has
always
> > been on the function with my asthetic sense whilst not offended clearly
> not
> > well developed. It's really good to have some input here to complement
my
> > shortcomings!
> >
> > I think I have brought in all of your code now and I have re-applied the
> > latest bug fixes I have done.
> >
> > Many thanks for this substantial contribution.
> >
> > Phil
> >
> > On Saturday 30 August 2003 07:00, you wrote:
> > > Phil Daintree,
> > >
> > > As mentioned in my last email, attached is a zip file of the code.
> > >
> > > Shane Barnaby
> > > Web Administrator
> > > Alco Ventures Inc.
> > > sba...@al... <mailto:sba...@al...>
> > > www.alcoventures.com <http://www.alcoventures.com/>
> > > tell: 604.513.2527
> > > fax: 604.513.2528
> >
> >
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[Web-erp-developers] Re: Code as promised...

[Phil D. <ph...@du...>]

Hi Shane,

It looks great and I agree the overall appeal of the system has lifted
greatly - first impressions count a whole lot.

The difficulty is that with a big restrucuture like this inevitably the risk
is high that we introduce problems. I'm desperately keen to avoid these at
least in the distribution files. So in the short term my focus will be on
ensuring we do in fact have the latest files updated with the includes
header.inc sesssion.inc etc and that all the scripts work as intended so we
can release a new distribution archive with the new look. Your help in this
would be most appreciated. If you could fire off files to me as and when
that would be preferable to a complete zip of the whole lot otherwise its a
devil of a job to pick through all the files to figure out the changes. So
if you modify a file send it off there and then so I can incorporate it
straight away. The likelyhood of us both working on the same script at the
same time is minimised.

Sounds like there is no problem with .gifs anymore - great.

The focus for me for the future is:

Bug fixes and quality improvement as the major focus.

Shipment costing - integrated a shipment costing system into accounts
payable. Much of the work is done but have not got into finishing it off.

Conversion to R & OS pdf.php class for the balance of the reports - although
this may cause some difficulty for Sherif/Hani doing the conversion to
multi-language/localisation I understand that this class we are using has
some problems with foreign fonts. However, the pdflib pricing is astronmical
in a commercial environment and part of the fun of all this is doing for $0
what costs USD$35k from 1st tier software companies. I am holding off on
developing down this track while Hani works through the issues for
localisation.

Manufacturing functionality will then become a focus for me:
Work Orders
Work order issues of material
Work order receipts of manufactured stock
Labour issued to works orders - labour recovery and overhead recovery GL
postings.
Work orders outstanding
Work order cost report
Work order closing and cost updates/variance posting for usage and
efficiency variances.
Master production schedule maintenance
Material requirements planning - suggested works orders and suggested
purchase orders.

In general increasing the breadth of functionality ultimately so I could use
it the manufacturing business I am CFO for.

Things that would also be great and have large scale appeal to the business
community (I think) would be:

1. EDI standards compliant XML  based transactions with third parties. This
is an area I don't know much about although I have written a script to send
an order to a 3rd party warehouse for picking and packing in a format
required by the Radio Beacon warehouse management software used by some of
the logistics warehouse. I had some knowledge here. I guess this script
could be adapted quite easily to sending orders to suppliers in  formats
required by the supplier. But I am an XML dummy and have no knowledge. EDI
is a complex area and there are a number of standards - which of course
means there is no standard!

2. Point of Sale functionality. I have very limited knowledge here.

3. Bar coding and warehouse management functionality reading bar codes into
the browser window off a RF reader for picking inventory for sales orders.
Which could interface back to the confirm_DispatchInvoice.php script perhaps
for automated invoicing based on quantities picked. Dispatch labels, freight
company interfaces for freight ticketing or charging.

4. Lot control and serialisation of inventory. I think someone is working on
this.

5. Customer relationship management. Call logs, specific requirements,
rebates structure calculations etc. Incentives recording.

I have been  avoiding payroll - mainly because this is so specific to the
country and that to replicate stand alone software that is not really meant
for networking in a system which is all about networking and sharing of
information seems pointless.

Alco Ventures may have specific requirements and you may as well put into
the system the functionality you need. There is far too much to do.

Many ... many thanks for your contribution!

Phil


----- Original Message -----
From: "Shane Barnaby" <SBa...@al...>
To: <ph...@du...>
Sent: Wednesday, September 03, 2003 6:34 AM
Subject: RE: Code as promised...


> Phil,
>
> I'm happy that you like the overall idea. I didn't expect you to
incorporate
> the changes so quickly. :)
>
> I have been making websites 'look good' for a long time. I think your
logic
> is good and it is what attracted us to web-erp. I'm not an accountant. :)
> When you put the two together I believe the system will be functional and
> easy to use.
>
> I read in the developers section of sourceforge that there are issues with
> the Netscape browser. I had to warn that I didn't do much testing on the
> changes I made when I sent the files. This was kind of a "first crack" at
> getting into the code for me. I had intended to test my changes further if
> you liked the ideas.
>
> As you can tell, I am new to the open source community and you may have to
> steer me in the right direction now and again. The use of GIF is a habit.
> PNG or JPG will work as well. (However, as a point of interest, I think
the
> LZW (GIF file format) patent expired this year. I also don't think
> CompuServe intends on renewing the patent.) The use of the Microsoft
> Graphics was just as place holders. (I didn't feel like drawing them at
the
> time :)) I never intended them for distribution.
>
> In answer to your comments:
>
> 1. I intended the image directory to be for images that will not change.
The
> logo.jpg would be a good example of this as you mentioned. I did not
intend
> the part_pics directory to change.
>
> 2. I always encourage segmenting the code into common directories. Having
a
> directory for scripts is very common. Things have a tendency to grow fast.
>
> I set myself up with a CVS tool so I can monitor the changes posted at
> sourceforge. Now that you have posted the changes, I will tidy things up
and
> test with some other browsers. At Alco, we have been primarily a Microsoft
> shop and we are trying to change that. We have a habit of using the IE6
> browser which can hide errors other browsers do not.
>
> If there is anything you would like me to focus on let me know.
>
> Shane Barnaby
> Web Administrator
> Alco Ventures Inc.
> sba...@al...
> www.alcoventures.com
>
>
> -----Original Message-----
> From: Phil Daintree [mailto:ph...@du...]
> Sent: Saturday, August 30, 2003 10:55 PM
> To: Shane Barnaby
> Cc: web...@li...
> Subject: Re: Code as promised...
>
>
> Shane,
>
> This is brilliant - it really lifts the system graphically - there is a
fair
>
> amount of work in there too clearly you have put in a couple of hours to
get
>
> it to this point!
>
> It actually makes more room for the data by reducing the size of the
header
> and moving the copyright stuff down in the footer where it probably
belongs.
>
> I guess I was minimising the work for the parser by reducing the number of
> includes. (he said trying to make excuses for the woeful appearance of the
> old version by comparison!)
>
> I did like the company logo on the screen - though the point is well made
it
>
> was too heavy on real estate. The logo.jpg is still required on reports -
> inovices statements etc. I am not sure where the logo.jpg should live -
> wouldn't want it to depend on the theme so perhaps leave it in the root
> directory ??
>
> I am amazed at what you have done with a minimal amount of additional
> graphics.
>
> Is the images directory meant to replace the part_pics directory ?? But
you
> still refer to the part_pics directory in the config.php also have the
> images
> under the theme directory under css. I see the css/theme/images directory
> purpose but am a little confused on what the /images directory is for.
>
> I notice the icons are microsoft ones - I'd be keen to avoid these... I
also
> thought the use of .gifs was a problem - we certainly don't want any
> legal trouble. In the meantime I changed the icons to open source ones - I
> am
> completely relaxed about which ones are used except anything that lands a
> lawsuit on me should be avoided :-)
>
> Some structure to the files is appropriate, now there are getting to be
> quite
> a number of scripts. I was a fan of putting the whole lot in the same
> directory so the newbie developer doesn't have to hunt down the file he's
> after. However, the directory includes should give the game away adequetly
I
>
> think!
>
> There are a number of other files that probably belong under the includes
> directrory ie they are never called on their own but from some other
script.
> config.php ?
> class.pdf.php
> RFC822.php
> htmlMimeMail.php
> mimePart.php
> smtp.php
> DefineCartClass.php
> DefineJournalClass.php
> DefinePaymentClass.php
> DefinePOClass.php
> DefineReceiptClass.php
> DefineSuppAllocClass.php
> DefineCustAllocsClass.php
> DefineSuppTransClass.php
> FailedLogin.php
> Login.php
> Logout.php
>
>
> I have no problem with renaming the header.inc - session.inc and
> HeaderTitle.inc header.inc except for the work in doing so and in
modifying
> all the files that refer to them !! it does make more sense the way you
have
>
> it.
>
>
> I LOVE the WebERP+ logo!
>
>
> I have found a few bugs and will work through them:
>
> On some pages the footer appears at the top left of the page over the
titles
> -
> supplierallocations.php I didn't look into why but it'll be simple to fix
> I'm
> sure.
>
> The SelectItems.php table of options - that comes up when an item is
> selected
> - is missing some headings - again a simple one I guess.
>
> Clearly, I have seriously neglected the visuals on the system to date and
> your
> input here looks as though its going to be fantastic. My focus has always
> been on the function with my asthetic sense whilst not offended clearly
not
> well developed. It's really good to have some input here to complement my
> shortcomings!
>
> I think I have brought in all of your code now and I have re-applied the
> latest bug fixes I have done.
>
> Many thanks for this substantial contribution.
>
> Phil
>
> On Saturday 30 August 2003 07:00, you wrote:
> > Phil Daintree,
> >
> > As mentioned in my last email, attached is a zip file of the code.
> >
> > Shane Barnaby
> > Web Administrator
> > Alco Ventures Inc.
> > sba...@al... <mailto:sba...@al...>
> > www.alcoventures.com <http://www.alcoventures.com/>
> > tell: 604.513.2527
> > fax: 604.513.2528
>
>

Re: [Web-erp-developers] Facelift

[Sherif O. <sh...@ky...>]

Phil,

I can't seem to connect to CVS, the connection string I'm using is :

:pserver:ano...@cv...:/cvsroot/web-erp

is this correct ?

I'd like to have a look at the new stuff - do you have it up somewhere ?

cheers
Sherif

----- Original Message ----- 
From: "Phil Daintree" <ph...@du...>
To: <web...@li...>
Sent: Monday, September 01, 2003 1:27 PM
Subject: [Web-erp-developers] Facelift


> Men,
>
> Has anyone had a look at the new system (in CVS) using netscape. It looks
> great in Konqueror and Opera but clearly not liked at all by Netscape. I
> guess this is pretty academic since not many folks use netscape. I have
not
> looked at it on IE or a Palm browser yet either.
>
> I notice that not  all the latest scripts were used before applying these
> mods. No link to from index.php, PDFBankingSummary.php old format and I
> suspect there will be more. I am a little worried about introducing more
> problems that we fix.
>
> Obviously I have a copy of where we were in case it all turns pear shaped.
I'd
> like to recover things and retain the cosmetic improvements. Overall I
think
> readability might have taken a knock? It could just be that because I
didn't
> write it and have had to get to grips with it.!
>
> Would be interested in any other views on the changes?
>
> Phil
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[Web-erp-developers] Facelift

[Phil D. <ph...@du...>]

Men,

Has anyone had a look at the new system (in CVS) using netscape. It looks 
great in Konqueror and Opera but clearly not liked at all by Netscape. I 
guess this is pretty academic since not many folks use netscape. I have not 
looked at it on IE or a Palm browser yet either.

I notice that not  all the latest scripts were used before applying these 
mods. No link to from index.php, PDFBankingSummary.php old format and I 
suspect there will be more. I am a little worried about introducing more 
problems that we fix.

Obviously I have a copy of where we were in case it all turns pear shaped. I'd 
like to recover things and retain the cosmetic improvements. Overall I think 
readability might have taken a knock? It could just be that because I didn't 
write it and have had to get to grips with it.!

Would be interested in any other views on the changes?

Phil

[Web-erp-developers] Stability

[Phil D. <ph...@du...>]

She's a little wobbly after all this restructure ie the version from a 
checkout of the latest CVS. I will work through the testing to try and get 
things solid again before releasing a new archive.

So far I've fixed the SelectOrderItems.php and DeliveryDetails.php scripts 
working on PrintCustOrder_generic.php.

Looks great!

Phil

[Web-erp-developers] Re: Code as promised...

[Phil D. <ph...@du...>]

Shane,

This is brilliant - it really lifts the system graphically - there is a fair 
amount of work in there too clearly you have put in a couple of hours to get 
it to this point!

It actually makes more room for the data by reducing the size of the header 
and moving the copyright stuff down in the footer where it probably belongs. 
I guess I was minimising the work for the parser by reducing the number of 
includes. (he said trying to make excuses for the woeful appearance of the 
old version by comparison!)

I did like the company logo on the screen - though the point is well made it 
was too heavy on real estate. The logo.jpg is still required on reports - 
inovices statements etc. I am not sure where the logo.jpg should live - 
wouldn't want it to depend on the theme so perhaps leave it in the root 
directory ??

I am amazed at what you have done with a minimal amount of additional 
graphics.

Is the images directory meant to replace the part_pics directory ?? But you 
still refer to the part_pics directory in the config.php also have the images 
under the theme directory under css. I see the css/theme/images directory 
purpose but am a little confused on what the /images directory is for.

I notice the icons are microsoft ones - I'd be keen to avoid these...
I also thought the use of .gifs was a problem - we certainly don't want any 
legal trouble. In the meantime I changed the icons to open source ones - I am 
completely relaxed about which ones are used except anything that lands a 
lawsuit on me should be avoided :-)

Some structure to the files is appropriate, now there are getting to be quite 
a number of scripts. I was a fan of putting the whole lot in the same 
directory so the newbie developer doesn't have to hunt down the file he's 
after. However, the directory includes should give the game away adequetly I 
think! 

There are a number of other files that probably belong under the includes 
directrory ie they are never called on their own but from some other script.
 config.php ? 
class.pdf.php
RFC822.php
htmlMimeMail.php
mimePart.php
smtp.php
DefineCartClass.php
DefineJournalClass.php
DefinePaymentClass.php
DefinePOClass.php
DefineReceiptClass.php
DefineSuppAllocClass.php
DefineCustAllocsClass.php
DefineSuppTransClass.php
FailedLogin.php
Login.php
Logout.php


I have no problem with renaming the header.inc - session.inc and 
HeaderTitle.inc header.inc except for the work in doing so and in modifying 
all the files that refer to them !! it does make more sense the way you have 
it.


I LOVE the WebERP+ logo!


I have found a few bugs and will work through them:

On some pages the footer appears at the top left of the page over the titles - 
supplierallocations.php I didn't look into why but it'll be simple to fix I'm 
sure.

The SelectItems.php table of options - that comes up when an item is selected 
- is missing some headings - again a simple one I guess.

Clearly, I have seriously neglected the visuals on the system to date and your 
input here looks as though its going to be fantastic. My focus has always 
been on the function with my asthetic sense whilst not offended clearly not 
well developed. It's really good to have some input here to complement my 
shortcomings!

I think I have brought in all of your code now and I have re-applied the 
latest bug fixes I have done.

Many thanks for this substantial contribution.

Phil

On Saturday 30 August 2003 07:00, you wrote:
> Phil Daintree,
>
> As mentioned in my last email, attached is a zip file of the code.
>
> Shane Barnaby
> Web Administrator
> Alco Ventures Inc.
> sba...@al... <mailto:sba...@al...>
> www.alcoventures.com <http://www.alcoventures.com/>
> tell: 604.513.2527
> fax: 604.513.2528