How would you create a matrixed P&L?

Question

Hello,

I just went through a painful process of manually creating ~230 lines in a custom row set to go along with 14 columns created in a column set to effectively create a matrixed P&L. The client wanted to have everything on one report and have everything above ‘Gross Profit’ broken down between their divisions (they have 4) as well as showing a total column, and repeat this to show a monthly set and a year to date set on the same page. The rows needed to show all of the correct header column data in a single row and the merge worked pretty well.

This was my novice approach at this task but how would you have created something like this?

Page 1 / 1

Hello,

Two options that come to mind for a P & L broken out by division, with periods and year to date across the page are ARM reports (Row Set, as you created) and Velix o - to produce financial reports in Excel with direct updates from (and to) Acumatica.

Laura

Reply

Laura02 · Accepted Answer

Hello,Two options that come to mind for a P & L broken out by division, with periods and year to date across the page are ARM reports (Row Set, as you created) and Velix o - to produce financial reports in Excel with direct updates from (and to) Acumatica.Laura

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded