PR Accounts Receivable Data Analysis report (reportings), steps 1-4 [10/17/23] | Scribe

    PR Accounts Receivable Data Analysis report (reportings), steps 1-4 [10/17/23]

    • NICOLE HONE |
    • 40 steps |
    • 2 minutes

      - Step One of Four -

      Generate report in PDS system

      1
      Type "4 \[ANALYTICS & ARCHIVES\]", then "[[enter]]"
      2
      Type "52 \[DUMPS TO EXCEL\]", then "[[enter]]"
      3
      Type "1 \[CUSTOMER AND A/R EXPORTS\]", then "[[enter]]"
      4
      Type "1 \[OPEN A/R ACTIVITY\]", then "[[enter]]"
      5
      Type "A \[ACCEPT\]", then "[[enter]]"
      6
      Type "N", then [[enter]]"
      information ordinal icon
      Tip! Do NOT want to LAUNCH REPORT MANAGER
      7
      This screen will appear and generate an Excel report. This report is found in the "Network 1.10.1.5.2" folder. IMPORTANT: Verify OPEN A/R total on this screen matches Excel column Q total.

      - Step Two of Four -

      Create Reporting Data in Excel

      8
      Click "11 (10.1.5.2)" - folder. note: This will allow access to "ardat" file
      9
      Open "ardat" file
      10
      Verify column Q total matches PDS report total (see above screenshot #7)
      11
      Sort column Q \[OPEN AMT\] from "Smallest to Largest"
      12
      Once column Q sorted Delete all rows with $20 and less. Note: this will removed majority of the short paid invoices.
      13
      Example: Column Q will reflect all aging over $20
      14
      Sort column S \[DUE IN\] from "Smallest to Largest"
      15
      Once column S is sorted Delete rows with 14 or less. Note: this will removed aging less than 15 days beyond net-terms (past-due).