Tim Goldstein
Full Member
 

'Cause sooner or later everyone needs a chief geek
Posts: 212
Gender:
|
Lenette, Yes! just started. Using XI. However I'm finding that due to the fact that there is no relation between BKGLTRAN.B and any other part of the system, it takes some work to "Munge" the BKGL.TRN.INVC string field into a DBL or INT to reference the WO, PO, SO and item numbers. However, I have created a monthly WO variance report with drill down that does work 90% of the time. I'm having a problem with it skipping a couple of items. I thing the problem is in my "Munge" but not sure. If you would like the code, let me know. It uses cascading prompts for date ranges (only available in XI) Cheers; Tim
|