Skip to Content

Dr/Cr Sign-triggered Reclassification

We are trying to create a conditional reclassification with the trigger of 4 items:

State Tax Receivable, State Tax Payable, Federal Tax Receivable and Federal Tax Payable

The condition is if the net cumulative balance is >= 0.

Then the goal is to reclassify target separately for State Tax Receivable and State Tax Payable to State Tax Receivable and for Federal Tax Receivable and Federal Tax Payable to Federal Tax Receivable.

The next condition is simply the opposite for when balance is <0.

It is not difficult to reclassify all items to an individual item, but we are struggling to find a way to have a separate the target for two State items and two Federal items when the condition is met.

Any suggestions regarding this are greatly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 23, 2010 at 11:43 AM

    Dan

    I would have thought you could create 2 reclass methods (2 tasks), each with 2 steps.

    You need to assign Source within the method layout, so you can define what gets posted to where.

    For reclass 1, you set the trigger as the 4 items, and the condition as the 4 items >0.

    Step 1 move State Payable to State Receivable

    Step 2 move Federal Payable to Federal Receivable

    For reclass 2, you set the trigger as the 4 items, and the condition as the 4 items <0.

    Step 1 move State Receivable to State Payable

    Step 2 move Federal Receivable to Federal Payable

    It seems the condition is at the header level, so this cannot be done within a single reclass.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2010 at 05:41 AM

    Dear Forum,

    We are working on a Direct cashflow and I am currently finding it difficult to get ONLY the debit transactions for a specific account (Royalties & Excise). A statistical cashflow item has been created for this account but when i execute the report, the total movements for the account comes through although we only want the debits. The Debit sign has been maintained for the CF item.

    Any guidance provided is appreciated.

    Add comment
    10|10000 characters needed characters exceeded