Sitemap

Amicuk Programming Answers

Query to show Change in Payment Terms BPs

-0001-11-30   Views:0

Advertisement

Hi All Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated Has anyone written such a Query that

Hi All
Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated
Has anyone written such a Query that they wouldn't mind sharing?
Thanks
Peter

The replay answer
Advertisement
To get the payment terms modified today you can use this query:
SELECT t.CardCode, t.GroupNum New, p.GroupNum Previous,
  t.UpdateDate,t.UserSign,u.U_Name
FROM ACRD t
  inner join ACRD p On t.CardCode=p.CardCode and t.Loginstanc-1=p.Loginstanc
  inner join OUSR u On t.UserSign=u.Internal_k
Where datediff(d,t.[UpdateDate],getdate() )=0
   and  p.[GroupNum]!=t.[GroupNum]

Go to See the other 5 answers

Query to show Change in Payment Terms BPs

Category:DefaultRelease time:-0001-11-30Views:130

Hi All Since we cannot restrict users from updating Customer Payment Terms if thay have access to BP Master Data, I would like to create a query (to set as an Alert) to show when BP Payment Terms have been updated Has anyone written such a Query that[More]

Receivables - Query of Customers, sorted by Payment Terms?

Category:DefaultRelease time:-0001-11-30Views:130

I'm looking for an easy way to run a query (through the Applications layer) of all customers, sorted by their Payment Terms (Net 30, Net 45, etc.) Any ideas?Hi Robert....... You can consider the Days of intervals as the payment temrs. For Example put[More]

Query to check BP Payment terms and Document Payment terms

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Can any one help me to create an approval query to check the BP payment terms and Document Payment terms are same or not? Normally we change our BP payment terms regularly as per the agreements between Customer and us. but when we copy any pr[More]

Query on Payment Terms

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, I need a report that will show me the payment terms for all plants in the Co codes for 1.The Accounts Payable Vendor Master 2. The Purchasing Vendor Master If the Accounts Payable Vendor Master and the Purchasing Vendor Master are always th[More]

Authorisations for Changing BP Payment Terms

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts Is there any way which I can prevent certain user changing BP Payment Terms using authorisations?  Alternately, would it be possible to write a query which shows me which users have changed Payment Terms of BPs which I can then setup as a[More]

Payment Terms fetch Issue(Plant Level) @ SRM 7.0

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts, We are currently implementing SRM 7.0 system(Classical Scenario) across regions.In one such scenario we found out that when we create a PO directly in SRM the Payment Terms is fetched correctly from the Vendor Master at Plant Level(Byp[More]

AR Invoice with Installment Payment Terms

Category:DefaultRelease time:2015-10-11Views:130

Hi to All, We have an invoice where the payment terms are based on installment. The installment is for 18 months.  Automatic cash receipts have been applied correctly for Installment 1 and Installment. Our situation is this where we want to apply an[More]

PO release in case of changes in Variance or Payment terms

Category:DefaultRelease time:2015-10-11Views:130

Dear All, In case of any changes in the PO other than the qty and rate, if we want new release to be effected for other fields tehn what is the way out. Eg. Changes have been made in the payment terms, or delivery variance (over and under) then what[More]

Payment Terms in Third Party Sales Invoice.

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, We are facing the problem in third party sales process. Suppose X is our customer and Y is our vendor, here Y is supplying the material directly to X and Y sending us the bill of entry and other documents to us, and then we create the sal[More]

Vendor  payment terms replication

Category:DefaultRelease time:2015-10-11Views:130

Hi, Vendor payment terms are not getting replicated to SRM 4.0 from ECC 5.0.We have batch jobs running for vendor replication ( new and update).When i change the payment terms  in ECC , it is  not coming to SRM.I checked in Manage BPs. Thanks for sug[More]

Vendor Payment Terms Changes - Listing?

Category:DefaultRelease time:2015-10-11Views:130

Hi SDN We are trying to track all the Vendor Payment Terms Changes done in the Vendor Master, and I was wondering if SAP offers some reports that could list, for a given time period, all the vendors that their payment terms changed, as well as what w[More]

Hot
Hello, it's my first time on the forum.I'm quite new in the apple world. Yesterday I upgraded my Iphone4 to IOS 5. The device asked me to plug it to the PC for the restore from my backup and here come problems.The restore started and after few second [More]
In Outlook you could attach a calendar or event to an email so the business associate would review and confirm the dates discussed. Is there a way to do this with iCal without being a member of MobilMe, or posting it to a server, or on a webpage? Tha [More]
When I print a web page to a pdf file, the text in the file is mostly garbled.  I have no problems in creating pdf files from MS office or other software.  I have Windows 7 Home. Any help will be appreciated. ThanksI do have Internet Explorer 9 and I [More]
Dear colleagues, I am using IDoc for maintenance of material master records. It's basic type is standard MATMAS05. When I trigger IDoc that needs to change material master record, this material master record is updated correctly, except AENAM field ( [More]
Dear All Senior's/Friends, This is Rakesh Kumar, I have learnt BW guide, and now I can able to create ODS, INFOCUBES, INFOPACKAGE..........& Bex Queries etc. My problem is this I have no experience in BW Implementation, I need a project for BW practi [More]
Hi, I need to know whether the Java stack can run without the ABAP stack. I am running a PI 7.1 system and my system is a bit low on memory. Since we use a web browser for all development work, I needed to know whether it is possible to only run the [More]
Hi, can someone please help me?! I just purchased my Toshiba Satellite Pro C650. Charged it for 16 hours, set it up and after restarting it went off and now it doesn't turn on of charge at all.Hi Remove the batter and disconnect the AC adaptor. Then [More]
OK, so Snow Leopard 10.6.8 is supposed to be preparing us for Lion by getting IPV6 right. Up until now, I've left my time capsule with IPV6 set to 'Host', so it takes care of any IPV6 stuff that comes along. As I understand it, what I should now be d [More]
I am often photomerging large sets of RAW images (8 to up 30 images at a time).  Yesterday, I photomerged 25 images (each image is about 14MB) together.  Before the photomerge ran, I had 35 GB HD space available.  After the Photomerge finished and af [More]
Hi all, I have a Blackberry Torch 9810 with OS 7. I dont know what happened but all of a sudden I am unable to send files through bluetooth. I cant see any option of bluetooth in the send options menu. I tried to deseclect port service in the bluetoo [More]