Versions Compared

Old Version 4

changes.mady.by.user Tatum Hohl

Saved on

compared with

New Version 5

changes.mady.by.user Tatum Hohl

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NorthScope allows users to enter new sales invoices or convert sales orders to invoices. NorthScope sales invoices allow the user to allocate items, edit logistics information, assign items to contracts, adjust brokerage, freight accruals, promotions, and on invoice charges amounts, and more. In addition, users have the option of integrating sales invoices with the host system.

Prerequisites

Required Prerequisites

  • Carriers
  • Customers
  • Inventory Items
  • Order Invoice Transaction class
  • Sites
  • Workflow
  • Status Setup

Optional Prerequisites

  • Sales Contracts
  • Sales Programs
  • Set the Sales Order preference for “Do Sales Orders become Invoices in NorthScope” to ‘Yes’
  • Set the Sales Order preference for “Enable Real Time Transaction Integration” to ‘Yes’
  • This user guide assumes the preference is set to “Yes”. If the preference is set to “No”, then the components described in Steps 9 and 10 will not occur.
  • Status Setup
  • User-Defined Attributes for Sales Orders

Understanding the data flow

Once sales invoices are set to ‘Ready To Post’ in NorthScope, they appear in the host system’s Sales module as a Sales Transaction Entry in the Sales Batch titled “READY TO POST” when the Sales Order preference for “Enable Real Time Transaction Integration” is set to ‘Yes.’

...

From either the Sales Order Transactions or Transaction Items list view, click the New toolbar icon and select Invoice from the drop-down menu. Or, from the navigation menu, click New Transaction and select Invoice from the drop-down menu.

This will open the Sales Order: New Invoice window, which will open with a list view of all customer addresses that are active and have an Address Type of ‘Shipping’ or ‘Both’ for customers that are not on hold with the Address ID, Address, Attention To, City, Customer Name, Customer, State, and Zip information.

...

Once the header fields have been completed, select the customer for the sales invoice and click the Catalog Items toolbar icon. This will open the Sales Order: Transactions Select Items window, which will open with the customer’s name as a hyperlink to the customer record view, the address type as a hyperlink to the address record view, the shipping date, the transaction type of ‘Invoice’, and the site selection, which will default from the address and will be selected from the Site drop-down menu.

The Sales Order: Transactions Select Items grid will open with the customer’s favorite items listed. If the customer does not have favorite items, the list will appear blank with “No records to display.” However, available items can be searched for using the search field in the toolbar. Available items are those that are included in the customer’s Catalog Items and/or Item Favorites or, if the customer has full item access, all items will be available. Once search criteria has been entered, the items within the criteria parameters will appear with the following fields:

...

The Invoice record view opens with four tabs and a grid. The first tab is the Home tab, which opens with the Doc Date, Ship By date, Site, Status, Workflow, Carrier, and Ship to address fields defaulted from the previously entered information. However, each of these fields is editable and appear along with the rest of the header fields, all of which include:

  • Actual Ship: Displays a text box field for the user to enter the date the invoiced items were shipped, as opposed to when it was “supposed to” shipdate field that will automatically pull the latest Actual Ship date from the shipments on the Shipments tab once all shipments have been marked as Shipped. This field is not editable but is required to save the invoice as and once it defaults from the Shipments tab, the transaction will automatically update to a status of ‘Shipped’ or higherShipped.
  • Carrier: Displays a drop-down menu of all active carriers for the user to select the shipment method for the invoiced items. If the address being shipped to has a carrier assigned to it, this field will default to select the assigned carrier. Or, if there is no carrier assigned to the address but there is a carrier selected for the “Default Carrier” Sales preference, this field will default to select the preference carrierto select the preference carrier. If the selected Carrier is visible to Logistics, the shipments on the transaction will be managed in the Logistics module. Whether or not the Carrier is required is determined by the ‘Do Sales Orders Require a Carrier’ Sales Order preference.
  • Deliver On: Displays a text box field for the user to enter the date on which the invoiced items need to be delivered.
  • Doc Date: Displays a text box field for the user to enter the date the invoice was made. This field defaults to today’s date.
  • PO: Displays a text box field for the user to enter the purchase order associated with the invoice. If the Purch. Order field on the New Invoice window was completed, the PO field will auto-populate to reflect the same entry.
  • Ship By: Displays a text box field for the user to enter the date by which the invoiced items must be shipped. This field defaults to the date selected for the Ship by field on the New Invoice window.
  • Ship to: Displays a drop-down menu of the available shipping addresses for the customer by ID. The address of the selected address ID is populated as read-only beneath the selection. This field’s title displays a hyperlink that, when clicked, opens the Edit ship-to address window, which allows the user to edit the “Ship Attention To” name, the address, and the phone number without affecting the address or customer record.
  • Site: Displays a drop-down menu of all the sites assigned to the workflow group for the address. These sites are determined in the Workflow setup in the System module.
  • Status: Displays a drop-down menu of the status options for the invoice. This field defaults to ‘New’ but all available statuses include New, Approved, and Ready to Postare determined in Status Setup.
  • Workflow: Displays a drop-down menu of the workflow options for the invoice. These workflow options are determined in the Workflow setup in the System module.

...

Step 3: Editing the grid contents and allocating items.

Editing the grid contents.

The Invoice record view grid will open with the items selected on the New Invoice window displaying as individual line items with the following information:

  • Alloc. Units: Displays the number of units allocated of the line item. This field is only editable in Allocate View or the Alloc. Details window.
  • Alloc. Weight: Displays the amount of weight allocated of the line item. This field is only editable in Allocate View or the Alloc. Details window.
  • Carrier: Displays the name of the Carrier that will ship the item(s). This field defaults from the Carrier header field. However, if the transaction allows multiple shipments, the Carrier field is editable at the line item level.
  • Contract: Displays a drop-down menu for the user to select the contract to which to apply the line item(s). The available contracts will be those in the Sales Contracts module that are assigned to the customer for the specified line item with remaining quantities.
  • Extended Price: Displays the product of the line item’s price per unit of measure and number of units invoiced. This field is read-only.
  • Item Description: Displays the description of the line item. This field is read-only.
  • Item: Displays the line item’s number. This field is read-only.
  • Load: Displays the load the line item’s shipment will be on. This field auto-populates and is read-only.
  • Ord. Units: Displays the amount of invoiced units of the line item.
  • Ord. Weight: Displays the amount of invoiced weight of the line item.
  • Price UOM: Displays the unit of measure the price is contingent upon.
  • Price: Displays the price per unit of measure.
  • Ship By: Displays the date by which the line item(s) must be shipped. This field defaults from the Ship By header fieldBy header field. However, if the transaction allows multiple shipments, the Ship By field is editable at the line item level.
  • Site: Displays the name of the site to which the line item(s) are being shipped. This field defaults from the header Site field. However, if the transaction allows multiple shipments, the Site field is editable at the line item level.
  • Status: Displays the status of the line item(s). This field defaults from the header Status field.
  • Units UOM: Displays the unit of measure in which the units are displayed.
  • Weight UOM: Displays the unit of measure in which the weight is displayed.

New items can be added by clicking the Catalog Items grid toolbar icon, which will open the Select Items window with the ordered items and amounts appearing at the top. Follow the same steps as selecting new items to add items.

Allocating items.

To allocate items to the order, click the Allocate View grid toolbar icon. This will open the grid in allocate view, opening the Alloc. Units field for edits. Enter the amount of units allocated for each line item. Allocating via this method will allocate the items based on the preference setting for ‘Auto Allocate by?’.

To select the specific lot the allocated items will be pulled from, select the line item and click the Alloc. Details grid toolbar icon. The Alloc. Details window will open with the following header fields:

...

Note: Allocating items on Invoices in a status less than shipped will increase each allocated lot's allocated balance and will decrease each allocated lot's available balance. 

Step 4: Editing the

...

‘Shipments’ tab.

The Logistics Shipments tab opens with a line item for each shipment. Shipments are determined by the line items’ Carrier, Site, and Ship By date and appear with the following information:

  • # Items: Displays the number of items on the shipment.
  • Actual Ship: Displays the date the shipment was actually shipped. This is required to save the Shipment in a status of ‘Shipped’.Alloc. Units: Displays the number of allocated units on the shipment.
  • BOL: Displays the Bill of Lading number for the shipment.
  • Carrier: Displays the carrier transporting the shipment.
  • Deliver On: Displays the date on which the shipment is to be delivered.
  • Details: Displays a hyperlink that, when clicked, opens the Sales Order: Shipment Details window with the following fields: Truck, Driver, Vessel, Destination, Container, Total Units, Total Weight, Base Rate, Sales Amount, and Comment. The values entered in the Truck and Driver fields will auto-populate the corresponding fields on the Logistics line item and vice versa.
  • Driver: Displays the name of the driver transporting the shipment.
  • Freight Amount: Displays the cost of the freight.
  • Freight Rate Type: Displays a drop-down menu of freight rate types for the user to select the freight rate type for the shipment.
  • Freight Rate: Displays the freight rate.
  • Freight Terms: Displays a drop-down menu of freight terms for the user to select the freight terms for the shipment.
  • Load Status: Displays the status of the shipment’s load.
  • Net Alloc. Lbs.: Displays the total weight of allocated units on the shipment.
  • Net Ord. Lbs.: Displays the total weight of units ordered.
  • Ord. Units: Displays the number of units ordered.
  • Ship By: Displays the date by which the shipment is to be shipped.
  • Shipment: Displays the shipment number.
  • Site: Displays the name of the site to which the shipment is being made.
  • Tracking #: Displays the shipment’s tracking number.
  • Truck: Displays the name of the truck transporting the shipment.
  • Waybill: Displays the waybill number for the shipment.

...

Program Details include Brokerage and Freight Accruals and Promotions and On Invoice Charges. To edit this information, click the Program Details toolbar icon. This will open the Program Details window to the Brokerage & Freight Accruals tab.

Adjusting brokerage and freight accruals.

The Brokerage & Freight Accruals tab will open with each line item’s brokerage and freight accrual information. The values for each line item will be calculated based on the Brokerage and Freight Accrual Sales Programs assigned to the customer’s address in the customer’s Sales Program tab. The only editable field will be the Adj. Rate column where the user can enter the new brokerage and/or freight accrual rate for each line item. These amounts will not appear on the invoice but will affect the general ledger.

Once the rates have been adjusted, click the Save toolbar icon.

Adjusting promotions and on invoice charges.

Open the Promotions & On Invoice Charges tab to view each line item’s promotions and other charges that will appear on the invoice. The values for each line item will be calculated based on the Promotions Sales Program assigned to the customer’s address in the customer’s Sales Program tab. The only editable field will be the Adj. Rate column where the user can enter the new promotions rate for each line item. These amounts will appear on the invoice and will affect the general ledger.

...

Changes can be made to a transaction until it is finalized. To finalize a transaction, the user will need to change the status to “Ready to Post”. In some companies, posting is a two-step process where the transaction(s) are approved by one person, and posted by another.

Approving the transaction

This step is optional and is used for companies that require a two-step process where the person who approves the transaction cannot be the same person that posts the transaction.

...

Once the status has been successfully updated to “Approved”, all editable fields, with the exception of Status, Workflow, and PO will be disabled.

Finalizing the transaction

When the transaction is ready to be finalized, open it and change the status to “Ready to Post” and save the transaction. Setting the transaction to “Ready to Post” does the following:

...

  • All allocated lot's allocated and on hand balances will decrease.
  • A posted SO Shipment transaction will be created in the inventory module for each lot allocation on the invoice, which will only be visible within the Inventory inquiries.