Search results

  1. L

    Idle Users

    You do not mention the OS In unix/linux most times the response is around the use of the "ps" command. Additionally you can link this to a "promon" that can take "piped" commands and produce output that you can read and react as necessary. Mfg/Pro's "idle" setting in the control file only...
  2. L

    How to change base currency if GL transaction existed

    It does not stop there... I do not know how much has been implemented and whether transactions already exist in the other modules. I also do not know whether you just want to change the code or actually switching the currencies (e.g. USD to JPN). All transactions already created (AR, AP, SO...
  3. L

    Calendar question, need help...

    May be a slightly different version but you should try 33.1.4 *33.1.1 GL Calendar Browse glbr003.p * *33.1.2 GL Calendar Report glcalrp.p * *33.1.4 Calendar Cross-Reference Build spglclmt.p * *33.1.5 Calendar Cross-Reference Inquiry spglcliq.p *
  4. L

    regarding to Reverse transaction

    In my prior response I said that if your INVENTORY STATUSES do not allow for overissues (e.g. create "negative" QOH) then you will not be able to "RETURN" an item (e.g. with or without serial number) if the specific location (e.g. ld_det) has not enough qty_oh to do the return. In short words...
  5. L

    of 5.5.5.5 and 5.5.5.11

    5.5.5.5 is program rsiq03.p 2+ 5.5.5.6 PO Shipper/Container Inquiry and is the same as in 5.13.15 5.5.5.11 is the actual receipt, you can see in 3.21.1 or better in the PO module using same program (5.13.15). The difference is that the shipper will be confirmed, meaning the goods...
  6. L

    regarding to Reverse transaction

    Well, you see, this is now a completely different question... RCT-PO is disconnected with ISS-WO. What you may be refering to is whether you can return even though the items were used, the answer is yes but.... If you are using lot/serial numbers and there is no more left in the ld_det for...
  7. L

    regarding to Reverse transaction

    Katheryn: For regular WO think of them as a big cooking pot per work order and id. You bring in a lot of ingredients (components) and you produce units of dinner (finished product). The work order will keep track of what was consumed and what was completed. Then it will try to figure out...
  8. L

    Where to view all entries of inventory

    If you mean "GL effects" yes it does. 3.21.1 has the purpose of detailing the tr_hist and the corresponding trgl_det records that resulted from a given transaction. 3.21.16 is a report that is targeted at reporting the GL effects. 3.21.1 has much more information that you won't see in...
  9. L

    regarding to Reverse transaction

    Reverse transactions of what?
  10. L

    Where to view all entries of inventory

    katheryb: You need to be a little more specific on your questions. 3.21.1 is the place where all inventory activity can be seen. If you are asking for accounting effects, you can also see them there.
  11. L

    Work Order Close & Forecast MPS

    Rosalie: I am going to say there is a misunderstanding of the basics of forecast and the difference between direct and indirect demand. The usage of forecast is to prevent "out-of-stock" situations by creating "indirect demand" so the machinery is put to work to satisfy upcoming demand. The...
  12. L

    Work Order Close & Forecast MPS

    Rosalie: Going to basics, a closed WO will not be seen by MRP as a source of supply. A master planner should ignore these WO. Do a test, create a new manufactured part, create a SO (e.g. 10000 items), run your slective MRP for this part (you will get action messages), create a WO to satisfy...
  13. L

    What Source Control to use - MFG

    Gary: SCS is not my area but there is something I want you to consider... In the latest versions (don't know exactly since when) QAD is doing away with the comment out/comment in changes. That is, other that leaving an entry of who was the last person to change the code and when, there will...
  14. L

    SO Allocation w/o CIM

    I would understand if you do not want to cim into SO maintenance but have you considered doing CIM into sosoal.p (7.1.6)? Allocations affect a lot of tables, among them ld_det, lad_det, mrp_det, sod_det, in_mstr. You can check what tables are being hit using your system cross reference...
  15. L

    Data Extract

    In QAD relationships between tables have to be specified externally. The best source of information would be QAD's documentation. There are 2 key documents for what you are trying to accomplish: db_def and entity_diagrams. Both are pdf and come along with the QAD CD suite. You can also download...
  16. L

    invoice eff_date

    Now... how to avoid this? As you mentioned, users are backdating the effective date at post time. This means the GL calendars have not been closed for SO for the previous period; that is the first thing you want to look at. By closing the GL calendar for SO, the system will not let you post...
Top