Recent content by Max Viskov

  1. M

    IS there anything wrong with the query?

    Hi 1. The (and in_qty_oh >0 ) should be in the "each in_mstr" scope. 2. You also have to reference the site. If you do not know, you can use pt_site . Output to "C:\Documents and Settings\seeming\Desktop\A.txt". FOR EACH pt_mstr NO-LOCK WHERE pt_status = "AC" and pt_prod_line= "RMCB", EACH...
  2. M

    Reports in PDF

    Hi Apache web servert does not do anything to HTML requests-responds, it only is passing them through to Tomcat. That is why php won't work here. (BTW Apache no longer in use in .NET interface but Tomcat is, eventially desktop will go away). You will need to identify QAD Java servlet in the...
  3. M

    Reports in PDF

    What telnet client are you using? Thanks ____________________________________ Max Viskov Senior Consultant, Implementation Services MFG/PRO Toronto User Group Board Member 32Soft Inc., an Official QAD Subcontractor Need GL...
  4. M

    Reports in PDF

    Yes, it works with Unix and Linux. Please remember, that this is a client solution, installed on your PC. You can download the trial version here: http://www.32soft.com/site/modules/PDdownloads/viewcat.php?cid=1 Regards ____________________________________ Max Viskov Senior Consultant...
  5. M

    Sales by Salesperson

    Hi Depending on your version, you may find the report here under sales Analysis: sasarp03.p 7.17.14 Sales by Customer Report (selection by Salesrep) Sales by Salesperson Browse ____________________________________ Max Viskov Senior Consultant, Implementation Services MFG/PRO Toronto...
  6. M

    Reports in PDF

    Hi You may see one here: http://www.32soft.com/site/modules/xt_conteudo/index.php?id=12 ____________________________________ Max Viskov Senior Consultant, Implementation Services MFG/PRO Toronto User Group Board Member 32Soft Inc., an Official QAD Subcontractor...
  7. M

    Item specific decimal places?

    Tony The container system allows you to link the pallet item number and the product item number. You will always put the pallet item number qty as 1, and the product qty - whatever you like. This will ensure, that the pallet will always be issued as one piece. This process is not really...
  8. M

    Inventory Valuation (sort by Customer)

    Hi What do you exactly mean by this? The standard MFG/PRO inventory system does not reference the customer. You can use different ways to achieve it, for example to use a reference field in ld_det to store a customer name this piece was allocated for. In eB2 there is a new functionality called...
  9. M

    Item specific decimal places?

    Hi! I am not aware of the standard functionality you are looking for. However, you can achieve what you want in a couple of ways. First, the operator can adjust qty to issue during the backflush process. I know, it may not a best solution, if you run automatic backflushes. Second, the big...
  10. M

    ONTUG Early Bird Registration Extended!

    Dear MFG/PRO Users! The deadline for the Early Bird registration has been extended until the end of Today! Ontario MFG/PRO User Meeting will take place on March 22, 2007 at the Hilton Toronto Airport Register for the user group meeting before the end of today and get a chance to win...
  11. M

    On Hand Inventory In a Specific date

    Hi You can try the standard qad report 1.5.23 Inventory Valuation as of Date (ppptrp06.p) Regards ____________________________________ Max Viskov Senior Consultant, Implementation Services MFG/PRO Toronto User Group Board Member 32Soft Inc., an Official QAD Subcontractor...
  12. M

    Importing from excel

    Hi You have several options here: 1. To send a file to the user by email. You defines a special printer device in MFG/PRO, which calls a special unix script sending a file to the user who runs the report. 2. Create a shared drive, which will be shared between Unix and Windows machine (for...
  13. M

    Query (not purchased items)

    This is right Open purchase orders are pod_det where pod_qty_ord > pod_qty_rct or pod_status = " " . ____________________________________ Max Viskov Senior Consultant, Implementation Services MFG/PRO Toronto User Group Board Member 32Soft Inc., an Official QAD Subcontractor...
  14. M

    Ontario User group Meeting - Register Early and Win Free Explore Pass

    Dear MFG/PRO Users! Only One day left for the EARLY BIRD REGISTRATION for Ontario MFG/PRO User Group Meeting! Remember - Register for the user group meeting before March 15 and get a chance to win a FREE PASS to QAD Explore 2007! The registration must be sent before the end of the...
  15. M

    Query (not purchased items)

    Hi You can try something like this: For each pt_mstr no-lock: find first tr_hist where tr_part = pt_part and tr_type = 'RCT-PO' and tr_date >= (today - 730) no-lock no-error . if not available tr_hist then display pt_part pt_desc1 end . ____________________________________ Max Viskov...
Top