Recent content by RedHeadedStepITChild

Yes, I knew there would be a lot of work in creating look-up tables for translation. I'm half way considering doing this using SSIS and a ODS. However, the same principle for translation of the old system to the new applies using those tools as well. However, I can't, for some reason, get any...

Unfortunately there is not any rhyme or reason to the parent (sales kit) SKUs in regards to the components that make them up. For instance the component part numbers of: 73868 (top) 67152 (legs) create the sales kit 220015-BBLURE3072-TBLKBLK don't beat me up over part numbers :) the powers...

oops...I left out in the do while portion firstPart = next({partMaster.IPROD}); secondPart = next({partMaster.IPROD});

I apologize if the subject was not concise enough, but was unsure how to word it. I also apologize if this question has been answered before, but after searching this forum quite extensively, I didn't find any posts that quite helped me out. Background of the issue: We have recently...

Fixed

This is probably an easy fix that I am just not seeing. I am working on an inventory tag report that is built into my ERP system (Epicor 9). I'm making changes to the report, but not everything on the report is showing up. I can see a gray box in the design view, and when print previewing the...

Just noticed that the ACTION menu in the tool bar is grayed out in the capabilities module. Is this normal? I don't remember this happening on Vantage 8. The action menu is available almost everywhere else.

Nevermind - this is not possible. The member and memberOf fields in AD are arrays.

Write a function that replaces all spaces with the equal sign (=) to represent a space.

I've searched the net and this site hi and low, but have been unable to piece an answer together that gets me what I need. I am trying to create a report, that shows me the user's name, telphone number, and department in a particular group in Active Directory. I have no problem getting the user...

lbass, Thanks for the help. I created the SQL expression and formula as suggested. For whatever reason the results of the summation of the @qtytest where not what was to be expected. I cannot figure out why it is off. I inserted a distinct cout of @qtytest and did a group selection to show...

I need help with a group selection. I cannot seem to get this to work, and at this point I think I've been working the issue too long. Background info on the report. Using Crystal XI and a DB2 database on AS400 v5r3. The report shows Shop order information. It is grouped in the following...

flapeyre... I appreciate your suggestions. While I'm new to sys. admin world (and even newer to AS400/iSeries) I've made my almost all the suggestions you listed to my "higher-ups." Perhaps its my negotiation skills that need upgrading ;) Once again, thanks all to all of you have helped.

No...unfortunatly BPCS doesn't. Basically the iSeries username is passed to BPCS, and access to the BPCS modules and/or CL programs is set within BPCS. To this point I don't think its even possible to pass a group profile (which would make my job tons easier). I have come across a few articles...

We are using BPCS, and yes it has it's own security. I did CHGMSQ MSGQ(QSYSOPR) DLVRY(*BREAK)in hopes of my terminal showing me when users log on and off. That doesn't seem to be working, or not working in the way I was hoping. I am learning very fast and, yes, I do know about WRKUSRPRF *ALL...