- 3 Posts
- 26 Views
Advance Price Business Function
Hi,
I have a requirement in my custom NER business function to get Advance Price for an item.
I will appreciate if you let me know which business function I should call to get an advance price.
Any HELP will be appreciated.
Thanks,
SP
@Sajid Patel If you do not receive the technical details you're looking for, you might want to consider reposting your question in the My Oracle Support Community at https://community.oracle.com/community/support/jdedwards_enterpriseone/distribution_-_jde1
Good luck!
-Jim
@Sajid Patel You won't like the answer, but the underlying function pulls in so many parameters from the order/vendor/item to cover all Advanced Pricing rules that it is virtually impossible to use in complex environments. Even P4074 (Price and Availability) opens a sales order in cache, then uses all the available fields to call the underlying business function. You can check that program out and found the underlying business function.
Again, if you have any complexity in your Advanced Pricing rules at all, you will find that you need 20 - 30 parameters passed into the call. On ours we got up to 50 and gave up.
A better route is Orchestrator on P4074.