Accounting Finance:Statements-Printing List of Customers with Debit Payment Types

From uniWIKI
Jump to navigation Jump to search

Overview

Print report listing customers with debit payment types

Before Running Statements

  • The auto cash application does not correctly deal with ’source’ type documents (payments) that have a debit amount – it ignores them.
  • Any accounts with this type of transaction will have to be manually settled.
  • Run the report before running statements.
  • For each customer listed on report, look into ASW A/R balance inquiry to see if there are any credits to settle these transactions against. If so, do so.


Printing List of Customers with Debit Payment Types

1. Select System management

SettlingDebits1.png

2. Select Query manager

SettlingDebits2.png

3. Select Run a query request

SettlingDebits3.png

4. Double-click FINAR001 - List customers with debit payment types

SettlingDebits4.png

5. Change Printer to LP05
6. Press Enter
7. For each customer listed, look into ASW A/R balance inquiry to see if there are any credits to settle these transactions against.

SettlingDebits5.png

Settling Debits against Credits

In ASW:

1. Click ASW fastpath
2. Click Cash management
3. Click A/R cash management tasks
4. Click A/R invoicing tasks
5. Click Enter financial transactions

SettlingDebits6.png

6. Enter Voucher type (25 - A/R Manual Housekeeping)
7. Press Enter

SettlingDebits7.png

8. Select Add to add new entry

SettlingDebits8.png

9. Enter Document type
10. Enter Document number
11. Press Enter

SettlingDebits9.png

12. Double-click selected transaction
  • Try to use the same transaction type ie. VI to VI, MC to MC, DBT to DBT, AX to AX, CVI to VI or CMC to MC, EFT to any type of payments except VT (Can apply to future periods if no past). For EFT, only pull for the period previous.
  • Don't do VT type or CHK
  • Settle VOD's otherwise they will remain unsettled. (Can apply to any type)


  • Don't apply to Invoices
13. If nothing to put it against, press Cancel settlement twice
OR select Update when completed

SettlingDebits10.png

14. Select F12 to move back to previous panel

SettlingDebits11.png

15. Select F3 when completed

SettlingDebits12.png

16. Press Enter

SettlingDebits13.png

17. Mark Close batch
18. Change Printer queue to PRT01 (no need to print)
19. Press Enter

SettlingDebits14.png

20. Press Enter

SettlingDebits15.png

Retrieved from "https://owl.unipharm.com/mediawiki/index.php?title=Accounting_Finance:Statements-Printing_List_of_Customers_with_Debit_Payment_Types&oldid=14048"