Ricard | 1 May 10:41 2009
Picon
Picon

Re: Small mod on InventoryPlanning.php

Hi Phil:

You are right, current period (at the beginning of the current month) it is unlikely to the the maximum.

But we could assume not just sales on the current period but:

Estimated sales on current period = current sales to date * 30 / day of the month (today) (sorry, my last post
had wrong signs)

So we will have a rough estimation of the sales for the current period. (There are million ways to do a better
estimate, just for the sake of simplicity).

Imagine we sell macadamia nuts ice-cream cones:

Month -4: 70
Month -3: 70
Month -2: 90
Month -1: 95
Current Month: 15

If we are at 3th day of current month (and it happens to be the beggining of summer) we can assume we will sell 15
* 30 / 3 = 150 cones on this month so on day 3th we can do a better inventory planning, and a better suggestion.

If we are at 27th of current month (supposing the beggining of winter, as example) we will continue with the
suggested order of 95 cones, as 15 * 30 /27 = 17

With the current script we will suggest only 95 cones, whatever the situation is...

So, I still think will be a better script than the current one

(Continue reading)

Phil Daintree | 1 May 11:25 2009
Picon

Re: Small mod on InventoryPlanning.php

I am sure we could do forecasting a hundred ways - weighted averages, 
regression etc etc... ultimately my view is that you need to look at 
these things with some knowledge of what is going on in the 
business.Using the maximum of the last 4 months is quite conservative 
really.

eg. the weather forecast for the next 3 weeks is great so we can expect 
this month to be a solid one for icecream sales ...

I think it is useful to have the current month's sales shown but drawing 
conclusions based on just a few days is probably dangerous.
It could be that the item was only released to the market in the last 
few days so the previous months all show 0 and the last few days is all 
there is to go on, there is no substitute for some judgment.
This report is not intended to be the correct answer and any forecasting 
  report will always be wrong, but it does provide some information so 
judgments can be made.

Phil

> 
> Estimated sales on current period = current sales to date * 30 / day of the month (today) (sorry, my last post
had wrong signs)
> 
> So we will have a rough estimation of the sales for the current period. (There are million ways to do a better
estimate, just for the sake of simplicity).
> 
> Imagine we sell macadamia nuts ice-cream cones:
> 
> Month -4: 70
(Continue reading)

Joe Zhou | 1 May 17:23 2009
Picon

New feature request:specific client transaction payment status fast track

Hi,Weberp Masters,
Is it possible to make paid,partially paid,unpaid client transactions
more obviously to notice and easily to track?I think the best place to
mark is under Receivables there are Customer Transaction
Inquiries,Transaction Inquiries,could you add one extra field to show
the specific transaction is fully paid,partially paid,or unpaid.I
notice the client specific transaction payment status track is very
important to business.

Thanks for your attention and have a nice day!

Joe

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
Ricard | 1 May 17:36 2009
Picon
Picon

Re: Release 3.10.4

Hi Tim:

Downloaded 3.10.4 this afternoon, but seems it contains older files than
expected:

Index.php in CVS was 1.80, but inside 3.10.4 zip was 1.76 (so, Phil's script
as inventory planning from preferred supplier is unreachable),
Purchdata.php in CVS was 1.21 but inside 3-10-4 zip was 1.19
InventoryPlanning is an older version as well.

Only checked these 3 files, but I suspect there's more...

Was it done with any purpose (functions not stable yet, etc.) or something
I'm missing?

Thanks,

Ricard

-----Original Message-----
From: Tim Schofield [mailto:tim.schofield1960@...] 
Sent: viernes, 01 de mayo de 2009 2:35
To: webERP Users; webERP Developers
Subject: [webERP-users] Release 3.10.4

Dear all,

I have just released the latest release from the 3.10 stable branch.
This is version 3.10.4

(Continue reading)

Joe Zhou | 1 May 17:39 2009
Picon

invoice description line can't display a full line words

Hi,there,
How can I make invoice description line to display as many letters as
possible.
Because sometimes I put a lot of letters in the item short descriptions and detailed descriptions.But on the invoice on the description column it just displays 3,4 or 5 letters. For
example,I put the short description line and detailed description under the item pangram:The quick brown fox jumps over the lazy dog.
But on my invoice description line just display as follows:
The quick brown
I think we should use a text wrap method in php to prevent this
kind of situation happen.

Is any have similar problem to me?Or just my own usage problem?

At the same time I would like to have two lines to display product
description,but now the invoice just allows displaying one one.
If you could help me to modify it,that would be perfect!

Thanks!

Joe

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Tim Schofield | 1 May 20:00 2009

Re: Release 3.10.4

Hi Ricard,

Yes the intention is with these 3.10.x releases is just to correct any
bugs in the 3.10 functionality, not to introduce any new features.
This way the releases should be very stable. For those wanting the
newest features I occasionally release cvs snapshot versions that have
all the bug fixes, with the latest features as well. However the new
functionality may introduce new bugs not found as yet, so the cvs
releases will not be as stable.

Tim

2009/5/1 Ricard <ricardandreu@...>:
> Hi Tim:
>
> Downloaded 3.10.4 this afternoon, but seems it contains older files than
> expected:
>
> Index.php in CVS was 1.80, but inside 3.10.4 zip was 1.76 (so, Phil's script
> as inventory planning from preferred supplier is unreachable),
> Purchdata.php in CVS was 1.21 but inside 3-10-4 zip was 1.19
> InventoryPlanning is an older version as well.
>
> Only checked these 3 files, but I suspect there's more...
>
> Was it done with any purpose (functions not stable yet, etc.) or something
> I'm missing?
>
> Thanks,
>
> Ricard
>
> -----Original Message-----
> From: Tim Schofield [mailto:tim.schofield1960@...]
> Sent: viernes, 01 de mayo de 2009 2:35
> To: webERP Users; webERP Developers
> Subject: [webERP-users] Release 3.10.4
>
> Dear all,
>
> I have just released the latest release from the 3.10 stable branch.
> This is version 3.10.4
>
> The changes are as follows:
> 29/04/09 Phil:RecurringSalesOrdersProcess.php - Made it so sales order
> headers use the order number from GetNextTransNo (30) as well as the
> sales order details - and avoiding the inconsistency issues where the
> auto-increment was out of sync with the systypes typeid=30 typeno
> 29/04/09 Phil:InventoryPlanningPrefSupplier.php - OrderNo relying on
> auto-increment for the header but using the systypes GetNextTransNo
> for the salesorderdetails modified to us the GetNextTransNo for both
> header and line details
> 29/04/09 Phil:DeliveryDetails.php - OrderNo relying on auto-increment
> for the header but using the systypes GetNextTransNo for the
> salesorderdetails modified to us the GetNextTransNo for both header
> and line details
> 28/04/09 Murray: fix some HTML typos in DeliveryDetails and remove 6
> digit price restriction from Credit_Invoice
> 27/04/09 Tim: api/api_xml-rpc.php - Corrections to enable API
> documentation to be shown
> 27/04/09 Tim: doc/Manual/ManualAPIFunctions.php - Corrections to
> enable API documentation to be shown
> 27/04/09 Tim: doc/Manual/ManualContents.php - Corrections to enable
> API documentation to be shown
> 26/04/09 Tim: CustomerBranches.php - Reinstate changes to correctly
> update latitude and longitude
> 21/04/09 Murray: add some extra help to SelectOrderItems.php
> 20/04/09 Murray: add some sanity checking to geocode section on
> suppliers and customer branches
> 19/04/09 Tim: reportwriter/admin/RCFunctions.inc - Check that the
> imported file is of type Text
> 19/04/09 Tim: SpecialOrder.php - Update systypes when the order is placed
> 19/04/09 David Lamotte: DeliveryDetails.php - Check that BestShipper
> is initialised and trap error if not.
> 18/04/09 Phil: PrintCustTransPortrait.php vertical lines of grid on a
> full page in the wrong place - now fixed
> 16/04/09 Tim: CustomerBranches.php - Correct sql for strict mode
> compatability
> 14/04/09 Ricard: Update PurchData.php now allows multiple prices from
> a supplier with different effective dates
> 10/04/09 Tim: SelectCustomer.php - Correctly change the customer when
> returning from OrderDetails.php
> 10/04/09 Tim: includes/session.inc - Ensure last visit field is always
> updated
> 10/04/09 Tim: Z_Upgrade3.10.php - Remove deprecated <center> tags
> 03/04/09 Tim: SelectCompletedOrder.php - Amend sql to show completed orders
> only
> 02/04/09 Tim: SelectCompletedOrder.php - Amend sql to show parts even
> when no purchase orders
> 01/04/09 Tim: SelectProduct.php - Correctly show category product properties
> 26/03/09 CW: SelectCustomer.php - This will give a link to setup
> customer types if they are not already
> 26/03/09 CW: Customers.php - This will give a link to setup customer
> types if they are not already
>
>
> Thanks
> Tim
>
> ----------------------------------------------------------------------------
> --
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
Tim Schofield | 1 May 20:06 2009

Re: New feature request:specific client transaction payment status fast track

Thanks Joe, I have added it to the list of feature requests that I
will look into.

Tim

2009/5/1 Joe Zhou <ossky0516@...>:
> Hi,Weberp Masters,
> Is it possible to make paid,partially paid,unpaid client transactions
> more obviously to notice and easily to track?I think the best place to
> mark is under Receivables there are Customer Transaction
> Inquiries,Transaction Inquiries,could you add one extra field to show
> the specific transaction is fully paid,partially paid,or unpaid.I
> notice the client specific transaction payment status track is very
> important to business.
>
> Thanks for your attention and have a nice day!
>
> Joe
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
Tim Schofield | 1 May 20:36 2009

Re: invoice description line can't display a full line words

Hi Joe,

I have trouble replicating this problem. I have tried landscape and
portrait invoices and get the full short description printed on the
Invoice. Is there anything unusual in what your doing (different
localisation for instance). Does the full description appear on the
screen when you go to invoice?

Thanks
Tim

2009/5/1 Joe Zhou <ossky0516@...>:
> Hi,there,
> How can I make invoice description line to display as many letters as
> possible.
> Because sometimes I put a lot of letters in the item short descriptions and
> detailed descriptions.But on the invoice on the description column it just
> displays 3,4 or 5 letters. For
> example,I put the short description line and detailed description under the
> item pangram:The quick brown fox jumps over the lazy dog.
> But on my invoice description line just display as follows:
> The quick brown
> I think we should use a text wrap method in php to prevent this
> kind of situation happen.
>
> Is any have similar problem to me?Or just my own usage problem?
>
> At the same time I would like to have two lines to display product
> description,but now the invoice just allows displaying one one.
> If you could help me to modify it,that would be perfect!
>
> Thanks!
>
> Joe
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
Joe Zhou | 2 May 15:45 2009
Picon

Re: New feature request:specific client transaction payment status fast track

Tim,
Thanks for your attention.

Joe

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users
Joe Zhou | 2 May 15:41 2009
Picon

invoice description line can't display a full line words

Tim,
Thanks for your reply.The situation is like this.I think the description  on the invoice is display the contents of the short description of the item code.When you enter the letters in the field of the short description,you got to be very careful,you have to count letters.There is some limit of letters.If you enter more letters than this limit,even one more letter,then the description of invoice only display 3 or  4 letters which is not what you want.
For example,If I put the short description line under the item pangram:The quick brown fox jumps over the lazy dog.
On my invoice description column it display the full contents of what I just entered,that is "The quick brown fox jumps over the lazy dog."
But if I entered "The quick brown fox jumps over the lazy dog.the",immediately the invoice just only display the contents:"The quick brown" not the same as "The quick brown fox jumps over the lazy dog.the",even you just enter "The quick brown fox jumps over the lazy dog.t",the invoice just displays "The quick brown".
Please note don't replicate the above example,I didn't justify it,it is just for my illustration purpose.

Thanks
Joe

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

Gmane