headers
MoxxConsulting | 1 Jul 2009 05:57
Picon

Re: Chemical inventory


Hi Idrut - 

I am sure there are other ways, but here is one approach that served our
customer well for a similar requirement (in another industry): it involves
some scripting though. 

- We added a PRODUCTVARIANTS table - for the main product 07181 in
stockmaster, 07181-25g and other variants would be stored in this table. 

- Stock is measured at the variant level - and is summed up at the product
level (we only have one UOM, so in our context, if you have 20 x 07181-25g +
10kg x 0718, you would have 10.5 kg) 

- Stock moves and some other transactions were modified to update stock both
at the ProductVariant level as well as at the master level. 

The above solution is not yet in WebERP and was built for a customer (with a
somewhat similar need). 
Hope this helps. 

Regards, 
Nagaraj
nagaraj@...

ldrut wrote:
> 
> I have a small chemicals company and need inventory to work to allow in a
> particular way. Would someone knowledgeable please let me know if WebERP
> can pull this off.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Mark Yeager | 1 Jul 2009 11:49
Favicon

Re: MRP test


Hi Ricard,

I changed the cost in MRPPlannedOrders.php, MRPPlannedWorkOrders.php, and
MRPShortages.php to use materialcost + labourcost + overheadcost instead of
the actualcost. When I originally loaded in my stockmaster file, I had put
the part's cost into actualcost, so I was getting cost amounts to show up on
the reports. I'm able to run MRPShortages without getting an error, so let
me know if you still get one.

MRPDemandTypes.php is set up similar to the way other webERP programs are in
that it won't allow you to delete the demand type if there are still demand
records with that demand type. There might be cases where you wanted to
delete all of the demands of a certain type, but still maintain that demand
type because you want to enter a new batch of the same demand type.

I changed MRP.php so that 'All' shows as the first choice in the scroll box
for the location. You can click on that or ctrl-click on individual
locations to select more than one.

The Use Mrpdemands check box allows you to run MRP with or without the
records you enter with MRPDemands or MRPCreateDemands. If the box isn't
checked, it doesn't read the mrpdemands file, so the MRP is only based on
actual orders rather than forecasts. I think there is an "if" statement
around line 300, that looks at the check box.

I was wondering if you are getting any errors using the non-MRP programs
from cvs. Since I set MySQL to run in strict mode, I've been getting lots of
errors where there is a SELECT COUNT(*) or SELECT SUM() statement, but some
element is missing in the GROUP BY. I'm getting this in some very basic
(Continue reading)

Permalink | Reply | 7 comments |
headers
John Craven | 1 Jul 2009 22:23

Tax Groups for the United States

In our current financial system we have over one thousand tax groups (we 
provide product in almost every state of the USA and also around the world). 
I am looking to migrate to webERP but found that I can only have a maximum of 
127 tax groups (due I believe to the taxgroupid field in taxgroups being of 
type tinyint). Am I going about this the wrong way or should I change the 
type of the taxgroupid field to smallint? Has anyone else had this problem?

Thanks in advance.

------------------------------------------------------------------------------
Permalink | Reply | 1 comment |
headers
Armand Jordaan | 2 Jul 2009 06:19

Incorrect Balance sheet balances, as well as incorrect P&L figures


When I do the profit & loss statement or balance sheet, I get incorrect
balances from time to time. I understand this has to do with the bfwd field
of the chartdetails table, and that the Z_ scripts can be used to fix this.

I know this has been mentioned several times in the past, so the problem is
definitely not new.

I had a look at the SQL statements in the audittrial, and find that they
look like this:

UPDATE chartdetails SET bfwd = bfwd + 509.36 WHERE accountcode = 5700 AND
period & gt; 114

My question regards the & gt; that I find there. If I try to execute a
statement like: 

SELECT period, accountcode, bfwd FROM chartdetails WHERE accountcode = 5700
AND period & gt; 114

then I get an error. However, if I change it to: 

SELECT period, accountcode, bfwd FROM chartdetails WHERE accountcode = 5700
AND period > 114

then statement is executed by MySQL.

Could this be part of the problem? (please note I am not a php, MySQL or
HTML expert. Also note the that the examples of & gt; contains a space, but
in my actual statements and in my audittrial there is no space between & and
(Continue reading)

Permalink | Reply | 3 comments |
headers
Phil Daintree | 2 Jul 2009 09:13
Picon

Re: Tax Groups for the United States

Wow!! I had never envisaged such a large number of tax groups.

Happily its an easy fix since you can easily modify the type of these 
variables to int - hopefully this will allow enough tax groups to meet 
your requirements.

Phil

John Craven wrote:
> In our current financial system we have over one thousand tax groups (we 
> provide product in almost every state of the USA and also around the world). 
> I am looking to migrate to webERP but found that I can only have a maximum of 
> 127 tax groups (due I believe to the taxgroupid field in taxgroups being of 
> type tinyint). Am I going about this the wrong way or should I change the 
> type of the taxgroupid field to smallint? Has anyone else had this problem?
> 
> Thanks in advance.
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
> 

------------------------------------------------------------------------------
Permalink | Reply | 0 comments |
headers
Tim Schofield | 2 Jul 2009 09:55

Re: Incorrect Balance sheet balances, as well as incorrect P&L figures

Hi Armand,

Thanks for this report, I had hoped that this problem was solved. Can
you confirm what version of webERP you are using, and specifically the
version of includes/DateFunctions.inc that you are using?

What you are seeing in the audittrail table is just the way that mysql
is representing what it perceives may be to be html tags (using < and
>) the query internally, and doesn't necessarily mean that the
original the query was executed that way. However if you are using a
recent DateFunctions.inc and you can pinpoint roughly when this
happend then I would very much like to see a copy of your audittrail
table. if that is ok with you.

Thanks
Tim

2009/7/2 Armand Jordaan <armand@...>:
>
> When I do the profit & loss statement or balance sheet, I get incorrect
> balances from time to time. I understand this has to do with the bfwd field
> of the chartdetails table, and that the Z_ scripts can be used to fix this.
>
> I know this has been mentioned several times in the past, so the problem is
> definitely not new.
>
> I had a look at the SQL statements in the audittrial, and find that they
> look like this:
>
> UPDATE chartdetails SET bfwd = bfwd + 509.36 WHERE accountcode = 5700 AND
(Continue reading)

Permalink | Reply | 2 comments |
headers
Juma Lungo | 2 Jul 2009 10:08
Picon
Favicon

Forms Fields Alignment


Hi
i was working on the sourcecode to align the forms' fields and labels. for example the Add Customer form, all
lables and fields are aligned to left. then i was aligning the labels to the right.

Now i dont know where i touched. but all my form fields are aligned to the centre. can any one shade light on how
i can re-align my form fields to the left?

Lungo

------------------------------------------------------------------------------
Permalink | Reply | 1 comment |
headers
Armand Jordaan | 2 Jul 2009 10:28

Re: Incorrect Balance sheet balances, as well as incorrect P&L figures


Hi Tim,

We are using webERP v 3.10.5. The version of the  includes/DateFunctions.inc
is version 1.32 (it came with the 3.10.5 download.

I'd be more than happy to give a copy of the audittrail table to you.
Problem is I am not very knowledgable on MySQL, so if you can tell me how to
do this I will send it as soon as possible (we have a Suse 10.3 Linux server
running and I can access the databases with Webmin). 

In webERP, we viewed the trial balance at about 17:20 PM on 30 June 2009,
and it was still OK. The next day at about 1-2PM on 1 July 2009 when we
viewed the balance sheet and I realized there was a problem. I can see in
the audittrail that around 17:23 PM on 30 June 2009 a few entries occur that
we are not sure how they got there. Once you have the table we can try and
figure out exactly what happened.

Regards

Armand

Tim Schofield wrote:
> 
> Hi Armand,
> 
> Thanks for this report, I had hoped that this problem was solved. Can
> you confirm what version of webERP you are using, and specifically the
> version of includes/DateFunctions.inc that you are using?
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Armand Jordaan | 2 Jul 2009 10:43

Re: Incorrect Balance sheet balances, as well as incorrect P&L figures


In addition to my previous post - is it OK to send the audittrail as a CSV
file?

regards
Armand

http://www.nabble.com/file/p24303292/weberp_audittrail_csv_2009_07_02.csv
weberp_audittrail_csv_2009_07_02.csv 

Armand Jordaan wrote:
> 
> Hi Tim,
> 
> We are using webERP v 3.10.5. The version of the 
> includes/DateFunctions.inc is version 1.32 (it came with the 3.10.5
> download.
> 
> I'd be more than happy to give a copy of the audittrail table to you.
> Problem is I am not very knowledgable on MySQL, so if you can tell me how
> to do this I will send it as soon as possible (we have a Suse 10.3 Linux
> server running and I can access the databases with Webmin). 
> 
> In webERP, we viewed the trial balance at about 17:20 PM on 30 June 2009,
> and it was still OK. The next day at about 1-2PM on 1 July 2009 when we
> viewed the balance sheet and I realized there was a problem. I can see in
> the audittrail that around 17:23 PM on 30 June 2009 a few entries occur
> that we are not sure how they got there. Once you have the table we can
> try and figure out exactly what happened.
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Tim Schofield | 2 Jul 2009 11:16

Re: Incorrect Balance sheet balances, as well as incorrect P&L figures

Hi Armand,

Do you know what transaction user susan was doin at 17.23 on 30/6?

Thanks
Tim

2009/7/2 Tim Schofield <tim.schofield1960@...>:
> Thats great, thanks Armand I will take a look at it.
>
>
> 2009/7/2 Armand Jordaan <armand@...>:
>>
>> In addition to my previous post - is it OK to send the audittrail as a CSV
>> file?
>>
>> regards
>> Armand
>>
>> http://www.nabble.com/file/p24303292/weberp_audittrail_csv_2009_07_02.csv
>> weberp_audittrail_csv_2009_07_02.csv
>>
>> Armand Jordaan wrote:
>>>
>>> Hi Tim,
>>>
>>> We are using webERP v 3.10.5. The version of the
>>> includes/DateFunctions.inc is version 1.32 (it came with the 3.10.5
>>> download.
>>>
(Continue reading)

Permalink | Reply | 4 comments |

Gmane