Enhancements to MAS200 Effecting Reports

Let's see you have not:

1. Told us what tables you are using.
2. Why the report is not working or what is happening.
3. What you are trying to report on.
4. What the enhancement does.
5. What report you are trying to modify.

Sorry about that

The two tables on the report already are:

IM1_InventoryMasterFile
IM_OBReorderPointFile

The report needs a date range that works off InvoiceDate from the AR_OpenInvoice.InvoiceDate field. The report we are attempting to modify is UsageSummaryCustom.rpt report.
When adding the date range to this report using the InvoiceDate field the report goes blank; no data is displayed. So, as an experiment we tried adding a date range on the DateLastRecpt field of the IM1_InventoryMasterFile table. When trying this, the report runs as normal, however, the date range is ignored completely, and we get data that is outside the range that we specified when running the report. As to what the enhancement does We are still negotiating with the author of the enhancement to determine what the enhancement does.

Thanks In Advance
MeonR

"The beatings will continue until morale improves

I would guess its a linking problem between the data tables.

1. Was the AR file part of the original custom?
2. Why is the AR file important?

I doubt the MD is the problem.

As to what the enhancement does we are still negotiating with the author of the enhancement to determine what the enhancement does."

This is NOT a good thing. The master developer should be able to tell you right off what the enhancement does. Also based on what you have posted here and on the Sage Community it appears this report was designed by the master developer. You would need to get with them to determine how to best acheive your desired results.

Thanks for the help everybody!!! Actually, I have discovered that the problem with getting the info from the master developer is on our end. Some sort of political thing

"The beatings will continue until morale improves