QAD 2017 Enterprise Edition > User Guides > Periodic Costing > Working with Periodic Costing Results > Using Reports and Browse Collections to Reconcile > PC Operations Reports
  
PC Operations Reports
You can use the reports in the PC Operations Reports menu (30.5.15) to help you review operations data.
PC Work Order WIP Cost Report (30.5.15.1)
PC WO WIP History Report (30.5.15.2)
PC WO WIP History Inquiry (30.5.15.6)
PC WO Bill Cost (30.5.15.7)
PC WO Routing Cost Browse (30.5.15.8)
PC WO Cost History Report (30.5.15.12)
Operational Trans Detail Inquiry (30.5.15.13)
Op Operational GL Transactions (30.5.15.14)
Operational Inv Transactions (30.5.15.24)
WO Receipts (30.5.15.25)
WO Components (30.5.15.26)
Operation Transaction (30.5.15.27)
Subcontract Receipts (30.5.15.28)
PC Cost Detail (30.5.15.29)
The following topics describe important reports and inquiries most frequently used in reconciling PC operations.
PC Work Order WIP Cost Report
Use PC Work Order WIP Cost Report (30.5.15.1) to specify a range of data to display for each cost set. You can specify the account, sub-account, cost center, project, work order, ID, item number, site, sales/job, or supplier.
PC WO WIP History Report
Use PC WO WIP History Report (30.5.15.2) to display work order WIP history for each cost set. You can specify a range of work orders, sites, item numbers, batches, due dates, IDs, sales/jobs, or suppliers. Optionally, you can specify whether to display items, routing details, and co-/by-product orders. You can also select a cumulative order with no effective date or set page breaks on work orders that display.
PC WO Routing Cost Browse
PC WO Routing Cost Browse (30.5.15.8) displays Periodic Costing work order routing cost for multiple periods. For any cost set, when the WO has any operation or finished goods transactions that affect WIP, the browse displays all WO routing of this WO of this cost set.
PC WO WIP History Inquiry
Use PC WO WIP History Inquiry (30.5.15.6) to view WO WIP history data for components and routing operations. You can specify the cost set and operation type, which are mandatory fields; then specify whether the WO master, WO detail, or WO routing data displays in the report. When you press Go, you are prompted to enter additional information such as operation and component item data. Enter specifics about each area, then press Go to run the inquiry.

PC WO WIP History Inquiry (30.5.15.6)
PC WO Cost History Report
Use PC WO Cost History Report (30.5.15.12) to review work order cost data. You enter the work order; the system defaults the ID, item number, release and due dates, quantity ordered and completed, status, sales/job, and supplier. You can optionally choose to print BOM or routing detail or print co-/by-product orders. You can also choose to insert page breaks upon cost sets to aid when printing. The system defaults the currency to print, but you can change it.
The report displays the work order data in the header, including receipt, order, release, WO close, and due dates; quantity ordered, completed, and rejected; status, supplier, job, and other data. For each cost set, it displays the UM, quantity required, issue till date, and issue for the current period, then the average issue unit cost, total material issue cost, process to date/process current period, the average process unit cost, and the total issue process cost.
It displays the operation ID, standard operation, work center; the process quantity and the total hours till date and for this period; and the operation cost per unit and total operation cost.
Operation Trans Detail Inquiry
Use Operation Trans Detail Inquiry (30.5.15.13) report to view operational transaction details. You first enter the transaction number, then use the initial frame to view transaction details in the QAD EA standard maintenance frame setup. When you press Next, the system displays the report data.

Operation Trans Detail Inquiry (30.5.15.13)
Op Operational GL Transactions (30.5.15.14)
Use Op Operational GL Transactions (30.5.15.14) to view GL transaction data, including the transaction number, GL reference, effective date, reference ID, GL transaction type, account, sub-account, cost center, project, BC debit and credit, documents, orders, item number, site, entity, ID, and operation.
Several columns display a button when you right-click on the column. When you click the button, a supporting browse displays. Columns with additional data include:
 
Column
Button/Supporting Tab
Account
Account Codes
Order
Transaction Number
Item
Item Master
Site
Sites
Entity
Entity Codes

Op Operational GL Transactions (30.5.15.14)
Operational Inv Transactions (30.5.15.24)
Use Operation Inv Transactions (30.5.15.24) to view inventory operational transactions. You can view the transaction number, GL reference and reference ID, GL transaction type, account and sub-account, cost center, project, BC debit and credit, and more. Columns with additional data include:
 
Column
Button/Supporting Tab
Tran Nbr
Transaction PC Cost
Account
Account Code

Operational Inv Transactions (30.5.15.24)
WO Receipts and WO Components
Use the WO Receipts (30.5.15.25) to report WO receipt data, including the transaction number, effective date, transaction type, date, order, item number and description, site, location, location quantity change, transaction price, standard amount, Periodic Costing unit cost and amount, entity, address, and cost set.
Use WO Components (30.5.15.26) to report similar data to the WO Receipts report. Columns with additional data include:
 
Column
Button/Supporting Tab
Tran Nbr
Inv Operational GL Transactions
Transaction Type
Code Master
Order
Transaction Numbers
Item Number
Item Master
Site
Sites
Location
Location Master

WO Receipts (30.5.15.25)
Operation Transaction
Use Operation Transaction (30.5.15.27) to view transaction data, including the WO number and ID; item number; operation number and description; transaction number and type; effective date; employee; setup and run time; quantity completed, rejected, reworked, and scrapped; labor and burden cost standard; Periodic Costing amount; labor type; PO and receiver number; work center, department, and machine; and sequence number. Columns with additional data include:
 
Column
Button/Supporting Tab
ID
Work Order Lots
Item Number
Item Master
Order
Transaction Numbers
Item Number
Item Master
Tran Nbr
Operational GL Transactions
PC Cost Detail
Summarized Operation Transactions
Employee
Employees
Work Ctr
Work Centers
Department
Department Master

Operation Transaction (30.5.15.27)
Subcontract Receipts
Use Subcontract Receipts (30.5.15.28) to view subcontract receipt data, including the transaction number, effective date, transaction type, date, order, item number and description, site, location, location quantity change, transaction price, standard amount, Periodic Costing unit cost and amount, entity, address, shipper number, operation ID, and flag. The Flag field indicates when the RCT-PO transaction is for a subcontract PO and there is a related SUBCNT operation transaction in the operation history. Columns with additional data include:
 
Column
Button/Supporting Tab
Tran Nbr
Inv Operational GL Transactions
Transaction Type
Code Master
Order
Transaction Numbers
Item Number
Item Master
Site
Sites
Location
Location Master

Subcontract Receipts (30.5.15.28)
PC Cost Detail
Use PC Cost Detail (30.5.15.29) to view Periodic Costing details, including the transaction number and type, cost set and cost element, and level data. The report supports six transaction types:
Unit cost adjustment (PCCST-AD)
Total cost adjustment (PCTOT-AD)
WO component cost adjustment (PCWO-ADJ)
WO labor and burden cost adjustment (PCWOP-AD)
Unit cost calculation correction (PCCSTCOR)
Unit cost calculation details (PCCSTCAL)
For PCCST-AD, the two level-related columns indicate the current-level and lower-level cost after you make adjustments through PC Unit Cost Adjustment. For PCTOT-AD, PCWO-ADJ, and PCWOP-AD; the two level-related columns indicate the cost delta between the before and after adjustment after you run PC Total Cost Adjustment. For PCCSTCAL, the two level-related columns indicate the current-level and lower-level cost of the item-site. For PCCSTCOR, the two columns indicate the cost before a unit cost reset.
Columns with additional data include:
 
Column
Button/Supporting Tab
Transaction Type
Code Master

PC Cost Detail (30.5.15.29)