This chapter discusses how to:
(USF) Refer delinquent items to the Debt Management Service (DMS).
(USF) Submit transactions between agencies using the Intra-Governmental Payment and Collection System (IPAC).
(USF) Reclassify receivables accounting entries, direct journal accounting entries, and open items.
(USF) Track memo status changes.
Write off by ChartFields.
(USF) Generate the Receivables Due From the Public report.
Generate the 1099-C report.
(USF) Create federal customer statements.
This section provides an overview of the delinquent debt referral process, lists prerequisites and common elements, and discusses how to:
Select items for referral.
Create a DMS referral file.
Create a debt adjustment file.
Process DMS receipts.
The Debt Collection Improvement Act (DCIA) requires that any non-tax debt or claim owed to the United States that has been delinquent for a period of 180 days be turned over to the DMS of the U.S. Department of Treasury for appropriate action. This is known as cross-servicing. Debts less than 180 days delinquent can be voluntarily submitted to private collection agencies and agency Debt Collection Centers (DCCs). These are referred to as pass-through debts.
Using the PeopleSoft Receivables Delinquent Accounts feature, you can:
Enter DMS information for individual items on the DMS Information page.
Select items for referral.
Run the DMS Referral Application Engine process (AR_DMSREFRRL) to create the electronic flat file for submission to the DMS.
Run the DMS Adjustment Application Engine process (AR_DMSADJST) to create an electronic flat file containing adjustments and corrections to previously referred debt for submission to the DMS.
Run the DMS Process Receipts Application Engine process (AR_DMSRECEIP) to process any inbound files from the DMS containing collections or adjustments against the previously referred debt.
You can verify that each process runs successfully by viewing the log files for errors.
Before creating debt referral files:
Enable DMS processing by selecting the DMS Interface check box on the Installation Options - Receivables page.
Enter business unit-level DMS data on the DMS Information page.
Enter customer DMS information in the DMS Customer 1, DMS Customer 2, and DMS Customer 3 pages.
See Also
(USF) Defining Debt Management Information
Defining Receivables Installation Options
Entering Customer DMS Information
Admin Debt Classification (administrative debt classification) |
Select the appropriate value for credit bureau reporting. Values are Employee Advance, Fee, Fine, Miscellaneous Debt, Overpayment, and Penalty. |
Business Unit |
Enter the business unit for which you want to select items for referral. Generally, you process referrals monthly for a given business unit. |
Program ID |
Enter a code that enables the DMS to group related debts in their system for processing under specific business rules. |
Referral Type |
Select the type of referral for the items. Values are: Passthrough: Debts for referral to the Debt Management Service Center (DMSC) and Financial Management Service (FMS) system for referral to Private Collection Agencies (PCAs) under existing FMS contracts. Cross-Servicing: Debts for referral to the DMS for general collection activities. |
Destination File Name |
Enter the file path and file name of the delinquent account file that you are creating. |
Secured Debt |
Select to indicate that the debt is secured with collateral. |
Manual Selection |
Select to refer debts that are less than 180 days. |
Page Name |
Definition Name |
Navigation |
Usage |
View/Update Item Details - Detail 1 |
ITEM_MAINTAIN |
|
View item information and access the DMS Information page. |
DMS_ITEM_SEC |
Click the DMS Information link on the View/Update Item Details - Detail 1 page. |
Update DMS information for the item. |
|
DMS_CONTROL |
Accounts Receivable, Customer Accounts, Delinquent Accounts, Select Referral Items, Select Referral Items |
Select items to be referred to the DMS. |
|
DMS_REFERRAL |
Accounts Receivable, Customer Accounts, Delinquent Accounts, Create Referral File, Create Referral File |
Create a file of referred debt for submission to the DMS. |
|
RUN_DMS_ADJST |
Accounts Receivable, Customer Accounts, Delinquent Accounts, Create Adjustment File, Create Adjustment File |
Create a file of subsequent collections and adjustments of previously referred debt. |
|
RUN_DMS_RECEIPT |
Accounts Receivable, Customer Accounts, Delinquent Accounts, Process Receipts, Process Receipts |
Process an inbound file of collections or adjustments against previously referred debt. |
Access the Select Referral Items page (Accounts Receivable, Customer Accounts, Delinquent Accounts, Select Referral Items, Select Referral Items).
Select a business unit and referral type. The system processes one file for each business unit and referral type combination.
The page displays delinquent items for referral.
Viewing Item-Level Information
For each item listed in the grid, you can view the business unit, item ID, customer ID, and due date.
|
Click the View Detail button for an item to access the View/Update Item Details - Detail 1 page and access and change the DMS information for the item. |
Selected Flag |
Select to mark individual items for referral. |
Viewing and Adjusting DMS Information
Select the DMS Detail tab to view the DMS Information for the item. This information is automatically supplied based on the business unit and customer DMS setup. You can override these default values as needed.
Access the Create Referral File page (Accounts Receivable, Customer Accounts, Delinquent Accounts, Create Referral File, Create Referral File).
Select the business unit for which you want to create the referral file, the referral type that you want to process (Cross-Servicing or Passthrough), and enter the file path and name for the destination file.
Run the DMS Referral process to create the referral file for the DMS.
Access the Create Adjustment File page (Accounts Receivable, Customer Accounts, Delinquent Accounts, Create Adjustment File, Create Adjustment File).
Select the business unit and enter the destination file path and name.
Run the DMS Adjustment process. This process generates a file of subsequent adjustments or collections for debt that was previously referred to the DMS.
Access the Process Receipts page (Accounts Receivable, Customer Accounts, Delinquent Accounts, Process Receipts, Process Receipts).
Attached File |
Displays the name of the file received from the DMS. |
|
Click the Add Attachment button to browse for the file to attach. Once you have located the file, click the Upload button to load the file. |
|
Click the Delete Attachment button to delete the currently selected attachment. |
|
Click the View Attachment button to view the currently selected attachment. |
Run the DMS Process Receipts process to insert delinquent account data from the DMS into the Pending Item PS_PENDING_ITEM table using the DMS Inbound process.
Completing the Process Receipts Process
To complete the Process Receipts process:
Check the message log for errors.
View the group using the External Pending Item Entry component (ENT_EXTAID_UPDT) and select a posting action for the group.
Run the Receivable Update Application Engine process (ARUPDATE) to post the pending items.
See Also
This section provides an overview of IPAC processing, lists prerequisites, and discusses how to:
Enter IPAC information for an item.
Enter additional IPAC information.
Enter override options for the Format EFT File Application Engine process (FIN2025).
The IPAC system is maintained by the U.S. Department of Treasury for intra-governmental transactions. The IPAC system transmits billing information electronically, using a formatted file, to the U.S. Department of Treasury specifications so that bills and payments can be applied to the correct account. If your organization requires that you use the IPAC system, you can use PeopleSoft Receivables to create an extract file with receivables data that you send to the U.S. Department of Treasury. You create a request to collect funds from customers that are federal agencies by creating a flat file in PeopleSoft Receivables and sending the file online or in a bulk file connection to the IPAC system.
PeopleSoft Receivables supports four types of IPAC transactions:
Collection, which is associated with the 810 format.
Use this transaction type to collect funds from other agencies.
Adjustment, which is associated with the 812 format.
Use this transaction type to correct payment or collection information received by your agency, including the amount and the Standard General Ledger (SGL) account information. This transaction type is not available if you initiated the IPAC transaction.
Note. A credit item cannot be selected for refund processing until an IPAC adjustment transaction is entered. If an item that belongs to a customer, who requires IPAC processing, is selected for refund and the adjustment transaction is not created for the item, then an error message appears on the Maintenance Worksheet - Worksheet Application page.
Zero dollar, which is associated with the 835 format.
Use this transaction type to add or change collection information that you sent in an earlier transmission. This transaction type does not change the transaction amount or SGL account information.
Post SGL, which is associated with the 840 format.
Use this transaction type to add or change SGL account information for previously received or sent transactions. You can add or change the sender's information, the receiver's information, or both.
The system includes transactions in the file only if they are marked as Not Processed in the IPAC record.
This diagram shows the flow of the IPAC information. Your agency creates an item, enters the IPAC information, and creates an EFT file, which is sent to the Treasury Department and updated in the IPAC system. The Treasury Department sends the IPAC file to another agency, which creates the payment.
IPAC processing from your agency to the Treasury Department to another agency where payments are created.
If an IPAC transaction has been processed, the item and the group of items it belongs to cannot be unposted. If IPAC items are bundled and posted, but the file is not sent immediately to the Treasury Department, the bundled items can be unposted only in the time frame before sending to the Treasury Department. A suggestion would be to group all IPAC items into one group to be processed by IPAC on the same date. If the items were posted and a period of time elapsed before sending to IPAC, in this window, the group could be unposted.
See Also
Changing and Reviewing Item Information
Before you export PeopleSoft Receivables transactions to IPAC:
Enable the IPAC interface on the Installation Options - Receivables page.
Assign an IPAC billing agency location code and sender DO (disbursing office) to a setID for each business unit.
When defining customers, select the options for the IPAC interface and the customer agency location code.
Select a primary IPAC contact for each customer.
If you want to automatically supply the SGL account information, you must perform these tasks:
Create entry event codes that include the WS-01 step for the ARUPDATE entry event process on the Entry Event Code Definition page.
Add two ChartField attributes for accounts to which IPAC processing applies on the ChartField Attributes page:
IPAC: Enter Y for the ChartField attribute value.
USSGL: Enter the four-character SGL account that you want to interface with the IPAC system for the ChartField attribute value.
When you run the Receivable Update process (ARUPDATE), the system compares the GL accounts in the entry event code definition to the Account ChartField attributes to determine whether IPAC processing applies. If IPAC processing applies, the system uses the four-character GL account that you enter for the USSGL attribute value to populate the SGL Account fields.
If invoices are loaded from an external billing source, the IPAC interface option is selected on the Installation Options - Receivables page, and the IPAC interface option is selected for the customer who is associated with the invoice, then the Receivable Update process performs these edits:
Billing ALC - The pending item is marked in error if the ALC is not defined on the Receivables Business Unit options page.
Sender DO - The pending item is marked in error if the sender do is not defined on the Receivables Business Unit options page.
Customer ALC - The pending item is marked in error if the ALC is not defined on the Customer-General Options page.
Sender TAS - The pending item is marked in error if the TAS string is not defined and associated with the fund code on the item AR accounting line.
Unit Price - The pending item is marked in error if the item entry amount is zero.
SGL Account - The pending item is marked in error if the SGL Account is not defined and associated with an entry event code on the item.
Obligation Document and Purchase Order Id - Both fields default from the Purchase Order reference field. The pending item is marked in error if the purchase order reference is not populated.
See Also
Defining Receivables Installation Options
Adding Customer Names and Levels and Assigning Roles
Defining and Using Account Types and Attributes
Setting Up and Generating Federal Government and Statutory Reports
Page Name |
Definition Name |
Navigation |
Usage |
View/Update Item Details - Detail 1 |
ITEM_MAINTAIN |
Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 1 |
Change information about open and closed items. |
AR_IPAC_SEC |
Click the Transfer to IPAC Transactions link on the View/Update Item Details - Detail 1 page. |
Enter information required by IPAC. |
|
AR_IPAC_DESCR_SEC |
Click the Description link on the Receivable IPAC Transactions page. |
Enter a detailed description for an IPAC transaction. |
|
AR_IPAC_MISC_SEC |
Click the Misc Info (miscellaneous information) link on the Receivable IPAC Transactions page. |
Enter additional text to describe an IPAC transaction and additional sender and receiver information. |
|
AR_IPAC_SGLCMT_SBP |
Click the SGL Comments link on the Receivable IPAC Transactions page. |
Enter standard general ledger comments. |
|
PRCSDEFNOVRD |
PeopleTools, Process Scheduler, Processes, Override Options |
Enter override options for the Format EFT File process. |
|
IPAC_EXP_RQST |
Accounts Receivable, Receivables Maintenance, Request IPAC Interface, AR IPAC Run Request |
Run the Format EFT File process, which creates a file that can be uploaded to IPAC. |
Access the Receivable IPAC Transactions page (click the Transfer to IPAC Transactions link on the View/Update Item Details - Detail 1 page).
Some of the information displayed on this page comes from the default values for IPAC that you assigned to business units, customers, and contacts. You can override the default values as needed.
Entering IPAC Header Information
Entering Detail Information
Only the Original Line Item Number field is available for adjustment types. No other fields are available.
Trace ID |
Displays the user-assigned identification number to enable back-end systems to match transactions. |
Cross Ref Doc (cross-reference document) |
Displays the document reference number on the header of the original transaction. This field appears only for zero dollar transaction types. |
Original Line # (original line number) |
Displays the detail line number from the original transaction, which is used for adjustments only. |
Misc Info (miscellaneous information) |
Click to add additional information about the transaction. |
Description |
Click to add information about the IPAC description. |
Quantity |
Displays the quantity amount that can be used to verify that the amount on each IPAC detail record equals the quantity times unit price, except for the Zero Dollar record type. |
UOM (unit of measure) |
Displays the units by which goods and services are measured. This field is not available for adjustment type. |
Unit Price |
Displays the total amount of each IPAC unit, which is quantity multiplied by unit price. This field is required for payment and collection. |
Obligation Doc (obligation document) |
Displays the billing agency's internal accounting document associated with a specific bill. |
Final Pay |
Select to indicate whether a payment is final (F) or partial (P). |
Contract |
Displays a number that uniquely identifies a contract between two trading partners. |
Contract Line |
Displays a contract line item number. |
Requisition |
Displays whether a payment is from a requisition or a partial payment. |
PO ID (purchase order ID) |
Displays a purchase order number. This field is required for IPAC collections. A PO must exist before IPAC is created. |
Contact Name and Phone |
Displays information about the primary IPAC contact that you assigned to a customer. |
Entering Sender/Receiver TAS/BETC Information
The fields that are available in this section vary based on the IPAC transaction type. This table shows the fields that are available based on the IPAC type:
IPAC Transaction Type |
Available Fields |
Collection |
All fields. |
Adjustment |
All fields except sender and receiver DUNS and DUNS4. |
Zero Dollar |
All fields except sender and receiver BETC. |
TAS (treasury account symbol) |
For the sender, select the account number assigned by the U.S. Department of Treasury to classify transactions. Indicates the agency that initiated the billing. For the receiver, select the account of the fund that will receive the payment. |
BETC (business event type code) |
Select the code used in the Governmentwide Accounting and Reporting Program (GWA) to indicate the type of activity being reported, such as payments, collections, and so on. This code must accompany the Treasury Account Symbol (TAS) and the dollar amounts to classify the transaction against the fund balance with the Treasury. |
DUNS (Dun & Bradstreet number) |
Enter the Dun & Bradstreet number used to identify the sender (your agency) or the receiver (the customer's agency). The sender DUNS appears by default from the values defined on the Receivables Business Unit Options page. The receiver DUNS appears by default from the values defined on Customers - Additional General Information page. |
DUNS4 |
Enter the four-character identifier, along with the DUNS number, which identifies individual business locations for federal vendors and federal customers. The sender DUNS4 appears by default from the values defined on the Receivables Business Unit Options page. The receiver DUNS4 appears by default from the values defined on Customers - Additional General Information page. |
Department |
Displays the receiver department code of the customer. This field appears by default from the first two characters of the Customer ALC. |
Entering SGL Information
If you entered an entry event code for the item in PeopleSoft Billing or during pending item entry on the Pending Item 1 page, the Receivable Update process populates the fields in the SGL Information grid. You can override the values if needed. If you did not enter an entry event code, you must enter SGL account information for Post SGL transaction types, and you can optionally enter SGL account information for the Collection and Adjustment transaction types. The SGL information fields are not available for zero dollar transaction types.
Access the IPAC Miscellaneous Description page (click the Misc Info (miscellaneous information) link on the Receivable IPAC Transactions page).
Enter comments about the collection request in the text box.
Fiscal Year Obligation ID |
Select a value to indicate the fiscal year of the obligation. Values are Not Applicable, Current Fiscal Year, and Prior Fiscal Year. |
ACL/CD (account classification code) |
Displays a project code and is supplied to the billing agency by the customer on the original request for services. |
ACRN (account classification reference number) |
Appears for adjustment type only. |
Job |
Not available for adjustment type. |
JAS (job agency site) |
Displays a combination of job order number, accounting classification record number, and site ID. |
FSN (fiscal station number) |
Displays an 8-digit number identifying the subdivision of an agency location code. |
DoD (activity address code) |
Displays the activity address code. |
The fields that are available on this page vary based on the IPAC transaction type. This table shows the fields that are available based on the IPAC type:
IPAC Transaction Type |
Available Fields |
Collection |
All fields. |
Adjustment |
All fields. |
Zero Dollar |
All fields except Fiscal Year Obligation ID. |
Post SGL |
Only the text box. |
Access the Override Options page (PeopleTools, Process Scheduler, Processes, Override Options).
If you run PeopleSoft Receivables on a DB2 database on a Microsoft Windows or IBM OS390 server, you must manually insert an owner ID parameter in the list of parameters for the process definition before you can run the Format EFT Files process.
Parameters List |
Enter Prepend. |
Parameters |
In the Parameters field next to the Parameters List field, enter %%OWNERID%% :EFT_WRK_PARM1 as shown in the preceding example. Note that a space is between the owner ID parameter ( %%OWNERID%%) and :EFT_WRK_PARM1. |
Access the AR IPAC Run Request page (Accounts Receivable, Receivables Maintenance, Request IPAC Interface, AR IPAC Run Request).
IPAC Interface Options |
Select an IPAC Interface option: Values are Generate for All Units, Generate for One Unit, Generate for One Customer, and Rerun for Previous Job. |
To set up agency location codes (ALCs) and government wide accounting (GWA) reporting options for reporting, use the Agency Location component (AGENCY_LOC_CD).
To create Partial SF224 reports, use the SF224/ SF1220 Report Definition component (SF224_SF1220_DEFN).
This section provides an overview of Partial SF224 reporting and discusses how to:
Reclassify receivables item accounting entries.
Reclassify direct journal accounting entries.
Reclassify open receivables items.
The Financial Systems Integration Office (FSIO) has issued Core Systems Requirements that impact the SF224 report and the electronic interface that is used to report cash receipt and cash disbursement activity by Agency Location Code (ALC) to the U.S. Treasury. The FSIO Core System Requirements are based on new Government-wide Accounting (GWA) Partial 224 Business Rules. The GWA business rules set the stage for ultimately phasing out the SF-224 report over the next several years and replacing it with the Partial SF224 report. The new GWA Business Rules dictate how specific activity is to be excluded from SF224 reporting as the U.S. Treasury systems are modified in the future. When agencies can finally report cash activity by the Business Event Type Codes (BETC), the agencies will report only non-BETC-coded cash activity and cash reclassifications using the Partial SF224 report.
The U.S. Treasury will be implementing the BETC for federal agencies to use to identify and report specific information about cash receipt and disbursement transactions in lieu of that provided by the SF224 report. The BETC is being implemented by the U.S. Treasury during the next few years for IPAC (collections and payments), Cashlink II (collections), Electronic Certification System (payments), and the Treasury Disbursement Office (TDO) systems.
Agency financial systems will be modified so that the BETC code can be specified for all cash transactions. The evolution of the BETC drives the need for agency financial systems in the short term to be configurable so as to identify those interfaces (IPAC, CA$HLINK, TDO Payments) when they are modified to pass BETC with the associated cash activity to the U.S. Treasury.
Note. The Partial 224 report will not be available for use
until the U.S. Treasury implements BETC.
Contact the U.S. Treasury Financial Management Service (FMS) for its
schedule for implementation of the BETC. Until such time as the BETC is implemented
by the FMS, you must continue to produce the full SF224 - Statement of Cash
Transactions report.
See Also
Defining, Generating, Creating, and Printing SF224, SF1219, and SF1220 Reports
(USF) Setting Up Agency Location Codes
Page Name |
Definition Name |
Navigation |
Usage |
Reclassify AR accounting entries |
PAR224_ARENTRIES |
Accounts Receivable, Receivables Maintenance, Reclassify AR Entries |
Change the fund associated with posted accounting entries. You can reclassify the entire stream of the transaction. The reclassification entries are recorded in the PS_ITEM_DST table with a sequence number starting from 600. |
Reclassify Direct Journal Entries |
PAR224_DIRJRNL |
Accounts Receivable, Receivables Maintenance, Reclassify Direct Jrnl Entries |
Identify accounting entries for direct journals and reclassify the entries to correct the fund. The reclassification entries are recorded in the PS_PAY_MISC_DST table with a line number starting from 600. |
Transfer Selection |
PAR224_TRANSFER |
Accounts Receivable, Receivables Maintenance, Reclassify Open Item |
Create a new worksheet or add items to a transfer worksheet. |
Worksheet1 |
TRN_WORKSHEET1 |
Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Worksheet 1 |
Select the items to transfer. |
Worksheet2 |
TRN_WORKSHEET2 |
Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Worksheet 2 |
Override the default receivable distribution code. |
Transfer Action |
TRN_ACTION |
Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Transfer Action |
Select a posting action for a worksheet. Also use this page to delete a worksheet, create accounting entries online for the worksheets, or to delete accounting entries. |
Access the Reclassify AR accounting entries page (Accounts Receivable, Receivables Maintenance, Reclassify AR Entries).
Item Search |
Click to display the accounting lines that match the entered business unit, item ID, customer ID, fund code, and accounting date. |
Selection Criteria |
Select the types of entries to display in the Accounting Lines area. the values are All Entries and Reclassification Entries. |
Update |
Click to generate new accounting entries for the selected accounting lines after you have entered the appropriate fund code and accounting date. The system generates reversal entries for the selected accounting lines and creates new accounting entries with the following attributes:
|
Access the Reclassify Direct Journal Entries page (Accounts Receivable, Receivables Maintenance, Reclassify Direct Jrnl Entries).
Search |
Click to display the accounting lines that match the entered deposit unit, payment sequence, fund code, and accounting date. |
Selection Criteria |
Select the types of entries to display in the Accounting Lines area. the values are All Entries and Reclassification Entries. |
Accounting Date |
Enter the accounting date to be used on the new reclassification entries. If no date is entered, it will default to the current date. The budget date will be set to the same date as the accounting date. |
Update |
Click to generate new accounting entries for the selected accounting lines after you have entered the appropriate fund code and accounting date. The system generates reversal entries for the selected accounting lines and creates new accounting entries with the following attributes:
|
This section discusses how to:
Build a transfer worksheet for reclassifying receivables items.
Reclassify open receivables items.
Modify the distribution code.
Choose an action for a receivables reclassification worksheet.
Building a Transfer Worksheet for Reclassifying Receivables Items
Access the Transfer Selection page (Accounts Receivable, Receivables Maintenance, Reclassify Open Item).
Enter your customer and reference selection criteria.
Build |
Click to build a worksheet that reclassifies an open item. |
See Building a Customer or Business Unit Transfer Worksheet.
Reclassifying Open Receivables Items
Access the Worksheet1 page (Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Worksheet 1).
Sel (select) |
Select the items to reclassify. |
Modifying the Distribution Code
Access the Worksheet2 page (Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Worksheet 2).
Dist ID AR (receivables distribution code) |
Override the default distribution code that was assigned to the business unit. For reclassification, use the RECLASSIFY distribution code. |
See Modifying Item Information.
Choosing an Action for a Receivables Reclassification Worksheet
Access the Transfer Action page (Accounts Receivable, Receivables Maintenance, Reclassify Open Item, Transfer Action).
See Selecting a Transfer Worksheet Action.
This section provides an overview of the track memo status changes process, lists prerequisites, and discusses how to:
Check an item's current memo status.
Change an item's memo status.
Run the Memo Status Changes report.
The DMS requires you to maintain account information about individual accounts receivable. To support this requirement, PeopleSoft Receivables enables you to track multiple statuses for a receivable item.
This involves:
Updating the memo status and details on the View/Update Item Details - Detail 2 page.
Running the Memo Status Changes report, which lists, by item, the history of changes to the memo status field.
Two tables are required to use the track memo changes:
The Memo Status Codes table (PS_MEMO_STATUS_TBL) contains the valid statuses.
The Memo Status Changes Control table (PS_ ITEM_MEMO_CHGS) contains each change made to the memo status field, along with the user ID.
Before tracking memo status:
Enable the Track Memo Status Changes feature by selecting the Use Memo Status check box on the Installation Options - Receivables page.
Set up memo status codes.
See Also
(USF) Setting Up Memo Status Codes
Defining Receivables Installation Options
Page Name |
Definition Name |
Navigation |
Usage |
View/Update Item Details - Detail 2 |
ITEM_MAINTAIN_2 |
Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 2 |
Check an item's current memo status. |
MEMO_STATUS_SEC |
Click the Detail button on the View/Update Item Details - Detail 2 page. |
Add and maintain a history of memo status code changes. |
|
RUN_AR34006 |
Accounts Receivable, Customer Accounts, Item Information, Memo Status Change Report, Memo Status Changes |
Generate the Memo Status Changes report (AR34006). Use the report to see the history of memo status changes by item. |
Access View/Update Item Details - Detail 2 page (Accounts Receivable, Customer Accounts, Item Information, View/Update Item Details, Detail 2).
Memo Status Code |
Displays the current memo status for the item. This field appears only if you have enabled this feature on the Installation Options - Receivables page. |
Detail |
Click to access the Memo Status Changes page, where you can review a history of status changes for the item and add a status change as needed. |
Access the Memo Status Changes page (click the Detail button on the View/Update Item Details - Detail 2 page).
Change an item's memo status by adding a new row to the Memo Status Changes grid.
Access the Memo Status Changes (report) page (Accounts Receivable, Customer Accounts, Item Information, Memo Status Change Report, Memo Status Changes).
You can specify a date range for the report, a specific business unit, a customer ID, and whether to include closed items on the report. If you specify a date range, the report includes only items with a memo status change within the specified date range.
This section provides an overview of the Write-Offs By ChartField Application Engine process (AR_WOBYCF) and discusses how to run the Write-Offs by ChartField process.
The Write-Offs By ChartField process searches for items that contain distribution lines with ChartField values that match the selection criteria that you enter on the run control. Run this process to close out a specific ChartField, such as a Fund. If all the distribution lines for an item qualify, the process assigns the entire open amount of the items to a pending group and sets the posting action to Batch Standard. The next time you run the Receivable Update process, the process writes off the items and closes the group. If the qualifying distribution lines for an item make up only a portion of the open amount, the Write-Offs By ChartField process assigns the remaining balance of the items to a maintenance worksheet. You must access the maintenance worksheet and decide how to write off the item.
Page Name |
Definition Name |
Navigation |
Usage |
AR_WOBYCF_REQ |
Accounts Receivable, Receivables Maintenance, Automatic Maintenance, Write-Offs by Chartfield, Write-Offs By ChartField |
Enter ChartField selection criteria to select items to write off by running the Write-Offs By ChartField process. |
Access the Write-Offs By ChartField page (Accounts Receivable, Receivables Maintenance, Automatic Maintenance, Write-Offs by Chartfield, Write-Offs By ChartField).
Select a business unit and customer to process. You can process only one business unit at a time. The system uses the setID for the business unit to provide prompt values for the customer and the write-off reason.
Write-off Reason |
Enter an entry reason that the process assigns to the write-off items that it creates. |
Field Name |
Select the ChartField values that you want to select in the ChartField value fields. |
ChartField Value and ChartField TO Value |
Select the range of ChartField values that are in the distribution lines for the items that you want to write off. |
This section provides an overview of the Treasury Report on Receivables (TROR) and Debt Collection Activities, and describes how to:
Add a TROR Template.
Update a TROR Template.
Set up the Reporting Entity Code.
Generate the Treasury Report on Receivables.
The Treasury Report on Receivables and Debt Collection Activities is the U.S. Department of Treasury's means for periodically collecting data on the status and condition of the federal government's nontax department portfolio in accordance with the requirements of the Debt Collection Act of 1982 and the Debt Collection Improvement Act of 1996 (DCIA).
This report creates a form used by the U.S. Department of Treasury to collect data on the status and condition of the federal government's non-tax debt portfolio. This report is used if an agency has debts but is pursuing them through collection. The Department of Treasury shares the information in this report with other government agencies, some private sector organizations, and the public.
Process Flow
Set up the following:
Receivables Installation Options
Receivables Types
Customer Types
Delinquency Codes
TROR Templates
Reporting Entity Codes
Assign an entity code and receivable type to an item in one of the following places:
TROR Report Types page, which you access from the Pending Item 1 page.
This assigns the codes to pending items.
View/Update Item Details - Detail 2 page.
This assigns the codes to posted items.
Post pending items by running the Receivable Update process.
Assign a delinquency code on the Item Delinquency page to items whose amounts you want to include in various report lines.
Access Treasury Report on Receivables, enter report parameters, and run the report.
View the XML and PDF report output in the Report Manager.
You must perform these setup procedures prior to setting up and updating one or more TROR templates:
Access the Receivables installation options page (Set Up Financials/Supply Chain, Installation Options, Receivables) and select the Treasury Report on Receivables check box to enable the fields and buttons that are associated with the Treasury Report on Receivables report to appear on the business unit, pending item entry, and item maintenance pages.
Access the Add a Report Template page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Add Report Template) to define a new report template name and version.
Access the Update Report Template page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Update Report Template) to search for the template that you just added and set up the characteristics of each system-defined line, which is associated with a system-defined part and section.
Access the Receivable Type page (Set Up Financials/Supply Chain, Product Related, Receivables, and Options, Receivable Type) to define the codes that represent the receivable types.
Access the Reporting Entity Code page (Set Up Financials/Supply Chain, Product Related, Receivables, Options, Reporting Entity Code) to define the report entity codes for the government agencies and divisions to which the Treasury Report on Receivables is submitted.
The entity code component now includes TROR reporting options. These reporting options enable users to set up and report behavior and map Receivable business units to the entity code.
Access the Delinquency Code page (Set Up Financials/Supply Chain, Product Related, Payments, Delinquency Code) to define delinquency codes.
Note. You can also set up user-defined customer types.
TROR Template
The TROR Template provides you with the flexibility to set up one or more effective dated report templates. There are two ways to add a TROR Template:
Access the Add a Report Template page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Add Report Template) to define a new report template name and version. Next, access the Update Report Template page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Update Report Template) to search for the template that you just added and set up the characteristics of each system-defined line, which is associated with a system-defined part and section.
Access the Update Report Template search page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Update Report Template) to search for an existing template. Click the Copy Template icon on the Report on Receivables Setup page to display the Report on Receivables Template Copy page. You can select a new setID and enter a new template name on this page. The version is display only and is controlled by the system defined version control table. For example, user can create a new template using sample template TRORV1 under setID SHARE, report version 2007.01, if wish to reuse the set up data for the sample template.
Once the new template has been copied, you can return to the Update Report Template search page and search for the new template that you just created. You can modify the characteristics of this template as needed.
Use the TROR template to select data that you want to appear on the TROR report. The template enables the inclusion and exclusion of receivables based on the setup. This means that item entry use Id's can be included or excluded from certain lines in the report, as well as item delinquency codes.
The report version system data controls the output and template structure. Lines cannot be added or deleted to a template by the end user. The end user can set up a new template for a report using the system-defined version of the report. The system-defined version of the report cannot be modified. This ensures that the generated report is current and complies with the output specifications of the US Treasury.
When a newer version of the report is released by the US Treasury in the future, the system data and report output will be updated using the support development process.
The TROR template consists of these categories.
Report Template
The report template is created by the end user to select and report on receivables within their system.
Report Part
The number of Report Parts in the template is defined in the report version control record. Report parts cannot be added or deleted to a template. This ensures that the report output is consistent with the US Treasury's version of the report.
Report Section
The number of Report Sections in the template is defined in the report version control record. Report sections cannot be added or deleted to a template. This ensures the report output is consistent with the US Treasury's version of the report.
Report Line
The number of Report Lines in the template is defined in the report version control record. Report lines cannot be added or deleted to a template. This ensures the report output is consistent with the US Treasury's version of the report.
The lines in the report display as one line or many sub-lines. The report template component will treat each line line/sub line combination as one line. Each line has its own select statement where you define the receivable select criteria as well as delinquency code selection criteria.
Since the TROR uses setup data defined specific to your implementation of Receivables, the process of establishing a new template with selection and exclusion criteria can be an involved process. To expedite the setup process, a sample template is delivered as demo data. The sample template can be copied and used as a starting point to create a template for your implementation.
Entity Code Setup
You set up reporting entity codes (Set Up Financials/Supply Chain, Product Related, Receivables, Options, Reporting Entity Code) to represent the government agencies and divisions for which the Treasury Report on Receivables is submitted.
Setting up an entity code enables you to set up report behavior and map Receivable business units to the entity code. You select a TROR reporting template for an entity code. When you run the report, this template is applied based on the setID and entity code that you select on the Preparer run control page. You select the receivable types that can be applied to a report, and select only one of these receivable type options to apply to the specific report you are running.
You select business units for the entity code. When you select a setID on the Preparer run control page, it determines which entity codes are available for selection, which in turn determines the business units and associated data that are selected to the Treasury Report on Receivables that you generate. There is an edit on the Reporting Entity Code page that verifies that the business units you select on the Reporting Entity Code page have the same setID as the setID the entity code that you are setting up.
Treasury Report on Receivables Run Control
Users run the Treasury Report on Receivables by entering the entity code on which to report. Users select the range of periods to include in the processing on the Treasury Report on Receivables run control Preparer's page. When the entity code is set up, the system verifies that all selected business units have the same calendar id to ensure that the selected period range is valid. The beginning and ending dates for generating the report are determined by the begin date of the From Period and the ending date of the To Period.
The report output can be viewed in a pdf format.
Access the Add Report Template page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Add Report Template).
SetID |
Select the setID that applies to your organization. |
Template Name |
Assign an identifiable name for this TROR template. |
Report Version |
Select the version of this report. This number represents the most current report version and is derived from the version control record (AR_RPT_VERSION), which is delivered as system data. |
Access the Report on Receivables Setup page (Set Up Financials/Supply Chain, Product Related, Receivables, TROR Report, Update Report Template, Report on Receivables Setup).
SetID, Template Name, Report Version |
These values displayed based on the values selected on the Update Report Template search page. |
Effective Date |
Select the date from which this report template setup is applicable. |
Status |
Select whether the data on this report template is an Active or Inactive. Note. You can modify the information on this template as of a selected effective date by clicking the + icon, changing the effective data and making that date active. |
Description |
Enter a description of this template. |
Basis Date for Aging |
Select either the Due Date, which is the due date assigned to an item, or the As of Date of an item. |
Customer Type |
Customer Types are defined based on your implementation setup. You can select a specific type of customer to exclude from this report or you can leave the field blank to include all customer types in the report. If you want to exclude more than one customer type, you can click the + icon to the right of the Customer Type field and select another customer type to exclude from the report. You can continue to add the customer types that you want to exclude using the + icon. |
Report Setup |
Click the Report Setup arrow to display the Report Setup and Line Setup group boxes. The Report Setup group box consists of a consecutive series of Parts, Sections, and Lines along with their descriptions. When you click View All on the right side of the Report Setup header row, you can display all of the Report Setup and Line Setup for each part, section and line of the report. |
Line Setup |
Name indicates the name of the part, section, and line that will be printed on the report. To define the Line Setup, you can select from these options (some of which are active or inactive due to your selection):
For example, to define the line setup for: Part I Name: Status of Receivables Section A Name: Receivables and Collections Line 4A Name: (A) At Agency (-) You can select from these options:
|
Access the Reporting Entity Code page (Set Up Financials/Supply Chain, Product Related, Receivables, Options, Reporting Entity Code, Reporting Entity Code).
Entity Code |
Enter the entity code for the reporting entity that you want to define. The first two digits identify the agency, the next two digits identify the bureau, and the remaining digits identify the entity. |
Reporting Template |
Select the TROR reporting template to use when generating the Treasury Report On Receivables based on the selection of this reporting entity code. |
Default Delinquency Code |
Select the delinquency code that you prefer as the default value for new receivables. |
Exclude Prepaid Items |
Select this check box if you want to exclude prepaid items on the Treasury Report on Receivables for this reporting entity code. |
Receivable Types |
Select the Receivable Types that identify a receivable as Administrative, Default Guaranteed Loans, and Direct Loans. The receivable type can be defined as any value in the system and is mapped from this entity code to the receivable type on the TROR. Note. Only one Receivable Type appears on a given report. |
Calendar ID |
Select the calendar that you want to apply to the generation of data for the Treasury Report on Receivables report. The calendar ID that you select for the entity code determines the fiscal year and accounting periods that appear on the report. |
Included AR Business Units |
Select any business units that you want to include in the processing of the data for the Receivable Due From the Public report. An error message will display If the calendar ID for the selected business unit does not match the calendar ID selected for this reporting entity code. |
Access the Preparer run control page (Accounts Receivable, Receivables Update, Posting Results - Upd Pend Item (update pending items), Treasury Report on Receivables).
SetID |
Select the setID that is associated with the entity code selected for this report. |
Entity Code |
Select the reporting entity code that will be included in this report. The selected entity code contains the TROR template to be used for this report and all business units defined for this entity. |
Receivable Type |
Select the Receivable Type to apply to this report. The possible Receivable Types for this entity are set up on the Reporting Entity Code page. |
Fiscal Year |
Select the fiscal year to apply to this report. The fiscal year that you select is based on the Calendar ID setup for the selected entity code. |
Accounting Period From, Accounting Period To |
Enter the accounting period range that you want to include in this report. |
Preparer's Information |
Enter the name, phone number, fax number, and e-mail address of the preparer depending on the information that is available. |
Supervisor Information |
Enter the name, phone number, fax number, and e-mail address of the preparer's supervisor depending on the information that is available. |
Access the Address tab.
Enter the Address Information for the entity associated with this report.
Access the Debt Disposition tab.
PCA Debt Disposition Number, Amount (private collection agency debt disposition number, amount) |
Enter the number and amount of written-off delinquent debts that are still being pursued by the U. S. Department of Treasury or a private collection agency. |
TXS Debt Disposition Number, Amount (treasury or debt collection center debt disposition number, amount) |
Enter the number and amount of written-off delinquent debts that are still being pursued by the U. S. Department of Treasury or a designated debt collection center. |
TOP Debt Disposition Number, Amount (treasury for offset debt disposition number, amount) |
Enter the number and amount of written-off delinquent debts that are still being pursued by the U. S. Department of Treasury for offset. |
OTH Debt Disposition Number, Amount (other debt disposition number, amount) |
Enter the number and amount of written-off delinquent debts that are still being pursued by means other than those listed. |
IRS 1099-C Submitted Number, Amount |
Enter the number and amount of written-off delinquent debts that have been reported to the IRS on Form 1099-C. |
IRS Not Reported 1099-C Number, Amount |
Enter the number and amount of written-off delinquent debts that have been not been reported to the IRS on Form 1099-C. |
Footnote |
This field does not print to the Treasury Report on Receivables. |
The PeopleSoft Application Engine processing (AR_TROR_XML) generates the Treasury Report on Receivables using BI Publisher based on the selected information:
This section provides an overview of 1099-C report generation and discusses how to set up and run the 1099-C report.
The 1099-C form for Cancellation of Debt is required by the Internal Revenue Service (IRS) in the United States to summarize how much debt has been written off for a specific customer.
To generate the 1099-C form for one or more customers:
Enable 1099-C processing in the Receivables installation options.
Define the system functions that are legitimate canceled debt transactions.
Create the debt creditor ID, including taxpayer identification, address, and associated Receivables business units.
Set up customers for 1099-C processing, including taxpayer identification and reporting details.
Create a customer group for Canceled Debt Reporting. (Optional)
Run the 1099-C process.
You can also audit the 1099-C processing history for one or more customers.
Before you generate the 1099-C report, enable 1099-C processing by selecting the 1099-C Forms check box on the Installation Options - Receivables page (Set Up Financials/Supply Chain, Install, Installation Options, click the Receivables link).
Page Name |
Definition Name |
Navigation |
Usage |
Canceled Debt Report Setup |
AR_CANCEL_DEBT_RP |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Cancel Debt Report Setup 1099, Canceled Debt Report Setup |
Define control values to identify the type of system function codes to use for canceled debt reporting. |
Canceled Debt Creditor |
AR_CANCEL_DEBT_CR |
Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Canceled Debt Creditor 1099-c, Canceled Debt Creditor |
Enter creditor taxpayer ID and address information. Associate AR business units with the ID. |
1099-C Reporting Details |
CUST_CREDIT_SEC |
Customers, Customer Information, General Information, Credit Profile, and click the 1099-C Reporting link |
Enter customer cancellation of debt details. |
Receivables 1099-C |
RUN_AR_1099C |
Accounts Receivable, Receivables Update, Posting Results-Upd Pend Items, Receivables 1099C Prep |
Run control to create a preliminary table with data necessary for 1099-C reporting. |
Submit 1099-C |
SUBMIT_AR_1099C |
Accounts Receivable, Receivables Update, Posting Results-Upd Pend Items, Receivables 1099C Submit |
Select one or more customers for 1099-C form submission. Reset submission dates for or delete selected customer rows from the reporting table. |
Audit 1099-C |
AUDIT_AR_1099C |
Accounts Receivable, Receivables Update, Posting Results-Upd Pend Items, Receivables 1099C Audit |
Search for and review 1099-C actions for one or more customers. |
Access the Canceled Debt Report Setup page (Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Cancel Debt Report Setup 1099, Canceled Debt Report Setup).
You must enter at least one System Function ID in the Canceled Debt Entries grid. Control values identify which function codes the system will use to report canceled debt. If desired, you can further limit which system function codes to select by entering an Entry Type and Entry Reason.
Only transactions with a Posted status in the Item Activity table are eligible for 1099-C reporting. If only the system function code is selected without a qualifying entry type or reason code, all transactions with the system function code are considered eligible. If a user defines an entry type and entry reason, only transactions with the specified entry type and entry reason are selected; all other entry types and entry reasons for the system function code will be ignored.
Reporting Interest Amounts in Box 3
The amount of canceled debt reported on the 1099-C form includes write-offs of principal owed, which can also include interest, administrative fees, and penalties, as specified in the Canceled Debt Entries on the Canceled Debt Report Setup page.
To report interest amounts in Box 3 of the 1099-C form, you must add a Canceled Debt Entry using system functions FC-01 and/or IT-01 with OC in the Entry Type field to designate Overdue Charges. If desired, you can include an Entry Reason value to further filter which types of overdue amount transactions are reported in Box 3 of the 1099-C form.
Note. On the Canceled Debt Report Setup page, entry type OC is reserved for reporting interest amounts in Box 3 of the 1099C form. Entry type OC will not be used for reporting amounts in Box 2.
Access the Canceled Debt Creditor page (Set Up Financials/Supply Chain, Product Related, Receivables, Credit/Collections, Canceled Debt Creditor 1099-c, Canceled Debt Creditor).
Control ID |
Enter a valid control value. You can define control values on the Canceled Debt Report Setup page. The Control ID will identify which function codes the system will use to report canceled debt for this creditor. |
Taxpayer ID |
Enter the 9-digit numerical value that identifies this creditor to the IRS. |
AR Business Units |
Enter at least one business unit associated with this creditor. Conversely, a business unit can be associated with only one creditor. The system uses the business unit to identify which items to select when creating canceled debt amounts. |
Before you can create the 1099-C Cancellation of Debt report, the customer for whom you are submitting the 1099-C report must have required tax identification in your Receivables system. To set up customers for 1099-C processing, complete these steps:
Enter customer tax identification numbers.
Define customer 1099-C reporting details.
Note. Only customer transactions with a Posted status in the Item Activity table are used to gather amounts. The total amount of canceled debt for a customer must be more than 600 USD to be eligible for 1099-C reporting.
See PeopleSoft Order to Cash Common Information PeopleBook, "Maintaining General Customer Information."
Entering Taxpayer IDs for Customers
The tax identification number as well as subcustomer information can be entered on the Miscellaneous General Info page (Customers, Customer Information, General Information, Miscellaneous General Info).
See PeopleSoft Order to Cash Common Information PeopleBook, "Maintaining General Customer Information," Entering Tax ID, Vendor ID, Web Addresses, Stock Symbols, and SubCustomer Information.
Defining Customer 1099-C Reporting Details
Access the 1099-C Reporting Details page (Customers, Customer Information, General Information, Credit Profile, and click the 1099-C Reporting link).
Bankrupt |
Select this check box if the customer is bankrupt. For reporting Receivables transactions such as write-offs as canceled debt, the Bankrupt check box must be selected or a Description must be entered. |
Personally Liable |
Select this check box if this customer is an individual and not a business entity. This information appears on the 1099-C form to be submitted to the IRS. |
Description |
If desired, enter a description of the canceled debt. This information appears on the 1099-C form to be submitted to the IRS. |
Fair Market Value |
Enter an amount in USD for the fair market value of the canceled debt, such as a foreclosure, to indicate that the canceled debt is not related to a Receivables transaction, such as a write-off. If you enter a value here, the system bypasses transactions associated with the control values identified on the Canceled Debt Report Setup page for this customer in Receivables and reports only this amount on the 1099-C form. |
AR Business Unit |
Required if you enter a fair market value amount. The business unit must be associated with a creditor on the Canceled Debt Creditor page. |
See PeopleSoft Order to Cash Common Information PeopleBook, "Maintaining General Customer Information," Setting Up and Reviewing Customer Credit Profiles.
You can optionally group customers with similar traits and define processing criteria for the entire group instead of individual customers. If desired, you can associate a customer with the Canceled Debt Reporting customer group. You can then select the designated 1099-C customer group, a single customer, or all customers for 1099-C preparation processing on the Receivables 1099-C Run Control page.
For 1099-C reporting, use the Canceled Debt Reporting group type delivered as system data. First, create a group table for your 1099-C customers. Then add eligible customers to the customer group.
Creating a Canceled Debt Reporting Customer Group Table
Access the Customer Group Table search page (Set Up Financials/Supply Chain, Common Definitions, Customers, Customer Group Table).
To add a new customer group specifically for canceled debt reporting, follow these steps:
Select a setID value.
Select Canceled Debt Reporting from the Customer Group Type list.
Add a Customer Group value, for example, USGROUP.
Click the Add button.
The Customer Group Table page for your new Customer Group appears.
Enter required values on the Customer Group Table page, including Effective Date, Description, and Short Description. In this example, the user has already saved these values.
See PeopleSoft Order to Cash Common Information PeopleBook, "Maintaining Additional Customer Information," Establishing Customer Group Tables.
Adding Customers to the Canceled Debt Reporting Customer Group
Access the General Information - Customer Group Info page (Customers, Customer Information, General Information, and select 0070 - Customer Group in the General Info Links list on the General Info page).
To associate a customer with a group, add a row to the Customer Groups by Type grid. In the Group Type field, select CDT. Select a Customer Group from the lookup list. Only groups added with the Canceled Debt Reporting group type will display on the list. Customers associated with a group can also be selected for individual 1099-C reporting.
See PeopleSoft Order to Cash Common Information PeopleBook, "Maintaining General Customer Information," Assigning Individual Customers to Customer Groups.
Run the 1099-C process to create the report in two steps. First, you run a preparation Application Engine program, which creates the basic data table (AR_1099C_TBL). Next, you use the Submission page to select records from this table to print, resubmit, or delete.
Running the 1099-C Preparation Program (AR_1099_PREP)
Access the Receivables 1099-C page (Accounts Receivable, Receivables Update, Posting Results-Upd Pend Items, Receivables 1099-C Prep, Receivables 1099-C).
SetID |
Select a setID. Customer data used for reporting must be within this setID value. You cannot report 1099-C information across setIDs. |
Creditor Identifier |
Select the Creditor ID. This value determines the creditor information including taxpayer ID and address, as defined on the Canceled Debt Creditor page. This value also determines the Control ID as entered on the Canceled Debt Creditor page, which controls the type of data selected for the 1099-C report. The business units associated with the Creditor ID are the only business units that will be used to gather data for the customer's 1099-C report. Receivables business units can be associated with only one Creditor ID. You cannot create 1099-C reports that contain data across taxpayer IDs. |
Calendar Year |
Enter a four-digit value for the calendar year. All data selected for reporting are restricted to one calendar year. Any calendar year is valid. |
From Date and To Date |
Select a date range within the calendar year entered in the Calendar Year field. The data for reporting will be restricted to the selected date range. |
Customer Reporting Group |
Select the customers to be included in the record table from these options:
|
Enter the desired parameters and click the Run button to launch the AR_1099_PREP process to create the record table (AR_1099C_TBL) that will be used to submit records for the Cancellation of Debt report.
Submitting Records for the 1099-C Form
Access the Submit 1099-C page (Accounts Receivable, Receivables Update, Posting Results–Upd Pend Items, Receivables 1099 Submit Report, Submit 1099-C).
Search Selected Canceled Debt |
Select the search criteria for customer records to retrieve from the record table (AR_1099C_TBL) to display in the Canceled Debt Worksheet grid. You can choose from these search options to display records within the setID and calendar year specified on the Submit 1099-C page:
For each field, you can select a filter from the drop-down list to search for values that are Equal, Greater Than, Greater Than or Equal, Less Than, Less Than or Equal, Like, or Not Equal to the entered values. If you leave the search fields blank, the system retrieves all records for the selected setID and calendar year. |
Canceled Debt Worksheet |
Select rows in the worksheet for which you want to perform a single action. You can select rows in the worksheet using these options:
The action buttons will delete, submit reports for, or reset for submission the rows that you select in the worksheet. |
Selecting a 1099-C Action
To perform an action, click one of the action buttons to delete selected records, submit selected records to be formatted for the 1099-C form and sent to the IRS, or reset the selections for submission. When you click an action button, a warning message appears. You can choose to cancel or proceed with the action.
Note. The 1099-C action buttons on the Submit 1099-C page produce one-way results. After you confirm the action, the only recovery is to run or in some cases re-run the 1099-C process.
Delete Selected Rows |
Click this button to remove rows from the record table, AR_1099C_TBL. Use this button to remove data before recreating the row with corrected data for the customer, if needed. Only selected rows with a Date Submitted value of None can be deleted. If a row has already been submitted, you must first reset the row using the Reset for Submission button, then delete the row. An audit record will be written to the AR_1099_AUD_TBL for each row that has been deleted. |
Submit Report |
Click this button to create a 1099-C form for all selected rows that have a Date Submitted value of None. The system will not process any row that has already been submitted, namely, that has a Date Submitted field with any value other than spaces. When processing is complete, the Date Submitted field for the row will be updated with the current date. |
Reset for Submission |
Click this button to reset the Date Submitted value for the selected row to None before deleting or resubmitting the row to create a new 1099-C form. Only selected rows with a Date Submitted value other than spaces will be processed. An audit record will be written to the AR_1099_AUD_TBL for each row with a Date Submitted value that has been reset to None. |
Access the Canceled Debt Audit page (Accounts Receivable, Receivables Update, Posting Results–Upd Pend Items, Receivables 1099C Audit, Canceled Debt Audit).
If the Customer ID fields are blank when you click the Search button, the system displays all records on the audit table (AR_1099_AUD_TBL).
You can filter the Canceled Debt Audit Records by Customer ID in the Search Selected Canceled Debt box.
This section provides an overview of federal customer statements, lists prerequisites, and discusses how to generate federal customer statements.
The Federal Customer Statements report is used internally by the federal government to track agreements between federal government agencies. This feature gathers information from the PeopleSoft General Ledger, PeopleSoft Receivables, and PeopleSoft Contracts systems to produce the Federal Customer Statements report.
To create federal statements, run the Federal Customer Statements multiprocess job (ARSTFED), which includes:
The AR_FED_STMTS Application Engine process, which merges information from the PeopleSoft General Ledger and PeopleSoft Contract systems with PeopleSoft Receivables data and updates these tables:
Reimbursable Agreements Federal Statement table (PS_FEDST_TBL_RA), which stores information from PeopleSoft General Ledger and PeopleSoft Contracts for reimbursable agreements.
PeopleSoft Receivables Federal Statement table (PS_FEDST_TBL_AR), which contains customer-related information for the period that the report is run.
The Federal Customer Statement report (AR80019/ARX80019).
If a customer has reimbursable activity and nonreimbursable activity, the report displays summary totals for both.
Before creating federal customer statements:
Enable the Federal Customer feature on the General Info page for the customer.
Enable the Federal Reimbursable Agreement feature on the Installation Options - Contracts page.
Set up the account mappings on the Reimbursable Agreement Account page.
Note. If you do not have PeopleSoft General Ledger or PeopleSoft Contracts installed on your system, disable the products on the Installed Products page to ensure that the reports show correct information.
See Also
Adding Customer Names and Levels and Assigning Roles
Defining Contracts Installation Options
Setting Up Federal Reimbursable Agreement Accounts in General Ledger
Page Name |
Definition Name |
Navigation |
Usage |
FEDERAL_CUST_STMT |
Accounts Receivable, Customer Interactions, Statements, Create Federal Statements, Create Federal Statements |
Enter the run control parameters for the Federal Customer Statements multiprocess job that creates federal customer statements. |
Access the Create Federal Statements page (Accounts Receivable, Customer Interactions, Statements, Create Federal Statements, Create Federal Statements).
Unit |
Enter a business unit to create statements for all customers with transactions in a specific business unit. If you leave this field blank, a default business unit will automatically appear in the field. |
From Date and To Date |
Enter a date range for the accounting date of items that are included in the statement activity. The dates determine the fiscal year and accounting periods used to select information from PeopleSoft General Ledger. |
SetID |
Select a setID or accept the default setID. If you leave this field blank, a default setID will automatically appear in the field. |
Customer |
Enter only a customer ID to create statements for the specified customer. If you select a customer who is part of a correspondence group, the system addresses the statement to the correspondence customer, but includes only the specified customer's information. |
Correspondence Customer |
Enter only the customer ID for a correspondence customer to create statements for all customers in the correspondence group. |
Project |
Optionally, enter a project ID that is associated with a reimbursable agreement to include information only for customers that have reimbursable activity for that project. |
Provide more than one parameter to tailor statements even further. The following table describes the results of combining different parameters. It assumes that a parameter in the left column is combined with one or more parameters to the right of that parameter:
Parameter |
SetID |
Business Unit |
Customer ID |
Business Unit |
One statement for each correspondence customer in the business unit. |
Not applicable (NA) |
NA |
Customer ID |
A single statement for the customer. If the customer is part of a correspondence customer group, the process addresses the statement to the correspondence customer but includes only items that are for the specified customer. |
A single statement for the customer, containing only items in the business unit. If the customer is part of a correspondence customer group, the process addresses the statement to the correspondence customer but includes only items for the specified customer. |
NA |
Correspondence Customer |
A single statement, for the correspondence customer, containing items for all customers in the correspondence group. |
A single statement for the correspondence customer, containing items in the business unit for all customers in the correspondence group. |
A single statement that is addressed to the correspondence customer, containing only items for the specified customer. |