Financial - JDE1 (MOSC)

MOSC Banner

Grid upload for AR Receipt (P03B102)

edited Jul 7, 2016 5:04AM in Financial - JDE1 (MOSC) 2 commentsAnswered

Hi all,

I've been working to try to find a possible way to upload manual partial receipts in Accounts Receivable in some type of mass upload.

For example:

  • I have one receipt for a customer, for a total of 100 usd.
  • This is used to match to 2 invoices (123 and 124) which are 80 usd and 50 usd each.
  • I want to close out invoice 123 and leave invoice 123 with 30 usd open amount.

AS I know which invoices to match this amount to, I wanted to work in a spreadsheet and load the amounts at the same time I match the invoices into the receipt


P03B102 standard grid upload does not allow modification of the invoice number / doc type / Doc Company.

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 Financial 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