8/4/2019 Retain Age

1/19

Complex Services POs are NOT possible from the old PO forms based screens. We must

create the Complex PO from new R12 Buyer Work Center PO screens.

1. The First Step is creating a Document Style.

Navigation: Purchasing Responsibility->Set Up->Document Style.

Advances: It is the amount given Up front to supplier before any work is performed.

Retainage Rate: Rate at which the buyer company can retain (withhold) from theinvoices submitted by the supplier. Up to the maximum amount, if a maximum is

entered.

Pay Items:

Milestone: Milestone that needs to be fully complete before the associated

payment can be claimed by the contractor.

Rate: Rate of work completion. Payments for these can be claimed as units of

work are completed

Lump Sum: Amount allocated to a portion of work against which payments can

be released based on the stage of completion. Unlike milestone pay items, contractors

can report partial progress against such pay items and request payments

8/4/2019 Retain Age

2/19

2. Create Complex Services Purchase Order

Navigation: Purchasing Responsibility->Buyer Work Center->Orders

At far right of screen, next to the Create field, use drop down/LOV to choose

document style we created in Step1 and click on Go.

3.Enter Header level of PO Form, Details Like Operating unit, Supplier, SupplierSite, Pay on Receipt etc,

8/4/2019 Retain Age

3/19

4.Enter the line Information like Type, Item/Job, Description, Category etc,

8/4/2019 Retain Age

4/19

5. Add Complex Services Financing and Retainage details By Clicking on the details

Button.

8/4/2019 Retain Age

5/19

6. Add Complex Services Pay Items to Line 1

Field Values

Pay Item 1

Type Lump Sum

Description Demolishing Old Building

Price 2000

Need by Date Current date + 1 week

Pay Item 2

Type Rate

Description Ex. Days in the site

Qty 10Unit Day

Price 400 (Amount should default to 4000 based on

days and price)

Need by Date Current date + 10 days

Pay Item 3

Type Milestone

8/4/2019 Retain Age

6/19

Description Ex. Comference Room Remodel Complete

Value (%) 40

Price 4000 (should default in based on %)

Need by Date Current date + 3 weeks

7.Distributions will be Automatically Created, Observe that the Distribution for

Advance has been created.

8/4/2019 Retain Age

7/19

8. Login to Isupplier portal.

8/4/2019 Retain Age

8/19

Either we can Create Advance Invoice in Isupplier Portal or In The Payables

responsibility.

9.

8/4/2019 Retain Age

9/19

10.

8/4/2019 Retain Age

10/19

11.

8/4/2019 Retain Age

11/19

12. Create an invoice for Lumsump Amount

8/4/2019 Retain Age

12/19

The Prepayment is Automatically Applied and

8/4/2019 Retain Age

13/19

13.Create invoice for Rate Amount.

8/4/2019 Retain Age

14/19

14.

8/4/2019 Retain Age

15/19

15.Create an Invoice for Mile Stone Amount.

8/4/2019 Retain Age

16/19

16.Create a Retainage release Invoice and match it to the PO.

8/4/2019 Retain Age

17/19

17.

8/4/2019 Retain Age

18/19

Click on Release Button, Retainage Invoice distributions are created.

Technical Details:

APListh_156272_08030454_diag.html Prepayment Invoice created.

APListh_156272_08030413_diag.html

APListh_156274_08030506_diag.html Standard Invoice created for Lumpsum

Amount

APListh_156274_08030506_diag.html

APListh_156275_08030508_diag.html - Standard Invoice created for Rate work

completed.

8/4/2019 Retain Age

19/19

APListh_156275_08030508_diag.html

APListh_156276_08030510_diag.html Standard Invoice created for Mile Stone

work completed.

APListh_156276_08030510_diag.html

APListh_156277_08030510_diag.html - Retainage Release Invoice Created.

APListh_156277_08030511_diag.html

AP_INVOICE_DISTRIBUTIONS_ALL. RETAINED_INVOICE_DIST_ID

This will have the Distribution id of the Original Retained Distribution id.

AP_INVOICE_LINES_ALL.RETAINED_INVOICE_ID

This will have the Invoice id of the Original Retained Invoice id.

So if we look at the RETAINAGE RELEASE Invoice, ap_invoice_lines_all,

retained_invoice_id column will have all the retained invoice ids.