Trucking Billing Manifest

From UG

Revision as of 23:36, 2 December 2009 by Alex (Talk | contribs)
Jump to: navigation, search


Contents

Business Requirements

  • Operators need xls spreadsheet for Trucking MOT that has:
    • Manifest section:
      • commodity info (PO, SKU, etc)
      • general CT info (Shipper, etc)
    • Billing section:
      • per CT
      • has commodity totals (Gross weight, etc)
      • has fields that contain formulas

Suggested Design

File:Select_CTs_from_Groups.JPG

thumb|500px|Trucking_Billing_Manifest_Template.JPG

Home and Select Groups or CTs panel

  • It is suggested to have this option available on Doc Center Tab in Master
  • On "generate template" system would present pop-up panel that gives a choice to the user of what CTs to include into the document - see Select_CTs_from_Groups.JPG

Template

  • See File:Trucking_Billing_Manifest_Template.JPG
  • Mapping:
    • Date // today's date
    • Client // GenTab.E0
    • Author By // Gen Tab
    • Rate // float; default=0.00
    • Min Rate // float; default=0.00
    • Fuel // float; default=0.000


Generated xls

Personal tools