Skip to main content

I have a list of accounts and sub-accounts that flow into the Finance/Admin line item on the FS. It is accounts 63000 to 71300 (sub account 700-000) as well as accounts 72300 to 72303 (sub account 000-000).

How can I set up the Data Source in Row Sets to include both of these in the same line?

 

 

Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).

If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?

Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).

If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?

I’ve created a third row that totals the two above & under Printing Control, I have set it to Hidden on first two rows so it only shows the Total. 

 

Appears to work. Thanks for suggestion.

 

Hi @jwarren ! I’m not the greatest with ARM reports but I would think if you set the start sub of 000000 and end sub of 700000 it should capture all that (and maybe more in between which you didn’t want!).

If that can’t work have you tried adding a second line with the second account/subaccount range and adding it to the first line?

Hi Benjamin, 

You are correct that setting start sub as 000000 will result in including way more subaccounts than we are needing.

 

I’ve created a second line and would like to sum these so it only shows 1 line. Right now I’m stuck with two lines on my report.

 

 

hello

i have an inquiry related to this topic, i was setting up for our combined income statement, i have questions please see below in row set data source:

  1. is it possible to call 2 different account in a row? example: Account id 522340 & 522352 ?
  2. is it possible to have a operation in account? example: Account id 611035 + 611048 ?

 

 

anyone please help

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved