Skip to main content

Avatar PM 2022 Update 63

Product Requirements / Recommendations

Avatar PM required
RADplus required

Product Update Form Description

The 'Summary Trial Balance Report' is updated to allow detail information to be displayed in CSV format.

Included Updates

None

Required Updates

None

Details

NEW1 CHANGED0 FIXED0
New (1)
Avatar PM 'Summary Trial Balance Report'
The 'Summary Trial Balance Report' is updated to allow detail information to be displayed in CSV format.
The 'Export Detail Information to CSV' field has been added to the Avatar PM 'Summary Trial Balance Report' form. When 'Yes' is selected, report result data will be rendered in a .CSV (comma-separated value) format, allowing user to export/save 'Summary Trial Balance Report' results for external use.
Value Added: Adds support for .CSV format result data in 'Summary Trial Balance Report'.
Topics
• NX • Summary Trial Balance Report
 
Acceptance Tests

AV-79939 Summary | Details
Avatar PM 'Summary Trial Balance Report'
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Summary Trial Balance Report
Scenario 1: 'Summary Trial Balance Report' - Verification of .CSV format report results
Steps
  1. Open Avatar PM 'Summary Trial Balance Report' form (under 'Avatar PM / Billing / Billing Reports / Monthly Closeout Reports' menu).
  2. Enter/select values for 'Summary Balance As Of ', 'Aging Category' and 'Include Bad Debt Information' report criteria fields.
  3. Ensure 'Export Detail Information to CSV' field is present in form, with 'Yes' checkbox/selection available.
  4. No selection in the 'Export Detail Information to CSV' field will render report results in the default report format
  5. Selecting 'Yes' in the 'Export Detail Information to CSV' field will display report results in CSV (comma-separated value) format (allowing user to export/save 'Summary Trial Balance Report' results for external use)
  6. Click 'Process' button to run report/render result data.
  7. If no value is selected in 'Export Detail Information to CSV' field, ensure that 'Summary Trial Balance Report' results are rendered/displayed in the default report format.
  8. If 'Yes' is selected for 'Export Detail Information to CSV' field, ensure that 'Summary Trial Balance Report' results are rendered/displayed in .CSV format within myAvatar/Avatar NX, with following header and individual data rows present:
  9. 'Summary Trial Balance Report' .CSV format data header (first row in report data results) will contain the following data elements:
  10. 'RRG'
  11. 'RRG Description'
  12. 'Financial Class'
  13. 'Financial Class Description'
  14. 'Unbilled In-House'
  15. 'Unbilled Disch'
  16. 'Days'
  17. Aging Categories (default or custom entered/edited values as defined in 'Aging Category' report criteria field; 'Aging 0', 'Aging 30', 'Aging 60', 'Aging 120', etc.)
  18. Header row examples:
  19. "RRG,RRG Description,Financial Class,Financial Class Description,Unbilled In-House,Unbilled Disch,Days,Billed/Aging Category 0,Billed/Aging Category 30,Billed/Aging Category 60,Billed/Aging Category 90,Billed/Aging Category 120,Total"
  20. "RRG,RRG Description,Financial Class,Financial Class Description,Unbilled In-House,Unbilled Disch,Days,Billed/Aging Category 5,Billed/Aging Category 10,Billed/Aging Category 20,Billed/Aging Category 30,Billed/Aging Category 40,Billed/Aging Category 50,Billed/Aging Category 60,Total"
  21. 'Total'
  22. 'Summary Trial Balance Report' .CSV format individual data rows (second and all subsequent rows in report data results) will contain report data for each element, one row per result.
  23. Data row examples:
  24. "5,Outpatient Substance Abuse,7,Medicare Part A,2397.15,0.00,0,1181.21,0.00,0.00,0.00,815.00,4393.36"
  25. "1,Inpatient Psychiatric,10,Non-Recoverable,18635.12,6000.50,0,3360.52,88.00,1500.00,200.00,6526.80,40022.44"
  26. "5,Outpatient Psychiatric,3,Blue Cross,1176903.89,0.00,0,1476.11,0.00,0.00,0.00,0.00,0.00,12365.15,1190745.15"
  27. In 'Summary Trial Balance Report' results display, click 'Export All Pages' or 'Export Page' button to export/save .CSV format report data to file.
  28. Open/review exported .CSV format file, ensuring that data header and all individual data rows are present in file as displayed/defined above.
Topics
• NX • Summary Trial Balance Report

 

  • Was this article helpful?