Stock in warehouse report

[Former Member]

Hi All

Im using a Stock in Warehouse report as my Loading List but I can't get a report to split the warehouses on each report.

I want the report to give a complete stock in warehouse report , the report must be in per warehouse .

I dont want to select the include warehouse A001 to A001

I want to select a range and then based on the range it reads and spilts the report by warehouse code select A001 to A080

And on the report I used some formulas to take out the currency code and to round it to 2 decimals , when i run the report with out the filter it gives me an error Printing error : The operation is not supported for this data type (RTP -6716) (Field : Field_070) Method: Amount Data Type variant

Here are my Fields

Committed Stock : Field_049

Formula Round(Field_049,0)

Field No 062

Price : Field_072

Formula Amount(Field_057)

Field No 070

Total Value : Field_060

Formula Amount((Field_057*Field_049))

Thanks in advance

[former_member583013 · Accepted solution]

The Amount function did not work because the Price field probably has the currency symbol in front.

Try this

ToNumber(Field_057)

Or

Amount(ToNumber(Field_057))

[Former Member · Accepted solution]

Thanks

Now how cn i split the report based on the selected warehouse ?

[former_member583013 · Accepted solution]

By this "split the report based on the selected warehouse " , do you mean you want to print Each warehouse on a seperate page?

Suda

[Former Member · Accepted solution]

Hi Suda

Yes , I want to know how can i make each warehouse show on its own page and when you running the report to filter automatically on the committed column and only show rows with value , ( Must not show rows with no value)

Thanks in advance