My Oracle Support Banner

EeS: Merchandise Amt Incorrect After Saving Self Service Invoice Created From Packing Slip with Multiple Distribution Lines (Doc ID 3037512.1)

Last updated on JULY 28, 2024

Applies to:

PeopleSoft Enterprise FIN eSettlements - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When creating a Self-Service Invoice from a Packing Slip that has 2 Distribution lines associated to a Receipt line, once the Receiver is copied onto the Self-Service Invoice, the Merchandise Amts appearing under the Accounting Lines section are correct. However, once the Self-Service Invoice is saved and re-displayed, the Merchandise Amts are incorrect. The Unit Price times Quantity no longer equals the Merchandise Amt for each Distribution Line.

STEPS TO REPLICATE
1. Purchasing > Purchase Orders > Add/Update POs
2. Purchase Order page, add a 1 line PO with 2 distribution lines
    a. Business Unit = XXXXX
    b. Supplier ID = YYYYYYYYYY
    c. Receiving Required
    d. PO Qty = 10
    e. Price = 65.00
    f. Click the Schedule icon
    g. Schedules page, click the Distributions/ChartFields icon
    h. Distributions for Schedule 1 page
    i. Dist 1 / Percent = 50.00 / PO Qty = 5 / Merchandise Amount = 325.00
    j. Dist 2 / Percent = 50.00 / PO Qty = 5 / Merchandise Amount = 325.00
    k. Purchase Order page, click Dispatch to dispatch the PO
3. Purchasing > Receipts > Add/Update Receipts
    a. Business Unit = XXXXX
    b. Copy the PO from Step 2 onto the Receiver
    c. Links and Status tab, click the Distrib icon
    d. Receipt Distributions page
    e. Line 1 / Merchandise Amt = 325.00
    f. Line 2 / Merchandise Amt = 325.00
4. eSettlements > Enter Self Service Invoice
5. Create a Self Service Invoice, click the Create Invoice link
6. Create Invoice / Invoice Entry page
    a. Supplier = YYYYYYYYYY
    b. Buyer = XXXXX
    c. Click Copy from a Packing Slip
    d. Look Up a Packing Slip page
    e. Display the Receipt created from Step 4
    f. Click Copy To Invoice
    g. Receipt copied onto the Invoice
    h. Additional Information tab, click the Accounting icon
    i. Accounting Lines section
    j. Dist #1 / Quantity = 5.0 / Merchandise Amt = 325.00, which is correct
    k. Dist #2 / Quantity = 5.0 / Merchandise Amt = 325.00, which is correct
    l. Click Save and Submit
    m. Invoice successfully saved
7. eSettlements > Enter Self Service Invoice
8. View the Self Service Invoice, click the View Invoice link
9. View Invoice page, select Self Service Invoice created in Step 7
10. Create Invoice / Invoice Entry page
      a. Additional Information tab, click the Accounting icon
      b. Accounting Lines section
      c. Dist #1 / Quantity = 5.0 / Merchandise Amt = 162.50, which is incorrect. (Unit Price of $65.00 x Quantity of 5 = $325.00 and not $162.50)
      d. Dist #2 / Quantity = 5.0 / Merchandise Amt = 162.50, which is incorrect. (Unit Price of $65.00 x Quantity of 5 = $325.00 and not $162.50)

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.