Title: Purchase Order X Transaction
Description: PURCHASE ORDER x TRANSACTION
rmendes - June 27, 2006 05:21 PM (GMT)
I need to get the purchase order related to a transaction when its come from the Purchase Order subsystem. Is it possible? How to get this information? Does anybody know the correct link? I couldn't find it at lawson documentation. Do I need to use the table MMDIST?
3monkeys - June 28, 2006 08:17 PM (GMT)
Could you provide a little more detail as to what you're trying to do? Write a report, do a query... Do you see the information you're looking for on a form, just don't know how it got there?
-GW
strandb - June 29, 2006 05:42 PM (GMT)
If it's just a single transaction, you should be able to use Drill-Around to find the PO information.
rmendes - June 30, 2006 08:00 PM (GMT)
I would like to know how to link the table GLTRANS to PURCHORDER, if it is possible. My objective is to find the PO related to a single transaction.
Thank you!
trezaei - June 30, 2006 08:17 PM (GMT)
I am not a big GL buff but I think this is what you're looking for
| CODE |
Purchorder.Company -> Mmdist.Company
Purchorder.Po Number -> Mmdist.Doc Number
Purchorder.Po Release -> Mmdist.Doc Nbr Num
Purchorder.Po Code -> Mmdist.Po Code
Mmdist.Line Nbr
Mmdist.Aoc Code
Mmdist.Line Seq
|
| CODE |
Gltrans.Obj Id -> Mmdist.Glt Obj Id
Mmdist.Company
Mmdist.System Cd
Mmdist.Location
Mmdist.Doc Type
Mmdist.Doc Number
Mmdist.Doc Nbr Num
Mmdist.Line Nbr
Mmdist.Component Seq
Mmdist.Line Seq
|
So the table in between if you were to ask me is MMDIST. Good luck