Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jmd0252

    Introducing A Levy Against Suppliers Via Accounts Payable

    might go to jdelist.com to post this question. not many jde people on this site.. As asking, have you looked at the business rules for JDE,, I was on World 7.3 cumm 11,, and I remember somewhere where we defined the business rules, for what went where, but that was like 6 years ago..
  2. jmd0252

    Writing a Large Data Record to a Flat file

    you may have better luck asking the question on jdelist.com, more edwards people over there..
  3. jmd0252

    Numeric Value Of A Datetime Field

    I believe that as long as the field is defined as a "date",, then subtract that field fron todays date, and get the number of days that have elapsed.
  4. jmd0252

    Show quarterly and YTD in report

    Well,, you could run the YTD totals, as an sql command, and join the 2 tables, using the ytd as your basis for your join. because if it is in the ytd nnumbers, it may or may not be in the other numbers, so be sure and make provisions, if the other numbers are null ( ie not there).
  5. jmd0252

    Deleting entire file

    do you know how to do a wrkqry, an IBM utility? If so,, go thru that, and pick upi records where the "key" matches,, that way you can be assured that the data is valid.Then you could try a setll and do a reade, and see what happens..
  6. jmd0252

    Crystal Reports Command (SQL Query)

    do you have anything in your database manager, that would allow you to create a "view"? That way you can create the view and "see", the underlying sql atatement.
  7. jmd0252

    Deleting entire file

    you might try a set lower limts, but I would do a read equal. My initial question was you are sure that filea, does contain some records that need to be deleted.. so you do have some where the chain "hits"..
  8. jmd0252

    Deleting entire file

    I'll ask the obvious. You are sure that some file a records are in file b?
  9. jmd0252

    How to convert decimal hours to HH:MM format in Crystal Report

    Well, try this the math does work. take your decimal value, say.25 and multiple by .6 the result is .15. I have done the math, and it works thru.9 for the decimal, which equals out to .54. A tenth of an hour ahould be 6 minutes.
  10. jmd0252

    FTP source code from I-series to PC

    What kind of problems are you having???
  11. jmd0252

    FTP source code from I-series to PC

    http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzaiq/rzaiq.pdf This is an IBM reference, you should be able to find the info you need..
  12. jmd0252

    speed order entry solution

    There are not many JDE people on this web site. You better bet would be to go to jdelist.com. It is a site deveoted to JDE, and the AS400. You can find info both on the World,and the OneWorld, to use the "old" names..
  13. jmd0252

    How do is disply the current rights for each user class

    DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE) OUTFILE(QTEMP/TEMP1) doing this command will create a file named temp1, in the library qtemp,, now you can change the command to fit your needs,, then you can do what you want with your file..
  14. jmd0252

    CR 2008 linked to ACCDB on BOE XI 3

    I would try setting up a mapped drive on the server, into the access database, and see, if that helps.
  15. jmd0252

    Listing of Transactions from Two Tables

    You could create a view in say SQL, and when you create the view, you do a "UNION", which combines all entries from table1, and all entries from table2 into a brand new file.. Would that give you what you need??
  16. jmd0252

    New field in command

    are you doing this in your command?? I would cretae a formula in CR, doing this function after reading the data.
  17. jmd0252

    Mac cannot connect to Server 2003 shares

    http://www.applesource.com.au/how-to/soa/Connect-a-Mac-to-Windows-Small-Business-Server/0,2000451082,339287478,00.htm Found this article http://forums.whirlpool.net.au/archive/1187644 and also this one,, hope it helps..
  18. jmd0252

    Mac printing issues with Departmental codes

    Sounds to me like a Toshiba problem. Do you have someone local from Toshiba? I would guess you have setup the printer, via an IP address, just want to check and make sure..
  19. jmd0252

    easy newbie SQL question

    Commands execute much quicker, as they are processed by the SQL server before they "get into" Crystal. But when you join files, tables, view, etc, etc. The command becomes very cumbersome. Why not rewrite it and just use the data, like you normally would. You have the original, which shows you...
  20. jmd0252

    easy newbie SQL question

    you do not want to add a command,, click on the left side, and add the view(s) to the right side,, when you click ok,, it will take you to a screen, where you define how the data is joined..for most reports, this is the accepted way to define files, or views..

Part and Inventory Search

Back
Top