KB - Error message when you print the PA Transaction Adjustment Report in Project Accounting in Microsoft Dynamics GP: "Error in getting the Accounts"

After you enter an adjustment transaction for an employee expense in Project Accounting in Microsoft Dynamics GP, you receive the following error message when you print the PA Transaction Adjustment Report:

Error in getting the Accounts.

This problem occurs if you are not registered for Multicurrency Management in Microsoft Dynamics GP.

Note This error message may also occur for the following transaction types:

• Employee Expenses
• Timesheets
• Equipment Logs
• Miscellaneous Logs

Cause 1

This problem may occur if the CURNCYID field is blank in the PA30500 table. This problem may also occur if the CURRNIDX field is blank in the PA30500 table or in the PA30501 table. See Resolution 1 in the "Resolution" section.

Cause 2

Resolution 1

To update the CURNCYID field with the correct value, follow these steps:

1. Click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .

2. In the database list, select the company database where you receive the error message.

3. Type the following statements in the Query window.

select CURNCYID, CURRNIDX,* from PA30500 

select CURRNIDX,* from PA30501

4. Click Execute.

5. If the fields are blank for the transactions that you are trying to post, type the following statements to update the fields with the correct, functional Currency ID and Currency Index values.

update PA30500 set CURNCYID = 'Z-US$' 

update PA30500 set CURRNIDX = '1007'

update PA30501 set CURRNIDX = '1007' 

select * from MC40000

6.  Click Execute.

 

-------------------------------------------------

Resolution 2

To make a posting account active, follow these steps:

1. On the Cards menu, post to Financial , and then click Accounts .

2. Click to clear the Inactive check box.

3. Click Save.

-------------------------------------------------

If you receive this error message for a transaction type other than an adjustment transaction type, follow the steps that are listed in the "Resolution" section. However, in steps 3 and 5, replace table PA30500 and table PA30501 with the following tables:

• Timesheet transaction types
Replace the PA30500 table with the PA30100 table. Replace the PA30501 table with the PA30101 table.
• Equipment Log transaction types
Replace the PA30500 table with the PA30200 table. Replace the PA30501 table with the PA30201 table.
• Miscellaneous Log transaction types
Replace the PA30500 table with the PA30300 table. Replace the PA30501 table with the PA30301 table.