Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 140
	Members: 0
	Total: 140

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

Matching GLTrans to Invoices/PO

1 Replies

0 Subscribed to this topic

44 Subscribed to this forum

Sort:

Author

Messages

DennisJMitchell

New Member

Posts: 4

New Poster

10/5/2018 11:35 PM

Is it possible to match information from a general ledger adjustment to a PO or Invoice? I have dumbed every table I can think of to find something I can use to tie the GLTrans information to a PO or invoice. The system code for the adjustment I am looking for is IC (Inventory Control). Are there definitions available for the system codes (IC, OE, PO, WO, PH) so I can see if IC type system codes even tie back to an invoice or PO?

Kat V

Veteran Member

Posts: 1020

New Poster

Engaged Reader

Avid Reader

10/9/2018 1:09 PM

I have not done it so grain of salt time! If you have a specific line you can see on GL90, drill around to the inventory control folder - that should give you a document number - if that number appears on GLTRANS then try to tie it to ICTRANS or ICTRANSDTL on that doc number.