BookmarkBookmark this page!
Jun 15, 2023
Work Order Formats - Details Column Tab

Location: Program Menu>Configurations>System Configurations>Work Order Format>Detail Column Tab


Description: This allows you to set up standard contract formats for the Work Order.
 

  • There are 7 columns on the standard contract formats (Invoice format has 6, and column 5 does not apply). 
  • Several of these columns have up to 35 different selections.
  • You can choose none to leave the column blank.  You may set your rental and sales columns up separately.


Details Columns Tab:

 (See Field Definitions section at the bottom for descriptions of columns and field

 

image004_052_893x443

 

 Detail Columns (Same for rental and sales items)

 
Column 1

 

NothingLeaves field blank.
Item QtyPrints qty of each item

 

Columns 2, 4, 6, 7

  

NothingLeaves field blank.Delivery BoxesPrints 2 boxes for you to check that items were loaded and delivered.Discount Amt /EachCombo field that shows the discount amount and each price.Extended UndiscountedSame as above, just the total of the line item. 
KeyPrints Item KeyPickup BoxesPrints 2 boxes for you to check that items were picked up and unloaded.Replacement CostThe replacement field is used if defined.  If blank then uses sell priceExtended UndiscountedSame as above, just the total of the line item. 
Part NumberPrints Item Part NumberList BoxPrints 1 box for you to use however you would like.Retail SavingsRetail Price minus the final pricePurchase Case QtyCase Quantity in the Options tab of the item.
Serial NumberPrints Item Serial NumberManufacturerItems ManufacturerExtended Retail PriceBest for closed contracts.  Shows total hours/days/weeks rented.Rental Case QtyRental Quantity in the Options tab of the item.
Each PricePrints Total Price Divided by QtyVendorVendor 1 in the item record.Hours/Days/WeeksBest for closed contracts.  Shows total hours/days/weeks rented.TTL Discount AmtComplete discount of the line item, regardless of whether it’s an amount or a percent
Discount AmountShow the discount amount for the line itemModel #Item Model NumberEach Retail PriceRetail Cost divided by item qty.Rental DateFrom the date of the open to the date the item closes with the time
Discount PercentShows discount percent for the line itemUser-Defined 1User-Defined 1 fieldItem DescriptionField right below item name in the item record.  If used in Column 2, leave column 3 blank.  Also, if there is no item description, it will use the item name.Rental Date/TimeFrom the date of the open to the date the item closes with the time
Due Date OnlyShows only the date due not the time for each item.User-Defined 2User-Defined 2 fieldVendorVendor 1 in the item record.Rental PeriodFrom the date of the open to the date, the item closes
Date Time DueDate and time due back for each item.Items WeightItem Weight defined in the item recordTTL DiscountShows discount if either or both discount amount or percent is used, based on Retail CostRental Period W/TimeFrom the date of the open to the date the item closes with the time
Total PriceLine item total priceItems Setup TimeItem Setup Time defined in the item record.Each UndiscountedEach Price of the item before the discount, based on the price of the item on the contract.  This is different from the effective discount because it discounts off what is shown on the screen, not the retail price of the item.Bin LocationBin Location in the item record.

 

 Column 3

 

Nothing Item Name Item Description

 

 Column 5
 

Nothing 
 Status - Shows if the item is open, returned, on hold, reserved...etc.
 Discount % - Shows discount percent for the line item.

 

Other related Work Order format documents

Work Order Format - Header Tab
Work Order Format - Item Details Tab
Work Order Format - Sections
Work Order Formats - Footer
Work Order Formats - Parameters
 

 

 

 

 

Related Articles