Пропустить навигацию
1 2 Назад Вперед

JDE EnterpriseOne Support Blog

24 Записи автора: Peggyhr-Oracle

Record reservation functionality is available in a number of programs in EnterpriseOne.  With a recent 9.2 update, record reservation has been added to the Print Delivery Notes UBE (R42535) in the 9.2 release. With the ESU installed, if a record is reserved by another program Print Delivery Notes (R42535) will not process the record.

 

See Record Reservation Functionality in Print Delivery Notes (R42535) (Doc ID 2601784.1) for the Bug / ESU information along with post install instructions.

Address Book Data Security / Data Privacy allows you to restrict users from viewing sensitive Address Book information. After performing the required setup for this feature, secured users will be able to see the secured fields, but these fields are populated with asterisks.  These fields are also disabled so no changes can be made.

 

A recent update in the 9.2 release ensures your Address Book Data Privacy carries over to the Purchase Order Entry application (P4310).  See  Data Privacy Setting Functionality Available in Purchase Order Entry (Purchase Order Entry) (Doc ID 2565600.1) for the 9.2 Bug / ESU information.

 

For more information about Address Book Data Privacy, see How To Set Up Address Book Data Privacy In JD Edwards EnterpriseOne (P01138) (Doc ID 1517572.1).

Historically, there has been a difference in the Soft Rounding calculation between Sales Orders and Purchase Orders when using an Item Group (Purchasing Taxable) for Multiple Tax Rate configuration. In the Sales Order module, when Sales Update (R42800) creates Accounts Receivable records (F03B11/F0911), a Soft Rounding for Tax Calculation is done grouped by Tax Area and Item Group. In the Purchase Order module, when Match Voucher to Open Receipts (P4314) creates Accounts Payable records (F0411/F0911) a Soft Rounding for Tax Calculation is done grouped by Tax Area only. The Item Group (Purchasing Taxable) was ignored.

 

An enhancement is now available in releases 9.1 and 9.2 that allows users to choose to enable Voucher Match Tax Rounding by company for Accounts Payable.

 

For more information see Enhancement Available in Match Voucher Match to Open Receipts (P4314) to Allow Soft Rounding for Tax Calculation Grouped by Tax Area and Item Group (Doc ID 2475356.1).

You asked. We delivered.

 

Historically in sales order entry, in order to use existing Available to Promise (ATP) or Cumulative Available to Promise (CATP) calculations to determine a Delivery Date during current sales order entry, the user must exit to the Supply/Demand Inquiry form where the date is displayed and then return the date.

 

An Enhancement is now available in the 9.2 release that streamlines the sales order entry process by allowing for automatic population of sales order dates without having to access the Supply/Demand Inquiry form.

 

The new functionality automatically populates the pick date without having to access the Supply/Demand Inquiry form when the user enters a sales order line for a quantity of an item and tabs to the next line without entering any dates.

 

For more information see Enhancement Available in Sales Order Entry (P4210/P42101) to Automatically Return Pick Date from Available to Promise (ATP) or Cumulative Available to Promise (CATP) (Doc ID 2555461.1)

Have you ever identified a batch that posted completely but not correctly?

 

Maybe, during your review of integrity reports you identified a batch where the AE entry was not created but the remainder of the entries in the batch are posted. Or, you may have identified a batch where the debits do not equal the credits but all the entries in the batch are posted.

 

After researching the batch, you identify the amounts and accounts that are missing entries.  Now what?

 

How do you create a journal entry, or multiple journal entries, to bring the batch back into balance? How do you create a one-sided journal entry and then successfully post the journal entry to update the Account Ledger (F0911) and the Account Balance (F0902) tables?

 

Our knowledge document How To Create and Post a One-Sided Journal Entry (Doc ID 2513031.1) walks you through successfully creating and posting a one-sided journal entry.

impact-clipart-599193-migrateorsynchr_13BED_CLIPART_OF_31983_SMJPG_2.jpg

Are you using the customer credit limits and credit hold codes to effectively manage accounts receivable?

 

Credits granted to your customers are similar to financial loans.  Effective use of the credit limit ensures that the amount of credit granted a customer aligns with the financial abilities of each customer.

 

Setting up a credit limit on a customer account does not mean that new sales orders cannot be created for the customer. In EnterpriseOne, credit holds can be setup based on the customer's credit limit or based on the age of open accounts receivable.  A credit hold on a customer's sales order(s) will prevent further processing of the order, to reduce your risk.  You don't always want to ship items to customers who are poor payers, customers with a history of late payments or missed payments.

 

Did you know that you can record information for credit insurance policies (insured credit limit) in EnterpriseOne?

 

Don't get caught with large noncollectable accounts receivable balances. Review the functionality available in EnterpriseOne in Credit Checking (Doc ID 2319760.2).

 

 

8iE6jn6bT.gifMany suppliers have a business process where they cannot invoice customers until the customer confirms delivery of the product, which completes the supplier’s performance obligation. The elapsed time between shipping and delivery can be as great as 60 days. With this business process, suppliers cannot recognize revenue until the invoice has been posted, which must occur after the performance obligation. Also during the in-transit period the shipping company continues to have legal ownership of the product until it has been accepted by the receiving customer.

 

During this period, the value of in-transit inventory must remain on the balance sheet of the shipping company until the material is received and accepted by the customer. Invoicing and Sales Update processing must be delayed until the material is received and accepted at which time the legal ownership is transferred from the Supplier to the Customer.

 

An enhancement is available in the 9.2 release of JD Edwards EnterpriseOne to provide the functionality to create journal entries for In-Transit Inventory at the time of Ship Confirm (P4205).  For additional information see 9.2 Enhancement - Retaining Ownership of Inventory While In Transit (Doc ID 2246772.1).

An enhancement is available for JD Edwards EnterpriseOne 9.2 customers using the distribution modules.  Refresh Inventory Commitments (R42990) refreshes any inventory commitments in F41021 (Item Location File) where the item does not have any active sales orders associated with it. The existing program, Repost Active Sales Orders (R42995) refreshes the commitments for only those items that have an active sales order. There may be a case where the sales orders are all completed for an item but for some reason there is still an outstanding commitment recorded in F41021 that needs to be cleared out. R42995 will not update this item in F41021.

 

Prior to the enhancement, if no active sales orders exist prior to running the Repost Active Sales Orders (R42995), when R42995 was run for locations that have hard/soft committed buckets filled but no open orders in the Sales Order Detail (F4211) exist, commitments would not be cleared for those Item Locations in the F41021 file. One workaround involved creating a 'dummy' order for the specific item so that R42995 would correctly repost the order. The 'dummy' order would then need to be cancelled after running the Repost Active Sales Orders (R42995) program. Another workaround involved using a database utility program such as SQL to clear the commitment buckets in the Item Location (F41021) prior to running the Repost Active Sales Orders (R42995). This process was more efficient if numerous items need to have the quantities and amounts reposted but do not have an open order in the Sales Order Detail (F4211). This process eliminated the need to create and delete what could be many individual "dummy" orders.

 

For complete information on the enhancement, see Refresh Inventory Commitments (R42990) (Doc ID 2230896.1).

Companies can use Receipt Routing to track the movement of items as they leave the Supplier's warehouse until they arrive in stock through a series of operations that make up a Receipt Route. Depending on the operations, several steps may exist, such as dock, staging area, inspection, and so forth.

 

Any company that has a multi-step receiving process can benefit by using a Receipt Route. Receipt Routing allows companies to locate goods at any point within the routing process, which can be setup to track from the "in transit" operation to stock. A Receipt Route can be setup to require testing or inspection where samples are tested to determine the quality of the goods. Unacceptable goods, regardless of how they are found, can be dispositioned during any step prior to being placed into stock. Quantities that are dispositioned will not continue in the receipt route and will not be included in stock. Dispositioned items can be eligible for payment if the system is setup that way.

 

For an all inclusive document on receipt routing, review Receipt Routing (Doc ID 2101173.2).  You will find all the information on route setup, disposition, reviewing each movement of an item through a receipt route, the AAIs used in receipt routing , examples of transactions and much, much more.


Do Unit of Measure Conversions puzzle you?  How does unit of measure conversion work in JD Edwards EntepriseOne?

 

In order to perform daily operations and process business transactions successfully, all businesses  that distribute products (inventory) require two types of unit of measure conversions: Item Unit of Measure Conversions and Standard Unit of Measure Conversions.

 

What is the difference between item unit of measure conversion and standard unit of conversion? What setup is required for unit of measure conversion? How is unit of measure conversion used in Procurement? In Sales?

 

Review our knowledge document Unit of Measure Conversion (Doc ID 2102783.2) for the answers to these questions. Additionally, you will find information for troubleshooting common errors and specific errors.  And, much more!

 

Do you need to track inventory in one unit of measure and transact and calculate price in a different unit of measure?  If so, dual unit of measure functionality may be the solution for your business.  Check out our knowledge document  Dual Unit of Measure (Doc ID 625673.1).

The difference between a lot controlled item and a serialized item is that  quantities for receipt or shipment from a lot number are only limited by availability. It is not possible to receive or ship a quantity greater than 1 of a specific serial number.

 

EnterpriseOne provides two methods for managing serial numbered items. One method, the older method. stores a serial number in the Serial Number (F4220) table, which has a one-to-many relationship with the Item Location (F41021) table. The second method, the newer method, stores the Serial Number in the Lot/Serial field (LOTN) in the Item Location (F41021) table. Using the newer method, it is possible to track a both a lot number and serial number by linking to the Memo Lot 1/2/3 (LOT1/LOT2/LOT3) fields in the Lot Master (F4108).

 

The differences in setup and functionality of the two methods of serial number control are significant and are explored  in greater detail in our new knowledge document Lot Processing and Serial Number Control (Doc ID 2094021.2).

A Transfer Order is an internal sales order used to transfer inventory from one warehouse (branch) to another. The Transfer Order program (P4210) creates both a sales order in the "From Branch", the shipping branch, and a purchase order in the "To Branch", the receiving branch.

 

Transfer Orders (ST/OT) are designed to be used to move quantities from one Branch/Plant to another. Non-stock items, direct ship items and other items that do not have quantities in the Item Balance (F41021) table are not appropriate for transfer orders and are  not supported. Also, kits containing a parent item with K stocking type and a bill of material with component items are not supported for Transfer Orders. The individual component items can be used for transfer orders provided the line types meet the line type requirements for Transfer Orders.

 

The default document types created for transfer orders are ST (sales order) and OT (purchase order), and are often referred to as an ST/OT order. When a sales transfer order (ST) order is created, the purchase transfer order (OT) is also created, regardless of whether the "Generate Purchase Order" flag is activated or not in the line type constants (P40205). Additionally, the Transfer/Direct Ship/Intercompany field (SDS011) in the Sales Order Detail file (F4211) is marked with a '1', indicating a transfer order.

 

Transfer Orders have unique setup considerations compared with regular customer sales orders which will be discussed in detail in document Transfer Order (ST/OT) (Doc ID 2094796.2).

Do you have questions regarding approval processing?


Are you setting up approval processing for the first time?


Have your auditors suggested revisions to your approval processing?

 

Find answers to the above questions and much more including understanding the Held Orders Table (F4209) and troubleshooting common errors in our new knowledge document Approval Processing in EnterpriseOne (Doc ID 2090884.2).

Are you investigating Vertex Q Series for Payroll and/or Sales & Use Tax to meet your business needs? Or, are you currently working with Vertex Q Series for Payroll and/or Sales & Use Tax?  Check out the wealth of information available in Vertex Knowledge Center for JD Edwards EnterpriseOne (Doc 1676973.2).

 

This document provides assistance with setup, configuration, reference and troubleshooting information related to Vertex Q Series tax software being used with the JD Edwards EnterpriseOne applications. In addition to providing easy access to knowledge documents, our knowledge center provides step-by-step start to finish instructions useful for understanding how to complete the integration of Vertex Q Series with JD Edwards EnterpriseOne, along with implementing corresponding features and functionality.

 

Both technical and functional users will find the knowledge center information helpful.  We cover  both configuration and testing details (integration), and functional aspects of relevant JD Edwards EnterpriseOne features and functionality (implementation).

 

The Overview page provides immediately useful information.  More specific and logically grouped knowledge documents (Payroll Tax, Sales & Use Tax, technical, Bugs, etc.) are provided via the "Reference & Resolve" tab.

 

The Integrate & Implement tab guides you through the process of integration and implementation of the Vertex Q Series Tax software with your JD Edwards EnterpriseOne applications.

 

Be sure to mark the Vertex Knowledge Center for JD Edwards EnterpriseOne (Doc 1676973.2) as a favorite document.


Peggyhr-Oracle

Encumbrance Accounting Tips

Опубликовано: Peggyhr-Oracle 10.11.2015

Is your fiscal year-end is fast approaching? If so, you might want to review information pertinent to encumbrance/commitment accounting as it pertains to JD Edwards EnterpriseOne.

 

An encumbrance accounting system allows you to reserve budgeted funds for outstanding obligations. In EnterpriseOne Procurement, an encumbrance is represented by an open purchase order or contract. Since funds are typically expended on a fiscal year basis, an encumbrance should be relieved in the same fiscal year in which it was encumbered.

 

The terms commitment and encumbrance are interchangeable in EnterpriseOne Procurement applications. The term commitment is typically used for non-stock purchasing or managing contracts. The term encumbrance is typically used in conjunction with services and expense based purchasing.

 

The system tracks encumbrances and actual amounts logged against each pertinent account number for the fiscal year to determine the remaining budget available.

 

Encumbrances versus Actual Amounts - points to remember:

  • An encumbered expense is one that pertains to an ‘open’ purchase order. Encumbered amounts are tracked in the Account Balances file (F0902) using ledger type PA.
  • An actual expense is one that represents an actual cost incurred. Actual amounts are tracked in the F0902 using ledger type AA.
  • An encumbered amount becomes an actual amount when a purchase order is either:
    • Received via the Enter Receipts By Item or Enter Receipts by Order application (P4312) then Matched to the receipt(s) using the Voucher Match to Open Receipts application (P0411/P4314) using a 3-way match.  The resulting voucher batch, batch type V, is posted.
    • Matched to the purchase order using the Voucher Match to Open Receipts application (P0411/P4314) via a 2-way match. The resulting voucher batch, batch type V, is posted.

 

Encumbrance dates to remember:

  • An expense is encumbered as of the G/L Date entered on the purchase order detail line (F4311).
  • An encumbrance is relieved as of the G/L Date assigned to the journal entries created by P4312 or P4314 or as of the date the purchase order is cancelled.

 

The cancel date for a purchase order line is recognized as the date the cancellation occurs. However, the cancel date is not maintained in any file. If you run the repost, the commitment date is used as the cancel date.

 

For an outline of process flows for Two-Way Match for Commitments and Encumbrances, Three-Way Match for Commitments and Encumbrances and Purge/Rebuild/Repost see Commitment/Encumbrance Best Practices (Doc ID 646593.1)

 

When troubleshooting issues related to encumbrances and/or commitments, it is always beneficial to ensure the most up-to-date objects for the related processes are installed in your environment.  See Change Assistant Pre-Defined Query For Encumbrance / Commitment Objects (Doc ID 1945124.1).

 

If encumbrance amounts display incorrectly in Encumbrance Inquiry (P40230A) or Budget Comparison (P09210A), review Checklist for Troubleshooting Commitment/Encumbrance Integrity Issues (Doc ID 657403.1).

 

At fiscal year-end you must either close or rollover all open purchase orders to the next fiscal year. The Encumbrance Rollover program (R4317) is an automated batch process you can use to:

  • Cancel all open purchase order lines in the prior year.
  • Roll over open purchase order lines and amounts from the prior fiscal year to the new year.

 

For information about R4317, please see Encumbrance Rollover (R4317) (Doc ID 625473.1).

Фильтр по блогу

По дате: По метке:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.