You are not allowed to have negative Actual Quantity.
You are not allowed to have negative Actual Costs.
You are not allowed to have negative Actual Accrued Revenues.
You are not allowed to have negative Total Revenue for the Cost Category within the Budget.
You are not allowed return accrued revenues greater than the actual posted amount.
You are not allowed to return a quantity greater than the actual posted quantity.
You are not allowed to return costs greater than the actual posted amount.
These errors may be seen in the following cost transaction entry windows:
Employee Expense Entry
Equipment Log Entry
Inventory Transfer Entry
Returns from Project Entry
Returns Transaction Entry
It is the PA01301 (Project Budget Master) table that is examined to make this determination. These are the fields that are reviewed for each of the areas.
Quantity -- PAPostedQty and PAUnpostedQty
Cost -- PAPostedTotalCostN and PAUnpostedTotalCostN
Revenues -- PAPosted_Accr_RevN and PAUnpostAccrRevN
The system will add up the values in both fields and then compare that to what you are currently entering. For example, you posted a timesheet with a quantity of 8 hours (PAPostedQty = 8). You then entered a new timesheet for -2 hours to reverse part of the original and saved it in a batch (PAUnpostedQty = -2). You would be able to enter another transaction for -6 (8 + -2 + -6 = 0) but not for -7 since then with the 3 transactions you would have a -1 quantity on the project.
The same calculation applies to the Cost and Revenue fields.
Note Miscellaneous Log cost category types are the only ones that are allowed to go negative for actual posted Quantity, Cost, and Revenues.
You can also review the values in the table by running the following script.
SELECT PAUnpostedQty, PAPostedQty, PAUnpostedTotalCostN, PAPostedTotalCostN, PAUnpostAccrRevN, PAPosted_Accr_RevN, * FROM PA01301 WHERE PAPROJNUMBER = 'XXX' and PACOSTCATID = 'YYY'
Note XXX would be replaced by the Project Number.
Note YYY would be replaced by the Cost Category ID.
If your detail transactions do not support your summary values, run PA Reconcile on Cost Transactions for the customer on this project. To run PA Reconcile on the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to Project, and then click PA Reconcile.
If PA Reconcile does not correct the error, then verify there are no orphan, unposted transactions in the corresponding Work transaction table.
Employee Expenses: PA10501
Equipment Logs: PA10101
Purchase Materials: PA10901 and PA10702
If stranded records are found, remove them, and then run PA Reconcile again.
Posted cost transactions are stored in the following tables:
Employee Expenses: PA30501
Equipment Logs: PA30201
Purchase Materials: PA30901 and PA31102
Note If you are working with a purchase materials transaction, verify in the PA31102 that the ORD field is set correctly. If the receipt was from a purchase order (PApurordnum field is populated), then the ORD field should be populated with something other than 0. If no PO was involved, then the ORD field should be 0. If it is incorrect, update it, and then re-run PA Reconcile on Cost Transactions.
Article ID: 2549380 - Last Review: Mar 17, 2016 - Revision: 1