Recent content by alex28

  1. A

    mfg/pro response time isue

    Yes, try - 36.25.67 - Mfguser qad_wkfl Data Cleanup. If it does not help, hire experienced DBA to troubleshoot this. There could be many factors like IO, db server settings, BI related, etc.. Alex Kim 32 Soft Inc Excel Data Loaders
  2. A

    generalised code validation if source code not available

    1) if you do not have the source, write a progress wrapper program 2) or get a source code and Customize maintenance program. 3) or purchase Tailor Pro software from White Star or ICT from QAD Alex Kim 32 Soft Inc Excel Data Loaders
  3. A

    Revenues and Payments MFG questions

    Hi There, 1. No that I know of. However you would use different Sales Order sequencing for direct/indirect SO's or would flag indirect SO's in a custom field. 2. Yes, in 7.15 menu. 3. idh_hist table, idh_price is your actual net price, idh_list_pr is your list (STD) price. However both of these...
  4. A

    Performance tuning in Progress 4GL programs

    There are many sources about 4GL performance tuning. I find the most complete one in this book by Dan Foreman: http://www.bravepoint.com/products-publications-performance-tuning-guide.shtml Alex Kim Phone: 877-348-5432 32 Soft Inc Excel Data Loaders High end web applications P.O. Box...
  5. A

    Change GL Year and Period in History Files

    Joe, Yep, that's a good idea for delete/re-build GL calendar. Should not be a problem to leave GL transactions in the unposted register, while you'll be doing all that. Good luck! Alex Kim Direct: +1 (416) 802 2392 32 Soft Inc Excel Data Loaders High end web applications
  6. A

    Change GL Year and Period in History Files

    Joe, You can set GL calendar to new periods, retroactively. Leave gltr_hist as is, then simply run 36.25.39 to recalculate general ledger. This should do it. Alex Kim Direct: +1 (416) 802 2392 32 Soft Inc Excel Data Loaders High end web applications
  7. A

    Automating date parameter for batch job

    you may check this article http://www.32soft.com/blog/?p=68
  8. A

    Exporting Data from Excel to MFGPRO

    check this link Excel interface for QAD
  9. A

    Qxtend

    Some thought on this subject: check this posting
  10. A

    CIM or eCommerce

    We offer commercial solutions for Sales Order Entry and other QAD modules, real time solutions: - Excel spreadsheet, turn key Excel template for SO Entry and printing SO confirmation, packing list, etc - Web user interface, turn key web applications for internal use (CSR, sales reps, remote...
  11. A

    payroll and mfg/pro

    Hi there, We have an excel module for repetitive Journal Entries in QAD, which can be used as payroll entries. If you prepare spreadsheet with typical journal entries, then all you need to do is copy-paste a block of data to our Excel loader sheet and post to QAD. [this is how you can...
  12. A

    Reports in excel format

    Everyone, We offer affordable easy to use Excel output solution for QAD, called LBOX. Works with GUI, .NET, Character, eB desktop interfaces. LBOX extracts information from QAD and forwards it in a form of PDF or Excel to your staff or partners, out-of-the box. Easy to install and operate...
  13. A

    Reports in excel format

    Everyone, Many QAD users are looking for Excel output solutions, so they would manipulate QAD data further in Excel application. Once they find and install this solution, for the most part, they face another problem: how data from Excel sheet to be uploaded back to QAD system after...
  14. A

    Does anyone have Excel templates for converting spreadsheet to CIM Load format?

    You may ask QAD support team if they still have this excel template. Regards, Alex Kim 32 Soft http://www.32soft.com QAD+Excel=Best Of Both | Home of Excel<=>QAD Integration http://www.32soft.com/excelqad.html
  15. A

    CIM load Error

    Your "batchload" sequence can be failing because of the hidden fields in the budget maintenance program. Here is what you can do: exit to progress editor from MFG/Pro menu by typing P to exit prompt and execute the following: {mfdeclre.i} batchrun = yes. {gprun.i ""glbgmt.p""} This way you...
Top