I want a report that shows:
date received po# vendor item quantity price
I'm just using the report writer in "Store Operations Manager" version 2.0
I don't have access to the source code or a version of sql to which I can write directly.
report on receipts in a period
Apr 25, 2008
10 Replies
hi, send me your email then I will forward you lot of reports. Akber
"cynthia" wrote:
Cynthia - if you're familiar with TSQL you can run some select queries against your database - start Store Ops Administrator - Query - New....
Run sp_tables to get an overview of tables and views in your database; for receiving purposes, you'll query the purchaseorder and purchaseorderentry tables, but I think you will find the viewitemmovementhistory a useful table to track partial receivers if that applies to your business.
Hope this helps.....
"cynthia" wrote:
snipped-for-privacy@hotmail.com
thanks
"Akber Alwani" wrote:
Akber,
Can you send me these reports too? snipped-for-privacy@hugginsgrenada.com
Thanks in advance... Don
Hello Akber,
We are just starting RMS and would appreciate any reports that you can send us.
Thanks for your help.
Michael
"Akber Alwani" wrote:
This is Michael again. Sorry Akber, i just asked you to send me the reports assuming that you would just have to click on reply but I see that everyone else adds their email address to their threads, so
Please send me your reports to snipped-for-privacy@hotmail.com
Again, Thanks Michael
"Akber Alwani" wrote:
Helloooooooo Adber, can you send all those reports tooo. thanks
jay snipped-for-privacy@gmail.com
"Akber Alwani" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required