Page Comparison

...

• Account Setup
  • If the Freight Accrual’s 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 Freight Accrual, thus requiring that these accounts be setup.
• Integration setup
  • Setting the Host system integration for SO Invoice to immediate or timed.

...

• Description: Enter the description of the program. This will display in the Programs list view and will help differentiate the sales program from all other Freight Accrual programs. This field is displayed in the header section of the record. 
• Class: Select the Program Class to assign to the Freight Accrual. This is for categorical purposes and the lookup will only include those program classes assigned a program type of ‘Freight Accrual’. This field is required.
• From: Enter the date as of which the Freight Accrual is eligible. This field is required.
• To: Enter the date as of which the Freight Accrual is no longer eligible.  This field is required.
• Settle To: This field defaults to ‘Invoice’ and is not editable for Freight Accrual programs.
• Frequency: This field defaults to ‘Invoice’ and is not editable for Freight Accrual programs.
• Program Rate Currency: This field defaults to blank, but displays a drop-down menu of currencies configured in the system. This field is always required and cannot be edited after saving the program record. The currency determines the addresses displayed in the Addresses tab. Only customers with the corresponding currency are displayed in the Addresses tab and can be assigned to the program.
• Assign Addresses By: This field defaults to Address and determines if the program is assigned to individual Addresses or Address sets. This field is required and cannot be edited after saving the program record. 

Once the base properties have been assigned and the program record is saved, the following properties are displayed:

• Accounting Rules: This field is automatically updated based on the Debit/Expense Account and Credit/Accrual Account values selected. The field is never editable and displays one of the following values: 
  • Use Item Accounts: Will use the Freight Expense and Freight Accrual accounts of each individual item in the assigned Item Set(s) to account for the Freight Accrual via distributions in the invoice’s journal entry.
  • Use Item Debit Accounts: Will use the Freight Expense account of each individual item in the assigned Item Set(s) to account for the Freight Accrual’s expense and will use the selected account for the Credit/Accrual value to account for the Freight Accrual’s accrual.
  • Use Item Credit Accounts: Will use the Freight Accrual account of each individual item in the assigned Item Set(s) to account for the Freight Accrual’s accrual and will use the selected account for the Debit/Expense value to account for the Freight Accrual’s expense.
  • Specify Both Accounts: Will use the selected account for the Debit/Expense value to account for the Freight Accrual’s expense for all items and will use the selected account for the Credit/Accrual value to account for the Freight Accrual’s accrual for all items.
• Debit/Expense Value: This field defaults to (From Item), but is always editable. The drop-down menu displays all active GL Accounts configured in the system. This field determines the debit account for the freight accrual. 
• Credit/Accrual Value: This field defaults to (From Item), but is always editable. The drop-down menu displays all active GL Accounts configured in the system. This field determines the credit account for the freight accrual.

Once completing the header fields, click Save.

...

• Seq: This field defaults to the next number in the sequence and is not immediately editable. However, once the Item Sets tab is saved, each Item Set can be dragged and dropped into the correct order of hierarchy.
• Item Set: Select the Item Set to assign to the Freight Accrual. Duplicate Item Sets are not allowed to be assigned to the same sales program. This field will display a drop-down menu of all Item Sets assigned a ‘type’ of ‘Sales Programs’ or ‘All Modules’. This field is required.
  • To setup Item Sets, go to Inventory>Item Sets and click new. Enter the Item Set name and description and select the item set’s ‘Type’. By default, all new Item Sets include all items. To limit the items included in the item set, apply as many filters as necessary to include only the items meeting the filtered criteria. Filters can be placed on the following item values: Item Type, Item Class, Attribute Class, UOM Schedule and all Item Attribute Values. Items can be manually included and excluded if necessary. Saving the item set record updates the Items tab displaying the items assigned to the item set record. When a new item is added to NorthScope that fits the filtered criteria of an Item Set, that item is automatically added to the Item Set and therefore assigned to any sales program the Item Set is assigned to. 
• Calculation Method: Select the method by which the program will be calculated. This field displays a drop-down menu of calculation methods including the following:
  • $/UOM: Calculates the program based on the rate assigned to the item set for the program and the UOM assigned to the item set for the program. This calculation is the rate times the quantity (of the program UOM) that exists on the invoice for all items belonging to the item set. If this calculation method is selected, the UOM field is required.
  • % Gross $’s: Calculates the program based on the percentage rate assigned to the item set for the program and the total dollars of all items on the item set. This calculation is the percentage rate times the sum dollar amount of all items belonging to the item set on the invoice.
  • % Net $’s: Calculates the program based on the percentage rate assigned to the item set for program and the total dollars of all items on the item set. This calculation is the sum dollar amount of all items belonging to the item set on the invoice less the charges from all other sales programs times the percentage rate.
  • % off Total Invoice $’s: Calculates the program based on the percentage rate assigned to the item set for the program and the invoice’s total amount. This calculation is the percentage rate times the total invoice dollar amount, including items not belonging to the assigned item set(s).
• Rate: Enter the rate by which to calculate the Freight Accrual. If the Calculation Method is set to $/UOM, the rate being entered must be a dollar amount to be charged/discounted per 1 unit of the selected UOM. If the Calculation Method is set to anything other than $/UOM, the rate being entered is a percentage to be charged/discounted.  Note: The rate must be positive.
• UOM: Select the unit of measure by which to calculate the program. If the Calculation Method is set to $/UOM, the UOM field is required and will determine the unit by which the rate is charged/discounted. If the Calculation Method is set to anything other than $/UOM, the UOM field is disabled and will display %.
• # Items: This field is never editable by the user and will automatically update once the Item Set is saved to display the number of items on the item set, which are now assigned to the Sales Program.

...

The Customers tab will display all customer addresses with a check box, allowing the user to select the address(es) to assign to the brokerageprogram. Each column within the list is filterable, allowing the user to easily narrow down the addresses that display to select the appropriate address(es) addresses to assign. Once finding an address to assign to the brokerage, select the checkbox that corresponds to the address and click the save grid toolbar icon. This will sort the selected address(es) to the top of the list to easily identify the address(es) currently assigned to the brokerageTo assign addresses to a program, check the check box displayed before the Customer ID and click Mass Update.  This opens the mass update dialog, where addresses can be assigned. Set ‘Assign Addresses’ to ‘Yes’ and click Apply. Also the start date can be assigned on the mass update dialog, but this is not required. Multiple addresses can be assigned to the program simultaneously. To remove addresses from the program, check the check box and click Mass Update toolbar icon. Set ‘Remove Addresses’ to ‘No’ and click Apply. When an address is assigned to a program, the On Program column displays Yes. Addresses assigned to the program are displayed on top of the list view.

Assigning Sites

To assign a Site, open the Sites tab within the Sales Program record.

...

Once the invoice is saved as Ready to Post, the invoice will be sent to the host system, so long as the ‘Enable Real Time Transaction Integration’ Sales Order preference is set to ‘Yes’, integration is turned on,  and the freight accrual’s distributions will be sent with the invoice.