Distribution - JDE1 (MOSC)

MOSC Banner

As-of / cumulative of F43121 (receipt) report

Hi Experts,


Is these any report that can show us the total value of receipt (F43121) qty and amount per period like F41112 (as-of) table?

In example :

PO 123 order qty 10 with amount 100 order date 01/01/21

GLDate 02/02/21 -> receipt qty 7 with amount 70, open qty = 3, open amount = 30

GLDate 13/02/21 -> receipt qty 1 with amount 10, open qty = 2, open amount = 20

GLDate 05/03/21 -> receipt qty 2 with amount 20, open qty = 0, open amount = 0


So, on 06/03/21 I run the as-of receipt report run, I need the output is :


I need this report from F43121. If I use the F0911 table, I can't know what PO and line number for the landed cost transaction.

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