GP9 - SQL 2005
We have Req Managment (fairly recent addition). I went looking for a way to see which Requisition gave us which PO (at the request of our accountants). Sounds pretty easy. Ok - so the Req Mgmt stuff is in the Dynamics database and the PO is actually in the company data - no big deal (I wont be able to use Report Write, but that is the way it goes) --- EXCEPT --- I can not find a link between the Req and the PO (no dex_row common - no keys common - no nothing) - yet when a req is approved an email is generated from the portal saying that Req ab0001 has been approved and is not PO # cd0001
ok - I am at a loss - anyone know where that link is stored? I have been scanning through both the company dbs and the Dynamics DB - no luck
We have Req Managment (fairly recent addition). I went looking for a way to see which Requisition gave us which PO (at the request of our accountants). Sounds pretty easy. Ok - so the Req Mgmt stuff is in the Dynamics database and the PO is actually in the company data - no big deal (I wont be able to use Report Write, but that is the way it goes) --- EXCEPT --- I can not find a link between the Req and the PO (no dex_row common - no keys common - no nothing) - yet when a req is approved an email is generated from the portal saying that Req ab0001 has been approved and is not PO # cd0001
ok - I am at a loss - anyone know where that link is stored? I have been scanning through both the company dbs and the Dynamics DB - no luck