Project Integration's/Estimated Setup/Procedure : The following is a brief explanation of the required setup of the general ledger accounts and transaction types that will be required for project integrations. The general ledger accounts used in this example are only suggested. The setup for mapping to dimensions is the same as that for all other integrations. 1. Planned PRP Warehouse Order: Allows for the transfer of standard inventory to a customized item and / or allows for the transfer of a customized item back to standard inventory. If this is performed a financial transaction is created. The transaction should account for the movement between standard inventory and project inventory. 1.A. Session: Maintain Inventory and WIP * Transaction Origin:PRP Warehouse * Fin Transaction :Inventory Transfer Debit : Project Interim Acct. Credit: Inventory * The system performs a "negative Debit" and a "negative credit" so the above should be setup in reverse. 1.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 1.B. Session: Maintain Project Trans.Accts * Transaction Origin:PRP Warehouse * Fin Transaction :Material Cost Debit : Project WIP Credit: Project Interim Acct. 1.b. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 2. PRP Warehouse Order / Inventory Variance : This transaction is created when the cost of the anonymous item differs from that of the customized item when the inventory is transferred to the project. 2.A. Session: Maintain Project Transactions : * Transaction Origin:PRP Warehouse * Fin Transaction :Inventory Variance Debit : Project Interim Acct. Credit: Inventory 2.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 3. Issuing Material To a Production Order for a Project: Creates a transaction for moving Inventory from stock to the Production Order / Project. The transaction should account for the movement between standard inventory and project inventory. 3.A. Session: Maintain Inventory and WIP * Transaction Origin:Production * Fin Transaction :Inventory Transfer Debit : Project Interim Acct. Credit: Inventory 3.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 3.B. Session: Maintain Project Trans.Accts * Transaction Origin:Production * Fin Transaction :Material Cost Debit : Project WIP Credit: Project Interim Acct. 3.b. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. Subcontracting : The purchasing of outside services . This transaction is created when a subcontracted routing step is completed / received against a purchase order. 4.A. Session: Maintain Project Trans.Accts * Transaction Origin:Production * Fin Transaction :Subcontracting Debit : Project WIP Credit: A/P accrual When the invoice is received the accrual entry will be reversed and if any additional cost is incurred a transaction for "production/production result " will be created. 4.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element 5. Issuing Hrs To a Prod Order for a Project In HRS ACCT : Creates a transaction which should account for the operation cost resulting from the direct labor hrs earned and associated overhead. 5.A. Session: Maintain Project Trans.Accts * Transaction Origin:Production * Fin Transaction :Operation Cost Debit : Project WIP Credit: Absorption accts/Based on cost component(can be both labor and overhead) 5.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 6. Purchase Receipt : The purchase of inventoried items specifically for a project. This transaction is created when items are received against a P.O. 6.A. Session: Maintain Project Trans.Accts * Transaction Origin:Purchase * Fin Transaction :Material Cost Debit : Project WIP Credit: A/P accrual When the invoice is received the accrual entry will be reversed and if any additional cost is incurred a transaction for "purchase variance " will be created. 6.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element 7. Purchase Variance : This transaction is created when the price of the purchased item is < > than the standard cost. 7.A. Session: Maintain Project Trans.Accts * Transaction Origin:Purchase * Fin Transaction :Variance Debit : Project WIP Credit: Variance 7.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element 8. Purchase Sundry Cost : This transaction is created when cost items are purchased. 8.A. Session: Maintain Project Trans.Accts * Transaction Origin:Purchase * Fin Transaction :Sundry Cost Debit : Project WIP Credit: A/P accrual 8.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element 9. Issuing Hrs Directly To a Project In HRS ACCT : Creates a transaction which should account for the operation cost or indirect labor charged directly to a project. 9.A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :Operation Cost Debit : Project WIP Credit: Absorption accts/Based on cost component(can be both labor and overhead) 9.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 10. General Cost : Misc. charges to a Project either through A/P or Surcharges. Creates a transaction when maintained in the project estimate or an A/P invoice is processed. This transaction should account for the misc. charges incurred for a project. If the actual General Cost is < > than the standard a variance transaction will be created. It should be noted that if this option is used, the cost will be entered into the ledger account which is flagged for PCS integrations, not into the project WIP. 10.A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :General Cost Debit : Project WIP Credit: Absorption accts/Expense Acct. 10.A1. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :General Cost Variance Debit : Project Wip Credit: Variance / or Abs. / Expense Acct. 10.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. * General cost can be charged in the mfg/project session pcs/general cost or a ledger acct can be flagged for pcs/general cost and when this acct is used the pcs/general cost session will pop up and we can view all projects so the correct one can be selected. 11. Surcharges : Method to attach additional cost or other indirect cost to a project or project item . This transaction will be created when the project or item which carries the surcharge is used in an inventory transaction. If the actual surcharge is <> than the standard a variance transaction will be created. 11A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :Surcharges Debit : Project WIP Credit: Expense Acct./Can define Multiple acct's if each surcharge is a different type of expense.You will do this by defining accts by cost component. 11A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :Surcharge Variance Debit : Project WIP Credit: Variance / or expense acct. 11.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 12. PCS / Production Results : This transaction is created if the actual cost of the project is over / under the estimated cost and the variance was not assigned to any other transaction such . This transaction can be best described as a "catch all ". 12.A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :Production Result Debit : Project WIP Credit: Variance Account 12.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 13. Estimated COGS : Everytime project cost is calculated a transaction will be created if additional cost have been incurred from the last calculation. If the project is created from a sales order the COGS entry will not be created until the project is invoiced. 13.A. Session: Maintain Project Trans.Accts * Transaction Origin:PCS * Fin Transaction :Estimated COGS Debit : COGS Credit: Project WIP 13.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 14. Sales Revenue: Transaction will be created at invoicing time and processed delivered sales orders has been run. 14.A. Session: Maintain Project Trans.Accts * Transaction Origin:Sales * Fin Transaction :Revenue Debit : Sales Interim Acct Credit: Sales ** Triton always creates an entry at invoicing time.An entry is made to A/R (Financial Customer Group)and an entry is made to the acct defined in the session maintain vat codes by country(should use an Interim Sales acct here.).It will important to offset the entry made to the acct defined in this session.. 14.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. 15. Sales Order: Sales orders can be entered for standard items and charged to a project.This cost will be added to the total cost of the project but will not be in the project estimate or show as a line item on the project. 15.A. Session: Maintain Inventory and WIP * Transaction Origin :Sales * Fin Transaction : Inventory Transfer Debit : Project Interim Credit: Inventory 15.B. Session: Maintain Project Trans.Accts * Transaction Origin :Sales * Fin Transaction :Material Cost Debit : Project WIP Credit: Project Interim 15.a. Session: Trans Type by Trans Origin: **For the above combination attach a transaction type and an Integration Element. DRAFT - 12-08-99