Purpose
The purpose of this business function is to determine Profit Recognition data for a Job, Project or Subledge/Subledger Type and generate records in
the F5144 and F5145 files, as required.
PROCESSING NOTES:
Records inserted into the F5144 file will be processed accordingly:
Profit Recognition summarized by Project
Produces blank records for each job belonging to a project and an audit record for the project containing the accumulated totals of those jobs that
belong to the project. Sorted by Project.
Profit Recognition summarized by Job
Produces a detail record for each job with blanks in the subledger and subledger type fields. Sorted by Job.
Profit Recognition summarized by Subledger/Subledger Type
Produces a detail record for each job. Sorted by Ledger Type / Subledger / Subledger Type.
Period End Date
The user enters a valid date and the system will calculate what the fiscal period end date should be and makes that the new effective date while the
user entry date becomes the generation date.
Prior Quarter End Date
If user entered a date here, search through F5144 for that effective date. If such a record exists, move the found record's Earned Job to Date
amounts for current record's Earned Prior Quarter. If user did not enter a date, set the Earned Prior Quarter amount = 0.
Profit Recognition Threshold
This percentage is requested by the user and an F5144 and subsequent F5145 record will only be created if the profit is indeed greater than or equal
to the threshold amount.
Deferred Preference
By default profit will be recognized all at once, but the user can defer over the life of the Job/Project.
Projected Final Cost Method
By default the projected Final Cost is accumulated as stored in the HA ledger, but the user can request to derive Projected Final Cost using the
percentage of completion from the F% ledger with a blank Cost Code and Cost Type.
Profit Recognition Method
By default the method of calculating Profit will be based on the "Percent of Cost." However, the user can request "Percent of Revenue" or "Percent
of Cost or Revenue; whichever gives lower profit."
Accumulate the JCCA and JCST AAI ranges set up for the company.
Records inserted into the F5145 file will be processed accordingly:
DN5100009 - Build Profit Recognition Records
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
jdFiscalPeriodEndDate | DEF | JDEDATE | REQ | INPUT |
The date on which this transaction takes effect. The effective date is used generically. It can be the date of the next raise, a lease effective
| ||||
jdPriorQuarterEndDate | DEE | JDEDATE | REQ | INPUT |
The ending date (in the range of SPC expiration dates) to be used to build the workfile for review. This date should be entered in
| ||||
szCompany | CO | char | REQ | INPUT |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
cSummarizationLevel | EV01 | char | REQ | INPUT |
An option that specifies the type of processing for an event. | ||||
mnProfitThresholdPercent | PTPC | MATH_NUMERIC | REQ | INPUT |
The level of completion at which the actual cost becomes significant for recognizing profit on a job. If the percent complete for a job is less
| ||||
cDeferredProfitRecongni | PTTH | char | REQ | INPUT |
A value that controls how to recognize the deferred profit that accrues while the percent complete for a job is less than the threshold percent
| ||||
cProjectedFinalCostMethod | EV03 | char | REQ | INPUT |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cMethodProfitRecog | RECM | char | REQ | INPUT |
A code that specifies the method of recognition for job-to-date earned profit. The recognition method controls whether the percent complete
| ||||
szCostCenter | MCU | char | REQ | INPUT |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szSubledger | SBL | char | REQ | INPUT |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | REQ | INPUT |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
| ||||
szVersionconsolidated | VER | char | REQ | INPUT |
Identifies a specific set of data selection and sequencing settings for the application. Versions may be named using any combination of
| ||||
mnNextNumberValue | NNBR | MATH_NUMERIC | REQ | INPUT |
The number that the system will use next for automatically assigning numbers. Next numbers can be used for many types of documents;
| ||||
mnFiscalPeriod | PN | MATH_NUMERIC | REQ | INPUT |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
| ||||
mnFiscalYear | FY | MATH_NUMERIC | REQ | INPUT |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
mnFiscalCentury | CTRY | MATH_NUMERIC | REQ | INPUT |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
jdDateGeneration | DGEN | JDEDATE | REQ | INPUT |
The date entered when the Profit Recognition File Build program (R51800) was run. This date is used to derive the profit recognition
| ||||
szLedgerType | LT | char | REQ | INPUT |
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
| ||||
szProject | MCUS | char | REQ | INPUT |
Either a subsequent business unit or a project number.
A subsequent business unit specifies where to charge costs (or revenues) when the
| ||||
mnStoredMaterials | STML | MATH_NUMERIC | OPT | BOTH |
A code that specifies whether to accrue or defer additional costs to a job. A deferred cost can be the value of stored materials, which have
| ||||
mnCostOriginalBudget | COB | MATH_NUMERIC | OPT | BOTH |
The original budgeted amount for the cost accounts of a job. It is equal to the sum of the original budgets (data item BORG) for all the cost
| ||||
mnRevnOriginalBudget | ROB | MATH_NUMERIC | OPT | BOTH |
The original budgeted amount for the revenue accounts of a job. It is equal to the sum of the original budgets (data item BORG) for all the
| ||||
mnCostChanges | CCH | MATH_NUMERIC | OPT | BOTH |
The total of all the changes to the budgeted amounts for the cost accounts of a job. It is calculated using the current year records from the
| ||||
mnRevnChanges | RCH | MATH_NUMERIC | OPT | BOTH |
The total of all the changes to the budgeted amounts for the revenue accounts of a job. Revenue is calculated using the current year
| ||||
mnActualCostToDate | CATD | MATH_NUMERIC | OPT | BOTH |
The actual amount (ledger type AA) recorded to date in the Account Balances table (F0902) for a job's cost accounts. It is the sum of the
| ||||
mnActualRevnToDate | RATD | MATH_NUMERIC | OPT | BOTH |
The actual amount (ledger type AA) recorded to date in the Account Balances file (F0902) for a job's revenue accounts. It is the sum of the
| ||||
mnJobToDateEarnedCost | CJTD | MATH_NUMERIC | OPT | BOTH |
The cumulative earned cost for a job. This cost is controlled by the method of recognition. The following rules apply:
o When the method
| ||||
mnJobToDateEarnedReven | RJTD | MATH_NUMERIC | OPT | BOTH |
The cumulative earned revenue for a job. This revenue is controlled by the method of recognition and the following criteria:
o When the
| ||||
mnCostProjectedFinal | CPF | MATH_NUMERIC | OPT | BOTH |
The original budgeted amount for all cost accounts on a job in the Projected Amounts ledger type HA. This figure is the sum of the Original
| ||||
mnCostProjectedFinalAdj | CPFA | MATH_NUMERIC | OPT | BOTH |
The projected final amount (ledger type HA) in the Account Balances table (F0902) for a job's cost accounts. Initially, this amount is equal to
| ||||
mnRevnProjectedFinal | RPF | MATH_NUMERIC | OPT | BOTH |
The original budgeted amount for the revenue account on a job in the Projected Amounts ledger HA. This value is equal to the Original
| ||||
mnRevnProjectedFinalAdj | RPFA | MATH_NUMERIC | OPT | BOTH |
The projected final amount (ledger type HA) in the Account Balances table (F0902) for a job's revenue accounts. Initially, this amount is
| ||||
mnCostEarnedPriorYr | CEPY | MATH_NUMERIC | OPT | BOTH |
The actual costs as calculated the last time that profit recognition was run in the prior year. Profit recognition is not run automatically, so the
| ||||
mnRevnEarnedPriorYr | REPY | MATH_NUMERIC | OPT | BOTH |
The actual revenue as calculated the last time that profit recognition was run in the prior year. This value represents revenue at the end of
| ||||
mnCostEarnedEndOfPrior | CEPQ | MATH_NUMERIC | OPT | BOTH |
The actual costs as calculated the last time that profit recognition was run in the prior quarter. This field is used for calculating Earned
| ||||
mnRevenueEarnedEndOfPrior | REPQ | MATH_NUMERIC | OPT | BOTH |
The revenue as calculated the last time that profit recognition was run in the prior quarter. This field is used to calculate Earned Current
| ||||
mnCostEarnedPriorMo | CEPM | MATH_NUMERIC | OPT | BOTH |
The actual costs as calculated the last time that profit recognition was run. | ||||
mnRevnEarnedPriorMo | REPM | MATH_NUMERIC | OPT | BOTH |
The actual revenue as calculated the last time that profit recognition was run. | ||||
cPreliminaryOrFinalProcessing | PRFI | char | OPT | NONE |
A code that specifies whether to run in preliminary or final mode. Valid values are:
Blank
Preliminary mode. This is the default.
1
Final
| ||||
szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
|
None |
None |