Recent content by Ray Man

  1. R

    Error Browse Timeout Error In Proxy Browse ( Dynamic Query)

    maybe it is a complex browse which inquires multiple tables? In a live environment the other tabels can be locked nu active users or other factors which you do not have in a "test" database.
  2. R

    Error Location Does Not Exist

    is it possible that the inventory has a different expire date? Maybe the message is not complete. The second line is trying to add inventory to an existing inventory lot but not all attributes are the same. (expire date, reference etc).
  3. R

    how to add master reference

    Reference number is equal to customer number = customer comment Reference number is equal to item number is product comment play with various types to store information for different departments. have fun and good luck
  4. R

    Safety Stock

    I believe the in_mstr (inventory master) will show you inventory of an item. As I understood it was only necessary to find an item with a safety stock and a price. In that case the first file is pt_mstr, select on pt_sfty_stk (safety stock > 0), second find the costs; find the sct_det where...
  5. R

    Safety Stock

    If your system looks messy you will complicate mathers with complex query's. Q-ries are very powerfulle if you want to check prices for items. If you want to use queries you need 2 things: 1 data dictionary (delivered with your software or you can get it at qad.com) 2 file relations to show how...
  6. R

    Safety Stock

    What are you trying to find out in your query? product charactaristics are in the pt_mstr GL prices are stored in the sct_det. You can find these tables in your data dictionairy of by using Ctrl f if you are on the field you like to inquire. good luck
  7. R

    MFG/PRO eb2 2tier Configuration

    Wat do you mean by a 2 tier?:confused:
  8. R

    Sales Order Shipment - Qty to Ship

    Are you sure that the alternative unit is set correctly? So it the alt um is 0,5 and not the double amount? If you are in doubt, check 3.18 to see if the required qty is std um is indeed what you expected.
  9. R

    Invalid Account Code (General Ledger)

    account currency ok? currency dates still valid? gl period open?
  10. R

    Invalid Account Code (General Ledger)

    Is teh account still active? (dates etc...)
  11. R

    Wo

    Workorder statusus: As you go up in the cycle, there are more fixed values in the workorder. P: planned by the computer to satisfy a mrp demand. Cannot be planned manually. Everything is dynamic, from dates tot bom etc... F: An order manually confirmed by the "planner". Either a confirmed "P"...
  12. R

    WO Changing to Alternate BOM

    If I understand correctly you want to: change a component in the work order bill of material. If your workorder has status P or F it is planned and by definition the bill of material is not fixed. So the bom of the workorders is in fact the bom in 13.5 etcc. The bom for a workorder is frozen as...
  13. R

    Serial Final Product / Lot Component Assignment

    Hi Diederik, You might also use a tracking/tracing possibility used a lot in the food industrie. In the food production, volume speed is very high. (12 tons an hour of all kind of products and additives). Due to this speed they keep track of production per day (or day-hour) and issue of...
  14. R

    Who is the user?

    suggestion: remove wo bill maintenance from their security profile. See who is complaining. good luck ps if there is distrust I believe it is wrong to secretly try to find out who did what. If you do not trust each other you can not set up general users with powerfull functionality, each user...
  15. R

    Where Used Inquiry (13.7)

    I do not fully understand the situation. Q: on 24-8-2006; was item A a component of BOM structure Z;Y;W;D;E;F;G? Q: What did you do with item A; (1)changed the item number or (2)replaced A in the Product structure (13.5) with A1 for parents Z;Y;W
Top