web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Recurring JE - can it be setup to include lines with no amount

(0) ShareShare
ReportReport
Posted on by 10

I have a Recurring journal entry setup that will result in numerous lines that need to be zero each time it will be posted. (JE is to record quarterly activity of a balance sheet and income statement for a subsidiary.  Different accounts won't change month to month, but I really don't want to insert new lines each time.)

I am struggling with posting the JE.  The batch was filtered by amount and those lines have been approved.  The lines with no amount (or zero) still have a status of new, as I don't really want to post zero values.  Upon filtering the JE by amount or status to post the recurring JE, it won't post.  It tells me "There are transaction which have not been approved" and says "there is nothing to post."  I swear I have posted this same entry before. 

Is it possible to filter out lines of a recurring JE and post only those you want, via status, amount or posting date?

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    11,471 on at

    If the Recurring Method is "V Variable", the "Amount" will be reset each time you post the transaction.

    I tried to post applying a filter on the "Document No." and it posted only that transaction.

  • chmallory Profile Picture
    10 on at

    The recurring method is variable.  These are filter options that I have used unsuccessfully...

    Amount<>0  

    Status = Approved

    Date...I changed all of the dates for lines with no data for the quarter, then filtered

    Document No.....I changed the document # for all lines with no data for the quarter, filter

    Is there possibly a system setting that would prevent G/L postings that utilize filters?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans