MATERIAL PRICING IN TCM Presented by David Miller D. Miller Associates
The Job Cost Unit Cost Database • Category • Item • Description • Billing Rate • Cost Rate • Unit of Measure • DCI Number
The Job Cost Unit Cost Database • Inventory • Add Item to Inventory • Maintain Item in Inventory • Unit Cost • List Price • Average Cost • Description • Billing Rate • Cost Rate • Unit of Measure • DCI Number
Import Unit Cost Information • TCMUnitCostImp.xls • Field Data Type Size Notes • Company ID Text 3 This field is required. The entry must be an existing company ID. • Category Text 10 • Category Description Text 30 • Unit Cost Item Text 16 This field is required. • DCI Number Text 20 • Item Description Text 35 • Cost Rate Amt Currency The default is 0.00. • Bill Rate Amt Currency The default is 0.00. • Unit Measure Text 10 • Comment Text 20 • IV Item Text 16 • Add to IV Text 1 The default is 1 .1 = No 2 = Yes • Maintain in IV Text 1 The default is 1 .1 = No 2 = Yes
Price Database Transfer and Update • Update Existing Price Database Items • Create New Price Database Items • Update Inventory Items • Copy Price from Column: • Cost • List • Column 1, 2 or 3
Using Your Material Pricing Database • Purchase Orders • Job Entries • Inventory Entries • Accounts Receivable Invoices • Job Estimates
Purchase Orders • When entering line items for your Purchase Order, the description and cost rate for the Unit Cost Item are displayed. You can use the additional description lines to specify color, model, size, etc.
Job Cost Entries • You can enter a Category/Item while preparing Job Entries. The Cost and Description will be automatically displayed when you enter a valid Category/Item code. You can also prepare this information in an Excel spreadsheet and import it into TCM.
Inventory Entries • The Item Number used in Inventory must match the Item Number setup in Work on Unit Cost Information. • TCM will automatically display the Item Number and Category setup in Work on Unit Cost Information.
Job Estimates • Entering the Quantity and valid Item Category/Number combination will automatically extend the cost into the Estimated Dollars field.
Job Income • Entering the Quantity and a valid Item Category/Number combination will automatically extend the value from the Billing Rate into the Contract Amount field.
Accounts Receivable • Entering the Quantity and a valid Item Category/Number combination will automatically extend the value from the Billing Rate into the Amount field. You can use the additional Description lines to specify size, color, model, etc.
SUMMARY • Creating and maintaining a Material Pricing Database inside TCM can enhance your use of the Accounts Receivable, Purchase Order, Inventory and Job Cost Modules.
SUMMARY • You can use your subscription to Trade Services (TRASER) to periodically update the prices in your database to reflect changes in the marketplace.
SUMMARY • You can also maintain this information in an Excel spreadsheet, and use it to add and update items in your Material Database.
SUMMARY • If you deal primarily with a single supplier, your supplier may be able to generate a price list in a format suitable for updating your TCM database.
???QUESTIONS??? • Thank you for attending the 2007 AMSI User Conference!