Is there any code or routines available that will cause MACOLA 7.5 Production Word Order module to generate a CSV that contains recently posted/added/modified work orders?
This is very easy to do via a crystal report, but you will need to define what "recently" means. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
"recent" production orders meaning I am hoping there is a field somewhere in the table that records when the work order information arrived in the produciton file. I would grab anything after <today-1> as "new"
Yes, in the PPORDFIL_SQL table there is a field Entered_Dt (entered date). Remember that macola stores its dates as an 8 digit integer, so in your crystal report, put the following as a record selection formula:
Numbertodate({PPORDFIL_SQL.Entered_dt}) in CurrentDate-1 to CurrentDate
I hope this helps. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.