Distribution - JDE1 (MOSC)

MOSC Banner

Sales order: Address overridden

edited Nov 21, 2019 12:19PM in Distribution - JDE1 (MOSC) 2 commentsAnswered ✓

Is there a field on the F4201 or the F4211 that says the order address has been overridden? I realize that the overridden info is in the F4006, but is there a flag on the F4201 or the F4211 that says "this order has its address overridden" but  "this order does NOT have its address overridden".

I'm writing a query or two to pull sales data for tax purposes. I can pull orders that have their address overridden, linking the F4211 with the F4006 and that works fine.

But I also need to pull the orders for where the address has NOT been overridden. I need to somehow be able to exclude the ones pulled in that first query to not duplicate. 

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center