Hi,
Further digging into this issue we have found discrepancies between Financial Reporting and the Sales Analysis details, so there are more issues than just the set paid indicator.

When we looked into balancing and correcting some of the invoices dates with Gridview R/W, it also appears that the date of the invoice being posted in Sale Analysis is being updated with the date of the credit note after a credit note is posted against the Sales Invoice.

The consequence of this transaction posting is that we are now able to explain why there are situations when Sales Analysis details in Gridviews or plain Adagio Sales Analysis Reports do not match to the Financial Reporting in the GL for comparable fiscal dates. Or reported details using "static" data in the Sales Analysis change from reported period to the same reported period by simply running reports at different subsequent dates.

We are seeing situations where an invoice is dated and posted in April as per AR, with a Credit Note dated May, updates the Sales Analysis original invoice date (April) with the May date of the credit note. We didn't spend the time to determine where or what causes this anomaly or whether the set paid indicator is run on the data set has an impact but the invoice date on the client's data was viewed and now shows the credit note date instead of the original invoice date. And so it now looks like the sales transaction was actually transacted in May instead of April that matches to the source documents.

So if you are attempting to balance the financial reporting of sales in the GL to the sales analysis data for the same date range, you may find that the numbers simply do not match because credit notes being credited in subsequent periods will change the date on the original posted invoices in Sales Analysis.

This needs to be corrected.

Brian