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!

Register Log in
  • Congratulations Chriss 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. GreatPains

    Error: "Cannot update the company information"

    Hi there, Need more information...? Is this a new installation, has the error just occuring..? etc etc... GreatPains
  2. GreatPains

    Crystal Reports

    1 other thing to check in crystal is that you uncheck "Save Data With Report" on the file menu. If this is Checked then the report will not ask for parameters, and will always return the same data. As far as Stored Procs go, it's probabily not worth it, Views are quite good if you don't want...
  3. GreatPains

    P.O. Requestedby info at Receipt time

    I'm not sure what you are trying to do.. but I use this to check if PO's are received or outstanding.... select CASE WHEN R.POPRCTNM IS NULL THEN 'NOT RECEIVED' ELSE 'RECEIVED' END as RECEIVED, PO.POLNESTA, PO.PONUMBER, H.USER2ENT, H.DOCDATE, H.VENDORID, H.VENDNAME, R.Status, R.ITEMNMBR...
  4. GreatPains

    vb script help on an integration

    Have you enclosed the batch in single quotes... Query.AdditionalCriteria = "Batch='" & dBatch & "' " An expert is one who knows more and more about less and less until eventually he knows absolutely everything about nothing.
  5. GreatPains

    Import Items into GP Pervasive SQL

    Have you made a DexSQL.Log to see what SQL is being executed. It seems to be a simple update statement... An expert is one who knows more and more about less and less until eventually he knows absolutely everything about nothing.
  6. GreatPains

    Temporary tables in report

    You can kinda fudge the tables together... SQL Server version... Create the report in GP and make a DEXSQL.LOG of the transactions. You can the edit the DEXSQL.LOG and turn the temp tables into real tables ( by removing the ## in front of the table name ). Then remove the 'DROP TABLE ##xxxxx'...
  7. GreatPains

    RM Outstanding receivables

    RM20101 is the Receivables Open File RM00101 is the Customer Master File They link on Customer Number Goto Tools / Resource Descriptions / Tables This will the list all the table groups in each of the series within the application.
  8. GreatPains

    RM Outstanding receivables

    OK, I've written a similar report for us, the SQL Being.. SELECT RM20101.CUSTNMBR, RM20101.DOCNUMBR, RM20101.RMDTYPAL, RM20101.DOCDATE, RM20101.ORTRXAMT, RM20101.CURTRXAM, RM00101.CUSTNAME, RM00101.SALSTERR, RM00101.SLPRSNID FROM ANA.dbo.RM20101 RM20101 INNER JOIN ANA.dbo.RM00101 RM00101 ON...
  9. GreatPains

    Machine Crashed During PA Purch Inv Entry

    Hi all, A User was doing a PA Purch Inv Entry, and was Matching an Equipment and freight line when their Machine crashed. Now, although the transaction was not posted, when they go in to re-enter the transaction the Equipment Item is no longer available for selection from the PO. Does anybody...

Part and Inventory Search

Back
Top