ReorderLevelLocation.php shows incorrect "Total Invoiced At Location" field (4.06.6)

[PakRicard]

See details at http://weberp.org/bugs/view.php?id=2

[phil]

I ended up reworking much of this script. It was attempting to calculate item sales by using the sales orders. The snag with that is that assembly components would not be listed - only their mums and dads! I re did the query using stockmoves type=10 and type=11 (invoices and credit notes) respectively.

[Exsonqu_Qu]

Hi, Phil,

That's great!

It's an excellent idea to design a table stockmoves. Just learned another point!!

Best regards!

Exson

[phil]

Hi Exson,

It's been there all along and we use it quite extensively - all the daily sales analysis inquiries I have written use it (use the salesanalysis table for monthly or greater periods)

[PakRicard]

I reopened the bug, as it still has some problems. Pls check details at http://weberp.org/bugs/view.php?id=2

[phil]

I saw that, but when I reworked the script, I wondered does the quantity sold in all locations really have a bearing on the reorder level at that location? That's why I didn't put that field back.

[PakRicard]

Ok, I see. The idea was to have an idea if it's a good selling location for that item, so stock can be re-balanced easily.

In 5 locations you've sold 100 pcs and in one particular location 60 of them, it is wise to probably increase the RL at that location, as it's a good selling item there.

Viceversa, ef that location only have sold 5 pcs out of 100, it is probably wise to move your stock out of that place, and try to sell it in another location.

It's maybe a "retail only" problem, and maybe would be better to have the percentage of sales (sold at location / sold at all locations * 100) instead of the 2 columns.