Three colunns in one file match and update formula

[Thiviya]

HI,

From the date source I have to match followings :

Column : Journal date - end of the month and beginning of the month

Column : Reversal : Created by reversal Process, Beginning of Next Period

Column : Journal ID : Matches to above two 

Amount : One amount is debit and the other is credit 

OUtcome : "Contra" as tax comments.

[Qiu]

@Thiviya 

Column : Journal date - end of the month and beginning of the month --> We can use DateTimeTrim function

Column : Reversal : Created by reversal Process, Beginning of Next Period --> Filter

Amount : One amount is debit and the other is credit  --> Not about this cretiria 😁

[Thiviya]

Hi, I have updated the first month and last month etc. I am also trying to get the "Journal line amount" positive amount relates to beginning of the month and negative amount relates to "created by reversal" include the comment in the "Tax Treatment" column as Contra

Can you please provide me some guidance how to update this .

Thanks

Regards

Thiviya