Docstoc

Server Inventory Template

Document Sample
Server Inventory Template Powered By Docstoc
					                                                                                                    Training Guide
                                                                                        Enterprise Inventory 8.9


                                         Enterprise Inventory 8.9
                             Created on Wednesday, August 10, 2011


                                             Table of Contents
Introduction ....................................................................................................................... ii
Transaction Accounting ................................................................................................... 1
   Creating Accounting Entry Lines ................................................................................................ 1
   Running the Journal Generator Process....................................................................................... 9
   Viewing Unposted Accounting Lines........................................................................................ 21




Last changed on: 8/10/2011 4:13 PM                                                                                    Page i of 27
 Training Guide
 Enterprise Inventory 8.9



Introduction
PeopleSoft Inventory supports multiple materials management functions. In many companies,
such functions are handled by separate, standalone systems. By incorporating these functions into
a single database, PeopleSoft Inventory can reduce redundant data and thereby reduce the
associated maintenance, reconciliation, and data integrity problems. Even though PeopleSoft
Inventory is designed to store large quantities of data to support many functions, you can control
the amount of data that you access at any given time by selecting only the information that you
need. PeopleSoft Inventory provides you with standard features, such as shipments, stocking,
transfers, adjustments, replenishment, and physical accounting.

Upon successful completion of this module, you will be able to:
• Define inventory facility structure.
• Define inventory items.
• Maintain containers.
• Stock material (Putaway).
• Discuss cross docking.
• Setup demand fulfillment options.
• Create material stock requests.
• Reserve inventory.
• Pick inventory.
• Ship inventory.
• Define transaction accounting rules
• Replenish inventory
• Transfer stock
• Count inventory stock
• Maintain par locations
• Maintain inventory
• Run reports




Last changed on: 8/10/2011 4:13:00 PM                                                Page ii of 27
                                                                            Training Guide
                                                                   Enterprise Inventory 8.9



Transaction Accounting
Once you have entered transactions into PeopleSoft Inventory, the system is ready to cost the
transactions using the Transaction Costing process (CM_COSTING), and then create the
accounting entries using the Accounting Line Creation process (CM_ALC).

Inventory transactions are stored in the TRANSACTION_INV table. The Transaction Costing
process picks up these transactions and attaches a cost to these inventory transactions based on
the cost profiles. For actual and average costed items that are manufactured in PeopleSoft
Manufacturing, this process can calculate the actual production costs. Transaction Costing also
calculates purchase price variances and exchange rate variances. The Accounting Line Creation
process picks up the calculated costs, creates the accounting entries, and stores the entries in the
CM_ACCTG_LINE table.

You use the Unposted Line Edit page to change the accounting entries before they are posted to
the general ledger. Once, you are satisfied with the entries, use the Journal Generator process
(JRNL_GEN_REQUEST) to summarize the accounting entries into journal entries. PeopleSoft
General Ledger can then post the journal entries to the correct ledgers.

Upon completion of this lesson, you will be able to:
• Create accounting entry lines.
• Run the Journal Generator process.
• View unposted accounting lines.


Creating Accounting Entry Lines
The Accounting Line Creation process (CM_ALC) retrieves costed transactions and finds the
ChartFields to use for the debit and credit lines of each accounting entry. The results are stored in
the CM_ACCTG_LINE table. The process always uses the date and time of the transaction and
not the transaction date that was entered.

The Accounting Line Creation process searches for the correct ChartField information to build
the accounting entry lines.

In this topic, you will learn to create accounting lines in PeopleSoft Inventory.

Several transactions are made in your company. You prepared costs for the transactions by
running the transaction costing process. You need to retrieve cost transactions and find
ChartFields for the debit and credit lines of each accounting entry. To do this, you run the
Accounting Line Creation process to create the accounting entry lines using PeopleSoft
Inventory.


Procedure



Last changed on: 8/10/2011 4:13 PM                                                       Page 1 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   1.        Begin by navigating to the Cost Accounting Creation page.
             Click the Cost Accounting link.

   2.        Click the Inventory and Mfg Accounting link.




Last changed on: 8/10/2011 4:13:00 PM                                    Page 2 of 27
                                                              Training Guide
                                                        Enterprise Inventory 8.9




   Step      Action
   3.        Click the Cost Accounting Creation link.




Last changed on: 8/10/2011 4:13 PM                                      Page 3 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   4.        You can run this process by searching for an existing Run Control ID or you can
             add a new value. Creating a Run Control ID that is relevant to the process may
             help you remember it for future use.
             Click the Add a New Value tab.




Last changed on: 8/10/2011 4:13:00 PM                                            Page 4 of 27
                                                                     Training Guide
                                                             Enterprise Inventory 8.9




   Step      Action
   5.        A Run Control ID is an identifier that, when paired with your User ID, uniquely
             identifies the process you are running. The Run Control ID defines parameters that
             are used when a process is run. This ensures that when a process runs in the
             background, the system does not prompt you for additional values.
             Enter the desired information into the Run Control ID field. Enter "ALC".
   6.        Click the Add button.

   7.        Use the Cost Accounting Creation page to enter the request parameters. These
             parameters will be used to define the processing rules and data to be included
             when the process is run.




Last changed on: 8/10/2011 4:13 PM                                                Page 5 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   8.        The Process Frequency group box enables you to specify the frequency at which
             the process runs. You can make the process run every time the batch process runs
             in PeopleSoft.

             Click the Always Process option.

   9.        Click in the *Request ID field.

   10.       A request ID represents a set of selection criteria for the process being run.
             Enter the desired information into the *Request ID field. Enter "ALC1".
   11.       Click in the Description field.

   12.       Enter the desired information into the Description field. Enter "US010".
   13.       Click in the *Business Unit field.

   14.       In the Business Unit field, you enter the business unit value for which you are
             running the process.
             Enter the desired information into the *Business Unit field. Enter "US010".
   15.       Click in the *Book Name field.

Last changed on: 8/10/2011 4:13:00 PM                                                Page 6 of 27
                                                                     Training Guide
                                                            Enterprise Inventory 8.9


   Step      Action
   16.       In the Book Name field, you enter the cost book used to record the accounting
             entry.
             Enter the desired information into the *Book Name field. Enter "FIN01".
   17.       Click the Run button.

   18.       Use the Process Scheduler Request page to enter or update parameters, such as
             server name and process output format.




   Step      Action
   19.       Click the Server Name list.

   20.       You must select a Server Name to identify the server on which the process will
             run. If you use the same Run Control ID for subsequent processes, the server
             name that you last used will default in this field.
             Click an entry in the list.

   21.       Click the OK button.


Last changed on: 8/10/2011 4:13 PM                                               Page 7 of 27
 Training Guide
 Enterprise Inventory 8.9


   Step      Action
   22.       Notice the Process Instance number appears. This number helps you identify the
             process you have run when you check the status.




   Step      Action
   23.       Click the Process Monitor link.

   24.       Use the Process List page to view the status of submitted process requests.




Last changed on: 8/10/2011 4:13:00 PM                                             Page 8 of 27
                                                                          Training Guide
                                                                 Enterprise Inventory 8.9




    Step       Action
    25.        The current status of the process is Queued. The process is finished when the
               status is Success. Continue to click the Refresh button until the status is Success.
               Click the Refresh button.

    26.        You have successfully created accounting entry lines using PeopleSoft Inventory.
               End of Procedure.


Running the Journal Generator Process
PeopleSoft Inventory provides inquiries and reports to view the accounting entries. You use the
Unposted Line Edit page to change the accounting entries before they are posted to the general
ledger. Once you are satisfied with the entries, use the Journal Generator process
(JRNL_GEN_REQUEST) to summarize the accounting entries into journal entries. PeopleSoft
General Ledger can then post the journal entries to the correct ledgers.

The Journal Generator process transforms accounting entries into PeopleSoft General Ledger
journals. Optionally, it edits and posts the journals created in the Journal Generator. It also
supports journals for multiple general ledger (GL) business units as well as multiple ledgers. In
addition, it supports debit and credit entries and negative correcting entries.

In this topic, you learn how to run the Journal Generator process using PeopleSoft Inventory.


Last changed on: 8/10/2011 4:13 PM                                                     Page 9 of 27
 Training Guide
 Enterprise Inventory 8.9


The accounting entries in your company are changed before they are posted to the general ledger.
The company is satisfied with the entries and needs to summarize them into journal entries. To do
this, you run the Journal Generator process to transform accounting entries into PeopleSoft
General Ledger journals.


Procedure




    Step       Action
    1.         Begin by navigating to the Generate Journals Request page.
               Click the vertical scrollbar.




Last changed on: 8/10/2011 4:13:00 PM                                              Page 10 of 27
                                                    Training Guide
                                              Enterprise Inventory 8.9




   Step      Action
   2.        Click the General Ledger link.

   3.        Click the Journals link.




Last changed on: 8/10/2011 4:13 PM                           Page 11 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   4.        Click the Generate Journals link.




Last changed on: 8/10/2011 4:13:00 PM            Page 12 of 27
                                                                     Training Guide
                                                            Enterprise Inventory 8.9




   Step      Action
   5.        You can run this process by searching for an existing Run Control ID or you can
             add a new value. Creating a Run Control ID that is relevant to the process may
             help you remember it for future use.
             Click the Add a New Value tab.




Last changed on: 8/10/2011 4:13 PM                                              Page 13 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   6.        A Run Control ID is an identifier that, when paired with your User ID, uniquely
             identifies the process you are running. The Run Control ID defines parameters that
             are used when a process is run. This ensures that when a process runs in the
             background, the system does not prompt you for additional values.
             Enter the desired information into the Run Control ID field. Enter "GJ".
   7.        Click the Add button.

   8.        Use the Generate Journals Request page to enter the request parameters. These
             parameters will be used to define the processing rules and data to be included
             when the process is run.




Last changed on: 8/10/2011 4:13:00 PM                                           Page 14 of 27
                                                                        Training Guide
                                                               Enterprise Inventory 8.9




   Step      Action
   9.        Click the Always option.

   10.       A SetID is required to extract the accounting entry definition for the request.
             Accept the default value for this field.
   11.       Click in the *Accounting Definition Name field.

   12.       Use the Accounting Definition Name field to identify which accounting entry
             definition the system uses when it creates the journal header and lines.
             Enter the desired information into the *Accounting Definition Name field. Enter
             "INDEFN".
   13.       Click in the Application Business Unit field.

   14.       Enter the desired information into the Application Business Unit field. Enter
             "US010".
   15.       Click in the Template field.

   16.       Select the template to be used when creating the journal lines. In this exercise, the
             journal generator creates entries for inventory transactions.
             Enter the desired information into the Template field. Enter "INVTRANS".


Last changed on: 8/10/2011 4:13 PM                                                  Page 15 of 27
 Training Guide
 Enterprise Inventory 8.9


   Step      Action
   17.       Click the *From Date Option list.

   18.       Use the From Date Option list to select a value to define which accounting
             entries the Journal Generator extracts with this request.
             Click an entry in the list.

   19.       Click in the From Date field.

   20.       Enter the desired information into the From Date field. Enter "01/01/2003".




   Step      Action
   21.       Click the *To Date Option list.

   22.       Use the To Date Option list to select a value to define which accounting entries
             the Journal Generator extracts with this request.
             Click an entry in the list.



Last changed on: 8/10/2011 4:13:00 PM                                            Page 16 of 27
                                                                      Training Guide
                                                             Enterprise Inventory 8.9




   Step      Action
   23.       Click in the To Date field.

   24.       Enter the desired information into the To Date field. Enter "01/01/2004".




Last changed on: 8/10/2011 4:13 PM                                               Page 17 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   25.       Click the Run button.

   26.       Use the Process Scheduler Request page to enter or update parameters, such as
             server name and process output format.




Last changed on: 8/10/2011 4:13:00 PM                                         Page 18 of 27
                                                                     Training Guide
                                                            Enterprise Inventory 8.9




   Step      Action
   27.       Click the Server Name list.

   28.       You must select a Server Name to identify the server on which the process will
             run. If you use the same Run Control ID for subsequent processes, the server
             name that you last used will default in this field.
             Click an entry in the list.

   29.       Click the OK button.

   30.       Notice the Process Instance number appears. This number helps you identify the
             process you have run when you check the status.




Last changed on: 8/10/2011 4:13 PM                                             Page 19 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   31.       Click the Process Monitor link.

   32.       Use the Process List page to view the status of submitted process requests.




Last changed on: 8/10/2011 4:13:00 PM                                            Page 20 of 27
                                                                          Training Guide
                                                                 Enterprise Inventory 8.9




    Step       Action
    33.        The current status of the process is Queued. The process is finished when the
               status is Success. Continue to click the Refresh button until the status is Success.
               Click the Refresh button.

    34.        You have successfully run the Journal Generator process in PeopleSoft
               Inventory.
               End of Procedure.


Viewing Unposted Accounting Lines
After you run the journal generator process, there are no unposted lines in PeopleSoft Inventory
for that business unit.

In this topic, you will view the Unposted Line Edit page after the Journal Generator process
has been run.

Your company has run the journal generator process. View the Unposted Line Edit page to
ensure that there are no unposted entries.




Last changed on: 8/10/2011 4:13 PM                                                   Page 21 of 27
 Training Guide
 Enterprise Inventory 8.9


Procedure




   Step      Action
   1.        Begin by navigating to the Edit Unposted Accounting Lines page .
             Click the Cost Accounting link.

   2.        Click the Inventory and Mfg Accounting link.




Last changed on: 8/10/2011 4:13:00 PM                                           Page 22 of 27
                                                                 Training Guide
                                                          Enterprise Inventory 8.9




   Step      Action
   3.        Click the Edit Unposted Accounting Lines link.

   4.        Use the Edit Unposted Accounting Lines page to change and view the
             accounting entry for a transaction before generating journals.




Last changed on: 8/10/2011 4:13 PM                                          Page 23 of 27
 Training Guide
 Enterprise Inventory 8.9




   Step      Action
   5.        Enter the desired information into the *Unit field. Enter "US010".
   6.        Click the Transaction Group list.

   7.        Use the Transaction Group list to categorize transactions for the purpose of
             costing.
             Click an entry in the list.

   8.        Click in the From field.

   9.        Enter the desired information into the From field. Enter "01/01/2003".
   10.       Click in the To field.

   11.       Enter the desired information into the To field. Enter "01/01/2004".
   12.       Click the Search button to view the unposted accounting lines.
             Click the Search button.

   13.       Notice that there are no unposted accounting lines in the Accounting Lines grid
             after you have run the Journal Generator process.


Last changed on: 8/10/2011 4:13:00 PM                                               Page 24 of 27
                                                                   Training Guide
                                                           Enterprise Inventory 8.9


   Step      Action
   14.       You have successfully viewed unposted accounting lines.
             End of Procedure.




Last changed on: 8/10/2011 4:13 PM                                        Page 25 of 27

				
DOCUMENT INFO
Description: Server Inventory Template document sample