Due date grid for FP04 transaction

[Former Member]

Hi Folks,

I need a report layout showing the due date grid for all the open items. Using FP04, I created layouts with all the required fields, but I'm unable to see the grid for due days. Few screenshots of the layout I designed and the summarization fields I defined in our system.

As shown in the output screenshot above, it doesn't display the total grid horizontally for a given customer, instead it is showing rows individually for each grid (30, 60,etc.).

Please advise how this can be fixed to show all the grids for a given customer (30, 60, 90, 180, etc.) in a single row.

Thanks in advance.

Regards,

Santosh

[AmlanBanerjee]

Hi Santosh,

Have you defined any layout for the open items line layout screen.

I think the issue lies there.

If you haven't defined one, then go to the define layout tab in the open items line layout screen and create one.

If you have already defined one and still you are getting the output as above,can you share the screenshot of the define layout screen.

Hope it helps.

Thanks,

Amlan

[Former Member]

Hi Amlan,

Thanks for your response.

Here is the layout I have defined.

I initially had few subtotals maintained, but I removed them later as it was not working.

Please advise.

Thanks,

Santosh.

[Former Member]

Any help with this issue would be really helpful.

Regards,

Santosh