PeopleSoftGuys.com Home
Navigate
August 26th, 2006

Common Financials Terms Used

ï‚§ Pre-encumbrance: Amount that you expect to spend, but which you have no legal obligation to spend. A requisition is a typical pre-encumbrance transaction.ï‚§ Encumbrance: Amount that you have a legal obligation to spend in the future. Issuance of a purchase order to a vendor is a typical encumbrance transaction.

ï‚§ Planned: A free-form non-actuals amount. Can be used as a memo entry or an entry to estimate future spending. Can also be used to record third-party source transactions that precede pre-encumbrance documents. The latter usage requires defining a new source transaction type.

ï‚§ Recognized Revenue: Revenue that you have booked and expect to receive.

ï‚§ Business Unit: A business unit is an organizational entity which maintains its own transaction data.

ï‚§ Transaction Tables: Transaction tables store data about day-to-day business activities. Transaction tables in PeopleSoft are keyed in by Business Unit.

ï‚§ Control Tables: Control tables store information that define the accounting structure and processing rules that are used when transactions are entered into your PeopleSoft applications. Control tables include master lists such as customers, vendors, products, items, and chart of accounts. Control tables are static; they change only when you perform specific maintenance, appropriate to changes in your business policies. Most PeopleSoft tables are keyed by Table Set Identifier, rather than by Business Unit. In addition, most are effective-dated.

ï‚§ TableSet Id: Most data recorded in control tables is stored by Table Set ID (also called as SetID). Whenever your enter information in control table, you must enter the SetID to establish the ownership of that information. A grouping of data that is keyed by the same SetID is called a TableSet.

ï‚§ Record Groups: The control tables used by each of the financial and distribution applications are grouped by function into record groups. A record group is a set of logically and functionally related control tables and views. All tables in the same record group will have the same key on each table.

ï‚§ Record Group Control: In the TableSet record group control panel, you specify which SetID you want a business unit to use for each record group. You can specify a single SetID for all Record Groups or a combination of any number of SetIDs.

ï‚§ TableSet Sharing: TableSet sharing allows different business units to use, or share, the same control information.

August 26th, 2006

Exporting Compare Reports to Excel

I felt that having upgrade compare reports produced in CSV or HTML format was a greatest help to the entire team. It will be very easy keep track of decision made for each and every object and possibly put some comments about the upgrade action taken.

You need tweak the regedit setting on the PC where you run the compare report in the following way.

1. Click on Start Menu - > Run
2. Type Regedit

3. Click on HKEY_CURRENT_USER

4. Click on Software

5. Click on PeopleSoft - > PeopleTools -> Release8.40

6. Click on PSIDE

7. Right Click on PSIDE and Select New DWORD value and create the following DWORD values.
UpgHtmlOutput - for HTML output
UpgTextOutput - for tab delimited text
UpgCsvOutput - for comma delimited CSV output

8. Double click on the DWORD and Set each value to 1 that you want to create reports for. To turn off, set value to 0, or delete the entry.

9. Now run the compare reports and you will have your compare reports in HTML , CSV or Text format files in the same directory as it was for PRT files.

 

August 25th, 2006

Advertisements

  PeopleSoft Guys - > Advertise at PeopleSoftguys 

 
  PeopleSoftguys provide high quality targeted traffic to enterprises who uses PeopleSoft and related software modules. 

PeopleSoftGuys offers variety of advertising options. For more information and rates please contact us at psadmin@peoplesoftguys.com

 

 
August 25th, 2006

Contact Us

  PeopleSoft Guys - > Contact 

 
  Do you have a comment, question, feedback or a bit of suggestion? Having a problem with the site? Have an idea for a partnership? Please feel free to contact us using the contact information below.  

E-mail:

General
psadmin@peoplesoftguys.com

Jobs
jobs@peoplesoftguys.com

 
August 25th, 2006

PeopleSoft Books

  PeopleSoft Guys - > PeopleSoft Books  

 

 
  PeopleSoft guys has been partnered with Amazon.com and offering the following latest peoplesoft books.  

Â