1. Home
  2. Point-Of-Sale Software
  3. Item History Report

Item History Report

I have modified the item movement history report to get an essential output for my client, who's main concern when purchasing is on the history of the item (needs to know when, who, quantitiy, and multi currency + exchange rate at time).

The reason i modded the Item movement history report is because it is easy accessible from the purchase order (although he has to double click on the item to bring up the item form and then click on the report button, which brings up the default filer for the itemlookup code in question).

The only issue with this report is that it brings up a filter of > 1/12/05, which needs to be removed every time the report is run.

Further to this, does anyone know how the report filters operate in RMS, and secondly, is there any way to set parameters of report based on form values (for example item lookup code like in the item movement history report).

Sorry for the long post, but my reseller has been impossible to answer these qs and i really cannot believe it is impossible.

Thanks in advance......

Reply to
Andrew Murphy
Loading thread data ...

Andrew,

Open your report and look in the //-- Filters --// section.

For your FilterLoLim, you didn't say what you wanted to change it to, but try "" instead of the date and then change FilterHiLim to "". This will run the report with Month to date info. If you don't want any dates in there, just change both to "" (that's 2 double quotation marks without a space). If you need some other filter type, ask here or I think they are available on CustomerSource.

I'm still sleepy and can't figure out what you are asking in the second part of your question. Please re-phrase.

Reply to
Jeff

Many thanks for your post. To clarify 2nd part of my request - do you know when you run the item movement hisory report, it brings up the default filter = itemlookup code of the item you were on.

Is there any way of passing information into rms reports like you can with MS access for example?

Reply to
Andrew Murphy

Andrew,

To run that report from the Report button in Properties, RMS creates a View in memory and passes the memory variables to the report. Look at the Items - Item Movement History.qrp. The report looks to see if there is a View in memory and if so uses that memorized Viewed item. Look at the PreQuery1 and PreQuery2 statements. If the view exists, use it, otherwise create a new one.

Don't know anything about MS Access. A FoxPro dabbler here.

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.