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

(0) Share

Report

Posted on by chmallory

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

All responses (2)

Answers (0)

chmallory 10 on at

Like (0)

Report

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

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?
mmv 11,467 on at

Like (0)

Report

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

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.