Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Balance Recurring entry
Microsoft Dynamics NAV (Archived)

Balance Recurring entry

(0) ShareShare
ReportReport
Posted on by Sanaullah Nawfal 15

I have a specific need of creating a recurring journal where i need to pass a sales incentive provision every month based on a certain percentage of sales GL account.   Which means recurring journal should read the balance of the specified account and apply percentage (say 2%) and make a journal entry in GL with an amount of 2% of sales by debiting expense account in PNL and crediting accrual account in balance sheet.  Is there anyone using any straight forward solution or any work around solution.  Kindly let me know.   

*This post is locked for comments

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Balance Recurring entry

    Then you should utilize Excel. Again, you could create either COA filtered view or analysis view that allows to copy-paste the information to Excel, where you'd have the template that formats data to required format, which you can copy-paste back to NAV journal.

    There isn't any other workaround, unless you go with bespoke development.

    Robertas

  • Sanaullah Nawfal Profile Picture
    Sanaullah Nawfal 15 on at
    RE: Balance Recurring entry

    Dear Robertas

    Many thanks for the help.  However, my company has 52 outlets (52 locations in nav) and i cannot afford to copy paste 52 times this entry.  Also there are many such journal entries of provisions need to be passed based on Sales account balance of MTD.  Still i look for some workable solution.  Hope you or someone else will be able to produce a workaround.  Regards   Nadeem

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Balance Recurring entry

    Hi Sanaullah,

    I would create a filtered view on Chart of Account. My filters would be for G/L Account, and a 'limit totals' for the month in question. This will give you the base value. You might want to save the view for next time.

    in recurring general journals, create the template for expense account and accrual account (using recurring journals means the template will be saved, and all you need to do is put values each month).

    Copy the base value from the view, go to recurring journal, paste the value and multiply by 0.02. Post the journal. The template will be saved, and if you choose the Recurring Method as Variable, system will save the template without values, so next time you need to put new values in.

    Hope that helps.

    Robertas

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans