Distribution - JDE1 (MOSC)

MOSC Banner

how to look up base and advance price and bring them to excel file

edited Oct 21, 2018 5:01AM in Distribution - JDE1 (MOSC) 1 commentAnswered

Hi,

we are using JDE 9.0 and currently we are having the P4210 cancel lines at order-entry if there is not enough availability of an item.  These lines go to a 980/999 status – but the system does not pull in any pricing into the F4211 table. Is there any E1 report that will pull these records and then do a price lookup to pull in the price associated with the Advanced Pricing setup for the customer/item using the Price Effective Date on the F4211 record?

IF I go for custom report I noticed, to look up base price I need item number and customer group, I can take customer group from customer master but in F03012 table we have stored the customer group as string (ex. RTL = retail customer) but the base price table shows that value in the form of numbers (183), so How can I map these two fields? and how the conversion from string to number is being done? where I can see those?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 Distribution Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center