copyright © 2013, oracle and/or its affiliates. all rights reserved. 1 roadmap is subject to change...

Copyright © 2013, Oracle and/or its affiliates. All rights reserved.1 Roadmap is subject to change without notice. The above is intended for information purposes and may not be incorporated into a contract


Focus on JD Edwards World: Procure to Pay Class

Dennis Nelson, Senior Support Engineer OSS

Jenny Felice, Senior Support Engineer OSS

Teri Maxwell, Senior Manager OSS

Sue Brown, Director Product Strategy


The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


Agenda

Introduction Procurement Enhancements Procure to Pay Lifecycle Accounts Payable Enhancements Correction of a Voucher Deleted in Accounts Payable Questions


World Procurement Enhancements

Approvals Management for Purchase Orders

No Supplier Master - Prohibit Order Entry

Prohibit Supplier Change in Voucher Match Supplier Prices for Negative Quantities

Company Business Unit Defaults

User Defined Data

Purchase Order Bursting for E-Mail Delivery

EDI Error Notification


Approvals Management for Purchase Orders

The Approvals Management system has been expanded to accommodate purchase orders. Approvals Management was a new system introduced in the A9.1 release to accommodate changes in the Address Book system. The primary benefits of using approvals management for Procurement are that it provides:

A flexible set of variables on which to base your approvals An elaborate designation of approvers A central workbench in which to manage approvals for different applications


Base Approvals on Any Data in:

Purchase Order Header (F4301)

Purchase Order Detail (F4311)

Purchase Order Multiple Accounts (F4316)


Approval Requests Can Be Triggered by (but not limited to):

Upper and Lower Amount Limits Order Types Cost Centers or Branches Account numbers Suppliers, buyers or other address numbers Foreign amounts (in multi-currency environments)


For more information:

See Document 889689.1: Approvals Management for Purchase Orders.

Attend……..


No Supplier Master - Prohibit Order Entry

Purchase Order Entry (P4311) has been enhanced with a processing option to prohibit the entry of orders for which there is no Supplier Master record (F0401) set up for the Supplier or Ship-To address number. This will prohibit the inadvertent entry of purchase orders using customer address numbers.


P4311 Processing Option


Prohibit Supplier Change in Voucher Match

Voucher Match (P4314) has been enhanced with a processing option to prohibit changes to the supplier number. This will help to cover security gaps in the Voucher Match program.


Supplier Prices for Negative Quantities

Prior to the A9.2 release, if you entered a purchase order stock line for a negative quantity, the system would not retrieve a supplier price for the goods, provided you set up amounts in the Supplier Price file (F41061).

It would use the purchasing cost value from the F4105. The system will now retrieve supplier prices for negative

purchase order quantities.


Purchase Price level 1 or 2 - F41061 Cost


Supplier Defaults by Company/Business Unit

This enhancement allows you to enter supplier Payment Information, Category Code and Accounting Distribution Information by Company and/or Business Unit for the same supplier.

Defaults and controls at a company and/or business unit level rather than just at the supplier or customer level.

New file F04015- Supplier Master Company/Business Unit


Supplier Master


Supplier Co/Bus. Unit Defaults


Order Default settings


Supplier Purchasing Instructions


Supplier – Supplier Master


Ship To Purchasing Instructions


Default Values at PO Entry

Red = From Supplier

Blue = From Ship To


Business Unit Default Settings


Defaulting from BU Defaults


Voucher w/o BU DefaultsPay Terms = A

Tax = S/Den

Alt Payee = 4343


Voucher with BU Defaults for BU 10

Pay Terms = NXT

Tax = E/CO

Alt Payee = 4345


User Defined Data

The User Defined Data (UDD) enhancement consists of numerous new files and programs that allow you to store and maintain supplemental data pertinent to inventory items, customers, suppliers, sales orders, and purchase orders.

The data you store for suppliers and inventory items can be used to default to the user-defined data you add for purchase orders.

Accommodate Electronic Data Interchange (EDI) clients who require a greater number of fields in which to store trading partner specific data. User defined data for purchase orders can be brought in to, or extracted from, the system via pertinent EDI transaction programs.

For more information, see Document 858973.1: User Defined Data for Distribution.


Set Up Supplier Default Values – F04016


UDD Defaults


Define F04016 F43016


Default @ PO Entry


Problem:• Does your enterprise suffer from a cumbersome PO distribution process? Do you

have requirements for e-delivery of Purchase Orders to suppliers? Is there an immediate need to streamline and speed up Purchase Order document delivery?

Solution:• Using JDE World Purchasing and Electronic Document Delivery with integrated

Oracle BI Publisher, users can generate and automatically distribute pixel perfect formatted PO documents to your suppliers via electronic communication: i.e. E-mail.


Continuing to expand the capabilities of Export and Electronic Document Delivery

More DREAM Writers have been enabled• MPS Planning Report P3450

• Supplier Schedule Print P34450

• Invoices P42565

• Purchase Orders P43500

• Quote Request P43530

FASTR and STAR are enabled Sample Templates for BI Publisher reports are available for

users to begin working with


Publish data through the integration to BI Publisher (sample templates available)


Our Example: Publish and Email Purchase Order(s) to Suppliers


Purchase Order Bursting for E-Mail Delivery

You can set up the system to deliver purchase orders to your suppliers via e-mail as of the A9.2 cumulative update 1 release. Bursting capability has been added to the Purchase Order Print program (P43500) such that the spool file generated by P43500 is burst by supplier for purposes of delivering purchase orders by e-mail.

The Quote Request program (P43530) also has bursting capability as of the A9.2 base release.

Using this functionality requires that you set up the Electronic Document Delivery system (EDD).

For more information about EDD, see Document 964321.1: JD Edwards World A9.2 Working with Electronic Document Delivery.


EDI Error Notification

Specific EDI programs have been enhanced to take advantage of the new Electronic Document Delivery (EDD) functionality to e-mail trading partners concerning errors that occur on inbound transactions.

The programs that accommodate inbound EDI transaction sets 810, 855 and 865 will now allow for notifying trading partners of problems so they can correct and resend their data, as necessary.

The programs will also purge transactions records in error upon notification to the trading partner.

For more information, see Document 858992.1: EDI Error Notification


Additional Procurement Enhancements

New Inquiry and Report to Cross Reference a Purchase Order to Associated G/L Documents

Enter Receipts, Do Not Allow Inventory to go Negative – P4312

Prevent the Creation of Accounts Payable Vouchers for Selected Line Types and Zero Dollar Vouchers

Accommodate Summarized Journal Entries via the RNV Reconciliation “As Of” Report

Update Lot Category Values Upon Receipt of an Item to New Lot

Behind the Scenes Changes to Aid in the Prevention of Rounding Issues

Accommodate Stock Line Types on Direct Ship Orders via the Receipt Process


Procurement – Cross Reference PO to G/L

The PO/Receipt/Voucher Summary Inquiry (P43260) is a new program that allows you to inquire on a purchase order to view the G/L Documents associated with the order.

Options exits from the video allow you to access:

– Purchase Order Entry– Open Order Information (P43030W)– Journal Entries (P09101)– Item Ledger (P4111)– Voucher Match (P4314)– Operation Ledger Inquiry for Receipts Routing (P43252)– Enter/Change Work Orders (P48013)


Option 1 will show PO info – P43030W


Option 2 will show POE – P4311


Option 3 will show Journal Entries - P09101


Option 4 will show Open Order Inquiry – P430301


Option 5 will show Item Ledger – P4111


Option 6 will show Manufacturing Work Order Detail P48013


Option 7 will show Voucher Match - P4314


Option 8 will show Receipt Routing Ledger Inquiry – P43252



Processing options for the PO/Receipt/Voucher Summary Inquiry (P43260) allow you to determine whether G/L documents display for landed costs and/or documents created in receipts routing.


Procurement – Cross Reference PO to G/L G/L documents created during the receipt routing process display in reverse

image on the video. Movement within the receipt route displays in the Item/Account Field.

G/L documents created for Landed Costs display a description of the landed cost in the Item/Account field.



The PO/Receipt/Voucher Summary Report (P43560) is a new program that allows you to print all G/L documents associated with a purchase order.

The report program is a wrapper program that calls the new inquiry program (P43260).

You use processing options for the wrapper program to designate which version of P43260 you want to call. You use data selection to select the orders you want to print.


Procurement – Cross Reference PO to G/LThe PO/Receipt/Voucher Summary Report (P43560)


Procurement – Cross Reference PO to G/LThe PO/Receipt/Voucher Summary Inquiry (P43260) and Report (P43560) programs are accessible from the Reconciliation Reports and Inquiries menu (G43A1111)


Enter Receipts, Do Not Allow Inventory to go Negative – P4312

Prevents the transaction from causing a negative inventory balance

Produce a hard error if inventory will go negative as a result of the pending transaction

Inventory going negative will result in an incorrect average cost for the item.


Procurement – Prevent Voucher Creation

The functionality now exists to prevent the creation of A/P vouchers by order line type using the Match Invoice to Voucher programs.

Example: A sales transfer order is typically used to track the movement of goods from one branch to another. You want the receiving branch to take receipt of the goods; however you may not want to create a voucher reflecting payment of the goods from the receiving branch to the shipping branch.

Prior to the A9.3 release, you must create a voucher to fully process the order. This is no longer the case in the A9.3 release.



Prevent the creation of vouchers by line type using the A/P Interface Flag in Order Line Types (P40205).



You must designate the line types for which there is no interface to the Accounts Payable (A/P) system in Order Line Types (P40205).

A value of No for the A/P Interface Flag in Order Line Types is now recognized by the online Voucher Match program (P4314) and the EDI/Batch Voucher Match program (P470412).

A value of No instructs the Voucher Match programs to create a match type 2 record in the Purchase Order Receipt/Voucher file (F43121). The record serves to indicate that no further processing of the receipt is necessary. The system assigns a zero to the Document Number field in the F43121, and no journal entries are created.

You must still perform voucher match to fully process all purchase order lines; however; you can set up the system to automatically perform voucher match using the Evaluated Receipts program (P43800), which calls the batch Voucher Match program (P470412).



You can also prevent the creation of zero dollar vouchers by setting on the following processing option, which exists for both the online and batch voucher match programs:


Procurement – RNV Reconciliation (P43542)

The “As Of Reconciliation” report (P43452) was introduced in the A9.1 release to list discrepancies between the G/L and purchasing system in regard to a particular RNV account.

The “As Of Reconciliation” report (P43452) is now fully functional in an environment in which journal entries are summarized via the Enter Receipts (P4312) and voucher match programs. This was not the case prior to the A9.3 release.

A new history file (F43121H) was also added in A91 to accommodate the report. The file preserves receipt and voucher transaction information in its initial form, unlike the PO Receipt/Voucher file (F43121).



“As Of Reconciliation” report (P43452) is now fully functionality when journal entries are summarized at Enter Receipts and Voucher Match.

Report format for non- summarized journal entries

Report format for summarized journal entries



You MUST run the appropriate version of P43452 to obtain the correct results for summarized journal entries.

Versions XJDE0003 and XJDE0004 accommodate environments where the journal entries are summarized, and sequence information by Document Number (instead of Purchase Order Number).


Procurement – Update Lot Category Values

It is common for companies that maintain lot controlled environments to create new lots ‘on the fly’ when taking receipt of purchased goods.

New requirements call for these businesses to maintain the country of origin for each lot received into inventory.

To accommodate items that originate from multiple countries, you can designate that a certain lot category code be used to record and maintain the country of origin for each lot number.

To facilitate this process, new functionality exists in the Enter Receipts program (P4312) to record lot category code values at the time that items are received with a lot number.



A new processing option exists for the Enter Receipts program (P4312) to automatically display the Lot Category code window upon receiving items into a new or existing lot:


Procurement – Update Lot Category ValuesUpon taking receipt of a lot controlled item, the Lot Category Code window will automatically display, allowing you to enter a value for Country of Origin (or anything else you choose).



To complete the process, the following programs have been enhanced in the Sales Order Management system to accommodate the printing of Lot Category Code and Country of Origin values:

– Invoice/Acknowledgement Print (P42565)– Bill of Lading (P42530)

Each of the programs above now has one or more processing options geared to print Lot Category Code values.


Procurement – Behind the Scenes

Several behind the scenes changes have been made to the Procurement system to aid in the prevention of multi-currency rounding issues, including:

– A new field (CRRF) added to the Receipts/Voucher file (F43121) to track the source date of the exchange rate (order date, current date, G/L date, override date).

– Order lines received in their entirety via P4312 will no longer be recalculated.

– Procurement programs will no longer call the G/L functional server (XT0911Z1) to make calculations, instead, calculations will be made in the program itself.

– The Voucher Match programs (P4314 and P470412) will now calculate foreign and domestic taxes separately rather than to calculate one side and convert to the other.


Procurement – Direct Ship Orders

New functionality has been added to the Procurement system to accommodate enhancements to the Direct Ship Order process. (Direct ship orders are created in Sales Order Management):

– The Procurement system will now maintain a one to one relationship between lines on the sales (SD) versus purchase order (OD) for direct ships.

– When you receive an OD, the Enter Receipts program (P4312) will update the location or lot number on the OD to the SD.

– When you receive an OD, the Enter Receipts program will automatically call the Batch Shipment Confirmation program (P42051) to ship the SD.


Procurement – Direct Ship OrdersProcessing options 51 thru 53 are new for Enter Receipts (P4312). Processing option 50 has been renumbered from previous releases.



Enter a one line direct ship order

Receive a partial quantity



The line on the OD is split to reflect the received quantity versus the quantity open to receive. The line on the SD is also split to allow for shipment of the received quantity, and to maintain a one to one relationship between the SD and OD.


Export Updates

The Enter Receipts program (P4312) has been enhanced to include interactive export capability via function key 23.

The Order Ledger Detail by Supplier report (P43421) has been enhanced to include batch export capability.

UDC tables list which programs and files are enabled for import/export.– 00/BI - Batch Files supported for import.

– 00/BE - Batch Programs supported for export.

– 00/II - Interactive Programs supported for import.

– 00/IE - Interactive Programs Supported for export.


Reference Documents

Document 1096425.1: World A9.2 Enhancements to the Procurement System Document 1446441.1: World A9.3 Enhancements to Procurement Document 889689.1: Approvals Management for Purchase Orders Document 858973.1: User Defined Data for Distribution Document 964321.1: JD Edwards World A9.2 Working with Electronic

Document Delivery Document 858992.1: EDI Error Notification. For more information about EDD Document 1153214.1 : Batch PC Export Function Key F6 From Additional

Parameters in DREAMWriters P43500 PO Print and P42565 Invoice Print


Break


Procure to Pay Lifecycle


Enter PO


PO Detail


Receive PO


Receive PO cont


Voucher Match


Voucher Created


F10 to view Voucher


P43260 - PO/Receipt/Voucher Summary


Accounts Payable Processing


P042003, Supplier Ledger

jenny ferguson


Supplier Master Defaults


Multiple Payments


Voucher 88677, 3 pay items:


UDC table 00 / PY


P0417, Payment Instrument Defaults


P04114, Speed Release


Speed release, F4, showing data in the fold


P04114, changing data on Speed Release


Create Payment Groups, P04570


P04570 Create Payment Groups


Reviewing processing options and data selection:


P04570, key processing options


Discount Date processing options, P04570


Override bank account:


Data selection for P04570, Create Payment Groups:


Payment Group Edit Report, P04570


P04257, Work With Payment Groups


P04257W2, Write Payments


Example of check created from the write process:


P04257, Work With Payment Groups


Payment Register, P04576


Posting Edit Report of an AP payment:


Electronic Funds Transfer (EFT)


Payment Instrument Defaults, P0417:


Create Payment Groups, P04570:


Work With Payment Groups, P04257


S04572TE; Advice Notification


P0457, Copy Bank Tape File to Tape


Display Physical File Member


F04572T:


P04576T


Post Edit Report for EFT Payments:


P042003, Supplier Ledger Inquiry


P04103,Void Payment Entry


P04103, Void Payment Entry


Voided voucher in wrong program


XT0411Z1


P04103, Processing option for Void Payment


P04105, processing options


P04103 Void Payment Entry


Error:


Please exit and run the following Qarbon Executables in order.

Final Deleted in ap 1 – 3-Way Match Process Final Deleted in ap 2 – File Review Final Deleted in ap 3 – Delete PV in F04105 Final Deleted in ap 4 – File Review after Improper Deletion Final Deleted in ap 5 – How to Correct


WORLD ACCOUNTS PAYABLE ENHANCEMENTS

Purchase Card (Pcards) Accounts Payable Approvals Management Batch Export to Email (Burst) for EFT remittance advice New IAT payment format, P04572T3


PURCHASE CARD MANAGEMENT

Using the Purchase Card Management (PCard) system allows companies to:

Coordinate restrictions and cardholder usage with their financial institution.

Receive and process transmissions from your financial institutions for the purchases your employees make.

Receive and process statements for reconciliation purposes.

Generate transactions in the General Ledger and Accounts Payable systems to record PCard expenses and pay your financial instituions.

Track purchasing trends and supplier performance.

Monitor cardholder purchases.

Monitor cardholder usage of preferred merchants

For more information please refer to the following document: – Purchase Card Management, (Doc ID 965269.1)


ACCOUNTS PAYABLE APPROVALS MANAGEMENT

A/P approvals controls can be set up to determine the approval status for all vouchers added or changed. Controls can be set up based on the voucher's:

gross or taxable amount

document type

business unit

company

any combination of the above

When A/P Approvals is activated, the system prevents payment on any voucher that does not have an appropriate A/P approval status regardless of its pay status.

For more information please refer to the following document; – Accounts Payable Approvals Process (P0453, X0453) (Doc ID 640961.1)


ELECTRONIC DOCUMENT DELIVERY (EDD)

For A/P Payments

- Added new payment format that will produce your hardcopy payment data (remittance advice for EFT payments) in an .XML file format. That can be emailed to your suppliers.

For more information please refer to the following documents:

- Using the Batch Export Process to Email Documents (Doc ID 1174023.1)

Do- Using JD Edwards World Import and Export, (Doc ID 1413956.2)

- Using JD Edwards World Electronic Document Deliver (EDD) (Doc ID 1414820.2)

- Programs and Files with Import/Export and Bursting Capabilities in Release A9.x

(Doc ID 1206790.1)

https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1413956.2


IAT PAYMENT FORMAT, P04572T3

Government requirement for a new NACHA format for businesses that are transferring money to a bank account in another country, known as the IAT format.

Created programming, P04572T3, that supports the new IAT format. The ODFI/RDFI bank account addresses are also now required. We created

Bank Account Addresses (P00303) for this purpose.


Information Centers


Information Center


Upgrading to A9.3.1


Procure to Pay Sessions at Collaborate 2013

Session# Day Time Title

107880 Tue 16:30 Distribution- The Range of Possibilities

108120 Wed 8:15JDE World Financial Reporting: Look at Everything We Have Done!

108090 Wed 4:15JD Edwards World - Purchase Card Management Reduces Your Payment Processing Costs


How to Correct a Voucher Deleted in Accounts Payable


Q&A

copyright © 2013, oracle and/or its affiliates. all rights reserved. 1 roadmap is subject to change...

Documents

information purposes

oracle andor

supplier change

contract approvals management

contract base approvals

approvals management

entry of orders

sole discretion of oracle