Search results

  1. Z

    cmt_indx

    What version of MFG/PRO? Perhaps you need to add link on cmt_domain...
  2. Z

    How to Add a Lookup to a Field

    Drill Down/Lookup Maintenance. You'll need to know the name of the field & procedure you're running (of course), and the procedure (browse) you want to execute. If the field is tied to generalized codes, you'll need to know the generalized code field name as well. You can probably figure out...
  3. Z

    BACKSPACE event ON LARGE editor

    Exactly what I was thinking. If you insist on doing what you're trying to do here, you would also have to consider other possibilities to achieve the same result (e.g., pressing the left arrow key and then pressing delete). Ugly, ugly, ugly.
  4. Z

    Batch processing

    I can confirm this is a Very Bad Idea. :awink: I am also not aware of this functionality in MFG/PRO, but I'm curious. How would you determine you wanted to delete a particular line on a PO, especially in a batch?
  5. Z

    low_date not working with field value ?

    ? is the unknown value for the date field. It does not evaluate to true for either less than or greater than... you must check for it explicitly.
  6. Z

    low_date not working with field value ?

    Add condition where ar_paid_date = ? and (ar_paid_date = ? or (ar_paid_date >= dt and ar_paid_date <= dt1))
  7. Z

    Search for ROWID

    At the risk of being beaten, laughed at, and forever scarred :awink:, what would be an example of an appropriate use for FIND FIRST?
  8. Z

    CIM for customized frame

    Sounds like the same problem we have here. What we did is create the CIM program to respond to the original prompts, and handle the logic which would normally be handled by the overlay frame within our CIM program directly. It's not ideal, but it works for what we need.
  9. Z

    Case statement

    Looks like your field is logical, rather than character. If so, remove the quotes around it. (if active = yes then 1 else 0)
  10. Z

    Reading a cell in Excel?

    You did not include :VALUE, according to the previous suggestion. Try this: MESSAGE chWorkSheet:Cells(14,1):VALUE skip chWorkSheet:Cells(15,1):VALUE skip chWorkSheet:Cells(16,1):VALUE skip chWorkSheet:Cells(17,1):VALUE...
  11. Z

    Error232:Missing FOR,FIND or CREATE for a table

    In the procedure contabilidad.w you need to reference the table which contains poliza. (Reference the table before referencing its fields using FIND, DO FOR, FOR EACH, CREATE or IF AVAILABLE statements.)
  12. Z

    Field help and Procedure help

    You can do this using 36.4.13 - Field Help Maintenance. Enter the name of the field and/or the name of the procedure (which must be on a menu), then enter the help text.
  13. Z

    List of all global_ fields available

    If you have source, mfdeclre.i is another place to check.
  14. Z

    Customer due date calculation

    You may want to look at the procedure help for Sales Order Auto Credit Hold (sochup.p -- 7.1.16 in eB2.1). A cursory look at this shows that you may be able to run this with defined values and automatically put the Sales Orders on hold, as previously mentioned by Kishor Chari.
  15. Z

    Group By In Progress not like sql?

    Something like this should get you going: FOR EACH rpm.coitem NO-LOCK WHERE (rpm.coitem.stat = "F" AND rpm.coitem.ship-date > 01/01/2009 AND rpm.coitem.ship-date < 02/06/2009), EACH rpm.item NO-LOCK OF rpm.coitem BREAK BY rpm.item.product-code: if...
  16. Z

    For GL Cost AVG method LL cost calculation

    As mentioned in your previous thread, you need to set the value of "Sum LL Costs Into Matl Cost" in 3.24 to No. This value determines how lower level costs are posted to Cost of Goods Sold. When No, lower-level costs are added to this-level costs for each cost component and the total posted to...
  17. Z

    AI Restore...talk me through it like I'm a Microsoft guy (I am)

    Rather than provide advice I am likely not qualified to give, here's a link to the documentation on Progress' website. :) Recovering a database
  18. Z

    AI Restore...talk me through it like I'm a Microsoft guy (I am)

    Disclaimer: I'm more of a Microsoft techie myself, and am not responsible for this type of thing. BUT ... we do have documentation and I have followed the procedure when we lost power once. Here's what we have: Restore the database. (Assuming you know how to do this) (We have a step to...
  19. Z

    Report File

    The default Purchase Order Print form (Form Code 1) is created with program porp0301.p
  20. Z

    status of wo after shipment

    Sounds to me like you did not close the WO. When you run Work Order Receipt, there is a prompt to close the Work Order. You also may want to look into Work Order Accounting Close....
Top