The Project Tracking interface is a two-sided interface to the general ledger for posting costs and revenue generated by projects. Cost postings are generated when cost transactions are entered. Revenue postings occur when transactions are billed to the customer.
Project Tracking transactions are posted to the general ledger using program GLGJ, Move Generic GL Interface Journal Trans for the PROJECT journal type.
* To view information for the posting types for the Project Tracking posting interface, see Project Tracking Interface Posting Types.
* Posting Templates for Project Tracking transactions are entered in program GPTM, Posting Template Maintenance, for the PROJECT posting interface. For more information on entering posting templates, see program GPTM, Posting Template Maintenance.
Project Tracking Posting Parameters
Posting parameters for the posting types are defined in program GPMM, Posting Parameter Item Maintenance, as follows. Any given transaction will not include values for all these parameters as the set of values will vary with the posting type involved. Posting templates use posting parameters to determine to which general ledger account to post a transaction.
BILLING_ID: Billing ID of the item being invoiced. Provided to support other query parameters.
CLASS_CODE: Project class code from the project line.
COST_ELEMENT Cost element from the rate code used in transactions.
CUST_NO Customer number associated with project.
DEPARTMENT Department associated with resource or employee.
EMPNO Employee number
ITEM_NO Item number associated with purchase or material items.
PROJECT_LINE_CODE Project line code from the project line.
PROJECT_LINE_TYPE Project line type from project line. 'L','M','E','P', 'W', and 'T' are valid.
PROJECT_NO Project number
LABOR_CODE Labor code as defined in the labor_type table.
LABOR_RESOURCE 'L' if the transaction is labor, 'R' if the transaction is for a resource
LINE_STATUS Project line status. Valid values are 'O', 'C', 'N', and 'B'.
PLANT_CODE Plant code associated with transaction
PO_LINE Purchase order line associated with receipt or voucher
PO_NO Purchase order number associated with receipt of voucher
PROJECT_ID Project ID from the project header.
RATE_CODE Rate code associated with the transaction
RATE_TYPE Rate type associated with transaction. 'R', 'O', 'P' are valid values
RESOURCE Resource ID of resource. Labor_Resource will be 'R' for these transactions.
TRANS_DATE Transaction Date
UNIT_CODE Unit code associated with transaction