• Table of Contents

Overview

Brokerage Programs are used to accrue brokerage expenses to the general ledger as well as make entries to a subsidiary payable ledger. When a transaction that contains a brokerage program is posted, a journal entry is created to Debit the Brokerage Expense account and Credit the Brokerage Payable account. The Credit is added to the Brokerage Settlement tables. Then, at a later date, someone can review the brokerage payables and approve them for payment via the Settlements page in the Sales Programs module. When a brokerage payment is approved one of two things happens: 1) an AP Invoice is created so a check can be cut on the next check run or 2) an AR Credit Memo is created that can offset an AR balance due.

...

To view the program’s effect(s) on the transaction, click the transaction’s Program Details header toolbar icon and open the Brokerage & Freight Accruals tab.

This tab will display all information regarding the effect(s) of the Brokerage on the transaction, per item affected, with the following details:

• Program Type: Displays ‘Brokerage’ for all effects due to a Brokerage Sales Program.
• Item - Description: Displays the item and item description of the transaction item affected by the program.
• Method: Displays the calculation method of the program.
• Rate: Displays the rate upon which the program was calculated. Negative rates will display within parentheses.
• UOM: Displays the UOM upon which the program was calculated.
• Adj. Rate: Displays a blank numeric text box for the user to enter a new rate to calculate the program for the corresponding line item. Entering a value here will override whatever rate is currently being enforced for the corresponding line item’s program’s calculations. To apply the adjusted program rate for the corresponding line item, click the Brokerage & Freight Accruals tab Save toolbar icon.
• Quantity: Displays the quantity of the transaction line item upon which the program was calculated.
• Amount: Displays the amount of the program as calculated for the corresponding line item.
• Item Set: Displays the name of the Item Set assigned to the program to which the corresponding transaction item belongs.
• Program ID: Displays the Program ID of the program for which the item’s corresponding program calculations were made.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 Freight Accrual

...