Search results

Hello, I have issues with two reports in QAD. The reports output of 25.15.2 (Account details) and 25.15.8 (Balance sheet) does not match. I checked couple of accounts and found value shown in account detail and balance sheet are different. How this can be possible? I had run ACD fix utility...

Hi, Although I use different command to convert from UNIX to DOS format, looks like output device is not specified. e.g. /bin/tools/unix2dos $OUTFILE > file1 Please try this out and let me know if this work. Subhendra.

Hi, Which version of QAD you are using. If you are using QAD 2007 or higher then you need to buy license for ECONTROL which will enable you to have audit trail on any table and field. Contact QAD for more details. Or you can write a trigger program on mf.p which will capture the changes on...

Hi, Sure, I know product line code runs into lots of module and tables but it's a company policy decision where we don't have any say. Secondly, we want to have global product line codes which can help us when we move to SAP. So to start on we want to have same product line codes for all...

Hi all, Due to business requirement, I need to change the product line in QAD database. This change will include changing old product line code to new product line code and/or changes in new product line code. Normal way is to delete/cancel/close the existing open orders (PO/SO/WO) and...

QAD 9.0 SP2 with Progress 8.3B. This problem also happens with OpenEdge 10.1C SP2 with QAD 2009 SE.

? is the unknown value which is by default added to the ar_paid_date field when record is created. Regards, Subhendra.

Thanks buddies. I have changed my query with the following condition and it's working. ------- and ((ar_paid_date >= pdate) and (ar_paid_date <= pdate1) or (pdate = low_date and ar_paid_date = ?)) -------- Thanks all the reply and help.

Hi everyone, I had written a query which accepts paid date as selection criteria. If paid date range is blanked then i assign to low_date and hi_date as per QAD standard. But this doesn't return record where AR paid date field having ? value. How can the query be written for such cases. below...

Hi, I had written similar trigger on Customer Maintenance. This works fine with me. You can try the below code for your program. --------------- {mfdeclre.i} ON ENTRY ANYWHERE DO: DEF VAR Hdl as handle no-undo. DEF VAR Cdl as handle no-undo. Hdl = SELF:HANDLE. IF Hdl:TYPE = "FRAME" AND...

Hi, I know it was late reply but still posting. Here is the small example through which you can have default value. I have tested this program in CHUI QAD 9.0 SP2 Progress 8.3B. Regards, Subhendra. --------- {mfdeclre.i} ON ENTRY ANYWHERE DO: DEF VAR Hdl as handle no-undo. DEF...

Hi, If the field is QAD field name like sod_line, sod_qty_ord, sod_price etc. then you can use the "on assign" session trigger on that field. This will get fired whenever there is any changed in the field and different from old value. Else you can trap "TAB" key to know what data is...

Hi, You can use two option to verify what is the source of price coming in Sales order ... 1. Use 1.10.1.13 (sopiwiiq.p - Pricing What-If Inquiry (S/O)) 2. Use 1.10.1.17 (soppiq.p - Sales Order Price Inquiry) Once you identified the source, then it become very easy to resolve the issue...

Thanks for the reply guys. I will go through the document and try to implement the same. Thanks once again.

I think this will not help because MRP regenerate uses 2 streams. One stream is the output file which is entered at output device and 2nd stream is the output to screen. When batch script is used the output to screen stream didn't work and hence it's gives the TERM error message. The best way is...

I had never worked on QAD EDI module.:( Can anyone help me to setup EDI process (step by step) for QAD 9.0 SP2. Thanks in advance.

We also use MRP regenerate in batch mode. Here is what u need to do ... 1. Create a batch id in 36.14.1 (mgbcmt.p) e.g mrpregen. 2. In 23.2 menu, entered the relevant data, Press F1 and enter the output file name and batchid as "mrpregen" 3. Goto 36.14.3 (mfbcdmt.p - Batch Request Detail)...

You can contact me.

Hi, I have the somewhat the similar issue with .NET 2.7.3 version QAD 2008 SE. My problem was when i attached any custom program (may be changing strandard QAD program and adding one additional column) in custom menu, output to page was not working. It was showing the QAD desktop screen. But...