Updates the grid with new transactions that match the filter criteria. This icon is only displayed after the initial batch is created to allow users to redefine search criteria and add additional transactions to the batch. 

New Batch

A Yes/No lookup to identify whether or not to settle sales transactions that have an open balance. This is required and defaults to "No" but can be changed. If set to "No", program sales transactions with an open balance (transactions that have not been fully paid or written off) will not be brought into the transaction settlement grid when the 'Build Batch' or 'Append to Batch' icons are clicked. If changed to "Yes", all program sales transactions will be brought into the transaction settlement grid when the 'Build Batch' or 'Append to Batch' icons are clicked.

Database Field:  ERPx_SPProgramSettlementBatch.IncludeUnpaidInvoices

Database Field: 

Database Fields: ERPx_SPProgramSettlementHeader.ProgramHeaderSK, ERPx_SPProgramSettlementHeader.ProgramID - ProgramDescription

A date picker to enter an Invoice Date to restrict program sales transaction from being selected in the transaction settlement grid. This defaults as blank and is not required. If blank, then this parameter is not evaluated. If entered, only program sales transactions with an Invoice Date <= the 'Invoice Date Thru' date will be selected. This is useful for companies that settle sales programs on a specific date for transactions up through a certain date.

Database Field: ERPx_SPProgramSettlementBatch.InvoiceDateThrough

A date picker to enter a 'Closed Date' (the date a sales transaction was fully paid or written off) to restrict program sales transaction from being selected in the transaction settlement grid. This defaults as blank and is not required. If blank, then this parameter is not evaluated. If entered, only program sales transactions with a 'Closed Date' <= the 'Paid in Full Thru' date will be selected. This is useful for companies that settle sales programs for only paid in full invoices that were paid as of a specific date.

Database Field: ERPx_SPProgramSettlementBatch.PaidInFullThrough

A single select lookup to limit which Sales Programs to settle. This is required and for 'Brokerage Programs' defaults to "Accounts Payable" and cannot be changed. For 'Rebate' and 'Off Book' Programs' this defaults to blank and must be selected.

The lookup contains the following values:

• Accounts Payable: Only programs with a 'Payee' that is an A/P Vendor will be selected.
• Accounts Receivable: Only programs with a 'Payee' that is an A/R Customer will be selected.
• Accounts Payable and Accounts Receivable: Both A/P and A/R Programs will be selected.

Database Field:  ERPx_SPProgramSettlementHeader.SPSettleToEN

Database Field: 

Identifies the date that will be used on the Settlement transactions created for Accounts Payable and/or Accounts Receivable. This is an editable date picker that defaults to the current date, is required, and if missing, the message "Settlement Date is required." will be displayed on Validate and/or Process. The date must fall withing a valid GL Date else the message "The Settlement Date must be within a GL period open to [Functional Area the Settlement is going to]." will be displayed on Validate and/or Process. 

Database Field: ERPx_SPProgramSettlementHeader.SettlementDate

A calculated field that displays the sum of the 'Amt. to Settle' column for all the program transactions with a 'Settle To' of either "AP Invoice - Paid In Full Orders" or "AP Invoice - All Orders".

This is not saved in the database.

A calculated field that displays the sum of the 'Amt. to Settle' column for all the program transactions with a 'Settle To' of "AR Credit Memo".

This is not saved in the database.

A calculated field that displays the sum of the 'Amt. to Settle' column for all the program transactions. It is also the sum of [Total A/P] + [Total A/R] calculated amounts.

This is not saved in the database.