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 TouchToneTommy 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. 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

    Need het on top 80 percent query

    Hi Guys Can someone please look at the code and see if you can optimize it. When I run the code I use 98% of my server and it takes forever DECLARE @_Inv2 AS TABLE( CID varchar(25) not null, VID varchar(25) not null, INVID nvarchar(255) not null, Amt money not null) INSERT INTO...
  5. 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
  6. jcw12000

    GP Remittance view as per user sees it. AP

    What data is stored in PM80500?
  7. jcw12000

    GP Remittance view as per user sees it. AP

    Would I use the doc type in PM30200 to know if the transaction is pos of neg? What doc types is pos and which is neg?
  8. jcw12000

    GP Remittance view as per user sees it. AP

    I am just waiting for confirmation but I think they are using a Report per vendor per payment date. Seems like the PayablesTransactions report/view
  9. jcw12000

    GP Remittance view as per user sees it. AP

    Yes I need to know how the data gets on this report, I spoke to the account dept and they will write down the steps for me as soon as they have time. The lady told me its a Creditors recon report but she will write don the steps. I dont know if Creditors recon gives you an idea?
  10. jcw12000

    GP Remittance view as per user sees it. AP

    I dont know what report is used. This is from the accounts dept. What data out of the tables would you need?
  11. jcw12000

    GP Remittance view as per user sees it. AP

    I forgot to add. The 3 transaction that has marks next to it is the transactions in question
  12. jcw12000

    GP Remittance view as per user sees it. AP

    I do understand that. Please see attachment. How is this possible. I see the data in the tables 100% but when this historical Remittance was printed the credit note is on it. http://www.mediafire.com/download.php?4796dca4zrwyu3d
  13. 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...
  14. jcw12000

    Need het on top 80 percent query

    Ignore above post. Posted wrong query but the above query works for 80 /20 percent on total data set and not per VID 80/20 percent
  15. jcw12000

    Need het on top 80 percent query

    Thanks. I modified your script a bit to improve performance. The data set that I am using is a bit big. Took query time from 3 hours down to 43min DECLARE @_Inv2 AS TABLE( CID varchar(25) not null, VID varchar(25) not null, INVID nvarchar(255) not null, Amt money not null) INSERT INTO...
  16. jcw12000

    Need het on top 80 percent query

    Does someone perhaps have a script that can help me. I am not very clued up on WHILE LOOPS.
  17. jcw12000

    Need het on top 80 percent query

    SET ANSI_WARNINGS OFF SET ARITHABORT off ;with cte as ( SELECT ROW_NUMBER() OVER( PARTITION BY [OriginalVendorNumber],[ControlGroupID]ORDER BY Invoiceamount DESC) as rn,sum(Invoiceamount) over (PARTITION BY [OriginalVendorNumber],[ControlGroupID] ) as totalinvamt,* FROM Step1_Top80Fulltest )...
  18. 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...
  19. jcw12000

    TAX Details for invoices PM

    This script will this give me all the GL transaction?
  20. jcw12000

    TAX Details for invoices PM

    If I could just get a script that has all the TAX GL info with a voucher number as per PM table

Part and Inventory Search

Back
Top