Who's On?

	Membership:
	Latest: JoseME
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5329

	People Online:
	Visitors: 290
	Members: 0
	Total: 290

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

Issues Information With Requesting Location

6 Replies

0 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

S. Rosa

Basic Member

Posts: 7

1/25/2011 11:37 PM

I am trying to obtain issues information from ICTRANS but also need to relate the IS document type transactions to requesting locations entered in IC21. MMDIST contains the account distribution I need and it actually has a REQ-LOCATION field but the field contains no information. MM280 is able to provide this information. Does anyone understand how?

JonA

Veteran Member

Posts: 1163

2/2/2011 2:54 PM

I've been trying to do this using addins and Crystal for nearly 7 years. I've nevery been able to get both IC21 direct issues and req data. I always revert to IC220 to analyze IC transations.

S. Rosa

Basic Member

Posts: 7

2/2/2011 3:25 PM

Thanks for the reply. The user was able to get MM280 to tie out to GL after some help with report parameters so the problem is resolved. It would still be nice to know where the reqloc information is located for IS documents. One would think that it would be in ICTRANS or MMDIST but noooooo :blink:

Cameron

Basic Member

Posts: 8

3/8/2011 4:40 PM

The Req Location for IS type documents is in field FROM_TO_LOC in ICTRANS.

JonA

Veteran Member

Posts: 1163

3/10/2011 12:06 PM

Yes, that will give you the req location but we're looking for the accounting unit and account that was charged for the supply. If you query ICTRANS it returns the AU and account for Issues (IC21) activity but not for the activity from requisitions/shipments that have been filled and finished in WH32.

Jason Locke

New Member

Posts: 1

4/2/2011 12:03 PM

This join to MMDIST should get you what is needed.

LAWSON.MMDIST MMDIST
ON (ICTRANS.COMPANY = MMDIST.COMPANY)
AND (ICTRANS.LOCATION = MMDIST.LOCATION)
AND (ICTRANS.DOCUMENT = MMDIST.DOC_NUMBER)
AND (ICTRANS.SHIPMENT_NBR = MMDIST.DOC_NBR_NUM)
AND (ICTRANS.LINE_NBR = MMDIST.LINE_NBR)

JonA

Veteran Member

Posts: 1163

5/18/2011 12:27 PM

Doesn't give me the offset acct unit for requisition issues,