AP Vendor Maintenance Invoice only showing Invoices for this year

Question

Hello I am running MAS 200 Version 4.40.0.6. 
 Today I was notified that in AP Vendor Maintenance Invoice tab as well as Transactions tab we can only see Invoices for this year 2016, for all Vendors, even if they have many more invoices from other years. 
 I checked AP Options and these are the current settings that we have that I think might be relevant to this issue: Fiscal Year 2016, Period 10, Days to keep Paid Invoices 120 (I changed this to 365 in test company and it made no difference but I'm imagining its not retroactive), Years to Retain Vendor History 10, Years to Retain 1099 Payment History 10. 
 I checked in the AP Vendor Maint\Invoice tab for any button or drop down setting I could change but there isn't any. 
 We would just like all Invoices for all years to show in this tab as well as in the Transactions tab. It currently shows all years in AR Customer Maint\Invoice tab and Transactions tab and this is what we want AP to look like. I also checked to make sure that we actually have all the data for past years for AP and we do because when viewing AP Vendor History Invoices in Business Insights Explorer we can see all invoices for all Vendors. So the data is there. We just need it to show up in the AP Vendor Maint\ Invoice tab. 
 Any help will be greatly appreciated. Thanks

TomTarget · Accepted Answer

I've been working with Sage 100/MAS 90 for over 30 years and to the best of my knowledge it has always worked that way. The longest time frame (without a custom mod) for keeping the items showing on the invoice tab has been 999 days (as set in the a/p options). Before explorer, the only way you would see it was to print the invoice history reports.

The invoices that appear on the invoice tab are contained in the A/P Open Invoice file. After the retention date they move to a history file and no long show on the invoice tab. I think this is done so as to make the system more responsive. The more data, the slower it can end up being.

That being said, I've had some clients cheat the system by not doing period end processing so it then appears that they are being retained for a long period of time. Maybe this is what happened in your case. No period end processing for a long time and then someone finally did it?

And to be perfectly honest the explore option can be much easier/efficient to use. In my opinion anyway.

Sage 100

AP Vendor Maintenance Invoice only showing Invoices for this year

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING