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

Business Central Vendor Pre-Payment Journal SSRS

(0) Share

Report

Posted on by GrahamR99

Hello

I'm a BI Developer and work with SSRS, I been asked to make changes to the Business Central Vendor Pre-Payment Journal.

Where I expect to see the detail of the column Due Date in Visual Studio there is no setting, why is this? Is there code hidden that someone can explain how I see it please.

I have highlighted the column, where when the report is run in BC it shows the due date column. I have been asked to move the document date and post date next to due date, but as I said can not see the setting in SSRS visual studio.

Any help would be great, thank you for reading.

Regards

GrahamR99

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

I believe you need to use Report Builder for RDL reports. I know it is possible with Visual Studio but you need AL add on. Please try Report Builder below and then see if you see expression. Also if the field you need is not available in Dataset (see below) then you need to add it to dataset (through AL coding) then use it.

www.microsoft.com/.../details.aspx

https://www.youtube.com/watch?v=Usf9VJBDbRA

Was this reply helpful? Yes No
GrahamR99 5 on at

Like (0)

Report

Hello MahGah

Do you have a video on how to edit the AL coding?

Regards

Graham Rock

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

I know the following

www.youtube.com/watch

www.youtube.com/watch

Was this reply helpful? Yes No