Skip to main content

Accounting Transactions: Open-Item bill payment ledger guide

Information on running the 6-step process in Access UBS and resolving issues where reversed invoices or payments are not appearing for knock-off.

Updated over a month ago

Run these steps to retrieve missing data for knock-off:

  1. Go to Transaction, Open Item menu, debtor, Bill Payment Ledger, and list the missing record in ARPOST.DBF

    1. Click OK, YES, Tick mark all.

    2. Click Generate, Exit, Cancel.

  2. Go to Transaction, Open Item Menu Debtor, Bill Payment Ledger, and list record in ARPOST.DBF

    1. Tick on Remove defective record.

    2. Click YES, OK, OK, Exit, Cancel.

  3. Go to Transaction, Open Item menu debtor, Bill Payment Ledger, and list defective records in ARPAY.DBF

    1. Tick on generate kperiod, YES, OK .

    2. Tick on remove defective record.

    3. Click YES, OK, OK, Exit, Cancel.

  4. Go to Transaction, Open Item menu debtor, Bill Payment Ledger, and check on duplicate entry Post No, OK, Exit.

  5. Go to Transaction, Open Item menu, debtor, Bill Payment Ledger, and view the bill payment ledger.

    1. Tick on generate paid amount.

    2. Click YES, OK, OK, Exit, Cancel.

  6. Go to Transaction, Open Item menu, debtor, Bill Payment Ledger, and edit the bill opening balance.

    1. Click OK, Next until finish.

    2. This must be done one by one.

    3. Don’t use the fast-forward button.

After this is done, run upgrade datafiles in housekeeping.

Related Articles
Accounting, Inventory & Transactions: Bill is not visible for the knock-off process
Accounting Errors: Batch Number () not allowed to remove
Accounting Transactions: Knock-off bills shown in the ledger but missing in the knock-off list
Accounting Transactions: Knock-off and reverse debtors bills
Accounting Transactions: Delete previous year transactions from the open item knock off list
Did this answer your question?