Search results for query: *

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

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

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.

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

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

What data is stored in PM80500?

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?

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

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?

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

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

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

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

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

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

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

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

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

This script will this give me all the GL transaction?

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