Connect GL to Equipment Profitability Portal

Abstract

The purpose of this functionality is to support the process for Equipment Profitability Portal with the possibility to update manual costs and revenue through an internal journal voucher.

Background

Sometimes it is needed to do manual adjustments of the Equipment Profitability. Some costs or revenue have not occurred yet on a transaction and an adjustment is required to get a correct outcome

Limitations

This automated functionality will only work if you use the predefined accounting model with model type=1 including creating the model lines with F14 in (CAS391). Line 180 will then contain the manual costs/revenues.

Accounting type CA99 can only be used in the accounting model and not in 'Accounting Rule. Set' (CRS395).

Workflow

The workflow is started by entering an internal journal voucher in (CAS100) where you select to update a certain transaction (the debit or the credit) to the Equipment Profitability Portal.

When the voucher is updated to General Ledger also the transaction table (CAS095), the balance table (CAS090) and the aggregated balance table (CAS340) are updated.

The voucher can also be reversed using 'auto reverse', a parameter in 'FAM Function. Open Details' (CRS406) for FAM function CA10 or using GLS900, 'Reverse voucher'.

The transaction table, the balance table and the aggregated balance table will be updated accordingly when an internal journal voucher is reversed.

Follow these steps

1. Specify CAS100 to create an internal journal voucher. Select parameter 'Uptr' on the ac-count entry that you want to update in Equipment Profitability Portal, either the debit or the credit, in (GLS120).

2. When parameter 'Uptr' is selected a new popup screen will appear.

3. Specify your item and serial number in column value 1 and 2 or prompt using F4 to find your item. If your company is ESM enabled (in MNS095) column value 1, column value 2 and column value 3 will be populated if you prompt and then select the item and serial number.

   If you change an accounting line and would like to update the transaction in Equipment Profitability Portal, select 'Uptr' and use F21 to get the popup window when the accounting line is in change mode.

4. Select ok when the popup is updated and enter the contra-accounting.

5. Select 'close' when the voucher is ready.

6. To see the updated manual adjustment, enter CAS340 and select the period, balance key=2, accounting model and column template. Line 180 in the model will include your manual adjustment.

Outcome

• 'Analytical Acc Transactions. Display' (CAS095) is updated with the transactions which are the base for the Equipment Profitability.
• 'Analytical Acc Balance File. Display' (CAS090) is updated with the balances of the account entries in the Equipment Profitability.
• 'Analytical Acc Aggregated Balance. Dsp' (CAS340) is updated with the aggregated balances of the account entries in Equipment Profitability.

Setup

• Select parameter 290 'Accounting Model is used' in (CAS900) .
• Create an accounting model in (CAS390) with model with type 1 which is a predefined accounting model.
• Update the column headings of the predefined accounting model dimensions in (CAS390/E) according to below:

  1. Item

  2. Serial no

  3. Origin ID

  4. Customer

  5. Agreement

  6. Order no

  7. Budget ID

  8. Life/Product group (depending on the setup of the model)

  9. Struct level

  10. Highest level

• Set up the column templates in (CAS085) (see NCR 4966 for set up) to be used in (CAS340) .
• Select the parameter 'Upd Acc Model' in 'FAM Function. Open Details' (CRS406) for FAM function CA10.

Settings Descriptions