Search results for query: *

Dgillz, Thank you for your feedback. I'll follow your advice. Regards, JUrban

Sorry for the delay in my response. I needed to ask for more clarification in order to better answer your question. For transactions comming from the IM module, the reference field available in GLTRXFIL_SQL table shows the PO and item numbers. I need the vendor name number associated with these...

I am referring to item descriptions of AP transactions. I extracted item numbers for IM transactions from the reference field (took your tip regarding the vendorm name extract further) Regards, JUrban

Due to your tip, I extracted the vendor name from the reference field and conditined it for AP source data. My ultimate goal is to create a gl transaction report which would include vendor name (done), and item description (should I use APTRXDST_SQL table, and if yes, how to link it to...

Thank you for your prompt and accurate answer. Yes, the vendor name is in the reference field, and I will try to use the InStr function to extract it. Any ideas on how to incorporate Item Description in my GL report? When done, I would like users to filter on cost center, vendor, and item...

Hello, I need to create a set of Crystal reports which would show GL transaction history and supplement it with the Vendor name/number and item description where applies. My problem is that i cannot find join fields to acomplish this (tried GENTRX_SQL.Id_No to APDISFIL_SQL>Id_No, but GENTRXSQL...