Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 127
	Members: 0
	Total: 127

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Report showing qty ordered vs quantity shipped??

5 Replies

1 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

Den

Advanced Member Send Private Message

Posts: 38

3/12/2020 1:47 PM

Good Morning Everyone! I hope this is a simple question...

I am looking for a report that shows requisitions within a time frame, requesting location and name, item and the quantitiy requested and the quantity shipped. I can see this information on RQ44.2, but I don't know how to get the data out of Lawson. Is there a report that can pull this information from RQ44.2, and export to excel so I can build my reports.

Thank you all!

Den

David Williams

Veteran Member Send Private Message

Posts: 1127

3/12/2020 1:56 PM

Try the RQ240 report. Once run, you should be able to push out a CSV version that you can open in Excel.

Den

Advanced Member Send Private Message

Posts: 38

3/12/2020 2:05 PM

This is a good idea, but RQ240 shows a summary of the requesting location. I need a report that shows individual lines on requisitions, similar to IC220's excel output.

I appreciate the help!

David Williams

Veteran Member Send Private Message

Posts: 1127

3/12/2020 2:15 PM

You do have the option to pull the data from the tables directly using a SQL query or MS Add-Ins.

Den

Advanced Member Send Private Message

Posts: 38

3/12/2020 2:16 PM

I'm sorry... I do not. I am a regular user... not in IT, or any IS roles.

JonA

Veteran Member Send Private Message

Posts: 1163

3/12/2020 5:51 PM

I don't think there's a single report that will get you all the detail. RQ260 can show you req line history (req#, req loc, item#, qty ordered,) but to get what was actually issued/shipped from the storeroom you can run IC220. Export both to csv and use vlookup to marry the data on the document and item columns.