Recent content by jdrouil

  1. J

    Custom QAD Scanning Menu with QAD Logon/password prompt

    I was able to do this using Avanti Velocity software which comes on most new Zebra scanners. I basically trained the scanner using this software to only display what I wanted to display. Works great and much prettier too! And I didn't need to create a small-scale scanning menu using QAD's...
  2. J

    Custom QAD Scanning Menu with QAD Logon/password prompt

    Hello - I am developing some custom scanning screens to feed data to QAD using input redirection, eg. Backflush. How do I include them in a small-size login and custom menu that will fit on the small scanning terminal screen? It will need to include QAD's login logic. Thanks, Joe MfgPro...
  3. J

    Pegging in 7.9.2. Off for Pre-shippers. On for shippers.

    EB2.1 sp4 7.9.2 PreShipper/Shipper Workbench. Pegging of REQ (requirements based, ie Nissan/Hyundai) Pre-Shippers. We wish to avoid pegging REQ orders when creating a pre-shipper. This is accomplished for us in the shipper gateway from our scanning solution. We do not necessarily complete...
  4. J

    Any advice on auto clearing of checks and Positive Pay?

    I was looking for this as I was having trouble getting this CIM to work. Found the answer from QAD, but without any explanation for the extra "-" after the amount. Please note that you must eliminate all leading spaces on each line. Each line must start all the way to the left. Never had to...
  5. J

    How to interchange quickly from shipper number to edi sequence number?

    Here is what I came up with. The following example displays the header record structure when provided a shipper number and domain as input. It first finds the sequence number from a relatively short file, then uses it to garner information from a much longer one. This sped up the search on a...
  6. J

    How to interchange quickly from shipper number to edi sequence number?

    I am writing a custom report where the user keys in a shipper/asn number, and I report a combination of data from the abs_mstr and various edi_ecommerce files (e.g.: edmfr_mstr). I know I can get at it using edmfr_mft_idx edmfr_mft_idx_val, but these are not indexed in the table, so this...
  7. J

    mrp_dataset = bp sold?

    What is the source of mrp_det records with mrp_dataset = "BP Sold"? EB 2.1. thks
  8. J

    How to run program in an r-code library from windows command prompt

    Quotes work. Doh! _progres.exe -ld avdb c:\avdb\ajrosestv -p "avsvc.pl<<avsv50.r>>" -Wa -wpp Thanks anyways, Joe
  9. J

    How to run program in an r-code library from windows command prompt

    I can load character progress from a windows icon and run a program from an r-code library (.pl), but not from a bat file which I need for character scanning. "C:\Program Files\PROGRESS\bin\_progres.exe" -ld avdb c:\dir\xxxxx -p yyyyy.pl<<zzzzz.r>> -Wa -wpp The above works fine from an icon...
  10. J

    Setting extent size in structure file to save space gained from archive.

    Appreciate the input, and I see your points, but what can I do for now? I guess I will just multiply the storage area disk space usage by 1.5 for fixed extents and post back on the results.
  11. J

    Setting extent size in structure file to save space gained from archive.

    I archived a good chunk of data from the database (91E), and now want to cut back on the number of extents so that the database has a smaller footprint. Of course I want to allow room for growth with an empty fixed extent or two, plus the last one variable. I have one area in the database...
  12. J

    QAD Documentation for 7.3 Available ?

    Does anyone have QAD documentation for version 7.3? Don't even know if they had the PDFs back then. Or a different version of Docs on Disk. Thanks.
  13. J

    Change GL Year and Period in History Files

    Alex - Thanks, I need to first delete the old calendar records for this year. The maintenance screen will not let me because of active transactions in the period. I will therefore do so with a Progress program as follows: for each glc_cal where glc_year ge 2010: delete glc_cal. end. for...
  14. J

    Change GL Year and Period in History Files

    My company wants to change to a new fiscal calendar going to a true calendar year. They are currently July to June. Here is the kicker, they want to do so retroactively. Can I just go into all files with year, period, and effective date and change 6 months of records around to match the...
  15. J

    Excel Formatting

    Thanks Paul. I am doing the csv thing now and it is "ok". Not looking for anything too fancy, just column widths that match the data, and the ability to specify cell or column formats. Will try your html idea and get back. Thanks again for responding.
Top