Recent content by zee

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

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

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.

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?

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

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

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

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.

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

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

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

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.

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

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.

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