Fixed Asset reconciliaton workflow

Question

HI,

In the section 4 attached the screenshot where filtered the primary row to bring one row per asset id.

The one in F related to tax asset id which has two different categories compared to accounting.

These two transactions are required for tax to finalise the tax WDV etc, how can I ensure the accounting side is blank instead of repeating the same details are existing on the asset.

Can I add something prior to filtering the primary row to make sure these two lines also populated but blank on accounting side.

Thanks

Fixed Asset reconciliation.yxzp

Screenshot 2026-03-25 143411.png

OTrieger · Accepted Answer

@Thiviya 
Yes, you can set cells to be blank with Formula tool. You can write it as a condition with IF arguments defining what should stay and what should be blank, you can blank the whole field, it is really depends on what you need.

jrlindem · Accepted Answer

If you need to blank out all the fields you can use the Multi-Field Formula Tool (see illustration below).  Otherwise, @OTrieger's approach accomplishes the same but for selective fields.

If you need to integrate the blanked out row back to your workflow, a Union Tool will do the trick (as I'm sure you're aware).

Hope this helps, -Jay