Archive for the 'Financials' Category

PeopleSoft AR transaction tables

The following are the common AR Transaction tables
PS_ITEM  - Item related information will be stored.
PS_GROUP_CONTROL – Groups related information will be stored
PS_PENDING_ITEM  - Pending items related to pending group will be stored.
PS_ITEM_DST - Accounting information related to a pending group will be stored.
PS_PENDING_DST - Accounting information related to a posted group will be  stored.
PS_DEPOSIT_CONTROL - [...]

Conversion of SBT to PeopleSoft 8.8 FSCM

I’m currently leading a project for a public sector client and we needed to perform a data conversion of legacy data from SBT system into PeopleSoft financials and supply chain system.
The approach I designed to bring the data into the PeopleSoft system is

Export the data from SBT system (Which is in FoxPro) to .dbf files
Import the [...]

PeopleSoft AR Deposit Entry Errors out with Time out

This was one of the strange situations we faced when we went live with PeopleTools 8.45.17 and Financials 8.8 SP1 Maintenance Pack 3.
After a couple of days that we went live users in Accounts Receivables area started complaining that they can’t enter the deposits any more and the system started throwing them out.
I identified that [...]

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. [...]