FormerMember

FRPOST Help

Posted By FormerMember

Hi All,

I am fairly new to using the Sage FR module and I have 2 quick questions regarding FRPOST.

1. I have been able to use =FRPOST("TRANSAMT","","(JRNLDATE = 20190909)") to retrieve the daily amounts no problem but on days where there is nothing posted to an account I get a #VALUE! error. I have tried using several variations on selection criteria but have not been able to get around this error. Is there a way to eliminate this error when generating the report (return a 0 instead)?

2. Is there a way to link the JRNLDATE to cell so that I don't have to manually change all the dates? I have tried using a basic cell reference but it did not work.

Thanks in advance.