Best Of
Re: Is there a way to calculate a percent discount on a purchase order?
Hi Nick,
Thanks for the info and documentation. I tested and was able to apply a 5% discount to each PO line. But there's nothing on the online PO itself that indicates a price adjustment was made, except by drilling down into the Schedule for each line and clicking on the Price Adjustment icon.
There's also nothing on the printed copy of the PO. It just shows the adjusted prices, without any mention of an adjustment being applied or what the original base prices were.
It also will apply the adjustment to every PO that is created from the contract when we only want it to apply to POs over a specific dollar amount.
What I'm looking for is how to apply a 5% discount to POs over $300. Is there a way to do that? I don't think there is an automatic way for that to happen but wanted to confirm. It seems my only option is to manually add a line onto the PO for a negative dollar amount.
Re: Adding multiple email recipients CreateRequest of Outbound Communications Manager BS
Hi @Ameen Dehaliah,
Okay, I have read again your request.
we have a workflow (Step: BS.Outbound Communications Manager | Method.CreateRequest) where we dynamically select the email recipient depending of the project status and overwrite the recipient from email template (Recipient Group), either the approver or the owner.
For implementing you have to use the CreateRequest method parameter "TestAddress: Recipient address (for the To line) to use for testing. This address overrides all other addresses". See .
I hope, it helps. You can contact me if you have any question. And yes, it works, i.e., the recipient group is overwritten.
Regards,
Jose Luis
Re: ODACLI configure-dataguard fails around step 7 Restore missing archivelog (Primary Site)
I don't think there's any workaround on the old version, at least using the oda commands.
You can configure it using dgmgrl on that version though.
Re: Script see who added a responsibility or removed end date of responsibility to user
Oops, in the query
ug.last_updated_by
should be
ug.last_update_date
Apologies for that, was typing along and wrote the wrong thing.
Thanks,
J
Re: Script see who added a responsibility or removed end date of responsibility to user
Hi Linda,
This query should work. It will prompt for the user name and the responsibility name Be aware that it can only show who last updated it. So if the responsibility has been taken away again, you will see the person who took it away.
select u.user_name, t.responsibility_name, ug.start_date access_began, ug.end_date access_ends
, ug.last_updated_by access_change_date, uc.user_name access_updated_by
from apps.fnd_user_resp_groups_all ug, apps.fnd_responsibility_tl t
, apps.fnd_user u, apps.fnd_responsibility r, apps.fnd_user uc
where nvl(ug.end_date,sysdate+1) > sysdate -- user has the responsibility as of today
and nvl(r.end_date,sysdate+1) > sysdate -- responsibility itself is not end-dated as of today
and nvl(u.end_date,sysdate+1) > sysdate -- user is not end-dated as of today
and ug.responsibility_id = t.responsibility_id
and ug.responsibility_application_id = t.application_id
and t.responsibility_id = r.responsibility_id
and t.application_id = r.application_id
and ug.user_id = u.user_id
and uc.user_id = ug.last_updated_by
and u.user_name = '&USER_NAME'
and t.responsibility_name = '&RESPONSIBILITY'
If this works, please check Yes where it asks if this answers the question.
Thanks,
J
Re: AR WorkCenter - Regular Deposit Results
Thank you so much for your kind and prompt response, Pere; I will definitely add this on the Ideas lab.
Have an excellent day!
Maty
Re: Why Can't PO matched Invoice Distribution charge account be updated, Once the AP posted to GL and th
Hi @User_5RRJX ,
Please refer
R12: Invoice and Invoice Distribution Adjustment Charts - Explains what Fields can be Adjusted on an Invoice and when the System Prevents Update (Doc ID 1300685.1)
Thank You,
Anees
Re: AR WorkCenter - Regular Deposit Results
Hello @FIN_USER_7 ,
I hope all is well with you over there ;o)
Thanks for your latest post in the PeopleSoft Financial Management Community!!
Having reviewed your comments, I am assuming that you are talking about the below Entered Date column:
Note that the Regular Deposit within the Links > Payments section from Fluid Receivables WorkCenter is basically pointing to the Regular Deposit search page under the below navigation path:
- Accounts Receivable > Payments > Online Payments > Regular Deposit
The Entered Date column has been listed in the search results for many releases now. Adding the Accounting Date, while a valid point, would be an Enhancement Request. I would suggest you raise this same post into the Receivables Ideas Lab site, so it can be considered by the Strategy and Development teams for future FSCM 9.2 PUM Images.
The Search Record behind the Regular Deposit page within the Component PAYMENT_ENTRY is based on DEPOSIT_NP_VW (Deposits - Not Posted). You will see the fields within this View include ENTRY_DT. If you wish to have the Accounting Date, you would need to customize this View to include/list ACCOUNTING_DT field as well.
I hope that the information provided has clarified all your doubts. Should you have additional related questions, do not hesitate letting us know. On the contrary, if all your queries, and doubts have been successfully addressed, please make sure to mark 'YES' on the 'Did this answer the question? Yes-No' link. This will enable other Community Users to quickly identify the solution suggested, and see that this post has been successfully
answered.
Have an excellent day!
Pere Taulé




