Sending Information to PeopleSoft Asset Management

This chapter provides an overview of the asset-loading process and discusses how to:

Click to jump to parent topicUnderstanding the Asset-Loading Process

This section discusses the following:

PeopleSoft Payables can be integrated with PeopleSoft Asset Management and PeopleSoft Purchasing. The interface between the applications eliminates the need for dual maintenance of receipts and vouchers and their corresponding asset data, and it provides the following benefits:

Another advantage of this interface is flexibility. You can:

PeopleSoft Payables and PeopleSoft Purchasing pass asset acquisition information to PeopleSoft Asset Management, including processing changes to assets if receivers or vouchers are modified or if subsequent receivers or vouchers are added for existing assets.

For example, PeopleSoft Payables creates new voucher accounting lines when a voucher for an asset is posted or unposted and subsequently distributes the accounting information to PeopleSoft Asset Management. Posting the voucher creates voucher accounting lines, and unposting the voucher creates reversal entries. The Payables to Assets Interface Application Engine process (INTFAPAM) distributes the information to PeopleSoft Asset Management from PeopleSoft Payables through the Load Assets Request page.

New accounting entries are also made during payment posting for discounts that are earned or lost. If the original accounting entries were asset-applicable, then the new entries are distributed to PeopleSoft Asset Management as well.

See Also

Integrating PeopleSoft Asset Management with Other Products

Click to jump to top of pageClick to jump to parent topicEligibility Criteria for Distribution to PeopleSoft Asset Management

Vouchers must meet the following conditions before you can send voucher information to PeopleSoft Asset Management:

Click to jump to top of pageClick to jump to parent topicInterface Types

This table describes the interface types for which PeopleSoft Payables sends voucher accounting entries to PeopleSoft Asset Management:

Interface Type

Criteria

Description

RET

AM_DISTRIB_STATUS = 'M'

Retirement. This interface type occurs when a voucher is unposted.

CLS

AM_DISTRIB_STATUS = 'N' and CLOSE_STATUS = 'C'

Closed. This interface type occurs when a voucher is posted that is marked for closure.

ADJ

AM_DISTRIB_STATUS = 'N' and CLOSE_STATUS <> 'C' and DST_ACCT_TYPE IN ('DSE', 'DSL', 'DSEM', 'DSLM', 'LAT')

Discount Lost/Earned. This interface type occurs when a voucher is posted with a discount earned or lost or with late charges.

Click to jump to top of pageClick to jump to parent topicDiscounts Earned or Lost

PeopleSoft Payables sends information about discounts earned or lost to PeopleSoft Asset Management so that PeopleSoft Asset Management can add or subtract the amount from the asset cost. The following examples illustrate this process.

In these scenarios, assume the following facts:

You run the Payables to Assets Interface process to send information to PeopleSoft Asset Management after voucher posting and again after payment posting. The following information is sent to record INTFC_PRE_AM after each of these posting processes.

Note. These entries are generated during each posting process and do not depend on whether the voucher is paid before or after voucher posting.

Example of Accounting at Net

This example shows accounting at net:

Example of Accounting at Gross

This example shows accounting at gross:

Note. The system does not track rebates lost or taken, and these are not sent to PeopleSoft Asset Management.

Click to jump to top of pageClick to jump to parent topicTechnical Details of the Payables to Assets Interface Process

The Payables to Assets Interface process selects all voucher accounting lines with these values:

Field

Description

Value

Definition

VCHR_ACCTG_LINE.ASSET_FLG

Asset.

Y

Yes.

Note. The value must be Y for each accounting entry to be distributed to PeopleSoft Asset Management.

VCHR_ACCTG_LINE.AM_DISTRIB_STATUS

Asset Management distribution status.

N or M

N (not yet distributed to asset management): The Voucher Posting process creates voucher accounting lines with this status, which indicates that the accounting lines have been posted.

M (modified): The Voucher Unposting process creates reversal entries with this status, which indicates that the accounting lines have been unposted.

VCHR_ACCTG_LINE. POST_STATUS_AP

Account Payable Posting Status

P

Posted.

VCHR_ACCTG_LINE.PRIMARY_LEDGER

Primary ledger.

Y

Yes.

Note. The value must be Y for each accounting entry to be distributed to PeopleSoft Asset Management.

Note. For vouchers with receiving required, only vouchers with fully matched receivers are sent to PeopleSoft Asset Management.

The Payables to Assets Interface process copies the following information from the voucher distribution level in PeopleSoft Payables to the preinterface table (INTFC_PRE_AM) in PeopleSoft Asset Management:

Description

Field Name

Transaction date.

VOUCHER.INVOICE_DT

Accounting date.

VCHR_ACCTG_LINE.ACCOUNTING_DT

Purchase order (PO) keys, if the voucher is a PO voucher:

 

• PO business unit.

VCHR_ACCTG_LINE.BUSINESS_UNIT_PO

• PO ID.

VCHR_ACCTG_LINE.PO_ID

• PO line number.

VCHR_ACCTG_LINE.LINE_NBR

• PO schedule number.

VCHR_ACCTG_LINE.SCHED_NBR

• PO distribution line number.

VCHR_ACCTG_LINE.PO_DIST_LINE_NUM

Receiver keys:

 

• Receiver business unit.

VCHR_ACCTG_LINE.BUSINESS_UNIT_RECV

• Receiver ID.

VCHR_ACCTG_LINE.RECEIVER_ID

• Receiver line number.

VCHR_ACCTG_LINE.RECV_LN_NBR

• Receiver ship sequence number.

VCHR_ACCTG_LINE.RECV_SHIP_SEQ_NBR

• Receiver distribution line number.

VCHR_ACCTG_LINE.RECV_DIST_LINE_NUM

Payables business unit.

VCHR_ACCTG_LINE.BUSINESS_UNIT

Voucher ID.

VCHR_ACCTG_LINE.VOUCHER_ID

Voucher line number.

VCHR_ACCTG_LINE.VOUCHER_LINE_NUM

Voucher distribution line number.

VCHR_ACCTG_LINE.DISTRIB_LINE_NUM

Asset Management business unit.

VCHR_ACCTG_LINE.BUSINESS_UNIT_AM

Asset ID.

VCHR_ACCTG_LINE.ASSET_ID

Profile ID.

VCHR_ACCTG_LINE.PROFILE_ID

Cost type.

VCHR_ACCTG_LINE.COST_TYPE

ChartFields.

Note. Available ChartFields include ACCOUNT, ALTACCT, BOOK_CODE, ADJUST_TYPE, CATEGORY, ACTIVITY, SCENARIO, STATISTICS_TBL, OPERATING_UNIT, DEPTID, PRODUCT, PROJECT_ID, FUND_CODE, CLASS_FLD, PROGRAM_CD, BUDGET_REF, AFFILIATE, AFFILIATE_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3.

VCHR_ACCTG_LINE."ChartField"

Note. Because ChartFields are configurable, they are mapped to their respective ChartField name. For example, department ID is mapped to VCHR_ACCTG_LINE.DEPTID.

Description.

VCHR_ACCTG_LINE.DESCR

Vendor ID.

VOUCHER.VENDOR_ID

Voucher quantity.

VCHR_ACCTG_LINE.QTY_VCHR

Cost in General Ledger business unit's base currency.

MONETARY_AMOUNT + FREIGHT_AMT_NP_BSE + MISC_AMT_NP_BSE + SALETX_AMT_NP_BSE + USETAX_AMT_NP_BSE + DSCNT_AMT_BSE.

If VOUCHER.VAT_NRCVR_PRO_FLG = 'N', then MONETARY_AMOUNT + FREIGHT_AMT_NP_BSE + MISC_AMT_NP_BSE + SALETX_AMT_NP_BSE + USETAX_AMT_NP_BSE + DSCNT_AMT_BSE + (A.VAT_INV_AMT_BSE + A.VAT_NONINV_AMT_BSE - A.VAT_RCVRY_AMT_BSE - A.VAT_REBATE_AMT_BSE). Note that all fields are from VCHR_ACCTG_LINE.

Note. Monetary amount is calculated as follows: Merchandise Amount + Sales Tax (if prorating sales tax) + Use Tax (if prorating use tax) + Freight (if prorating freight) + Miscellaneous Charges + Nonrecoverable Prorated VAT − Discount (if accounting at net).

Transaction cost in transaction currency.

FOREIGN_AMOUNT + FREIGHT_AMT_NP + MISC_AMT_NP + SALETX_AMT_NP + USETAX_AMT_NP + DSCNT_AMT.

If VOUCHER.VAT_NRCVR_PRO_FLG = 'N' then TXN_COST = FOREIGN_AMOUNT + FREIGHT_AMT_NP + MISC_AMT_NP + SALETX_AMT_NP + USETAX_AMT_NP + DSCNT_AMT + (VAT_INV_AMT + VAT_NONINV_AMT − VAT_RCVRY_AMT - VAT_REBATE_AMT). Note that all fields are from VCHR_ACCTG_LINE.

Sales tax amount in General Ledger business unit's base currency.

SALETX_AMT_BSE + SALETX_AMT_NP_BSE

Sales tax code.

VOUCHER.SALETX_CD

Use tax amount in General Ledger business unit's base currency.

USETAX_AMT_BSE + USETAX_AMT_NP_BSE

Use tax code.

VOUCHER.USETAX_CD

Freight amount in General Ledger business unit's base currency.

FREIGHT_AMT_BSE + FREIGHT_AMT_NP_BSE

Note. If VOUCHER.FRGHT_PRORATE_FLG is 'N', FREIGHT_AMT_NP_BSE is not 0 while FREIGHT_AMT_BSE is 0.

Discount amount.

VCHR_ACCTG_LINE.DSCNT_AMT

Invoice ID.

VOUCHER.INVOICE_ID

General Ledger business unit's base currency code.

VCHR_ACCTG_LINE.CURRENCY_CD

Transaction currency code.

VCHR_ACCTG_LINE.FOREIGN_CURRENCY

Project Costing business unit.

VCHR_ACCTG_LINE.BUSINESS_UNIT_PC

Activity ID.

VCHR_ACCTG_LINE.ACTIVITY_ID

Analysis type.

VCHR_ACCTG_LINE.ANALYSIS_TYPE

Resource type.

VCHR_ACCTG_LINE.RESOURCE_TYPE

Resource category.

VCHR_ACCTG_LINE.RESOURCE_CATEGORY

Resource subcategory.

VCHR_ACCTG_LINE.RESOURCE_SUB_CAT

Merchandise amount.

VCHR_ACCTG_LINE.MERCH_AMT_VSE

VAT invoice amount.

VCHR_ACCTG_LINE.VAT_INV_AMT_BSE

VAT recovery amount.

VCHR_ACCTG_LINE.VAT_RCVRY_AMT_BSE

VAT nonrecoverable amount.

VAT_INV_AMT_BSE + VAT_NONINV_AMT_BSE -.VAT_RCVRY_AMT_BSE − VAT_REBATE_AMT_BSE. Note that all fields are from VCHR_ACCTG_LINE.

Note. After the system copies the voucher information to the Pre-interface table, the Payables to Assets Interface process sets the AM_DISTRIB_STATUS field on the voucher accounting line for all the selected vouchers to D (distributed).

Once the voucher has been preloaded into the Pre-interface table using the Payables to Assets Interface process, you can view the information on the Load Preview - Pre-AM - Pre-AM 1 page.

Next, you complete the asset-loading process by running the Payables/Purchasing Interface Application Engine process (AMPS1000), which automatically calls the Transaction Loader Application Engine process (AMIF1000). The Payables/Purchasing Interface process creates interface IDs. The Transaction Loader process uses the interface IDs and creates an acquisition row for each asset. After you run the two processes, you can view the asset cost on the Asset Cost Adjust/Transfer page.

See Also

Integrating PeopleSoft Asset Management with Other Products

Adjusting, Transferring, and Evaluating Assets

Defining Cross-Application User Preferences

Creating Vouchers Online

Click to jump to top of pageClick to jump to parent topicReturn to Vendor Transaction Processing

Defined RTV adjustment options determine whether the PeopleSoft Payables or Purchasing applications generate asset retirement transactions that are sent to PeopleSoft Asset Management for processing (INTFC_PRE_AM). You can specify these adjustment options as defaults at the PeopleSoft Payables business unit level (using the Payables Definition - Voucher Build page), which you can override at the Purchasing RTV voucher defaults level (using the RTV Defaults page).

Note. PeopleSoft Purchasing's RTV Reconciliation Application Engine process (PO_RTVRECON) processes RTV information for use in PeopleSoft Asset Management only when a PeopleSoft Payables adjustment voucher will not be created.

See Also

Setting Voucher Build Options

Setting Up RTV Processing Options

Entering RTV Defaults

Click to jump to parent topicCreating Asset-Applicable Vouchers

This section provides an overview of asset-applicable vouchers and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Asset-Applicable Vouchers

You create asset-applicable vouchers on the Invoice Information page. If the voucher is created by copying from a purchase order or receipt, the asset information is also copied. If asset information was not entered on the purchase order or receipt, then it must be entered manually during voucher creation. Regardless of how you create the voucher, you must access the Assets tab to make the voucher asset-applicable.

You can also create asset-applicable vouchers by entering data on the Quick Invoice page.

Note. When a voucher is created by copying from another voucher or template voucher, the asset information is also copied from the source voucher.

See Also

Creating Vouchers Online

Using Quick Invoices

Click to jump to top of pageClick to jump to parent topicPages Used to Create Asset-Applicable Vouchers

Page Name

Definition Name

Navigation

Usage

Invoice Information

VCHR_EXPRESS1

Accounts Payable, Vouchers, Add/Update, Regular Entry, Invoice Information

Enter asset information on an invoice and create asset-applicable vouchers.

Quick Invoice

VCHR_HEADER_QV

Accounts Payable, Vouchers, Add/Update, Quick Invoice Entry, Quick Invoice

Select the Assets tab for the distribution line using the complete template.

Enter asset information on a quick invoice and create asset-applicable vouchers.

Click to jump to top of pageClick to jump to parent topicUsing the Assets Tab to Create Asset-Applicable Vouchers

Access the Assets tab on the Distribution Lines grid on the Invoice Information page or the Quick Invoice page using the complete template. Some of the fields described below are available only on the Invoice Information page.

Use One Asset ID

Select to assign a single asset ID to multiple distribution lines. This field appears in the Invoice Lines group box and does not appear for quick invoices.

Quantity

Enter a quantity on the GL Chart (general ledger ChartFields) tab and on the parent invoice line for each asset-applicable distribution line. The total of all quantities on the distribution lines must equal the quantity entered on the parent invoice line.

Asset

Select to make the distribution line asset applicable. This field does not appear for quick invoices.

Business Unit

Enter the PeopleSoft Asset Management business unit to which the asset is distributed. This field is required.

Profile ID

Enter the profile ID category to which the asset is assigned. This field is required.

Asset ID

Enter either an asset ID or leave the value as NEXT so that the system generates the asset ID after you send the asset information to PeopleSoft Asset Management. The default field value is NEXT.

If you enter an existing asset ID, the costs for the subsequent voucher are added to the asset ID entered on the page.

Sequence Number

Enter a sequence number to indicate an asset grouping of voucher distribution lines, if you have accepted the default asset ID value of NEXT. Leave this field blank if you entered a known asset ID. If the asset ID is NEXT and the Sequence Number field is blank, the system generates a unique number. This field does not appear for quick invoices.

Cost Type

Enter the cost type for the asset. Options are:

A: Allowance for ADV Depr (advanced depreciation).

C: Cost type.

G: Grant reimbursements.

I: Impairment loss.

M: Margin.

P: Scrap on asset.

R: Revaluation.

S: Sale of assets.

V: Reserve for ADV Depr (advanced depreciation).

W: Depr. write-off (depreciation write-off).

X: Revaluation reversal.

Y: Impairment reversal.

Note. If you copy the voucher information from the purchase order or receiver, these fields might be populated with information from the purchase order or receiver line.

Click to jump to top of pageClick to jump to parent topicCopying Asset-Applicable Vouchers from Purchase Orders and Receivers

If the voucher data you send to PeopleSoft Asset Management relates to previous assets that are created in PeopleSoft Purchasing, the voucher must be matched either fully or partially to the purchase order and receiver. When you create vouchers for asset-related items, copy the voucher information from the receiver. The Payables to Assets Interface process will only send receiver information to PeopleSoft Asset Management if the receiver information exists on the voucher.

Note. The Receiver Interface Push Application Engine process (PO_RECVPUSH) must be run to send receiver information related to a purchase order to PeopleSoft Asset Management. Both the Receiver Interface Push process and the Payables to Assets Interface process must be run when the voucher is created from a PO.

If asset information has been specified on a purchase order or receiver, you can:

The Matching process attempts to find receiver information for a voucher that contains only purchase order information. However, it can only do so if there is a one-to-one relationship between the purchase order and the receiver. Multiple receipts that sum to the voucher total can be associated by the Matching process. Partial receipts must be associated manually. If there are multiple receivers for the purchase order, the Payables to Assets Interface process obtains the receiver information from the PO_LINE_MATCHED table, which is populated by the Matching process.

See Also

Processing PeopleSoft Asset Management, Purchasing, and Payables Transactions

Using the Receiver Interface Push Application Engine Process (PO_RECVPUSH)

Click to jump to parent topicSending Voucher Information to PeopleSoft Asset Management

This section discusses how to run the Payables to Assets Interface process.

Click to jump to top of pageClick to jump to parent topicPages Used to Send Voucher Information to PeopleSoft Asset Management

Page Name

Definition Name

Navigation

Usage

Load Assets Request

INTFC_APAM_RQST

Accounts Payable, Batch Processes, Extracts and Loads, Load Assets Request

Request a run of the Payables to Assets Interface Application Engine process (INTFAPAM), which copies the voucher information from the selected vouchers, populates the Pre-interface table in PeopleSoft Asset Management, and updates the Asset Management distribution status on the distribution lines for the selected vouchers to be distributed.

Click to jump to top of pageClick to jump to parent topicRunning the Payables to Assets Interface Process

Access the Load Assets Request page (Accounts Payable, Batch Processes, Extracts and Loads, Load Assets Request).

Interface Asset Information

Select to preview the data on the Pre-Interface Table (Pre-AM01) using the Load Preview - Pre-AM page.

Process Option

Select the process option. Options are:

  • Process All Business Units.

  • Process Business Unit.

  • Process Control Group.

  • Process Origin.

  • Process Vendor.

  • Process Voucher.

Depending on the process option that you select, different fields in the group box become available for entry. If you select the process option Process All Business Units, no additional information is required. However, each of the other options requires additional parameters such as a business unit, voucher ID, group, vendor ID, origin, or buying agreement ID.

If you specify a vendor ID or origin, you also need to enter the associated setID.

See Also

Previewing Data in the Loader Tables