Sort Accounts Payable Aging

(0) Share

Report

Posted on by Jhill

I want to sort my accounts payable aging, but I cannot find a sort option. Is it possible to do this such that I can put the A/P aging in order by vendor name?

Thank you.

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

JAngle 123 on at

Like (0)

Report

RE: Sort Accounts Payable Aging

You will need to do a custom report layout change which is very easy to complete if you stick to RDLC. Note you will need at least SQL Report builder 2016 installed to do this.

Go to the custom report layouts page and create one for the corresponding report ID. GB is 322 so I've done that one. Export the layout and open it to reveal the below detail. Place the cursor where you see mine, you want that big orange bar on the left to appear.

right click to get the tablix properties open. And this:

Save and then import the layout to BC. Run the report and the sorting should be changed:

Was this reply helpful? Yes No
Verified answer

Jhill 30 on at

Like (0)

Report

RE: Sort Accounts Payable Aging

Thank you very much for your help!

Was this reply helpful? Yes No