Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Dynamics Budget import

Posted on by 5

Hi

Has anyone had the issue of importing a budget into Business Dynamics but then had the challenge of some G/L codes then doubling up when you run the P&L?

Any thoughts appreciated.

Thanks

David

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Dynamics Budget import

    Very often when I have seen this it has been because I have imported budget numbers both with and without dimensions.

    You can drilldown all the budget entries for one account and check the details that sums up the total budget for a specific G/L account. That might help you reconcile the budget.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Dynamics Budget import

    hi

    one possible reason for the doubling up of G/L codes when running the P&L report after importing a budget in Business Central could be due to the presence of duplicate or overlapping entries in the imported budget.

    To troubleshoot this issue, you can try the following steps:

    Check the imported budget: Verify that there are no duplicate or overlapping entries in the imported budget. This can happen if the same G/L account or department is included multiple times with different amounts or periods. If you find any duplicates, remove them from the budget.

    Verify the G/L account setup: Check that the G/L accounts are set up correctly with the appropriate account types, subcategories, and dimensions. Any duplicate or incorrect setup can affect the P&L report.

    Check the P&L report setup: Verify that the P&L report is set up correctly with the appropriate filters, date ranges, and dimension values. Any incorrect setup can affect the accuracy of the report.

    Re-import the budget: If the issue persists after verifying the budget, G/L account setup, and P&L report setup, try re-importing the budget with corrected entries.

    Consult with a Dynamics Business Central expert: If the issue persists after trying the above steps, it may be necessary to consult with a Dynamics Business Central expert who can analyze the system setup and data to identify the root cause of the issue and provide a solution.

    In summary, the doubling up of G/L codes in the P&L report after importing a budget in Business Central could be due to duplicate or overlapping entries in the budget, incorrect G/L account setup, incorrect P&L report setup, or other factors.

    DAniele

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans