Dr/Cr Sign-triggered Reclassification

[dan_sullivan]

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.

[Former Member · Accepted solution]

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

[dan_sullivan · Accepted solution]

Thanks for the suggestion, but the trigger and condition always includes all 4 items and thus the source and target values are determined by the sum (net) values of all and we do not know how to separate the 2 state items and 2 Federal items from this.

Any further details on how to do this are greatly appreciated.

[Former Member · Accepted solution]

Dan

I think you can specify the FS Item trigger at step level, by individual FS Item, with the condition at header level with all 4 items.

Reclass 1

Step 1

Trigger - State Payable

Condition - All >=0

Source - State Payable

Target - State Receivable

Step 2

Trigger - Fed Payable

Condition - All >=0

Source - Fed Payable

Target - Fed Receivable

A second reclass for the other side.

Regards

[dan_sullivan · Accepted solution]

Marsy B,

Thanks!

I've never had to do such a reclassification like this.

Dan

[Former Member]

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.

[Former Member]

Please open a new thread. This one is solved already.