ARM Reports Maja Talevska Milenkovska ERP Functional Consultant, - - PowerPoint PPT Presentation

arm reports
SMART_READER_LITE
LIVE PREVIEW

ARM Reports Maja Talevska Milenkovska ERP Functional Consultant, - - PowerPoint PPT Presentation

ARM Reports Maja Talevska Milenkovska ERP Functional Consultant, Acumatica Class Syllabus Day 1: ARM WarmUp What is an ARM Report? ARM Elements How can I create an ARM Report? Practice Examples Day 2 : The Real


slide-1
SLIDE 1

Maja Talevska Milenkovska

ERP Functional Consultant, Acumatica

ARM Reports

slide-2
SLIDE 2

2

Class Syllabus

  • Day 1: ARM WarmUp
  • What is an ARM Report?
  • ARM Elements
  • How can I create an ARM Report?
  • Practice Examples
  • Day 2 : The Real Deal!
  • Create a new report from scratch
slide-3
SLIDE 3

3

Advanced Preparations

  • Acumatica 2019 R1 u4 installed (19.104.0024)
  • I100 Demo Data installed
  • F350 User Guide
slide-4
SLIDE 4

4

Day 1: ARM WarmUp

slide-5
SLIDE 5

5

The Analytical Report Manager is a web-based report access and management tool for creating and modifying analytical reports. What is ARM? All reports created using the ARM Toolkit are called ARM Reports – Analytical, Financial reports

slide-6
SLIDE 6

6

PM History Table:

  • Project ID
  • Project Task ID
  • Cost Code ID
  • Account Group ID
  • Period ID

GL History Table:

  • Ledger ID
  • Branch ID
  • Account ID
  • Sub ID
  • FinPeriod ID

ARM: Key Data

slide-7
SLIDE 7

7

ARM Report Layout

Unit Set Row Headers Report Header (column set) Column Headers

slide-8
SLIDE 8

8

Report Definition

slide-9
SLIDE 9

9

Row Set

slide-10
SLIDE 10

10

Column Set

slide-11
SLIDE 11

11

Data Sources

slide-12
SLIDE 12

12

  • Save regularly
  • Use report description that matches title
  • Save parameters as a template
  • Use upper-case references to codes of row/units in formulas

(@ROWCODE1)

  • Use caution when deleting columns in column sets
  • Always use Upper Case references for rows and units in formulas
  • Do Not use @ symbol for row codes
  • Use numbers for Row Codes and leave a set of numbers in between to insert

rows at a later time. E.g. 0010, then 0020

slide-13
SLIDE 13

13

Day 2: The Real Deal!

slide-14
SLIDE 14

https://www.surveymonkey.com/r/onlinesessions2019

slide-15
SLIDE 15

15

Unit Set

slide-16
SLIDE 16

16

Filtering Data using Unit Sets Setting values versus Data Source

  • Values (@U1+@U2) layered

roll-ups, but no hyperlink drill down

  • Data Source filters data and

allows drill down

Printing Groups

  • Add to column set to hide
  • Match in unit set to show
slide-17
SLIDE 17

17

Overlapping Data Sources

Overlapping / merged data

  • Accounts, Subaccounts, branches
  • Row set gets 100 – 600
  • Column set gets 400 – 900
  • Result: 400 – 600

Non-overlapping data

  • Ledger, Account Class, Financial Periods, Offers,

Amount are used from a single data source

  • Unit Set (if available)
  • Row Set (if available)
  • Column Set (if available)
  • Report definition
slide-18
SLIDE 18

18

Account Ranges Start Account, Start Sub and Start Branch allows you to specify an account list, account range, or both

  • Syntax is similar to Microsoft Excel

ranges: 400000:420000

  • You can combine multiple ranges or

accounts, separate them with coma: 400000:420000,425000,426000:426099

  • Wildcards are supported in ranges:

4260??

slide-19
SLIDE 19

19

Handling of NaN/Infinity Values Scenario: Variance in Comparative Balance Sheet

Detects and eliminates divide by zero errors

slide-20
SLIDE 20

20

  • When modifying report, create a copy of the report
  • Use account classes instead of complicated masks
  • Masks can be used only for non-segmented accounts and

subaccounts

  • Cannot use Account Types in ARM reports
  • Overlapping Data Sources:
  • Accounts, subaccounts, branches are merged
  • Account classes, ledgers, financial periods are used from only one

data source

slide-21
SLIDE 21

Maja Talevska Milenkovska

mmilenkovska@acumatica.com