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
How can I sync my old Ipod without loosing everything? I dont remember my old password and dont have the same email. I have many pics stored on there of many trips we took over the years and songs as well please help...What are you wanting to do exac [More]
I read in another post that you cant use mapviewer unless you have an oracle database. Here is my confusion. The mapviewer product comes with OBIEE 11g, Correct? If I use Google Maps, and load the map information into an SQL data base, why wouldnt I [More]
Hi, I am new to the Oracle DB and preparing for the first test of the OCA. If there is a SQL statement that is parsing repeatly, should I use shared pool advisor or SGA advisor? thanks a lot for helpuser592813 wrote: Hi, I am new to the Oracle DB and [More]
Hi all, I have a problem to solve. I have an A matrix (col = 5, row = 5). If I want to calculate A power 100 by uusing method C=A*A*A*.....*A 100 times. What I should use and write in Java program. This is a fixed matrix. Any one could help, please h [More]
during install I get an error 1402 could not open key.  I ahve tried to install as administrator.  Running Windows 7 64 bit.  Help, anyone...thanksHi drysdale, which model do you use excatly? e.g. 4294-DXG? Follow @LenovoForums on Twitter! Try the fo [More]
Is HTMLDB appllication on http://htmldb.oracle.com backed up daily? Or is it the responsibility of the developer to backup the data. I was able to create a export of the application and the tables easily. However I couldn't find anything that would e [More]
I have a tri fold brochure that I've created. Prints great when two sided.  However, I need each part of the tri fold to be an individual page (will be 6 pages total). Is there a way I can do this withing InDesign so I don't lose quality? This is how [More]
Hi, I need to migrate data off 1 storage-subsystem and onto another, both storage-subsystems reside in separate fabrics. Background: 2 separately administered fabrics to be consolidated in some way. current layout:                  fabric-1           [More]
Opening a Safari window recently I got a message from an unknown source that somebodu wanted to become my sexbuddy. I was supposed to OK it which of course I didn't . Meanwhile all my functions in Safari were frozen. The only thing that worked was a [More]
Dear gurus: when i use T-code MIGO doing goods-receipt against Inbound delivery, the total goods movement status don't changed. i tryed VL32N to do goods receipt, and the status changed. how can i do to make the status change when i receive goods in [More]