Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Project Budgeting

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Wed, 14 Nov 2018 09:33


General

The Budgeting tab of Project Control allows setting predefined budgets for each project. Costs are grouped into each budget category based on how the rule is set up. The Purchase Order Cost and Actual Cost columns are updated based on transaction data. The Purchase Order Cost column will display the dollar value of unreceived items on PO's for each category. The Actual Cost column will display the actual cost for items shipped out for each category. The Budgeted Cost and Budgeted Price columns are updated from imported data.

Import: Opens a window to allow selecting and importing a Budget Template.

Export: Exports the currently displayed budget into Excel. The Export button can also be used create a blank Budget Template file from a project with no budget amounts.

ReCalc: Recalculates the Purchase Order Cost and Actual Cost columns. The Purchase Order Cost and Actual Costs are dynamically updated from transaction data, but the ReCalc button can be used to recalculate in cases where purchase order or shipping transactions are happening in another screen or Adjutant session.

Image



Rule Setup

Project Type: This field references the two character Project Type code from the Project Types rule. This is used to set up budgets for each specific Project Type.

Item CommCode: This field references the Item Commodity Code to use when grouping transactions into budget categories. A commodity code should not be matched with multiple budget codes.

Budget Code: This field references the budget code (budcode column) used on the Budget Import Template. A budget code can be used with more than one commodity code. For example, commodity codes BEM & COL for Beams and Columns could both be mapped to the same STR (Structural) budget code.

Image



Import Template

The import template can be downloaded here.

buddesc: Name displayed in the Project Budgeting screen for the associated budget code. For example, Structural could be put in this column for budget code STR.

cost: Budgeted cost for the category.

price: Budgeted price for the category.

acost: This column should be 0 for import. This will be filled out with the Actual Cost if a budget is exported.

pcost: This column should be 0 for import. This will be filled out with the Purchase Order Cost if a budget is exported.

keyno: This column should be empty for import. Keyno values will display on exported budget, but should be removed prior to import.

budcode: Budget code from the Project Budget Map rule. This must match a valid budget code entry in the rule, which is tied to the project type being imported.

sorter: Numerical sort order for the Budgeting grid. Enter a unique number from 1 to 99 on each line to set the display sort order for each line.

totline: This column should be "n" or empty for import. This will be "y" to indicate a total line if a budget is exported.





Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions