TECHNOTE: Worksheet Example for calculating PPA_WIP_VALUES

Document ID : KB000026862
Last Modified Date : 14/02/2018
Show Technical Document Details


What are the computations for the fields in the PPA_WIP_VALUES table?


Within the attached Microsoft® Excel Workbook an explanation is provided on the formulas used within the application for computing the values.  The workbook also provides you with the opportunity to enter in some sample values and see how the formulas are applied to the data entered.  

You can also refer to the following technical article for the same formulas.

TEC536925: How are the values in PPA_WIP_VALUES computed?

The attached Workbook contains 3 worksheets that will help you to understand the computations for this table:

  1. Formulas: This sheet provides you with the formulas for the computed values used in the application 
  2. Setup: This sheet provides you with setup details for sample test cases that illustrate the application of the formulas to data entered 
  3. Sample Output: This sheet provides you with a sample output generated into the PPA_WIP_VALUES table based on the sample date entered on the Setup sheet 

More Information:
Reference the Financial Management Guide for more information regarding financial transactions.
Reference TEC444494 : What is the difference between the use of 'Actual Cost' vs. 'Standard Cost'?

Attachment:  TEC444466 Excel Workbook (zip)

File Attachments: