Settlement Batches

Form ID: (CA307000)

On this form, you can review a settlement batch and perform operations on transactions within the batch: hide, record, or match them. You can also create a bank deposit that includes the transactions in the batch. For details on creating bank deposits, see Preparation of Deposits.

Note: This form appears in the system if the Integrated Card Processing feature has been enabled on the Enable/Disable Features (CS100000) form.

You open this form by clicking a link in the Reference Number column on the All Records or Unprocessed Batches tab on the Import Settlement Batches (CA507000) form.

Users with the Administrator, CA Admin, and CA Clerk roles have the Delete access rights to this form; users with the CA Viewer role have the View Only access rights to this form.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.


Button	Description
Create Deposit	Creates a bank deposit on the Bank Deposits (CA305000) form that includes the transactions in the selected settlement batch.

Summary Area

This area displays the settings of the settlement batch whose identifier is selected in the Reference Number box. All the other settings in this area are read-only and calculated by the system or copied from the Import Settlement Batches (CA507000) form for the selected settlement batch.


Element	Description
Reference Number	The reference number of the settlement batch.
Status	The processing status of the settlement batch. The status can be one of the following: Pending Import: A batch has been created, and the import of transactions has not yet started or has ended without all the transactions being imported. Pending Processing: The processing of transactions has resulted in an error, and the processing of the batch should be repeated. Processing: Transactions are being imported from the processing center or matched to transactions in MYOB Acumatica. Pending Review: Automatic processing has finished, but some transactions are missing. Processed: All transactions in the settlement batch have been matched to transactions in MYOB Acumatica or have been hidden. Deposited: A bank deposit based on the settlement batch has been released, or there are no payments to deposit. Error: An error has occurred during import.
Proc. Center ID	The ID of the processing center of the settlement batch.
Ext. Batch ID	The batch ID assigned by the processing center.
Settlement Time	The date and time when the batch was settled.
Settlement State	The state of the batch assigned by the processing center. The status can be one of the following: Settled Successfully: The batch has been approved and successfully settled. Settlement Error: An error occurred when trying to settle the batch. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cut-off time. Unknown: The batch settlement status could not be defined by the processing center.
Bank Deposit	The reference number of the bank deposit that the system created automatically on the Bank Deposits (CA305000) form, which is also a link you can click to view the bank deposit.
Settled Amount	The sum of the settled amounts for all card types.
Settled Count	The number of settled transactions for all card types.
Refund Amount	The sum of the refunded amounts for all card types.
Refund Count	The total number of refunded transactions for all card types.
Void Count	The total number of voided transactions for all card types.
Decline Count	The total number of declined transactions for all card types.
Transaction Count	The total number of transactions in the batch.
Imported Count	The number of transactions that have been imported.
Processed Count	The number of transactions that have the Processed status.
Missing Count	The number of transactions that have the Missing status.
Hidden Count	The number of transactions that have the Hidden status.
Excluded from Deposit Count	The number of transactions that will not be included in the bank deposit.

All Transactions Tab

This tab lists all transactions in the selected settlement batch.

Table 1. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Unhide	Changes the status transaction or transactions you have selected (by selecting the Included check boxes in the table) to Pending Review if the status of the settlement batch is Processed, and to Missing if the settlement batch has any other status. If the settlement batch has any status other than Deposited, this button is available if the selected transaction has the Hidden status.

Table 2. Table Columns
Column	Description
Included	An unlabeled check box that you select to include the transaction in processing if you create a deposit.
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction assigned by the processing center. The status can be one of the following: Settled Successfully: The batch has been approved and successfully settled. Settlement Error: An error occurred when trying to settle the batch. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cut-off time. Unknown: The batch settlement status could not be defined by the processing center.
Processing Status	The processing status of the transaction. The status can be one of the following: Pending Processing: The processing of the transaction has resulted in an error, and the processing should be repeated. Processed: The transaction has been matched to a transaction in MYOB Acumatica or has been hidden. Missing: The transaction was recorded in the processing center, but is missing in MYOB Acumatica. Hidden: The transaction was imported from the processing center, but should be excluded from processing.
Amount	The transaction amount.
Doc. Type	The document type of the transaction.
Reference Nbr.	The reference number of the document in MYOB Acumatica. This number is a link you can click to open the document in a pop-up window on the form on which the document was created.
Doc. Status	The status of the document in MYOB Acumatica.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Submit Time	The date on which the transaction was submitted.
Card Type	The card type of the transaction.
Fixed Fee	The amount of a fixed fee applied to the transaction by the processing center.
Percentage Fee	The amount of a percentage fee applied to the transaction by the processing center.
Total Fee	The total fees applied to the transaction.
Fee Type	The fee type specified in the settlement report.

Missing Transactions Tab

This tab lists the transactions that have the Missing status.

Table 3. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Record	Creates in the system the transaction or transactions for which you have selected the Included check box in the table. If the settlement status of the transaction is Settled Successfully or Refund Settled Successfully, the system opens the Payments and Applications (AR302000) form in a pop-up window with some of the boxes populated with the corresponding values from the batch transaction. If the settlement status of the transaction is Voided, the system does the following: For an external transaction linked to an AR payment, voids the linked payment and opens the Voided Payment document on the Payments and Applications (AR302000) form. For an external transaction linked to a cash sale, reverses the cash sale and opens the Cash Return document on the Cash Sales (AR304000) form. If an external transaction is not found, opens the Payments and Applications (AR302000) form so you can create a new document.
Hide	Excludes from processing the transaction or transactions for which you have selected the Included check box in the table and changes the processing status of the transaction or transactions to Hidden.
Match	Restarts the matching process for all transactions listed on this tab, which have the Missing status.

Table 4. Table Columns
Column	Description
Included	An unlabeled check box that you select to include the transaction in processing.
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction assigned by the processing center, which can be one of the following: Settled Successfully, Refund Settled Successfully, Settlement Error, Pending Settlement, Expired, Unknown, or Voided.
Amount	The transaction amount.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Submit Time	The date on which the transaction was submitted.
Card Type	The card type of the transaction.

Transactions Excluded from Deposit Tab

This tab lists transactions with the Processed status, which will not be included in the bank deposit created for the settlement batch. For a transaction to be listed on this tab (that is, excluded from a deposit), the document linked to the transaction has to meet at least one of the following criteria:

The Batch Deposit check box for the document is cleared on the form on which the document was created.
The Batch Deposit Nbr. on the creation form of the document is filled in, and the value is different than the value in the Bank Deposit box in the Summary area of the current form.
The payment's cash account is not linked to the deposit account of the processing center as a clearing account.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 5. Table Columns
Column	Description
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction assigned by the processing center, which can be one of the following: Settled Successfully, Refund Settled Successfully, Settlement Error, Pending Settlement, Expired, Unknown, or Voided.
Submit Time	The date on which the transaction was submitted.
Amount	The transaction amount.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Doc. Type	The document type of the transaction.
Reference Nbr.	The reference number of the document in MYOB Acumatica (AR payment or cash sale). You can click this link to open the document in a pop-up window on the appropriate form depending on the document type.
Cash Account	The cash account specified for the linked document.
Bank Deposit	A link to the bank deposit on the Bank Deposits (CA305000) form that includes the linked document.

Card Type Summary Tab

This tab shows the statistics for the settlement batch.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.