E1: 41: New Application that Allows a Join View of F41181 and F4118 (Doc ID 2174820.1)

Last updated on AUGUST 08, 2017

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Container Management standard has two basic applications: Container Transactions (P41181) and Billings Consultation Container (P4118).

The P41181 allows consult all shipments and pallets returns have been made with each client (F41181 table).

The application P4118 allows us to see all the billings of pallets which have made to a customer (F4118).

The business, in order to know the total debt of a customer has to consult both tables so; Customer is requesting a new application, to have in a single query all the transactions of every container for a particular customer or parent company (inputs, outputs and billings).

This application would allow users to consult these two tables (F41181, F4118) simultaneously

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms