Problems occur when you approve a document in Project Time and Expense if Automatic Processing is enabled in Microsoft Dynamics GP


Symptoms


When you approve a timesheet or an employee expense in Project Time and Expense in Microsoft Dynamics GP 10.0, in Microsoft Dynamics GP 9.0, or in Microsoft Business Solutions – Great Plains 8.0, you may receive one of the following error messages or the following unexpected behavior may occur. These problems occur if Automatic Processing is enabled.

Error messages

  • You receive the following error message when the pay rate has 4 decimal places. See Resolution 1 or Resolution 2.
    Processing failed for XYZ-TS-MMDDYY-X : Unit cost for this pay code do not match - unit cost cannot be changed.
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.
  • You receive the following error message when the profit in the rate table has changed since the time that the timesheet was entered. See Resolution 1 or Resolution 2.
    Total Accrued Revenue does not match sum of lines.
  • You receive the following error message when the total cost of the employee expense is rounded to two decimals. See Resolution 1 or Resolution 2.
    Processing failed for XYZ-EE-MMDDYY-X
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.
  • You receive the following error message when the vendor record does not have a value in the Address ID field in the Primary Address area of the Vendor Maintenance window. See Resolution 1, Resolution 2, or Resolution 3.
    Processing failed for XYZ-EE-MMDDYY-X: Input variable contains an empty value.
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.
  • You receive the following error message when the currency that is specified in the Billing Currency ID field for the project is not the functional currency. See Resolution 1 or Resolution 2.
    Processing failed for XYZ-TS-MMDDYY-X : Total Accrued revenue does not match sum of detail lines.
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.
  • You receive the following error message when the status of the budget is set to Completed. See Resolution 1, Resolution 2, or Resolution 4.
    Processing failed for XYZ-TS-date-1 : Budget status is invalid - budget status needs to be open.
    Note XYZ is the placeholder for the employee, and date is the placeholder for the date.

  • You receive the following error message when the employee expense transaction is for a negative quantity. See Resolution 1 or Resolution 2.
    Processing failed for XYZ-EE-MMDDYY-X: Input variable contains a negative value
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.
  • You receive the following error message when the Timesheet transaction is for a negative quantity. See Resolution 1 or Resolution 2.
    Processing failed for XYZ-EE-MMDDYY-X: Input variable (PATACRV) contains a negative value
    Note XYZ is the placeholder for the employee, MMDDYY is the placeholder for the date, and X is the placeholder for the sequence number.

Unexpected behavior

  • The employee expense document posts to the Payables Management module even if the Post to Payables Management check box is cleared in the Employee Expense Setup window. See Resolution 1 or Resolution 2.
  • Billing notes are not sent to Project Accounting together with the employee expense transaction. See Resolution 1 or Resolution 2.
  • The Timesheet Detail Work table (PA10001) contains records that do not have an associated header record in the Timesheet Header Work (PA10000) table. This problem occurs if you received an error message on one, but not all, of the lines of the timesheet when you approved the timesheet. See Resolution 1 or Resolution 2.

Resolution


Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

Resolution 1

Approve the document by using Personal Data Keeper (PDK).

Resolution 2

Turn off automatic processing for timesheets or for employee expenses. To do this, follow these steps.

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure. However, they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

  1. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

    Method 1: For SQL Server Desktop Engine

    If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    Method 2: For SQL Server 2000

    If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    Method 3: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
  2. Run the following statements against the company database:
    Update PmaTimesheetConfig set AutomaticProcessing =0
    Update PmaExpenseReportConfig set AutomaticProcessing =0 
  3. Approve the document in Project Time and Expense.
  4. Process the document to Project Accounting by using PDK.

Resolution 3

Enter an address for the vendor. To do this, follow these steps:
  1. On the Cards menu, point to Purchasing, and then click Vendor to access the vendor record for this employee.
  2. In the Primary Address field, type the address in the Address ID box.
  3. Save the vendor.

Resolution 4

Change the status of the budget to Open, and then leave the status of the project as Completed. To do this, follow these steps:
  1. On the Cards menu, point to Project, and then click Project.
  2. Type the project number, and then click Budget.
  3. In the Budget Maintenance window, click Open in the Status list.
  4. Click OK, and then save the project.