Financial - JDE1 (MOSC)

MOSC Banner

E1: 09: Need link F03B11 & F0911 in order to fetch DDJ for each AE row

edited Oct 24, 2016 2:49AM in Financial - JDE1 (MOSC) 3 commentsAnswered

Hello,

Users need to insert Due Date of customer invoices (F03B11.DDJ) in GL outbound interface file, to be extracted from F0911. So, the question is how to link AE record in F0911 with related invoice in F03B11, in order to select DDJ?

In our case, we have 2 doc types: RI & FI with separated NN counters. Below an example with 2 invoices with differents doc type, having same# and same GL date.

...

Except ''FI 16000015" and "RI 16000015" (in yellow color) located in field Explanation Alpha Name (F0911.EXA), we didn't find another link or criteria to be used to fetch the appropriate AE rows of each invoice.

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