Accounting Finance:Statements-Running List of Statements Not Balancing to ASW

From uniWIKI
Jump to navigation Jump to search

Overview

Run list of statements not balancing to ASW

Running List of Statements Not Balancing to ASW

1. Select 2 Start uniPharm Extensions

StmtBal1.PNG

2. Select 1 VA Company (PRODUCTION)

StmtBal2.PNG

3. Select 1 UWD Extensions

StmtBal3.PNG

4. Select 7 STM -- Statements

StmtBal4.PNG

5. Select 5 View Statement Runs

StmtBal5.PNG

6. Write down the run ID’s for Open Items and Balance Forward statements

StmtBal6.PNG

7. Select System management

StmtBal7.png

8. Select Query manager

StmtBal8.png

9. Select Run a query request

StmtBal9.png

10. Double-click FINSTAT001

StmtBal10.png

11. Change Statement End Date
12. Enter Balance Forward Run #
13. Enter Open Item Run #
  • Do not run MM (vendor statements)
14. Press Enter twice

StmtBal11a.png

15. Change Printer queue to LP05
16. Press Enter
  • These don’t print automatically. So check in Work with printer output. If there is nothing in the report, delete it.

StmtBal12.png

  • The first report will show customers that are not set up for statements.
  • The second report will show customers that have discrepancies between the statement balance and the balance in ASW.
  • The transactions that caused this will have to have the dates corrected
  • IT can identify these and correct them
  • After these corrections have been made, delete the statement run and generate them again
  • Run FINSTAT001 again to make sure there are no more problems.

Setting Customers up for Statements

1. Select 1 View Statement Customers

StmtBal13.PNG

2. Press F6 to add new statement type

StmtBal14.PNG

3. Enter Customer
4. Enter Statement Type
5. Enter Statement Format
6. Enter Effective Date Range
7. Press Enter

StmtBal15.PNG