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

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

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

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

invoice description line can't display a full line words

------------------------------------------------------------------------------
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

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

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

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

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

------------------------------------------------------------------------------
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

invoice description line can't display a full line words

------------------------------------------------------------------------------
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