Small and medium business | Business Central, N...

Global Variable on Report based on flowfield

(0) Share

Report

Posted on by Anita75

1,165

Hi All,

I'm trying to customise Sales back order report to extract a field form item Table which is a flowfield. Created a global variable and set the value as below but not working. Is there a way to insert a procedure in a report like on a page? or is there a way to get a global variable refer to CalFields() field?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Bilal Haider 414 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You need to give required filters to Item variable to calculate it correctly. And what is the issue you are getting exactly.

Was this reply helpful? Yes No
Suggested answer

JAngle 135 on at

Like (0)

Report
Copy link

Link copied!

The sales line dataitem is not in context with the item variable you are trying to calc. Start with if item.get(SalesLine.”no.”) then. That will at least give the calcfields the right data to produce a result. Worth considering you may need location code here as well if it’s for sales orders and it’s inventory related.

Was this reply helpful? Yes No