Stock Values Report Incorrect

[calljj]

Scenario:

You have 1 product which has 3 different barcodes.
All pricing is the same under the RRPs, regions e.t.c
Say you have 15 of the products in total in stock
They have a cost of £1, rrp of £2 each.
1 to a packet.

Go to Reports|Reports Switchboard|Stock|Stock Value By Product.

Print out the report, it gives the following:

Stocklevel 15
Value at cost 45 (15 * 1 * 3- Number of barcodes)
Value at retail 90 (15 * 2 * 3- Number of barcodes)

[calljj]

To get around above problem you have to change the SQL statements used in the report, the original includes:

SELECT tblProduct.ProductCode, ([packcost]/[packqnty])*[Stocklevel] AS ValueOnCost, [region1]*[stocklevel]  blah  blah blah;

I have produced and tested a solution to this, however it requires to be incorporated by Actinic into the original coding rather than a user change as it is held within the locked .mde file.

Perhaps support can email me and I could provide.

Without checking other reports, I would suspect this bug issue may occur quite a lot.

[Natalie]

Hi James,

Thanks for your posts.

I will check this with EPOS development and will get in touch with you regarding this issue.

[calljj]

http://community.actinic.com/showthread.php?t=31934

Just noticed this was also reported back in July!
6 months and still not changed.

[Natalie]

Hi James,

Sorry about the delay. I have spoken with a member of the development team who has informed me this bug will be fixed in the next release. There is no confirmed date for the release as of yet but will let you know as soon as I hear anything else.

[calljj]

Thanks for reply, I'll think I'll hold off my purchase of EPOS until this is corrected, no point me buying something that doesn't work at such a base level ... I already have microsoft for that.

[calljj]

Felt pity for those who are experiencing the problem with stock value so wrote a little prog to do it for you - a Free Tool called ACTIVALUE for calculating Cost and Retail value of stock held.

Tried to upload to forum without success so download on this page: CLICK HERE