Recent content by jdblank

Actually, after further testing our data is coming in correctly. For anyone that cares and future reference: IM Transactions - Issues; these transactions actually consume your forecast in views and probably reports. However, it doesn't consume the forecast record in the msfrcfil table; it is...

I think we're all set. These transactions are coming from an outside transaction and we need to fix. Thanks for the responses DG.

We forecast our finished goods and merge into MS. We also merge CO's and SO's. All items are set to = 'G'. Thanks.

Progression 7.6.100a - MS SQL Hello all: We're seeing some strange records in the MS Forecast Consumption View. We drill down on our current period to see current demand orders, and we are getting Order Types = 'XXX' with order numbers from out of nowhere and no customer numbers. I checked OE...

did you figure this out? you did a MS merge of forecast records into the actual master schedule before mrp regen?

Doc type Z is the FG receipt. Just trying to figure out how iminvtrx is working. The I - issues and R - returns write ctl_no in sequence 1,2,3,4......, but the Z record is a ctl_no mystery......thanks Don.

Yes, when I perform a Shop Floor Receipt, issue or return, where does iminvtrx.ctl_no come from? Its definitely not the shop order number written to that field. Doc Type "I" and Doc type "R" is somewhat logical in sequence, but the type "Z" record I have no idea where it is getting the...

Can someone please point in the right direction? looking for where iminvtrx.ctl_no for source = 'S' records come from. Thanks.

7.6.100a MS-SQL We have pretty hosed up SO/Job. I have transactions in MCTRXFIL which is spitting out the "No crew records on file" message. For some reason, the MCFIXCRW.INT is not fixing the records for Job. If anyone out there knows what MXFIXCRW.INT is doing so we can back door it, much...

are you using fixed or variable lead time usage in MFG setup? All days on shop calendar are open for business from now until 2008? check the variable lead time flag. if variable, if you have lot size of lets say 10, with a required/plan order of 1000, you will end up way in the past.

Thanks a lot for the info Don, sorry about the name confusion. I think I'll give it a try.

Dave, I agree, SQL Profiler is a pain to read. What about this SQL Delta? I've never seen it. Does it give you calculations by field? In other words, if we wanted to write a program to mimick a Macola transaction, will Delta kick out that kind of detail? Many thanks...... JB

my software version must be too old for the Pop Up Functionality, I don't have a Pop Up option under the Doc Type field......

Thanks.....great idea, I think this would work if there is a pop up option. Does the user have to manually select item notes button to see these or is there an option to get these notes to pop up after entering (or tabbing off of) item number? I can't get my notes to auto-popup during testing...

thanks.....no MRP plan when item = obsolete. We'll figure something out with flex code. thanks a lot....