...

• Program Class Setup
  • To assign to the Sales Program for categorical purposes.
• Item Set Setup
  • Item Sets contain groups of items that are part of the Brokerage Program.
• Customer Address Setup
  • Brokerage Programs are assigned to one or more customer addresses.
• UOM Setup
  • To assign the UOM for any brokerage rate set to a calculation of $/UOM.
• Account Setup
  • If the Brokerage Programs accounting rules are set to Use Item Debit Accounts, Use Item Credit Accounts, or Specify Both Accounts, a GL Account must be manually select to determine the debit and/or credit account for the accounting of the Brokerage Accrual, thus requiring that these accounts be setup.
• Default Vendor Checkbook ID  
  • To assign the checkbook for the settlement transaction batch. 
•  Payment Terms Setup
  • To assign payment terms to the settlement transactions.
  •  Payment terms are primarily retrieved from the vendor record and secondarily from the Sales Order Preference 'Default Payment Terms'. 

Optional Prerequisites

• Set the ‘Enable Real Time Transaction Integration’ Sales Order preference to ‘Yes’
• Set the ‘Summarize AP Documents by Vendor’ Sales Programs preference
  • Setting this preference to ‘Yes’ will summarize all settlements in a batch by Broker and send a single AP Invoice to the host system as opposed to sending individual AP Invoices for each Sales Transaction.
• Set the ‘Summarize AR Documents by Customer’ Sales Programs preference
  • Setting this preference to ‘Yes’ will summarize all settlements in a batch to send a single AR Credit Memo to the host system per Customer as opposed to sending an AR Credit Memo for each settlement transaction for the same customer.
  Account Setup
  • If the Brokerage Programs accounting rules are set to Use Item Debit Accounts, Use Item Credit Accounts, or Specify Both Accounts, a GL Account must be manually select to determine the debit and/or credit account for the accounting of the Brokerage Accrual, thus requiring that these accounts be setupopposed to sending an AR Credit Memo for each settlement transaction for the same customer.
• Customer or Vendor Setup
  • If the Settle To method is ‘AR Credit Memo’, a customer must be selected for the AR Credit Memo to be created for, thus requiring the customer is setup. However, if the Settle To method is ‘AP Invoice – Paid In Full Orders’ or ‘AP Invoice – All Orders’, a vendor must be selected for the AP Invoice to be created, thus requiring the vendor is setup.

...

• GL Account: Displays the GL account that is used to create the journal entry. The Sales Program’s Accounting Rules field determines the GL Account.   
• Gross $: Displays the item’s total gross dollar amount.  
• Item Set: Displays the name of the Item Set assigned to the program to which the corresponding transaction item belongs to.
• Item: Description: Displays the item and item description of the transaction item affected by the program.
• Method: Displays the calculation method of the program.
• Net $: Displays the item’s total net dollar amount.  
• Program Amt.: Displays the amount of the program as calculated for the corresponding line item.
• Program Group: Displays the Sales Program type, ID and Description. This field is not in the system view.
• Program ID: Displays the Program ID of the Sales Program. This field is not in the system view.
• Program Name: Displays the name of the Sales Program. This field is not in the system view.
• Program Type: Displays the type of the Sales Program. This field is not in the system view.
• Rate: This field displays the sales program rate as defined on the sales program record. This field is editable and the Program Amount is re-calculated after clicking Save. Note: Updating the rate on this window impacts only this transaction and it does not update the Sales Program record.
• Unit UOM: Identifies the unit UOM of the item that is affected by the sales program.  
• Units: Displays the total number of units ordered of the item that is affected by the sales program.
• UOM: Displays the UOM upon which the program was calculated.
• Weight: Displays total weight of the item that is affected by the sales program.
• Wt. UOM: Identifies the weight UOM of the item that is affected by the sales program.  
  
  

Step 3: Posting the transaction with the

...

Brokerage Sales Program

If a Brokerage exists on a Sales Order transaction, no additional work is needed for the program to be posted with the transaction. Simply follow the steps to post the transaction and the program will be posted with it. Steps for posting Sales Order transactions can be found here.

...

Use the filtering fields to find the settlement record(s) to be fully settled. Refresh Data toolbar icon updates the grid based on the filtering criteria.

By default the Amt. to Pay field populates with the settlement's Remaining Amt. to Pay field populates with the settlement's Remaining Amt.  Click Validate to update .  

Click Validate to validate the settlements. An informative message is displayed if e.g. settlement accounts are missing. Validate toolbar icon also updates the Total Settlement amount that is displayed on the upper right corner. Once Validation is completed, the Validate toolbar icon is changed to Process. Click Process to process the settlement(s). This will create the corresponding settlement document(s) in the host system, within a batch, ready to be posted. Several settlements can be processed simultaneously and the batch ID of settlement transactions is the date and time of the settlement process event. If the brokerage is settled to an AR Credit Memo, an AR Credit Memo will be created in the host system for the Customer on the brokerage program. If the brokerage is settled to an AP Invoice, an AP Invoice will be created in the host system for the Vendor on the brokerage program.

...

On the Process Settlement view the Amount to Pay column now displays the entered amount for the line item(s) that were selected for Editing.Click Validate to update (s) that were selected for Editing.

Click Validate to validate the settlements. An informative message is displayed if e.g. settlement accounts are missing. Validate toolbar icon also updates the Total Settlement amount that is displayed on the upper right corner. Once Validation is completed, the Validate toolbar icon is changed to Process. Click Process to process the settlement(s). This will create the corresponding settlement document in the host system, sent in the corresponding batch, to be posted. If the brokerage is settled to an AR Credit Memo, an AR Credit Memo will be created in the host system for the Customer on the brokerage program. If the brokerage is settled to an AP Invoice, an AP Invoice will be created in the host system for the Vendor on the brokerage program.

...

Once all values are entered correctly, click Save and close the Edit window or click Save & Close. The Edit window is closed and the Amount to Pay and the Remaining Amt columns are updated accordingly. Click Validate to update validate the settlements. An informative message is displayed if e.g. settlement accounts are missing. Validate toolbar icon also updates the Total Settlement amount (that is displayed on the upper right corner). Once Validation is complete, the Validate toolbar icon is changed to Process.

To settle the transactions, click Process. This will create the corresponding settlement document in the host system, sent in the corresponding batch, to be posted. If the brokerage is settled to an AR Credit Memo, an AR Credit Memo will be created in the host system for the Customer on the brokerage program. If the brokerage is settled to an AP Invoice, an AP Invoice will be created in the host system for the Vendor on the brokerage program. The transaction sent for the settlement will include distributions to the Brokerage Write Off account for the write off amount.

...