Search results for query: *

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....

yeah, its a more like a rf bin system than a true wms.... we have flex, was trying to avoid that route, but thats the only way i am seeing it as well..... thanks for the response dgillz.

This is the way the WMS was designed and/or developed. Our WMS has no Wave Capability. When you enter an Order, unless you manually put it on status Hold, it goes down to the WMS no matter what. Qty Ordered always = Qty Shipped, the Ship dates on the line, as well as the Qty Order/Qty Ship are...

Yes. Lets say I have forecast for August 1, I need to build the forecast in June/July - but need to prevent orders entered until Aug. 1. Then Aug 1; we can start shipping. The process is messed up, I know it sounds goofy, but this is the reality I'm trying to work around right now until we can...

Hello: Looking for work around. Need to plan and produce (SFC) new items, at the same time prevent OE from entering same new Items against OE orders. Need a flag that makes parent item active in mfg, but prevents entering for shipment. Unfortunately, our WMS isn't driven by OE Line dates, when...

I'm not a sql server guy, so I don't know if this is standard setup, but our locks are located in msllockdb.dbo.MACLOCKS. Do 'select * from msllockdb.dbo.MACLOCKS'; find the locked record and delete it from that table. it beats logging in and out. If you don't have that table, those locks should...