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 ...

    • 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 ...

    • Export Budget to GP Article

          Tutorial Link Note: For recovery purposes, Dynamic Budgets maintains an audit trail of all export sessions.  A snapshot of the before state of the records in Great Plains is captured as well as the batch of account records transmitted during the ...

    • Account Number (Budget Account Number) Article

      An Account Number refers to the full General Ledger Account Number  ("GL Accounts") which originates from Great Plains Accounting Software ("ERP").  Account Numbers cannot be created in Dynamic Budgets. This is by design and acts as a control such ...