Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jdblank

    MS - Forecast Consumption View

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

    MS - Forecast Consumption View

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

    MS - Forecast Consumption View

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

    MS - Forecast Consumption View

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

    MRP by Date Report not showing FOs

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

    iminvtrx question

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

    iminvtrx question

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

    iminvtrx question

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

    Need Help - MCA Trx

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

    Material Requirements by Date Report

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

    Utility to keep track of Database Flow...

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

    Utility to keep track of Database Flow...

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Work Around - OE/MFG

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

    Record Locks in Macola - entering Production

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

Part and Inventory Search

Back
Top