report on receipts in a period

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.

Reply to
cynthia
Loading thread data ...

hi, send me your email then I will forward you lot of reports. Akber

"cynthia" wrote:

Reply to
Akber Alwani

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:

Reply to
convoluted

Reply to
hozay

snipped-for-privacy@hotmail.com

thanks

"Akber Alwani" wrote:

Reply to
cynthia

Reply to
cynthia

Akber,

Can you send me these reports too? snipped-for-privacy@hugginsgrenada.com

Thanks in advance... Don

Reply to
donphillip

Reply to
pjdecara

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:

Reply to
MPSpyder

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:

Reply to
MPSpyder

Helloooooooo Adber, can you send all those reports tooo. thanks

jay snipped-for-privacy@gmail.com

"Akber Alwani" wrote:

Reply to
manoj

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.