How Do I Update an Account that Reports as a Negative But Has a Debit Balance in GP (or Visa Versa)? Article

How Do I Update an Account that Reports as a Negative But Has a Debit Balance in GP (or Visa Versa)? Article

When reporting in Dynamic Budgets it is expected that accounts with debit balances in Great Plains Accounting Software (ERP) will report as positive balances in Dynamic Budgets, and that accounts with credit balances in the ERP will reports as negative balances in Dynamic Budgets.


When you observe that an account reports as a negative balance in Dynamic Budgets but has a debit balance in the ERP (or visa versa) to update the direction of the balance in Dynamic Budgets:

  1. Navigate to the "Synchronize" screen and select the "Company DB" you wish to update;
  2. Click "Sync Review";
  3. Click "Update Account Attributes Only",  and then
  4. Rerun your report to see if the issue has been resolved.



If the account is still displaying incorrectly, please review the Account setup in the ERP:

  1. In the ERP/Account Maintenance, please check to see if the Typical Balance is set to DR or CR.  If it needs to be changed , please do so. 
  2. Then repeat steps 1. - 4. above.


Related Article:

Account Debit or Credit Setup (Typical Balance)?

    • Related Articles

    • Update Acct Attributes - MultiCo Article

      When Account Attributes are updated in the ERP these changes need to be captured in Dynamic Budgets as well. To update the Account Attributes in Dynamic Budgets for multiple companies: 1. Using Right and Left Pointing Arrows to Select/Deselect the ...

    • Account-Debit or Credit Setup (Typical Balance)? Article

      To review the Typical Balance (debit or credit) for an account go to the Export Budget to GP screen: 1) Select the CompanyDB and BudgetID you wish to review; and 2) Click on Search. 3) All accounts will display including the nature of the Typical ...

    • Synchronize Chart of Accounts Article

      Standard functionality includes Print, Export to Excel, Print to PDF, and  Auto-size Columns. When the system is first setup Great Plains Accounting ("ERP") software General Ledger ("GL")  Account Numbers are imported into Dynamic Budgets using  the ...

    • Manage Master Chart of Accounts Article

      Standard functionality is Print, Export to Excel, Print to PDF, Auto-fit Columns, Expand/Reduce Column Width, Filter, Column Data Sort-Ascending/Descending, and Copy and Paste. The Right-Click and Short-Cut Keys are: When a new General Ledger ("GL") ...

    • Custom Reports Article

         Tutorial Link Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. The report is structured to the user's needs. Reports with a customized Column Format as defined in Define Custom ...