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

Applies to: Dynamics GPDynamics GP 2010Dynamics GP 2013

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 Z-US$ placeholder with the value in the FUNLCURR field in the MC40000 table. Replace the 1007 placeholder with the value in the FUNCRIDX field in the MC40000 table. To find these values, run the following statement against the company database.
    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.

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

    MORE INFORMATION


    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.