Material Sales - Ticket Entry

Pgm: MS_TICKET_ENTRY – Ticket Entry; standard Treeview path: Material Sales > Ticket > Enter/Edit

The Selection Criteria section shows the company, sales order, item, item type, item location, date, origin, and destination. The unbilled, unposted, and posted checkboxes display unbilled and posted tickets in the Tickets section. Unbilled tickets are tickets that have not yet been billed. Unposted tickets are tickets that have been billed but are not yet posted. Posted tickets are tickets that have been billed and posted. The screen automatically adjusts depending on the parameters entered in the Selection Criteria section.

Tickets

Ticket Code

Enter the ticket number.

Sales Order

Enter the sales order associated to the ticket.

Date

Enter the date of the ticket. This should be on or after the start date of the item to be selected.

Customer/Job

The customer or job will be displayed depending on the type of sales order: external or internal sales order.

Item

Select the item from the LOV. The items default from the sales order and may be inventory items or non-stock items.

Type

Type refers to an inventory item. Entering a type will limit the ticket entry to the inventory item and type. Select the item type from the LOV. For an AR non-stock item or PO non-stock item, tab past the type field and an asterisk will be displayed indicating that it is a non-stock item.

Item Location

Select the item location from the LOV.

Origin

Enter the origin.

Ticket Type

Enter the ticket type.

From Zone Code, To Zone Code

Enter the range of zone codes.

Total AC %

Enter the override AC percentage.

Max. Protection %, Min. Protection %

Enter the maximum and minimum protection percentage.

Quantity

Enter the quantity of the item being delivered.

WM

The WM code for the item is displayed. It defaults from the WM code on the sales order.

Price

Enter the price of the item. The price defaults from the customer’s price list and the search order specified for that customer. Changing the unit price in the Tickets section requires privileged access.

Amount

The amount is calculated based on the price and quantity of the item.

Tax 1, Tax 2, Tax 3

Enter the tax codes.

Trucker

Select the trucker from the LOV. This may be an employee or sub-hauler.

This column will not be available if the control setting for the ‘Trucker Payroll Not Required’ checkbox is checked.

Truck/Trailer

Select the truck from the LOV.

This column will not be available if the control setting for the ‘Trucker Payroll Not Required’ checkbox is checked.

Regular Hours

Enter the number of hours that the trucker has worked.

This column will not be available if the control setting for the ‘Trucker Payroll Not Required’ checkbox is checked.

OT Hours

Enter the trucker overtime hours.

DOT Hours

Enter the trucker double overtime hours.

Trucker Pay Rate

Enter the hourly pay rate for the trucker. The pay rate is for external truckers or sub-haulers only. The pay rate will use the WM code of the product. Internal trucker pay rate will calculate number of hours × payroll rate and should not be entered here.

This column will not be available if the control setting for the Trucker Payroll Not Required checkbox is checked.

Min. Pay Qty

Enter the minimum trucker pay quantity.

Min Pay Amt

Enter the minimum trucker pay.

Trucker Pay

The calculated trucker pay is displayed here and is calculated as follows:

  • Sub-Hauler: Trucker Pay = Qty × Pay Rate

  • Employee: Trucker Pay = (Regular Hours + OT Hours + DOT Hours ) × Pay Rate

  • Broker: Trucker Pay = Qty × Pay Rate

This column will not be available if the control setting for the 'Trucker Payroll Not Required' checkbox is checked.

Surcharge %

Enter the trucker pay surcharge percentage.

Surcharge Rate

Enter the trucker pay surcharge per WM.

Lump Sum Amt

Enter the lump sum amount for the trucker pay surcharge.

Pay Surcharge

Enter the surcharge on the trucker pay.

Service Charge – Checkbox

If this box is checked, the Material Sales service charge is applied.

Delivery Charges

Enter the delivery charges per WM.

Min Charges Qty

Enter the minimum quantity required for delivery.

Min Charges Amt

Enter the minimum amount/charge required for delivery.

Delivery Charges

Enter the delivery charges.

Tax 1, Tax 2, Tax 3

Enter the tax codes for the delivery charge.

Surcharge %

Enter the delivery surcharge percentage.

Surcharge Rate

Enter the delivery surcharge rate per WM.

Lump Sum Amt

Enter the delivery surcharge lump sum amount.

Delivery Surcharge

Enter the surcharge on delivery charges.

Tax 1, Tax 2, Tax 3

Enter the tax codes for the delivery surcharge.

Trucker Invoice, Billing Invoice

For an unbilled ticket these fields are left blank. If the ticket was billed, the invoice numbers would be displayed in these fields.

Batch #

This displays the batch number that this ticket belongs to.

Post – Checkbox

This checkbox is checked if the invoice is posted. The checkbox cannot be overwritten. The post checkbox indicates the posted or unposted invoice status for the ticket.

Cash On Delivery – Checkbox

Check this box if this is a cash ticket.

Classifier 1, 2, 3, 4, 5, 6

Enter classifier codes or leave blank.

Notes

Enter notes for the selected ticket.

Print on Billing Address – Checkbox

If this box is checked, the notes will be printed on the AR billing invoice.

[Daily Order Info] – Button

This button opens the Daily Order Info pop-up window to maintain free form information associated with a Material Sales ticket. The daily order entered here can be used when creating a Material Sales internal ticket receipt to select data related to a specific daily order number.

These values are available in Accounts Receivable and Accounts Payable ticket adjustments to filter/query data for updates.

The following describes the fields available in the Daily Order Info pop-up window:

Daily Order#

Enter the daily order number.

Date

Enter the date of the order.

PO#

Enter the purchase order number.

Job Code

Enter a valid job code or select a value from the list.

Phase Code

Enter a valid phase code or select a value from the list.

Click [Accept] to save the changes and click [Close] to close the pop-up screen.

NOTE: The following fields are hidden by default in the Ticket Entry screen and can be added using the Lite Editor: Foreman, PO Line, Sold As Item, Sold As Item Class, Sold As Item Location, and Sold as Item Type. These fields are used to support third-party software and are not mandatory to create a ticket. These fields are also available in the Mass Update Tickets screen.

Foreman

Enter the foreman's name. This field is hidden by default and can be added using the Lite Editor.

PO Line

This field is read-only and is populated from third-party integrated software. This field is hidden by default and can be added using the Lite Editor.

Sold As Item

Enter/select a sold as item. The system will use the price from the sold as item to adjust the main item's price in the Price field. The Sold As Item field is hidden by default and can be added using the Lite Editor.

Sold As Item Class

Enter/select a class if the sold as item is an inventory item. This field is hidden by default and can be added using the Lite Editor.

Sold As Item Location

If data is entered in the Sold As Item field, enter/select a sold as item location. This field is hidden by default and can be added using the Lite Editor.

Sold As Item Type

If data is entered in the Sold As Item field, enter/select a sold as item type. This field is hidden by default and can be added using the Lite Editor.