Cost Report showing double at Work Period End

V5 Question
1

Hello,
i have a question about the cost report. Its showing the cost twice and i dont know what to change?
And its normal that the cost report is showing the cost before work period ended?

thx for answers

2

screenshot please? if you want to upload a video screenshot then this may also help

3

ok i will make a screenshot, but its normal that samba creates cost report before work period end?
in samba V4 no was normal…

4

What are you calling a cost report?

5

??? Are different Cost Reports? I mean the Cost Report in the Reports List …

6

The above is after and the other is before Work Period End…
The Second Line is the correct calculation…

7

What is wrong with it? To answer your question Yes it will work with WP open. When are you opening and closing your work periods? Are you editing end of day records?

EDIT: Nevermind I see what your saying let me look into it.

@emre can you look at this report its the default Cost Report. It is doubling the numbers on WP close. I am not sure why.

[Cost Report:5, 3, 3, 3, 3]
>Name|Qty|Cost|Price|Rate
{REPORT COST DETAILS:[C.Name]+'.'+[C.PortionName],C.Quantity.Sum,[([C.Cost]*[C.Quantity]).Sum]/[C.Quantity.Sum],[([C.AvgPrice]*[C.Quantity]).Sum]/[C.Quantity.Sum],[($4-$3)/$3];%##.00;-%##.00;-:CostItem.Cost!=0}
>Total|{REPORT COST DETAILS:C.Quantity.Sum,[([C.Cost]*[C.Quantity]).Sum],[([C.AvgPrice]*[C.Quantity]).Sum],[($3-$2)/$2];%##.00:CostItem.Cost!=0}
8

@Jesse I couldn’t reproduce that. Can you send me a backup so I can check what is wrong with that?

9

I can when I get home. I tested it on my test dB.

10

Helo, i open and close every day my WP…

this is my cost report:

[Cost Report:5, 3, 3, 3, 3]
>Name|Qty|Cost|Price|Rate
{REPORT COST DETAILS:[C.Name]+'.'+[C.PortionName],C.Quantity.Sum,[([C.Cost]*[C.Quantity]).Sum]/[C.Quantity.Sum],[([C.AvgPrice]*[C.Quantity]).Sum]/[C.Quantity.Sum],[($4-$3)/$3];%##.00;-%##.00;-:CostItem.Cost!=0}
>Total|{REPORT COST DETAILS:C.Quantity.Sum,[([C.Cost]*[C.Quantity]).Sum],[([C.AvgPrice]*[C.Quantity]).Sum],[($3-$2)/$2];%##.00:CostItem.Cost!=0}
11

Did anyone (@emre) ever figure this out or did anything else ever come of this?

I hadn’t noticed this happening before—I’ve only been using the Inventory/Recipe functions for a week—but it did just happen to me on yesterday’s work period. All quantities and totals that show in the Cost Report are doubled. However, if I go to End of Day Records>Costs tab the Sold Amounts do show up correctly.

I don’t know if the misreporting happened before or after the closing of the Work Period as I didn’t check the Cost Report before the Work Period closed.

Wondering if perhaps the error may simply lie in the Cost Report Template, I started playing around with it. I noticed that if I removed the .Sum from C.Quantity in line 3 of the report, (the line dealing with individual products), the quantities per product do show up correctly, however the totals at the bottom are still doubled.

What I also noticed is that all of the products and quantities are actually listed twice in the report. They’re listed individually with the right quantities and then the whole individual product and quantities list repeats itself before the totals are finally shown. Maybe this is a clue as to why the totals at the bottom appear to be doubled. Perhaps when the products sold data is being gathered for reporting, two copies of the data are being complied and passed along in the report (array?).

FTR, I’m currently on version 5.1.59. I’ll update and see if that fixes it.

12

Of course I just noticed this in the release notes for 5.1.60

  • Duplication issue on Cost reports fixed.

Updating now…
…and issue resolved.

Thanks again,
Cheers!