Frequently Asked Questions Regarding Company Names and Numbers (P0010)

Purpose

This document provides answers to frequently asked questions on Company Names and Numbers (P0010).

Questions and Answers

Question 1: After selecting "Allow PBCO Postings" or reopening the period, it still throws "Date Is in this Yr but Prior Mth (PBCO)" error. Why?

Answer 1: General Accounting Constants are cached information stored in both Database Caching and Service Cache. For full details on how to allow PBCO postings, refer to knowledge Overview of General Accounting Constants (P0000).

If you change settings for any of the constants, you must perform following steps in order for the changes to take effect:

• On fat client, signing off and signing back in will help to reset the cache.
• On web client, it will be required to explicitly reset the cache apart from signing off and signing back in.

Reset Database Cache:

• Log into a FAT/HTML or WebDev client.
• Fast Path to WSJ (Work with Submitted Jobs).
• Select Form Exit --> Advanced to open Work with Servers application (P986116 | ZJDE0002).
• Highlight your Enterprise Server and select Row Exit --> Reset Cache.
• Select Database, then click OK. This will flush database caching.

Reset Service Cache:

• Login to the Server Manager.
• Find the JAS instance you're working with.
• Under the Runtime Metrics, select JDBJ Database Caches.
• Select JDBj Service Cache option from the list and click on Clear Cache to flush Service Cache.
• Verify that Cache Size is set to zero.

For more details on Database Caching and Service Cache, refer to Frequently Asked Questions on Caching in EnterpriseOne.

9.1 Update 2

After 9.1 the JD Edwards EnterpriseOne announces a JDB Table Cache Refresh feature that removes the requirement of manually resetting or flushing Enterprise Server Database Cache, when certain tables are updated from programs, such as system constants, payment terms, and more.

The documentation in how the new process to clear cache works is explained in the JD EdwardsEnterpriseOne Tools System Administration Guide.

Question 2: Why is Currency Conversion F0010 CRYR field populated with a 'Y' or 'Z' for base company but as 'N' for the rest of the companies in a multicurrency environment?

Answer 2: The Currency Conversion (CRYR) field in the Company Constants (F0010) table for Company 00000 (default company) gets updated when the Multi Currency Conversion Flag in General Accounting constants (P0000) is setup. For information on how to setup General Accounting Constants, refer to Overview of General Accounting Constants (P0000).

When a new company is created using Company Constants (P0010), this application does not have access to this field and hence cannot update the CRYR field from the form. The system in this case updates the company record with the default value 'N' of CRYR DD item. Anyhow, the setup of a different value for the CRYR field for the rest of companies is not necessary since the system refers to the base company (00000) to fetch the value for Currency Conversion (CRYR) field to determine if the multicurrency flag is enabled or not.

Question 3: Is there a new way to clear the cache?

Answer 3: After 9.1  update 2 the JD Edwards EnterpriseOne announces a JDB Table Cache Refresh feature that removes the requirement of manually resetting or flushing Enterprise Server Database Cache, when certain tables are updated from programs, such as system constants, payment terms, and more.

The documentation in how the new process to clear cache works is explained in the JD EdwardsEnterpriseOne Tools System Administration Guide.

There are also 2 Tools Bugs for known issues for dynamically clearing table cache:
Bug 24924012 - ISSUE WITH JDB_CLEARTABLECACHE
Bug 26596102 - CLEARCACHE NOT HAPPENING AUTOMATICALLY

Question 4: Is it okay to change an existing address book associated with the company in Company Constants (P0010)?

Answer 4: This is just a practice to have the company number the same and company address number but the fields in the tables are different, company address number is data item AN8 and company number is data item CO and so when fetching for values should not affect reports. Just that it may be confusing for users but apart from that there should be no other issues. The main function of the address number field in the Work with Company (P0010) application, is the use of subledger type A and that address book value when intercompany settlements are created.

Moreover, it is not mandatory to specify any address book for company 00000 since it is not used as a transaction company.

Question 5: Does changing one company’s period number in the Company Numbers and Names (F0010) affect a different company’s period activity?

Answer 5: No, each company is set up in Company Numbers and Names (P0010) with its own date pattern, fiscal year and periods.   Changing the period number on one company does not affect a different company.

Question 6: Can the Accounts Payable or Accounts Receivable period number be a period number before the General Accounting period number?

 Answer 6: The system will not allow the Accounts Payable or Accounts Receivable period number to be before the General Accounting period number.  This is because every transaction created in these modules will create a record in the F0911 (Account Ledger) (i.e. a voucher will populate both F0411 and F0911).  The value can be changed while in the Company Setup screen, but when attempting to save the change the system will force the Accounts Payable and Accounts Receivable period numbers to be equal to the General Accounting period number.