Sage 100

Customer just upgraded to v2014. She is trying to print an AR statement for a customer but it is not showing all invoices. I even created a new statement which is the attached image. Note the totals don't agree at the bottom. @Sage100UrgentSupportNeeded

Does anyone know the logic for feeding the open invoices to the statement workfile? This one has me stumped.....

Is this controlled by the PVX code based on the prompts on the selection panel?

Well, yes but this customer has many more invoices which are not appearing on the statement. If you look in the lower right-hand corner, the invoices listed should total over 1.1 million but only come to 200k. What is keeping them from appearing on the statement? It looks like it is only showing invoices posted since the upgrade but statements are correct for other customers with invoices open prior to the upgrade.

Look at the temp work file created. See if it is a crystal issue or Pvx

Good thought @JimWoodhead but the worktable only has what appears on the statement so it is something with the programming. Aging is correct so why wouldn't some invoices appear on the statement? I've tried several different selections like including zero balance invoices. Again, only those after the upgrade appear. And as far as we know, this is the only customer affected.

Huh, rebuilt the AR_OpenInvoice and AR_TransactionPaymentHistory files then rebuilt sorts, recalculating aging in Customer Masterfile and NOW they all appear. As I said before, the Aged Invoice report worked before doing that so I was thinking that couldn't be it. So much for my logic.

Good news is always good to hear.... Very weird, so very sage...