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
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 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...
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...
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 site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.