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 dencom 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: *

  • Users: jcw12000
  • Content: Threads
  • Order by date
  1. jcw12000

    Complete GL distrubution of a transaction

    Hi Guys Has someone perhaps have a script to build a complete GL distribution of a transaction? Or where can I start? I do not sit on a SAP system but I do have most of the tables in SQL. Thanks Christo
  2. jcw12000

    Export Table in Oracle to pipe delimited text file

    Hi Guys I have a client that works on Oracle. Now for my dumb question, what script can I send the client to extract a table with all columns into a pipe delimited txt file. Thanks
  3. jcw12000

    ERD or List of all tables and table descriptions for Account Payable module NEED UGENT

    Hi Guys I am in need of a ERD or list of tables in the AP module. Data dictionary will also help a lot. I need it to run report out of SQL. Please help.
  4. jcw12000

    BSET and BSEG

    Hi Guys I just want to make sure. I would think that if a transaction is in BSET that it will also be in BSEG as BSEG should contain all transactions. Is this correct? Thanks Christo
  5. jcw12000

    GP Remittance view as per user sees it. AP

    HI I am sitting with a issue. According to what I understand I see that a credit note will be applied to an invoice. I have used scripts from Victoria's site. It shows me that a credit was applied to 4 invoices. My PM30300 confirms this. But now if I ask the Account dept to pull me the info aka...
  6. jcw12000

    Need het on top 80 percent query

    HI I have the following data Invoiceamount ControlGroupID OriginalVendorNumber RowNumber 143605.80 221 0000000505 1 55882.80 221 0000000505 2 6630.00 221 0000000505 3 2580.00 221 0000000505 4 1289.40 221...
  7. jcw12000

    TAX Details for invoices PM

    Hi I am trying to join TAX information from TX3000 to Invoices. PM side. I see that DOCNUMBR in TX3000 sometimes have a VCH number and other RCT numbers. As I understand the RCT numbers are transactions that the source is a PO if I am correct. Does someone have a script that I can use to link...
  8. jcw12000

    Complete Invoice detail and Payment detail needed - AP

    Hi Guys I am new to the GP system. What I need is a SQL query or report that will give me all AP invoices (paid and unpaid) with all its detail incl tax and payment detail. It would be nice if I could get the corresponding GL detail of the TAX. All the detail needs to be in one line. Only...
  9. jcw12000

    TAX Table AP

    Is there a specific table that holds all TAX information for AP transactions?
  10. jcw12000

    Complete Invoice detail and Payment detail needed - AP

    HI I am very new to Accpac. I am trying to compile a "Invoice table" for a 3rd party program for reporting. What a need is basic invoice detail and the payment detail of the invoices linked. All invoices and payments for the AP side. Hope you guys understand what I need...... Where do I...

Part and Inventory Search

Back
Top