Hi all,
I am looking at the SuiteAnalytics - SuiteSucces Incoming/Outgoing Future Cash Outlay report and I am trying to reconcile this with the AP / AR aging. What I see is that standard, the Bill Credits (AP) and the Credit Memo's are not included in the dataset. I have seen the criteria in the dataset and they should be included, but regardless of the criteria set, the Bill Credits and CM's are not popping up in the dataset. Therefore I can't reconcile AP and AR and the SuiteAnalytics report is not correct.
I have made a new dataset with Main line = True and Transaction Type = Bill Credit/Credit memo, and the result is that the field "Amount Unpaid (Transaction Currency) (not consolidated) is always EMPTY, so I believe that therefore it doesn't come up in the dataset.
But this is a suitesuccess dataset, I assume this is what Netsuite standard is giving us in this dataset from their bundle.
Why does it seem that this criteria is not correct, and therefore the CM/Bill Credits are therefore not showing up?
Kind regards,
Norman