Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mac555

    Fiscal Year to Calendar Year

    We are considering to switch from fiscal year to calendar year. How should we proceed with this ? Are there any problems/issues that we need to be awared of ? TIA.
  2. mac555

    Btr to SQL conversion

    We are running Progression Pervasive 775 and ready to move to MS SQL. We are hitting some errors during the conversion. The Btr2SQL doc. is a little inconsistent and I would like to get some clarification from some of you who have done this. 1) The conversion has to be run from a workstation...
  3. mac555

    GL year close problem.

    Oops Sorry I forgot. Anyway, ran again and it processed fine without error this time. Weird. Thanks.
  4. mac555

    GL year close problem.

    Anyone knows what is the SY000298 error ? When doing the GL Year End closing, the status dialog locks up and got error SY000298. Thanks.
  5. mac555

    AP check number already used message

    Running MS SQL, Progression 7.7.3. In AP, when running Print Check, it shows the what the next check number (46020) should be but when click on OK the message "Check Number Already Used" will come up. Will get the same message unless skip the check number to 46068. I checked the AP data files...
  6. mac555

    Windows 76 64bit

    Oops. Miss typed :) Another person told me he was unable to install Progression Pervasive on Win 7 64 bit. I guess I will test Progression SQL to see if it will install on win 7 64bit. Thanks.
  7. mac555

    Windows 76 64bit

    Can Macola Progression SQL run on Windows 76 64bit ?
  8. mac555

    join table

    Changed "Where" to "and" didn't quite work but I changed the statement to "Select cust.field1, cust.field2, ord.* from customers cust left join orders ord on cust.id=ord.id and ord.date>='01-01-2010' where (cust.type=1 or cust.type=2)" worked. Now I need to figure out how to get the same...
  9. mac555

    join table

    Let's say there are Customers Table and Orders Table. There are several customer types. I want to get the rows from 2 tables with the following conditions: All customers rows with of particular customer types (ex. 1 and 2) and their associated orders for a specified date range. If I used...
  10. mac555

    Cannot Post or Print AP transactions

    Didn't print to the screen either and I tried all the rebuild, re-initialize & reimport files,etc... and still didn't work. However, we finally got it working. Somehow, the Bank Book module option was checked. We don't use or have license for this. Not sure what's the relation of bank book &...
  11. mac555

    Cannot Post or Print AP transactions

    we can enter transactions but then can't process or print. From the print destination screen, it just goes back to the range selection dialog and no thing happen. No error No message display. I followed instruction to clean-up layer/work/temp files but still not working. Anyone know why ...
  12. mac555

    Display/Print more than 5 digits.

    lol. We all can wish. But the fields do not even allow hundred thousands value.
  13. mac555

    Display/Print more than 5 digits.

    Yes. it is payroll module. Actually, it's not the report. I believe the deduction fields do not allow the amount higher than 99,999.99. I am not sure if this is the built-in limitation or if it's possible to increase the digits limit thru the designer.
  14. mac555

    Display/Print more than 5 digits.

    the P/R register report does not print more 5 digits. Can the report be modified to print more digits ? Progression Pervasive SQL. ver 7.7.1 Thank you.
  15. mac555

    A/R ICR Aging report

    The standard Macola report runs with all correct data printed. However, the equivalent ICR aging report does not print all the data as the Macola report. What's wrong ? Thanks.
  16. mac555

    evbas13.dll not found error

    Got this error when run Progress Workflow Explorer. How do I correct this issue ? Thanks.
  17. mac555

    ICR - Reprint invoice

    That works. Thanks dgillz.
  18. mac555

    ICR - Reprint invoice

    When run this report from Macola interface, got error "macCRout.changelocation.....SFORDFIL_SQL not found..." after I clicked OK to close the error message, a dialog looks like a Crystal report criteria/parameter dialog come up. These modules are activated: IM, OE, PO, BOM, PO, bar coding...
  19. mac555

    ICR - Reprint invoice

    we are running Progression MS SQL v7.7.1. Get 'macRout.changelocation error" when try to run Reprint Invoice (ICR - oeinvfrmsql.rpt) from Macola interface. I saw an earlier thread saying this report cannot be ran from Macola. Is this still true with version v7.7.1 ? Thanks.
  20. mac555

    Changes using Designer Mode

    Progression Pervasive SQL 7.7.1 On another note, we are having an issue with Intersolv ODBC not installed correctly which then causing error (missing evbas13.dll file). Can't run Workflow Explorer or part of Visual Builder because of this. How do you correct this ? Thank you.

Part and Inventory Search

Back
Top