Manage Fiscal Year At the end of a fiscal year you normally compensate for the customer’s year change by matching up or correcting cumulative quantities.
You correct or reset your cumulative delivered quantity (CDQ) and, if applicable, the cumulative quantity issued by external agent (EA). This ensures that inconsistent cumulative quantities do not cause any surpluses or shortages in the new fiscal year.
In the SAP APO system you can decide whether:
The system should carry out the fiscal year change automatically , so that the system automatically resets the cumulative quantities.
You want to carry out the fiscal year change (the correction of the CDQ) manually .
No fiscal year change is carried out, so that the cumulative quantities are not reset at the end of the fiscal year.
Until now, the system carried out the fiscal year change (the resetting of the cumulative quantities) automatically, if this setting was made in the SAP R/3 system.
Example
This procedure would sometimes lead to inconsistent data, for example if an outbound delivery was posted in a year different to the year in which the customer posted the inbound delivery.
As a consequence, the customer’s cumulative received quantity (CRQ) differed from the vendor’s CDQ.
A fiscal year change is necessary if the release date is in the new fiscal year, in other words, if the new release (delivery schedule) relates to a later fiscal year than the last release stored in the database.
The system assumes that the customer has carried out a fiscal year change under the following circumstances:
Date Quantities Set to Zero
In the current release, the date on which the quantities were set to the zero lies between the start of the fiscal year and the release date, and the release date lies in the new fiscal year.
The customer can include the date on which the quantities were set to zero and the CRQ in the IDoc. The system takes this data into account when it checks whether a fiscal year change is necessary. This data is not taken into account when calculating the correction quantity.
Cumulative Issued Quantity ³ Cumulative Received Quantity (CIQ ³ CRQ)
The CDQ or CIQ for the new fiscal year is sufficient to cover the reported CRQ and the release date lies in the new fiscal year.
Cumulative Received Quantity Reduced (but CIQ < CRQ)
The CRQ of the current release is less than in the last release and the release date lies in the new fiscal year.
If the fiscal year change needs to be carried out for this reason, you must ensure that you enter the correct correction quantity.
The current delivery quantity, posted in the new fiscal year is not sufficient to cover the CRQ reported by the customer. Therefore, you must enter a correction quantity that is different to the CDQ of the fiscal year to be closed. It may be that the customer has already received deliveries from the previous year for which you have not yet posted goods issue.
Business Add-In
A fiscal year change is necessary according to the BAdI
Control the Fiscal Year Change
(/SAPAPO/CMDS_RES_CDQ).
You can use this BAdI to decide whether a fiscal year change is necessary, based on additional criteria.
If the system has not identified a fiscal year change you can use the method to decide whether a fiscal year is necessary anyway.
When a release is received or an existing release is changed the system checks whether a fiscal year change is necessary.
For sales scheduling agreements with manual fiscal year change for which the system or the
Business Add-In(BAdI)
Control the Fiscal Year Change
has determined that a fiscal year change is necessary, you must change the fiscal year and, if necessary, correct the cumulative quantities, before you can enter new releases in the new fiscal year.
In the manual fiscal year change, the last release is created again using the same release number. In this “double” release the CDQ is corrected.
This causes the original cumulative quantities, sent by the customer in the release, to be retained, while the new release with this release number contains the cumulative quantities corrected during the fiscal year change.
SAP R/3 copies the fiscal year and the correction quantities for the calculation of the cumulative quantities.
If you have set automatic fiscal year change the system carries out the fiscal year change automatically when a release is received or when an existing release is changed, if the release date lies in the new fiscal year and the cumulative quantities match (CRQ CIQ).
The CDQ is corrected so that the “new” CDQ only includes the deliveries that have taken place in the new fiscal year.
SAP R/3 copies the fiscal year from SAP APO.
See also:
Carry Out Manual Fiscal Year Change