Recent content by sanjus

  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?
See more
Top