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

SYMPTOMS

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

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

The problem may occur if any of the posting accounts are marked as Inactive . See Resolution 2 in the "Resolution" section.

RESOLUTION

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' 

Note Replace the

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×