Update pending sales transactions

Update pending transactions

Before you begin, check to see if you have any transactions waiting to be processed to the Sales Ledger. Choose Period End Routines > Report Pending Transactions.

Open: Sales Ledger > Period End Routines > Update Pending Transactions.

  1. Select the order you want to add the entries to the Sales Ledger.

    Choose from Transaction reference, Transaction date, or Order Entry.

  2. If you have manually imported transactions, select Update Cash Book to add sales receipts and payments to the relevant bank accounts.

  3. Enter the date up to which you want to update the customer transactions.

  4. Click OK.

Manually import transactions using the Pending Transactions file

The pending transactions file can also be used to manually import customer transactions. This can be done by your Business Partner or using a third-party software application.

Once transactions have been added to the file, use Update Pending Transactions to add the transactions to the Sales Ledger.

Select Update Cash Book to add sales receipts and payments to the relevant bank accounts.

To import foreign currency sales receipts and payments, you must select Update Cash Book to add these transactions to the Sales Ledger and the Cash Book.

Please contact your Business Partner for further assistance.

Outcomes

  • Customer account history is updated.

  • Customer account balance and turnover values are adjusted.

  • The value for the total outstanding entries in the Sales Ledger is adjusted.

  • The Nominal Ledger is updated, in accordance with the Sales Ledger setup.

  • The records for the VAT codes used on the customer entries are updated.

  • New VAT entries are created.

  • The Cash Book is updated, if you have selected Update Cash Book.

About updating pending transactions

You can choose when to update customer accounts with invoices and credit notes created in the Sales Order Processing or Invoicing modules, and from manually imported transactions.

If you do not select Add directly to the Sales Ledger in the SOP settings Processing tab, any invoices and credit notes will be placed in the pending transactions file when you post them from the Sales Order Processing or Invoicing modules.

Use Update pending transactions to add these invoices and credit notes to the Sales Ledger.

Note: Any sales orders that have payments entered with the order, are always added to the Sales Ledger directly.

If you have chosen to Update the nominal ledger immediately once transactions are entered in Accounting System Manager System Settings Operational settings tab, the transactions are posted to the Nominal ledger at the same time.