Search results

  1. S

    how can I send the data in tabular format in the body of the mail box

    you may have to enclose the report with something like this before sending it via email. put skip "<HTML><TITLE></TITLE><BODY><FONT FACE=courier SIZE=3><PRE>" skip. <your report output> put "</FONT></BODY></HTML>" skip. Courier or Courier New font only will retain the tabular format that you...
  2. S

    sod_project field added to Generalised codes,but not showing an error

    Do you have access to QAD KB? They have a documented solution on how to introduce generalized code validation on a field. It does need some schema changes. However, why do you want to generalized codes on sod_project? Why not define projects in Project Master? sod_project is validated against...
  3. S

    sod_project field added to Generalised codes,but not showing an error

    1. How did you make it as a generalized code field? 2. Press Ctrl-F on sod_project field (on screen) & print the screen. Does it show Generalized Code?
  4. S

    How do I transpose or concatenate strings from a column output into a single row?

    Thanks m.edu. That's what I ended doing - using a stored procedure (for cursor processing) which updates a view with the transposed record set.
  5. S

    How do I transpose or concatenate strings from a column output into a single row?

    I want to take a column from a table like this: select * from Color; Color ------ red orange blue green And return a resultset like this: Colors ------------------------- red,orange,blue,green
  6. S

    ODBC - Multiple DB Connections

    Environment: Server OS: Linux RHEL Progress (OpenEdge): 10.2x DataServers (brokers) started for 4GL & SQL seperately. Client: Win7 x 64 ODBC Driver: Progress Supplied (Merant/DataDirect) My Questions: 1. How can I connect multiple DBs thru a single System DSN? Is this even possible? 2. How...
  7. S

    QAD Enterprise Applications 2007.1 - vist 64bit problem

    what's the error? check the .netui log file on the client pc for more details.
  8. S

    QAD Enterprise Applications 2007.1 - vist 64bit problem

    Always provide a screen-shot of the problem whenever possible. 1. WebSpeed Agents active? 2. AppServer Agents Active? 3. did you check your connection manager? Are the sessions idle? 4. did you check your telnet connection settings? Is the problem on the server or the client? Is your ChUI...
  9. S

    balance not been shown up

    yep. the PDF you sent me via email. you are on your own on this to debug your data and see what's going on. the aging buckets are calculated field & if this number is changing for different dates that means there are some transactions in the system that's causing this.
  10. S

    balance not been shown up

    The reports are not giving any clue. You'll need to analyse the data by writing some queries or putting some debug statements in the AR Aging report as to why it's reversing the amount from 1 period to another.
  11. S

    balance not been shown up

    without knowing what went wrong during the merging or somewhere else - it's difficult to tell how to move forward. Somehow, the data-integrity is in question.
  12. S

    balance not been shown up

    in the text file - search for the invoice number mentioned. in the PDF there are only 3 pages so it should not be difficult to find the invoice number I mentioned.
  13. S

    balance not been shown up

    from your 27.13 output, Check WIRE0285 was applied against Invoice IN222027 13/06/05 IN222027 I 13/06/05 8,046.50 0.00 WIRE0285 266 but your PDF shows that Check WIRE3196 was applied against Invoice IN222027 Seems something is fishy/suspicious.
  14. S

    balance not been shown up

    Try running arcsrp05.p (vanilla) program and compare results. Your aging report is a customized report and could have issues in the code.
  15. S

    accounts not showing up in GL

    Did you ever find out what happened to the missing GL transactions?
  16. S

    accounts not showing up in GL

    The 2 entries listed on your screen shot are Journal Entries entered manually. Can you kindly display all the contents of the glt_det file (without the where condition)? Did you get the answer on #3?
  17. S

    accounts not showing up in GL

    Looks like your gltr_hist file does not have any records for the date 10/08/10 which means most likely it has not been posted - check your glt_det (Unposted Transaction file).
  18. S

    accounts not showing up in GL

    here's what I would suggest: 1. Check your ih_inv_date for those 2 invoices 2. What's the selection criteria on the Invoice Posting? Does it post with GL Details? 3. Do you have the output of the Invoice Posting stored in print files? IIRC, if invoice posting is done in Details, then it...
  19. S

    control characters for new Xerox FX APeosPort-Iv C3370 PCL6

    Looks like something is not right in the setup. If you see the first line it is printing some control characters. Not sure where it's coming from. Is the printer setup screen-shot for this Xerox printer? Most likely it's a font issue. Also, lets try this: Output the sales order print to...
  20. S

    control characters for new Xerox FX APeosPort-Iv C3370 PCL6

    1. Although there are valuable inputs, i think this issue needs to be posted in the Mfg/Pro forum :) 2. Can you send the screen-shot of the the output and the printer setup screen also?
Top