Page Comparison

As already indicated the external part (A new wiki page is under construction, click here to see if it's available.)

The external functionality of Dockets & Day Sheets is for:

• the capturing of cost via Docket Entry as the product or service is consumed. The cost & sell rate for each of these transactions is setup in a schedule.
• reconciling the AP invoice against the Dockets entered to ensure the initial accrual to the Job was accurate
• making any cost adjustments necessary

The first thing is to create the Docket Costing Schedule containing the Labour, Plant or Materials to be costed to the Job via Daysheets.

Maintain Docket Costing Schedule

Open the menu item 'Docket Costing Schedule Maintenance'

Image RemovedImage Added

• You can have any number of Docket Costing Schedules depending on your specific requirements.

Image RemovedImage Added

For Example:

• In some cases it may be appropriate to have a single schedule per Job.
• In other cases a number of different schedules may be used for a single Job.
• Alternatively you could have a range of generic costing schedules which are used on a range of different Jobs.
• The Docket Costing Schedule is only used for External Cost Items.

...

• LE
• PE
• MAT
• SUB
  • L = External Labour Hire
  • P = External Plant Hire
  • M = Materials Purchased
  • S = SubContracts
• FR

Note that 'L' type transactions can be treated as a Time transaction in Workbench. This is how you can get Time transactions into Workbench without using Workbench Timesheets. It is great for Labour Hire where you want the transaction treated as Time but payment will be through Accounts Payable. It makes 'Time' type Activities available.

• The Docket Costing Schedule lines hold the default rate which will be used for costing Dockets & Day Sheets as they are entered and the Sell Rate or Markup % to calculate Retail

Image RemovedImage Added

To add a schedule line:

• Select the Supplier. Press F4 in the 'AP AcctAccount' field and choose the appropriate required supplier.

• Press 'OK' to confirm the selected Supplier.

• Select the type of Schedule item Select the Type for the Schedule Line that you are setting up i.e. g. Labour, Materials, Plant, SubcontractF(uel), (L)abour, (M)aterials, (P)lant, (S)ubcontract.
• Enter a code Code for the schedule itemSchedule Line. This could be a code Code provided by the supplier Supplier for the materials to be delivered or your own codeCode.
• Enter a description Description for the schedule itemSchedule Line.
• Select the an Activity Code for this schedule lineSchedule Line. This is the Activity Code that will be costed to the Job when you enter deliveries them into the Docket later on. You can also specify a Work Centre at this stage. (There is no Activity validation through Activity Groups as no Job has been selected at this stageonly occurs when an Activity Group is selected, otherwise the following Activity Types are permitted: Disbursement, Overhead, Plant, Provision, Purchase, Stock, Subcontract, Time.)
• Enter the Unit for this schedule item Schedule Line e.g. Each, Day, Hr, Tonne, m3, m2. Also enter
• Enter the Unit Cost Rate for this itemLine.

Enter the Sell Rate or Markup % to calculate Retail for this item. The Docket Costing Schedules provides for a selling rate or markup percentage to be specified on each line. There are 3 options:

...

When you have completed entering the schedule you can Print a copy of it by pressing the 'Print' button in the top left hand corner of the form.

Docket Costing Schedule Report

...

You can also Import Schedule lines from an external file e.g. an Excel spreadsheet. There needs to be 11 columns as per 'Import Workbench Data' form.

• Create the Excel Spreadsheet

...

a CSV.

• Create a Schedule Header

• Click Import Lines.

...

You will be retuned to the Docket Costing Schedule Maintenance screen which will now contain all of the import lines on it.

Copy from another Docket Costing Schedule

...

• Make any changes to the copied schedule that are required.

Linking the Docket Costing Schedule to the Job

...