Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Using Recurring Genera...
Microsoft Dynamics NAV (Archived)

Using Recurring General Journal with Allocations

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have created a Recurring General Journal to pay approx. 60 individuals each month. I will take an excel spreadsheet and copy and paste entries into Nav.  I am using Recurring Method "Fixed" and the Document No.

uses a %4 to roll over  to next month after posting. What is causing me a lot of work is the Allocated Amt.

In order for these payments to go to the correct "Centers", I have to open up each entry Allocation and fill in the G/L, Allocation % and Center Code. Is there another way? Yes, I can copy and paste each entry but it would be much easier if all the entries could be posted at once. Maybe there is another way altogether that would work better. Thanks for all comments.

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Using Recurring General Journal with Allocations

    You can still try with standard functionality by cleaning the filters from the page where you assign the allocations. By default, it is filtered by the line no. from which you pressed the Allocations button. However, you can clean this filter and see all the allocations for all lines of this journal:

    5488.journal.png

    Perhaps, you will manage to achieve something in this direction.

    (By default, this page does not have filters visible and you need to add them from the main menu of the settings of this page).

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Using Recurring General Journal with Allocations

    The best solution for your scenario would be ask your development team/partner to develop an xmlport where you can have columns for general journal and the 4 columns for allocation, so in single import developer can handle to create entries in recurring general journal and in allocation.

    or other solution would be use rapid start services to import allocations assuming then entries go in the same order as general journal and the line no. will start from 10000, so you need to make sure all the entries in that batch are deleted before you copy the gen. journal.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans