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
I just got my Portege M800 weeks ago and frankly speaking, this model has been giving me much trouble. Earlier it is the heat problem at the palm rest and there is no solution to it. Now I am facing another issue with the fingerprint login. I am runn [More]
Does anyone have experience with this problem? Does anyone have a solution for this problem?Hi Ernie, I've gone thru my applications and do not see anything that appears to be an enhancement app. I previously had Missing Synch installed (since remove [More]
Where can I find a live chat with a representative? I'm about fed up with Verizon. Their're about as bad as AT&T!!!When you go to like look at a phone section online it always pops up live chat. Anywhere on the main page it will pop up if your there [More]
I purchased an upgrade for XI standard, installed it, have restarted the computer (although not necessary), I am clicking on the application "Adobe Acrobat XI Standard", there is a message saying "Serial valid, but a qualifying product coul [More]
Help! I have an iphone 4, which doesn't offer the "reduce motion" effect and iOS 7 is making me feel sick!!If you have an iPhone 4, then you don't have the "motion" feature to begin with or dynamic wallpaper.Read other 5 answers [More]
String cat = name.substring(0, name.lastIndexOf('\\')); String cat1 = cat.substring(cat.lastIndexOf('\\')+1)); Can anyone explain to be the difference between the 2? thanks.either look at this http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String. [More]
I think that Oracle National Language Support is quite confusing. How can I easily change NLS parameters for SQL Developer (for all connections) to match exactly those that my database is using?Hello, SELECT 5/8 x FROM dual;F9 -> 0.625 Change decimal [More]
I upgraded to 10.6.6, and now I find in "accounts" a user called "postgres" that I did not add. What is this?Hello ! The user postgres belongs to the database PostgreSQL. As you installed the the .dmg file with PostgreSQL you entered y [More]
I have a Imac G5 1.9ghz powerPC, 1 GB ddr2 sdram, version 10.5.8 But i have issues with it, it has white lines going from top to bottom or after couple of minutes the whole screen is full of lines So i thought reinstalling os x will help anyone will [More]
Why team not helping me? Problem is that my set USB port out of Order. I to update my nokia n95 v 35.0.002 10/11/2009 RM 159 Nokia N95 (170.1) not 8gb. sir I need device Mgr. Profile for nokia N95i DETAIL V.35.0.002 10.11.2009 RM-159 Nokia N95 (17.01 [More]