Report Designer Question: Incorrect Quantities are being Displayed

Question

We are using a report named Monthly Inventory Balance - that will display the customer’s monthly inventory balance. Currently, it is displaying incorrect values.

We are using a formula to calculate beginning and end qty:

(Base Item Volume * Qty * Inventory Multiplier). In this scenario, the expected result should be

Inventory ID	Beginning Qty	End Qty
CBAL	1.968	1.968
CBAL	-1.968	-1.968

However, the numbers showing up on the report are not accurate. There are variables that referencing the formulas above in addition to grouping. We tried ungrouping and removing the variables but the values still don’t seem right.

The joins below are pretty straight forward too

I am attaching a copy of the report below. Can you please suggest what I am missing here?

@lauraj46, do you have any recommendations? thank you again!

Thank you!

icon

Best answer by lauraj46 22 November 2023, 04:09

View original

lauraj46 · Accepted Answer

Hi @kanupindi,One issue that I see here is with the Format property on several of the fields. You need the .Format after the field name, otherwise the report designer will not print the value properly.Additionally, I see that you are assigning the ending balance to the starting balance in the group3 header. Is this what you intended, given that thegroupings may be for different inventory ids? I don’t think the logic here is quite right. Itmight be easier to debug when the number print correctly :).A good way to debug is to temporarilty displaythe fields that are used in the calculations ontothe report.Hope this helps!Laura

Report Designer Question: Incorrect Quantities are being Displayed

1 Attachment

1 reply

Reply

1 Attachment

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded