KB - Error message when you print the PA Transaction Adjustment Report in Project Accounting in Microsoft Dynamics GP: "Error in getting the Accounts" Content provided by Microsoft Applies to: Dynamics GPDynamics GP 2010Dynamics GP 2013Microsoft Dynamics GP 2015Dynamics GP 2016Dynamics GP 2018 More Select Product Version All Products 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 1This 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 2The problem may occur if any of the posting accounts are marked as Inactive . See Resolution 2 in the "Resolution" section. RESOLUTION Resolution 1To 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 PA305014. 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 MC400006. Click Execute. -------------------------------------------------Resolution 2To 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. Last Updated: 26/02/2020 Was this information helpful? Yes No Tell us what we can do to improve the article Submit Thanks! Your feedback will help us improve the support experience.