web-erp-users — User general webERP discussion list

[Web-erp-users] re:error with 0.2.0, missing SalesOrderDetai

[Keith B. <km...@km...>]

Hi Phil -

Yep, I found the 'missing' file.  It actually looks like something (most 
likely permissions) did not setup correctly when I installed it.   So, I've 
blown it away and reinstalled/ran the web-erp-new.sql script.  Things appear 
to be working so much better.  

Please excuse my stupidity,

Keith.




Hi Keith,

Chris I think has it... the file SalesOrderDetails.frm is actually used and
created by MySQL as the detail for the table SalesOrderDetails. I don't
understand too much about MySQL inner workings but this is one of the files
required to define the table.

Can you browse this table (SalesOrderDetails) in phpMyAdmin ? for whatever
reason it must be corrupt or permissions dodgy.

The easy way to fix it would be to drop the entire database and re-run the
database creation script web-erp-demo.sql through mysql.

Is MySQL running reliably?
Has it got the correct permissions on the data files? ie mysql is the owner
and the group for the data directory and all its contents.


Phil Daintree

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

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

Keith,

I had another thought - perhaps you do not have innodb tables enabled in
your my.cnf normally under /usr/local/mysql/data  or wherever your data is.
This would explain why some tables work ok and others don't.
SalesOrderDetails is certainly one table that requires innodb tables. Have a
read of the install.txt file in the distribution.

HTH
Phil

----- Original Message -----
From: "Daintree Family" <p.d...@xt...>
To: "Web-ERP List" <web...@li...>
Sent: Saturday, August 23, 2003 10:52 AM
Subject: Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm


> Hi Keith,
>
> There is something very poorly about your installation.
>
> I can't view salestypes, sales areas, select customers, add branches to
> customers, retrieve customers for receipts etc etc. its all stuffed! All
the
> error messages point to issues with the mysql installation.
>
> Have you got PhpMysqlAdmin on your machine and does it work ok?
> Was mysql set up from an rpm or the binary installation. May be worth
> another look. Follow the details in the INSTALL.txt for setting up a new
> user  for mysql.
>
> Sorry you are having problems, but confident the software is not at
fault -
> apart from being a little tricky to install!
>
> Phil
>
> ----- Original Message -----
> From: "Keith Brown" <km...@km...>
> To: "Chris Bice" <cb...@en...>
> Cc: <web...@li...>
> Sent: Saturday, August 23, 2003 8:42 AM
> Subject: Re: [Web-erp-users] error with 0.2.0, missing
SalesOrderDetails.frm
>
>
> > Opps - yeah I do have that frm file in the right spot.  My (file)
> permissions
> > are set to myself as owner, mysql as the group, the mods are 0660.  I
> beleive
> > I have the sql user permissions set correctly since I can use most of
the
> > rest of the system.  I have the weberp db user set to all in the
database
> > permissions table and the user permissions table is also set to all for
> the
> > weberp user.  However it still does not work.  It is setup at
> 209.221.140.137
> > to see for yourself.
> >
> > Thanks for your help -
> > Keith.
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
> at the same time. Free trial click
here:http://www.vmware.com/wl/offer/358/0
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

[Web-erp-users] New file release 0.2.1

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

The latest archive was uploaded earlier. Amongst the mods are:
- 4 levels of grouping now available for sales reports
- Pricing now down to the branch level
- Improvements to customer allocations
- Laser packing slips printing office and customer copies.
- How paid inquiry for customer invoices
- sales analysis reports and laser packing slips now using the php-pdf class
by R & OS continuing the transition away from pdflib dependency.
- stock movement inquiry now shows the balance of stock left after the
movement has been effected.
- stock check sheets listings.
- incremental work on the manual ... its slow going here!

Thanks for the feedback and suggestions, they are always appreciated.

Phil Daintree

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

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

Hi Keith,

There is something very poorly about your installation.

I can't view salestypes, sales areas, select customers, add branches to
customers, retrieve customers for receipts etc etc. its all stuffed! All the
error messages point to issues with the mysql installation.

Have you got PhpMysqlAdmin on your machine and does it work ok?
Was mysql set up from an rpm or the binary installation. May be worth
another look. Follow the details in the INSTALL.txt for setting up a new
user  for mysql.

Sorry you are having problems, but confident the software is not at fault -
apart from being a little tricky to install!

Phil

----- Original Message -----
From: "Keith Brown" <km...@km...>
To: "Chris Bice" <cb...@en...>
Cc: <web...@li...>
Sent: Saturday, August 23, 2003 8:42 AM
Subject: Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm


> Opps - yeah I do have that frm file in the right spot.  My (file)
permissions
> are set to myself as owner, mysql as the group, the mods are 0660.  I
beleive
> I have the sql user permissions set correctly since I can use most of the
> rest of the system.  I have the weberp db user set to all in the database
> permissions table and the user permissions table is also set to all for
the
> weberp user.  However it still does not work.  It is setup at
209.221.140.137
> to see for yourself.
>
> Thanks for your help -
> Keith.
>
>

Re: [Web-erp-users] No Search for All on Customer or Supllier Selection

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

Hi Richard,

Yes you're right, the check here requires that some search criteria be
entered.

The aim in this was to limit the output returned so that a customer database
of x00,000 customers was not dumped over a dial up connection! By an
unfortunate slip of the mouse. Of course if its on a LAN or broadband then
this is not so much of a concern. There is also a limit - that can be
defined in config.php for the maximum number of customer records to return -
for the same reason although this is a little easier to change.

Phil


----- Original Message -----
From: "Richard Story PBPC" <rs...@pb...>
To: <web...@li...>
Sent: Thursday, August 21, 2003 6:18 PM
Subject: [Web-erp-users] No Search for All on Customer or Supllier Selection


> Hi
>
> When attempting to search for a customer or supplier
> one cannot hit the button with an empty keyword field.
>
> Was this deliberate?
>
> If not We can add the feature?
>
> Msg returned="At least one customer name keyword OR an
>               extract of a customer code must be entered
>               for the search "
>
> Regards
> Richard
> rs...@ia...
> (27) 83 407 3931
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines
> at the same time. Free trial click
here:http://www.vmware.com/wl/offer/358/0
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

Re: [Web-erp-users] New Web Erp Functionality

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

Hi Richard,

This looks like a great development.

In principle my personal preference is one integrated application in
preference to two.

Serialising the stock needs modifications to all areas that produce stock
movements:

-invocing
-crediting
-receiving,
-adjusting,
-transfers.

>   In Web-Erp
>     - On the StockMaster add a field to indicate that Serial Numbers are
>       required for this item.  From here on all comments below apply only
>       to such items.

There is such a flag - its a little cryptically named "controlled". It is
not currently used for any other purpose and to flag serialised or lot
control was the intention.

> Goods Received [TBD Where is this in Web-ERP?]

Select an Outstanding purchase order and hit the receive link. Point well
made though.


> --------------
> In Web-Erp
>   - In Goods Received, on the header of a Receiving Note, when receiving a
>     known purchase order, a button leads to the import of the updated XML
>     file.  This creates the Receiving line items as well as adding lines
to
>     the new StockSerialNo Table.
>     [TBD - Is there a post/commit stage for the PO that could be expanded]
>

I would like to build functionality to enable this data to be keyed too. On
the receiving of controlled items a further step is required to enter the
serial numbers lots or batches of the stock received, that then reconciles
to the total received.


>
============================================================================
> Sales Order
> -----------
>
> Outside Web-Erp
>   - The the serial number collection App will create a new XML file for a
>     customer sale.
>
> --------------------------------------------------------------------------
--
> In Web-Erp
>   - In Sales Order Entry a button leads to the import of an XML file.
>     This creates the Sales Order line items as well as updating the New
>     StockSerialNo Table.
>     [TBD - Is there a post/commit stage for the SO that could be expanded]
>
============================================================================

The order -> invoice cycle is a two stage process, the order is created,
packing slip printed, order picked, packing slip comes back with quantities
dispatched, order confirmed with quantites dispatched and invoice produced.

Maybe the order doesn't need the serial number on it, but there is a need to
record the serial numbers of the items picked? This would be part of the
order confirmation then to spell out the serial numbers of the items picked.
Could these confirmations be done with the aid of a bar code reader which
read off the serial numbers of the items picked that perhaps had a tear off
sticky bar code that could be stuck too the office copy of the packing slip
?? Not entirely sure what the aims are.

> Stock Take
> ----------
>
> Outside Web-Erp
>   - The the serial number collection App will create a new XML file for a
>     Stock Take.
>
> --------------------------------------------------------------------------
--
> In Web-Erp
>   - In Stock Take [TBD Where is this in Web-ERP?] a button leads to the
>     import of an XML file.  This updates StockSerialNo.LastStockTakeDate
>
============================================================================

There is no stock check functionality in web-erp (as yet) - maybe this comes
before serialisation!

Just my 2c

Phil

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

[Keith B. <km...@km...>]

Opps - yeah I do have that frm file in the right spot.  My (file) permissions 
are set to myself as owner, mysql as the group, the mods are 0660.  I beleive 
I have the sql user permissions set correctly since I can use most of the 
rest of the system.  I have the weberp db user set to all in the database 
permissions table and the user permissions table is also set to all for the 
weberp user.  However it still does not work.  It is setup at 209.221.140.137 
to see for yourself.

Thanks for your help -
Keith.


On Thursday 21 August 2003 05:15 pm, Chris Bice wrote:
> if you check in /var/lib/mysql/weberp  there is no
> SalesOrderDetails.frm??  If so, you will need to re-download weberp.
> Or, you can try to re-run the appropriate .sql file from the install.
>
> Chris

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

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

Keith,

I can't repeat this problem on my system. I think we are hunting an =
installation issue ??
Need more info really....

-Had you entered anything into the BOMs.php page?
-What URL does your browser show in the address field?

Your server is running linux I think ?
Are you using apache or other server ?
What version of php ?

This file SalesOrderDetails.frm is certainly not in the distribution =
sorry I am at a loss.=20

Permissions on the script files can sometimes produce problems - on my =
SuSE distro of linux using apache 1.3.27 (I think) the scripts should be =
owned by the user nobody and belong to the nogroup group.


Phil

[Web-erp-users] No Search for All on Customer or Supllier Selection

[Richard S. P. <rs...@pb...>]

Hi

When attempting to search for a customer or supplier 
one cannot hit the button with an empty keyword field.

Was this deliberate?

If not We can add the feature?

Msg returned="At least one customer name keyword OR an 
              extract of a customer code must be entered 
              for the search "

Regards
Richard
rs...@ia...
(27) 83 407 3931

[Web-erp-users] New Web Erp Functionality

[Richard S. P. <rs...@pb...>]

Here's what we want to do, any ideas/issues/objections/cheers, anyone.


Goals
-----
  - Add to Web-Erp functionality to provide for Serial Number Tracking on
    Stock Items.
  - Provide for this Serial Number information (and other Stock info) to
    move in and out of Web-Erp via XML files.

Key
---
[TBD] = To Be Decided/Determined
[OWERP] = Outside Web ERP

Outline
-------
An external application will be used to record serial numbers by reading
barcodes or electronic tags.
This app will produce an XML output file including amongst other things
the stock code and each serial number that has been found.
An example of this XML file is at the end of this note.

Suggested Solution
------------------
Table Amendments
----------------
  In Web-Erp
    - On the StockMaster add a field to indicate that Serial Numbers are
      required for this item.  From here on all comments below apply only
      to such items.
    - Add a New StockSerialNo Table with Fields(StockId, SerialNo,
         DateRcvd, DateLastStockTake, PONum, GRNum, InvNum)


============================================================================
Purchase Order
--------------

  In Web-Erp
    - In Purchase Orders, on a specific PO, a button leads to the generation
      of an outgoing XML file describing the order.  This XML file will have
      an element per ordered item, including empty slots for the serial
      numbers. So ordering (Item(A) * Qty(10))+(Item(B) * Qty(3)) = 30
items.
      [TBD can we make sure this only occurrs on finalised PO's]

============================================================================

Outside Web-Erp
  - This XML file might be provided to a supplier, but in the specific case
    we are developing the file will go to the serial number collection App,
    for use during goods receiving.

    Regardless of where it goes, we expect the file to be updated with
    serial numbers for return to Web-Erp in Goods Recieved.

============================================================================
Goods Received [TBD Where is this in Web-ERP?]
--------------
In Web-Erp
  - In Goods Received, on the header of a Receiving Note, when receiving a
    known purchase order, a button leads to the import of the updated XML
    file.  This creates the Receiving line items as well as adding lines to
    the new StockSerialNo Table.
    [TBD - Is there a post/commit stage for the PO that could be expanded]

============================================================================
Sales Order
-----------

Outside Web-Erp
  - The the serial number collection App will create a new XML file for a
    customer sale.

----------------------------------------------------------------------------
In Web-Erp
  - In Sales Order Entry a button leads to the import of an XML file.
    This creates the Sales Order line items as well as updating the New
    StockSerialNo Table.
    [TBD - Is there a post/commit stage for the SO that could be expanded]
============================================================================
Stock Take
----------

Outside Web-Erp
  - The the serial number collection App will create a new XML file for a
    Stock Take.

----------------------------------------------------------------------------
In Web-Erp
  - In Stock Take [TBD Where is this in Web-ERP?] a button leads to the
    import of an XML file.  This updates StockSerialNo.LastStockTakeDate
============================================================================

Reports/Enquiry
---------------
 - Item/SN, PurchOrder, SalesOrder, Supplier, Customer, DateIn, DateOut
 - Stock Take Exception (eg you just recorded an Item supposedly sold)
 - [TBD what else?]

----------------------------------------------------------------------------
XML File Handling
-----------------
To permit the XML files transferred to be used by different systems,
All Arriving (comming into Web-Erp) and Departing XML files will be
transformed (using predominantly XML/XSL transform) into the correct format.

We will provide a default transform method, but allow this to be a
superceeded
by a specific method per Supplier or Customer.
For example for an Arriving Supplier Batch the order will be:
 1 - Look for an Arriving-Supplier-Specific Method.
 2 - Look for an Arriving-Supplier-Generic Method.
 3 - Look for an Arriving-Generic Method.

Web-ERP code will only be written to handle a SINGLE XML incomming format,
but will use the above to ensure it recieves this format.

Likewise Web-ERP code will only be written to handle a SINGLE XML outgoing
format, but will use the above to ensure it sends in the appropriate format.


----------------------------------------------------------------------------
Example XML File
----------------
----------------------------------------------------------------------------
<ROOT>
   <CONTROL Action="RECEIVING"/>
   <StockItem StockCode="CTV-64b100">
      <Item SerialNo="13254761-aerg"/>
      <Item SerialNo="22554761-aerg"/>
      <Item SerialNo="23254761-aeff"/>
   </StockItem>
   <StockItem StockCode="BnWTV-5568">
      <Item SerialNo="44500000001287"/>
      <Item SerialNo="44500000001288"/>
      <Item SerialNo="44500000001290"/>
   </StockItem>
</ROOT>
----------------------------------------------------------------------------

Regards
Richard
rs...@ia...
(27) 83 407 3931

[Web-erp-users] re:error with 0.2.0, missing SalesOrderDetails.frm

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

Hi Keith,

Chris I think has it... the file SalesOrderDetails.frm is actually used and
created by MySQL as the detail for the table SalesOrderDetails. I don't
understand too much about MySQL inner workings but this is one of the files
required to define the table.

Can you browse this table (SalesOrderDetails) in phpMyAdmin ? for whatever
reason it must be corrupt or permissions dodgy.

The easy way to fix it would be to drop the entire database and re-run the
database creation script web-erp-demo.sql through mysql.

Is MySQL running reliably?
Has it got the correct permissions on the data files? ie mysql is the owner
and the group for the data directory and all its contents.


Phil Daintree

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

[Keith B. <km...@km...>]

Hi Chris -

I'm running Debian Linux version 3, kernel 2.2.20, MySQL version 3.23.49, 
Apache 1.3, php 4.3.2.

You are right, the error 13 is typically a permissions problem.  I beleive 
the permission problem here is that the file "/weberp/SalesOrderDetails.frm" 
doesn't seem to be in the distro.  It seems to work OK on your test website.

Please show me I'm wrong.

Keith.


On Wednesday 20 August 2003 06:28 am, Chris Bice wrote:
> Normally error 13 is a permissions Problem within MySQL.
>
> root@chris root]# perror 13
> Error code  13:  Permission denied
>
> Are you running it on Linux, or on Windows??
>
> Thanks
>
> Chris

> Return-Path: <web...@li...>
> Received: from sc8-sf-list2.sourceforge.net (lists.sourceforge.net
> 	[66.35.250.206]) by apoc.megavolt.com (8.12.5/8.12.5) with ESMTP id
> 	h7K1noWE027553 for <cb...@me...>; Tue, 19 Aug 2003 20:49:50 -0500
> Received: from sc8-sf-list1-b.sourceforge.net ([10.3.1.13]
> 	helo=sc8-sf-list1.sourceforge.net) by sc8-sf-list2.sourceforge.net with
> 	esmtp (Exim 3.31-VA-mm2 #1 (Debian)) id 19pHvl-0006sv-00; Tue, 19 Aug 2003
> 	18:38:33 -0700
> Received: from bdsl.66.13.146.162.gte.net ([66.13.146.162] helo=km-orb
> 	ident=mail) by sc8-sf-list1.sourceforge.net with esmtp (Exim 3.31-VA-mm2 #1
> 	(Debian)) id 19pEml-0006Df-00 for <web...@li...>;
> 	Tue, 19 Aug 2003 15:17:03 -0700
> Received: from localhost ([127.0.0.1] helo=there ident=kmb) by km-orb with
> 	smtp (Exim 3.35 #1 (Debian)) id 19pEmG-00065r-00 for
> 	<web...@li...>; Tue, 19 Aug 2003 15:16:32 -0700
> Content-Type: text/plain; charset="iso-8859-1"
> From: Keith Brown <km...@km...>
> To: web...@li...
> X-Mailer: KMail [version 1.3.2]
> MIME-Version: 1.0
> Message-Id: <E19pEmG-00065r-00@km-orb>
> Subject: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm
> Sender: web...@li...
> Errors-To: web...@li...
> X-BeenThere: web...@li...
> X-Mailman-Version: 2.0.9-sf.net
> Precedence: bulk
> List-Help: <mailto:web...@li...?subject=help>
> List-Post: <mailto:web...@li...>
> List-Subscribe:
> 	<https://lists.sourceforge.net/lists/listinfo/web-erp-users>,
> 	<mailto:web...@li...?subject=subscribe>
> List-Id: For the general discussion of web-erp project
> 	<web-erp-users.lists.sourceforge.net>
> List-Unsubscribe:
> 	<https://lists.sourceforge.net/lists/listinfo/web-erp-users>,
> 	<mailto:web...@li...?subject=unsubscribe>
> List-Archive:
> 	<http://sourceforge.net/mailarchive/forum.php?forum=web-erp-users>
> Date: Tue, 19 Aug 2003 15:16:32 -0700
> Content-Transfer-Encoding: 7bit
> > Hi -
>
> I've been playing with this system on my home machine, actively looking for
> a replacement for our aging ERP system (Symix's SyteLine) for the place in
> which I work.  I was entering some parts information today when I ran into
> this error message:
>
> The SQL to find the parts selected failed with the message: Can't find
> file: './weberp/SalesOrderDetails.frm' (errno: 13) The SQL statement was:
> SELECT StockMaster.StockID, StockMaster.Description, StockMaster.Units,
> Sum(SalesOrderDetails.Quantity- SalesOrderDetails.QtyInvoiced) AS Demand,
> Sum(LocStock.Quantity) AS TotalOnHand FROM StockMaster, LocStock LEFT JOIN
> SalesOrderDetails ON StockMaster.StockID=SalesOrderDetails.StkCode WHERE
> (SalesOrderDetails.Completed is NULL OR SalesOrderDetails.Completed=0) AND
> StockMaster.StockID = LocStock.StockID AND StockMaster.Description LIKE
> '%63-1218-63%' AND (StockMaster.MBflag='M' OR StockMaster.MBflag='K' OR
> StockMaster.MBflag='A') GROUP BY StockMaster.StockID,
> StockMaster.Description, StockMaster.Units ORDER BY StockMaster.StockID
>
> I got there by Manufacturing -> Bills of Material Maintance.
>
> I don't see the missing file " SalesOrderDetails.frm" anywhere on my system
> nor do I see it in the tar file I downloaded (version 0.2.0).  Any ideas?
>
> Thanks in advance,
> Keith.
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Dice.com.
> Did you know that Dice has over 25,000 tech jobs available today? From
> careers in IT to Engineering to Tech Sales, Dice has tech jobs from the
> best hiring companies. http://www.dice.com/index.epl?rel_code=104
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

Re: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

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

Hi Keith,

Will look at this and come back tomorrow. Thanks for reporting it.

Phil
----- Original Message -----
From: "Keith Brown" <km...@km...>
To: <web...@li...>
Sent: Wednesday, August 20, 2003 10:16 AM
Subject: [Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm


>
>
> Hi -
>
> I've been playing with this system on my home machine, actively looking
for
> a replacement for our aging ERP system (Symix's SyteLine) for the place in
> which I work.  I was entering some parts information today when I ran into
> this error message:
>
> The SQL to find the parts selected failed with the message: Can't find
file:
> './weberp/SalesOrderDetails.frm' (errno: 13) The SQL statement was: SELECT
> StockMaster.StockID, StockMaster.Description, StockMaster.Units,
> Sum(SalesOrderDetails.Quantity- SalesOrderDetails.QtyInvoiced) AS Demand,
> Sum(LocStock.Quantity) AS TotalOnHand FROM StockMaster, LocStock LEFT JOIN
> SalesOrderDetails ON StockMaster.StockID=SalesOrderDetails.StkCode WHERE
> (SalesOrderDetails.Completed is NULL OR SalesOrderDetails.Completed=0) AND
> StockMaster.StockID = LocStock.StockID AND StockMaster.Description LIKE
> '%63-1218-63%' AND (StockMaster.MBflag='M' OR StockMaster.MBflag='K' OR
> StockMaster.MBflag='A') GROUP BY StockMaster.StockID,
> StockMaster.Description, StockMaster.Units ORDER BY StockMaster.StockID
>
> I got there by Manufacturing -> Bills of Material Maintance.
>
> I don't see the missing file " SalesOrderDetails.frm" anywhere on my
system
> nor do I see it in the tar file I downloaded (version 0.2.0).  Any ideas?
>
> Thanks in advance,
> Keith.
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Dice.com.
> Did you know that Dice has over 25,000 tech jobs available today? From
> careers in IT to Engineering to Tech Sales, Dice has tech jobs from the
> best hiring companies. http://www.dice.com/index.epl?rel_code=104
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

[Web-erp-users] error with 0.2.0, missing SalesOrderDetails.frm

[Keith B. <km...@km...>]

Hi -

I've been playing with this system on my home machine, actively looking for
a replacement for our aging ERP system (Symix's SyteLine) for the place in
which I work.  I was entering some parts information today when I ran into
this error message:

The SQL to find the parts selected failed with the message: Can't find file:
'./weberp/SalesOrderDetails.frm' (errno: 13) The SQL statement was: SELECT
StockMaster.StockID, StockMaster.Description, StockMaster.Units,
Sum(SalesOrderDetails.Quantity- SalesOrderDetails.QtyInvoiced) AS Demand,
Sum(LocStock.Quantity) AS TotalOnHand FROM StockMaster, LocStock LEFT JOIN
SalesOrderDetails ON StockMaster.StockID=SalesOrderDetails.StkCode WHERE
(SalesOrderDetails.Completed is NULL OR SalesOrderDetails.Completed=0) AND
StockMaster.StockID = LocStock.StockID AND StockMaster.Description LIKE
'%63-1218-63%' AND (StockMaster.MBflag='M' OR StockMaster.MBflag='K' OR
StockMaster.MBflag='A') GROUP BY StockMaster.StockID,
StockMaster.Description, StockMaster.Units ORDER BY StockMaster.StockID

I got there by Manufacturing -> Bills of Material Maintance.

I don't see the missing file " SalesOrderDetails.frm" anywhere on my system
nor do I see it in the tar file I downloaded (version 0.2.0).  Any ideas?

Thanks in advance,
Keith.

[Web-erp-users] Re: web-erp

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

The invoices, orders and statements and a couple of others use the R & OS
pdf-php class to create pdfs you will know these ones because they include
the file PDFStarter_ros.inc

You are using linux I guess. pdflib can be used as a shared module I think I
can't remember the details - I know I had some trouble installing it first
time out. The php manual has some good pointers about pdflib installation
and also there are a few links referred to in the INSTALL file of web-erp
which spell out pdflib installation.

Phil

----- Original Message -----
From: "Chris McClendon" <MCC...@dc...>
To: <ph...@du...>
Sent: Tuesday, August 19, 2003 1:06 AM
Subject: Re: web-erp


> Phil,
>
> I did install the pdflib.rpm, and it will create pdf files for some of the
reports and invoices. Could it be that I don't have pdflib compiled in PHP
or a configuration issue?
>
> Thanks,
>
> Chris
>
> Chris McClendon
> Technology Strategist
> Georgia Department of Corrections
> Phone 404-651-7045
> >>> Phil Daintree <ph...@du...> 08/16/03 00:24 AM >>>
> Hi Chris,
>
> This is because the system needs pdflib either compiled into PHP or the
module
> enabled. The system creates PDF files - the installation instructions talk
> about the requirement for pdflib (I hope!)
>
> The sourceforge web hosting does not have pdflib available since it is
rather
> expensive to lisence - work is underway to convert to a different pdf
> creation php-pdf class developed by R & OS Ltd
>
> Regards
> Phil
>
> On Saturday 16 August 2003 04:09, you wrote:
> > Phil,
> >
> > I have been looking at Web-erp for a small area in our
> > department. It works great with one exception. When I try to
> > run certain report functions, I get this error message;
> >
> > Fatal error: Call to undefined function: pdf_new() in
> > /var/www/html/web-erp/PDFStarter.inc on line 5
> >
> > I'm getting that on any PDF function that calls,
> > "PDFStarter.inc".
> >
> > I searched though the support section, but did not see
> > anyone else reporting the problem. It also happens on you
> > on-line demo.
> >
> > For instance, it happens when I try to run, Inventory
> > Valuation Reporting.
> >
> > Any help would be greatly appreciated.
> >
> > Chris McClendon
> > user ID=mcclec00
> > e-mail=mcc...@dc...
>
>

[Web-erp-users] Re: web-erp

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

Hi Chris,

This is because the system needs pdflib either compiled into PHP or the module 
enabled. The system creates PDF files - the installation instructions talk 
about the requirement for pdflib (I hope!)

The sourceforge web hosting does not have pdflib available since it is rather 
expensive to lisence - work is underway to convert to a different pdf 
creation php-pdf class developed by R & OS Ltd

Regards
Phil

On Saturday 16 August 2003 04:09, you wrote:
> Phil,
>
> I have been looking at Web-erp for a small area in our
> department. It works great with one exception. When I try to
> run certain report functions, I get this error message;
>
> Fatal error: Call to undefined function: pdf_new() in
> /var/www/html/web-erp/PDFStarter.inc on line 5
>
> I'm getting that on any PDF function that calls,
> "PDFStarter.inc".
>
> I searched though the support section, but did not see
> anyone else reporting the problem. It also happens on you
> on-line demo.
>
> For instance, it happens when I try to run, Inventory
> Valuation Reporting.
>
> Any help would be greatly appreciated.
>
> Chris McClendon
> user ID=mcclec00
> e-mail=mcc...@dc...

Re: [Web-erp-users] Round Up Problem for Purchasing and Selling

[Chris B. <cb...@en...>]

Ronald,

Also, you will need to change the following items to make it recognize
the two digit fraction for receiving:

GoodsReceived.php 
Line #'s 67,68 Change the 1 to a 2
	$DisplayQtyOrd = number_format($LnItm->Quantity,1);
	$DisplayQtyRec = number_format($LnItm->QtyReceived,1);

Chris Bice
IT Manager
EnCore Inc.


On Wed, 2003-08-06 at 13:04, ronald carhuas wrote:
> Dear Mr. Daintree,
> 
> When I purchase 0.89 Quantity in web-erp
> of any Item the P.O is automatically
> adjusted to 0.9.
> 
> It is the same for the adjustments.
> 
> Is there any way to avoid this.
> 
> 
> Thank you,
> 
> Ronald.
> 
> 
> ___________________________________________________ 
> Which tennis player was stabbed in 1993 while playing against Magdaleena Maleeva in the Citizen Cup? 
> Find out at postmaster.co.uk
> 
> http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=233
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

Re: [Web-erp-users] Round Up Problem for Purchasing and Selling

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

Hi Ronald,

This is just a rounding - in some businesses I quite understand that several
decimal places may be required. The quantity is held to 4 decimal places but
is rounded for display purposes to 1 on this screen. This is easy enough to
modify, there is a number_format() call during the display of the order
items - the second argument to this call is the number of dp to display. To
use decimal places in stock quantities throughout - that display with all
decimal places there are a few fields that would need to be modified to
display the exact quantities. Stock adjustments, sales order entry,
confirming invoices, stock transfers etc etc. I guess a good improvement
might be to make the decimal places to display for stock/inventory items a
config.php variable that is used in the formating of these displays. I will
keep a note of this to look into for future I do not think that it is a
major job to change.

Thanks for raising this concern.

Phil


----- Original Message -----
From: "ronald carhuas" <ro...@po...>
To: <web...@li...>
Sent: Thursday, August 07, 2003 6:04 AM
Subject: [Web-erp-users] Round Up Problem for Purchasing and Selling


> Dear Mr. Daintree,
>
> When I purchase 0.89 Quantity in web-erp
> of any Item the P.O is automatically
> adjusted to 0.9.
>
> It is the same for the adjustments.
>
> Is there any way to avoid this.
>
>
> Thank you,
>
> Ronald.
>

Re: [Web-erp-users] Round Up Problem for Purchasing and Selling

[Chris B. <cb...@en...>]

Ronald, 

If you comment out line 510 of PO_Items.php 
: $_POST['Qty'] =1;
It will allow you to put in fractions of a part.  Im not too sure why
you would want to do this, but I know in the remanufacturing environment
this is very common practice.  You would have to ask Phil if that would
make anything else not seem to work right, I have commented it out on a
test machine and it seems to work okay and not have any adverse affects.

Chris Bice
IT Manager
EnCore  

On Wed, 2003-08-06 at 13:04, ronald carhuas wrote:
> Dear Mr. Daintree,
> 
> When I purchase 0.89 Quantity in web-erp
> of any Item the P.O is automatically
> adjusted to 0.9.
> 
> It is the same for the adjustments.
> 
> Is there any way to avoid this.
> 
> 
> Thank you,
> 
> Ronald.
> 
> 
> ___________________________________________________ 
> Which tennis player was stabbed in 1993 while playing against Magdaleena Maleeva in the Citizen Cup? 
> Find out at postmaster.co.uk
> 
> http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=233
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

[Web-erp-users] Round Up Problem for Purchasing and Selling

[ronald c. <ro...@po...>]

Dear Mr. Daintree,

When I purchase 0.89 Quantity in web-erp
of any Item the P.O is automatically
adjusted to 0.9.

It is the same for the adjustments.

Is there any way to avoid this.


Thank you,

Ronald.


___________________________________________________ 
Which tennis player was stabbed in 1993 while playing against Magdaleena Maleeva in the Citizen Cup? 
Find out at postmaster.co.uk

http://www.postmaster.co.uk/cgi-bin/meme/quiz.pl?id=233

[Web-erp-users] execute a method or access a property of an incomplete object

[Barry C. <cb...@ne...>]

Phil,

You're right. The poblem is solved. Thank you.

Barry

-----Original Message-----
From: web...@li...
[mailto:web...@li...] On Behalf Of
web...@li...
Sent: Wednesday, August 06, 2003 11:30 AM
To: web...@li...
Subject: Web-erp-users digest, Vol 1 #36 - 2 msgs


Send Web-erp-users mailing list submissions to
	web...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/web-erp-users
or, via email, send a message with subject or body 'help' to
	web...@li...

You can reach the person managing the list at
	web...@li...

When replying, please edit your Subject line so it is more specific than
"Re: Contents of Web-erp-users digest..."


Today's Topics:

   1. execute a method or access a property of an incomplete object =
(Phil
Daintree)
   2. Re: execute a method or access a property of an incomplete object
(Chris Bice)

--__--__--

Message: 1
From: "Phil Daintree" <ph...@du...>
To: <web...@li...>
Date: Wed, 6 Aug 2003 11:49:44 +1200
Subject: [Web-erp-users] execute a method or access a property of an
incomplete object

Barry,

I think I have the answer.

The message you are getting is -

Fatal error: The script tried to execute a method or access a property =
of an
incomplete object. Please ensure that the class definition cart of the
object you are trying to operate on was loaded _before_ the session was
started

You can fix this by disabling session.auto_start in your php.ini

I don't think this is a default setting of PHP but would be interested =
to
know if you set this or the latest version has it enabled by default?

Thanks for reporting this and bearing with me to find the answer (I =
hope) If
this is now a default setting of PHP then I guess a number of folks will =
get
the same problem!

Phil Daintree




--__--__--

Message: 2
Date: Tue, 5 Aug 2003 20:41:51 -0500 (CDT)
Subject: Re: [Web-erp-users] execute a method or access a property of an
incomplete object
From: "Chris Bice" <cb...@en...>
To: <ph...@du...>
Cc: <web...@li...>
Reply-To: cb...@en...

The latest default shipment of PHP for Win32 and RedHat does ship out =
with
session.auto_start =3D 1 ;

Havn't gotten a clear response for the folks at PHP why. But Phil is =
right,
I had the same error on a new WebERP install on a new server.

If that doesn't seem to fix the problem, please post your Session =
variables
from within your php.ini file and I'm sure we can get it hammered out.

Chris Bice
IT Manager
EnCore Inc.

> Barry,
>
> I think I have the answer.
>
> The message you are getting is -
>
> Fatal error: The script tried to execute a method or access a property =

> of an incomplete object. Please ensure that the class definition cart=20
> of the object you are trying to operate on was loaded _before_ the=20
> session was started
>
> You can fix this by disabling session.auto_start in your php.ini
>
> I don't think this is a default setting of PHP but would be interested =

> to know if you set this or the latest version has it enabled by=20
> default?
>
> Thanks for reporting this and bearing with me to find the answer (I
> hope) If this is now a default setting of PHP then I guess a number of =

> folks will get the same problem!
>
> Phil Daintree
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including =

> Data Reports, E-commerce, Portals, and Forums are available now.=20
> Download today and enter to win an XBOX or Visual Studio .NET.=20
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_
> 01/01
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users






--__--__--

_______________________________________________
Web-erp-users mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-users


End of Web-erp-users Digest

Re: [Web-erp-users] execute a method or access a property of an incomplete object

[Chris B. <cb...@en...>]

The latest default shipment of PHP for Win32 and RedHat does ship out with
session.auto_start = 1 ;

Havn't gotten a clear response for the folks at PHP why. But Phil is
right, I had the same error on a new WebERP install on a new server.

If that doesn't seem to fix the problem, please post your Session
variables from within your php.ini file and I'm sure we can get it
hammered out.

Chris Bice
IT Manager
EnCore Inc.

> Barry,
>
> I think I have the answer.
>
> The message you are getting is -
>
> Fatal error: The script tried to execute a method or access a property
> of an incomplete object. Please ensure that the class definition cart of
> the object you are trying to operate on was loaded _before_ the session
> was started
>
> You can fix this by disabling session.auto_start in your php.ini
>
> I don't think this is a default setting of PHP but would be interested
> to know if you set this or the latest version has it enabled by default?
>
> Thanks for reporting this and bearing with me to find the answer (I
> hope) If this is now a default setting of PHP then I guess a number of
> folks will get the same problem!
>
> Phil Daintree
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

[Web-erp-users] execute a method or access a property of an incomplete object

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

Barry,

I think I have the answer.

The message you are getting is -

Fatal error: The script tried to execute a method or access a property of an
incomplete object. Please ensure that the class definition cart of the
object you are trying to operate on was loaded _before_ the session was
started

You can fix this by disabling session.auto_start in your php.ini

I don't think this is a default setting of PHP but would be interested to
know if you set this or the latest version has it enabled by default?

Thanks for reporting this and bearing with me to find the answer (I hope) If
this is now a default setting of PHP then I guess a number of folks will get
the same problem!

Phil Daintree

[Web-erp-users] Session Problem ??

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

Hi Barry,

Is your installation available off the internet - can I get in to have a
look?
Could you send me the error messages experienced in all areas you get error
messages.

I am reasonably confident we are looking at an installation issue here, but
just in case it is an application problem I would like to be sure.

Does PHPMyAdmin work on your server? Have you any other PHP apps working
properly?

Phil

[Web-erp-users] Customers with no branches

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

Excellent point Jerome! Thanks for pointing it out.
 
 Will think about how to deal with that one - your suggestion sounds like a
 good one.
 Previously, the search for a customer looked only for a customer
 irrespective of matching branch data. But users wanted to see the branches
 and really only searched by branches.
 
 Maybe an outer join might do it - all customer records irrespective of
 matching records in the CustBranch table.
 
 All contribtions gratefully received.
 
 Phil