You experience one of the following errors when you enter a negative quantity on a cost transaction or enter a return in an attempt to reduce the cost on your project.
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
When you enter a negative cost transaction or a return transaction in Project Accounting the system will look back to what has previously been posted against that project and cost category to determine if the transaction you are entering now will bring the posted amount below zero. It does this in 3 areas: Quantity, Cost, and Revenues and will only let you complete entry of the transaction if all 3 values will result in 0 or more on the project.
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.
To review the values considered, access the project and cost category in the Budget Detail Entry window. To access the Budget Detail Entry window on the Cards menu, point to Project, and then click Project. Enter your Project Number and click Budget. Highlight the cost category and click the expansion arrow on Cost Category ID field. Review what is displayed for Qty and Total Cost in the Actual row. To review the detail behind those summary values, click Actual to drill back to the associated cost transaction inquiry window.
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.
If the PA01301 is not reflecting the actual posted quantity, cost or revenue when you compare to the detail and PA Reconcile is not correcting it, then there is likely something incorrect or damaged with the posted cost transaction(s). Review the cost transaction for abnormalities and consider removing history and reentering the transaction.
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.