Error message when you try to submit a timesheet in Project Time and Expense in Business Portal: "Microsoft.Dynamics.Pma.PmaEntity.CostCategory"

Resolution 1

To resolve this problem, grant access to the Audit database. To do this, follow these steps:

1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Microsoft SQL Server Management Studio.
2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the instance of Microsoft SQL Server on which the Audit database is stored.
   
3. Expand Security, and then click Logins.
4. Right-click the Business Portal user, and then click Properties.
   
5. Click the Database Access tab, and then click the Audit database.
6. Click to select the Permit check box for the Audit database.
7. In the Permit in Database Role list, click to select the DYNGRP check box.
8. Click OK, and then exit Enterprise Manager.

Resolution 2

To resolve this problem, create a new timesheet template. This will overwrite the existing one. To do this, follow these steps: 

1. In Business Portal, click Employee, click Project Time, and then click New.
2. Create a new timesheet, and then click Save as template.
3. When you are prompted to replace the existing template, click OK.

If you are unable to recreate a new template so that the existing one is overridden, then use SQL to delete the existing template from the PDK00300 and PDK00301 for the affected employee ID.

Resolution 3

To resolve this problem, contact technical support for Microsoft Dynamics and related products. A support professional may be able to help you delete damaged or duplicate records in the PDK10000 table and in the PDK10001 table. For information about technical support for Microsoft Dynamics and related products, visit the following Microsoft Web site:

http://www.microsoft.com/dynamics/support/default.mspx

Resolution 4

Even though you may be using Canadian Payroll, the Position (and Department) fields on the US employee card need to be populated. To resolve this problem, add the Position field on the employee card. To do this, follow these steps:

1. In Microsoft Dynamics GP, click Cards, point to Payroll, and then click Employee.
2. Enter the employee ID for which you receive the error message.
3. Enter a valid position in the Position field.
4. Click the Save button.

Resolution 5

By default there are not any triggers on the PDK10000 PDK10001, PDK10500 and PDK10501 tables. Run this script (replacing the table name) in Microsoft SQL Server Management Studio to see if a trigger exists on the table. This trigger may need to be removed.

sp_helptrigger PDK10000

If a trigger exists, use this script to remove it and then try your Business Portal document again. In this example the name of the trigger is PDK10000Update.

ALTER TABLE PDK10000 DISABLE TRIGGER PDK10000Update

Resolution 6

Using Microsoft SQL Server Management Studio, run this script against your company database to determine if there are billing notes assigned to the document that do not exist in the PDK billing note master table.

select * from PDK10001 where PDK_Billing_Note_ID not in (select PDK_Billing_Note_ID from PDK01601) and PDK_Billing_Note_ID <> ''

Then to see if there are notes that exist in the Billing Notes Master table that are not on a document, run this script.

select * from PDK01601 where PDK_Billing_Note_ID not in (select PDK_Billing_Note_ID from PDK10001) and PDK_Billing_Note_ID not in (select PDK_Billing_Note_ID from PDK10501)

If either of these scripts return results, the record will likely need to be removed from the table using a SQL delete statement. Contact Technical Support for further assistance if needed.

Resolution 7

Review the timesheet documents in the PDK10000 table to see if the document number currently being used now, has been used before. The previous timesheet may need to be removed from the PDK10000 and PDK10001 tables before this new transaction can be entered if the existing reporting period setup needs to be used. The other option would be to reset the reporting period information back to what it was previously and then create a new timesheet.

Additional troubleshooting -

1. Run the following script in Microsoft SQL Server Management Studio to see if there are any cost categories on the timesheet that have a status other than Open or Completed. You cannot enter transactions for cost categories in an Estimate, Closed or On Hold status.

select a.PDK_TS_No, a.PAPROJNUMBER, a.PACOSTCATID from PDK10001 a
join PA01301 b
on
a.PAPROJNUMBER = b.PAPROJNUMBER
and a.PACOSTCATID = b.PACOSTCATID
where b.PASTAT not in (1, 5)

2. Run the following script in Microsoft SQL Server Management Studio to see if there are any projects on the timesheet that have a status other than Open or Completed. You cannot enter transactions for projects in an Estimate, Closed or On Hold status.

select a.PDK_TS_No, a.PAPROJNUMBER from PDK10001 a
join PA01201 b 
on
a.PAPROJNUMBER = b.PAPROJNUMBER
where b.PASTAT not in (1, 5)

3. Verify the value in the total quantities field (PDK_Total_Quantity) in the header (PDK10000) table match the sum of the lines quantity (PDK_Quantity) in the line table (PDK10001) for the timesheet. If they do not match, the timesheet is damaged and will need to be removed from the table using SQL. Contact Technical Support for further assistance if needed.