CAMS Date fields

In a Nutshell

• The In-Service Date and the Asset Depreciation Convention table determine the Depreciation date.
  • The Depreciation Date = the In-Service Date, unless the object sub type is in the Asset Depreciation Convention table. If the object sub-type is in the table with a
    • Half Year (HY) convention - Depreciation Date = 01/01
    • Full Year (FY) convention - Depreciation Date = 07/01
    • Straight Line (SL) convention - In Service Date - do not add the sub-type to the Asset Depreciation Convention table in order to trigger Straight Line depreciation. 
• The Posted Date on the MPAY determines the Fiscal Year and Period on the Asset Payment - it should be set to the date that the document posted to the GL so that GL and CAM match.
• The Posted Date on the Asset Global (Add) does NOT drive the Fiscal Year and Period. The Fiscal Year and Period on these payments are determined by the date the Asset Global (Add) is created or based on the Fiscal Period selected on the Asset Global (Add) document. Adding the Fiscal Period to the AA doc was a recent addition and can be used to post asset payments into a prior period to match the GL. 

Asset Global (Add)  - New Asset

The Accounting Period dropdown determines the Fiscal Year and Period of the Asset Payment on the Asset. Add AA and ARG (if desired) to parameter FISCAL_PERIOD_SELECTION_DOCUMENT_TYPES and Permission Edit Accounting Period to the appropriate role. 

The only editable date field on Asset Global Add is "Create Date" 

• Last Inventory Date defaults to the date the document is created. 
• Create Date defaults to today's date and can be changed.
• In-Service Date defaults to the Create Date. The In-Service date can be updated after the Asset is created using the Asset edit document.  You can also use an Asset Type that will not depreciate if it's something that will have several payments added before it can be placed in to service. At that time you would change the Asset Type to a depreciable Asset Type and set the In-service date to the date it was placed into service. 
• Depreciation Date is set based on the In-Service date. If the Object Sub Type is in the Asset Depreciation Convention, the date will be set based on HY (01/01) or FY (07/01), if the Object Sub Type is not in the Asset Depreciation Convention table, the Depreciation Date will be the In-Service Date and will depreciate using the straight line convention. When the Inservice Date is changed, the Depreciation Date will update as well. 

In the following example, the AA document was created on 3/15/2021, the Create Date was changed to 12/15/2020, which set the In-Service Date to 12/15/2020 and because the object sub-type is in the Asset Depreciation Convention table with HY convention, the Depreciation Date = 1/1/21. 

Add Payments tab

The Posted Date in the Add Payments tab should match the document that is referenced with the Document Number and Document Type Code - this is the date that the transaction posted to the GL. However, it does not determine the fiscal period or year on the Asset Payment. The Fiscal Year and Fiscal Period on the payment are determined by the date the AA document is created, or if the fiscal period dropdown is used, Fiscal Year and Period are based on that selection. FEB 2021 was selected above and so the Fiscal Year and Period are 2021 and 08 even though the Posted Date is 01/31/2021 and the document was created on 3/15/2021. If the Fiscal Period dropdown was not used, the Fiscal Year and Period would be 2021 09 reflecting the create date. 

Asset Manual Payment (MPAY)

However, the Posted Date on the MPAY DOES drive the Fiscal Year and Fiscal Period. The Posted Date on the MPAY should be the Fiscal Year and Period that should be associated with the payment. If this payment is being added to match an addition in the GL, it should be the same date as that addition, so the GL and CAM match. 

Asset - Payments tab

Following are the Payments on the Asset. 

Payment 1: Created from the Asset Global (Add)

• Posting Date reflects the Posted Date entered on the AA document and should be the date that document posted to the GL it does not determine the Fiscal Year and Period of the payment. 
• Fiscal Year and Period are the date the Asset Global (Add) was created or reflects the value from the Fiscal Period dropdown. 

Payment 2: Created from the MPAY

• Posting Date reflects the Posted Date entered on the MPAY.
• Fiscal Year and Period are derived based on the Posted Date. 

Asset Detail Tab

Fiscal Year and Period are determined by the In-Service Date and specify the depreciation start date.