Cash management preferences (CA101000)

Transactions number series

The entry type (configured for processing unrecognised payments and for payment reclassification) to be used by default in the Reclassify payments (CA506500) window.

For more information on processing unrecognised cash transactions, see: About the reclassification of unknown payments

The options are implemented for the Customer payments (AR302000) , Supplier payments (AP302000), and Transactions (CA304000) windows.

In the drop-down field you can select between the following options: 

• Disabled
  Nothing is changed when reversing a cash transaction, it works as before.
• Copy original or create new bank transaction
  When reversing a cash transaction, you will be redirected to the Process bank transactions (CA306000), the Process incoming payments (AR305000) or the Transactions (CA304000) window, depending on where the original line was created, and the original cash transaction is reversed.
  A new row is created in the Process bank transactions (CA306000) or the Process incoming payments (AR305000) window with date, amount and description.
• Unmatch original or create new bank transaction
  When reversing a cash transaction, you will be redirected to the Process bank transactions (CA306000), Process incoming payments (AR305000) or Transactions (CA304000) window, depending on where the original line was created, and the original cash transaction is reversed.
  A new row is created in the Process bank transactions (CA306000) or Process incoming payments (AR305000) window with date, amount, and description, if the transaction was created manually.
  Or unmatched, if the cash transaction was created from the Process bank transactions (CA306000) or the Process incoming payments (AR305000) window.
• Copy only original bank transaction
  You will be redirected to the Process bank transactions (CA306000) or Process incoming payments (AR305000), depending on where the original line was created, and the original cash transaction is reversed.
  A new row is created in the Process bank transactions (CA306000) or Process incoming payments (AR305000) with date, amount and description.
  If the payment is created manually, it will not create a new row in the Process bank transactions (CA306000) or Process incoming payments (AR305000) window.
• Unmatch only original bank transaction
  You will be redirected to the Process bank transactions (CA306000) or Process incoming payments (AR305000) window, depending on where the original line was created, the original cash transaction is reversed and the original bank transaction is unmatched.
  If the payment is created manually, it will not create a new row in the Process bank transactions (CA306000) or Process incoming payments (AR305000).

When a new row is created, the new line will get a prefix Re-opened or Unmatched + Ref. no + Original description, depending on the setting.

Now, you can match this to another customer, supplier, or cash transaction.

Note! We recommend you to use the Copy original or create new bank transaction option, else you will lose the connection to the voided payment in the Import bank transactions (CA306500) and Import incoming payments (AR305500) windows.

If a payment is created by the Direct debit function, it will not create any new, or unmatch existing bank transaction at all.

A check box that you select to make the system skip voided transactions during the reconciliation process if both the original and the voided transactions are registered in the same financial period.

For more information, see: About the reconciliation process

A check box that you select to make the system skip reconciled transactions during the reconciliation process if both the original and the reconciled transactions are registered in the same financial period.

If you select this check box, you indicate that supplier documents can be released from the Cash management workspace.

If this option is not selected, supplier documents can be released only from the Supplier ledger workspace.

If you select this check box, you indicate that customer documents can be released from the Cash management workspace.

If this option is not selected, customer documents can be released only from the Customer ledger workspace.

Days after bank transaction date

Days after bank transaction date

Doc. date weight

Estimated deviation (days)

A check box that indicates (if selected) that the system ignores the currency check when you import bank statements.

Select the check box, if you want to import statements that use a currency ID or code that does not match the currency ID associated with the cash account for which you perform import.

A check box that indicates (if selected) that importing a bank statement from a file should be performed to only a specific cash account.

The user can import the data only after the user has selected the cash account in the Import bank transactions (CA306500) window.

A check box that indicates (if selected) that unreleased batch payments are available for matching to bank transactions in the Process bank transactions (CA306000) window.

When a user initiates processing of the matched transactions (by clicking Process on the mentioned above window), the system releases matched batches.

For more information, see:About batch payment matching

The service to be used for importing bank statements if the Import bank statements to single cash account check box is cleared.

The available option is PX.Objects.CA.OFXStatementReader.

The service supports importing bank statements in the following formats: OFX (Open Financial Exchange), QBO (QuickBooks Online), and QFX (Quicken File eXchange).

If you select this check box, you enable customer/supplier recognition for bank transaction by the bank account number.

For example, when you click the Match automatically button in the Process bank transactions (CA306000) window.

When this check box is selected and the payment line contains a bank account from the bank and you select a customer/supplier, a lookup against the default IBAN/BBAN will be done in the Process bank transactions (CA306000) window.

If the customer's/supplier's bank account is empty or different, the button Update bank account will appear in the Process bank transactions (CA306000) window. Clicking the button will update the customer/supplier with the account from the bank.

You will get the warning Remaining balance available. on the supplier transactions, and the Ready to process check box will not be checked in the Process bank transactions (CA306000) window.

When you select this check box, no payment will be automatically created if bank payment amount is higher than invoice amount. The purpose is to avoid processing a bank transaction that is not fully applied since that would lead to an inbalance between bank and account receivable/general ledger.

You will get the warning Remaining balance available. if bank payment is higher than invoice amount or invoice is closed. In the Process bank transactions (CA306000) window and the Process incoming payments (AR305000) window, the Ready to process check box will not be checked before manual action is taken.

Select how or if documents will be automatically loaded in the Process bank transactions (CA306000) window for matching:

• First exact doc. amount, then all documents: First loads the documents with the exact document amount for the customer/supplier with credit notes first, then all other invoices until the payment amount is used. This is the default.
• Documents with exact amount: The system searches the documents that have the exact matching amount with the transactions and loads only them.
• Disabled: Automatic loading is not in use.

Days after bank transaction date

Days after bank transaction date

A check box that (if selected) specifies that a bank transaction with an empty reference number is automatically matched to a cash transaction with an empty reference number.

If this check box is cleared (the default value), the transactions with empty reference numbers are not considered as matching.  

Doc. date weight

Estimated deviation (days)

A check box that (if selected) handles the splitting of a batch payment from several customers into payments per customer.

When selected, the system will create the payment with all multiple invoices applied before processing the payment (clicking the Process button). When clicking the Process button, the application will be done.