Symptom
- Error message "/ECRS/UI_TD 039 - Declaration has one or more negative key figures" occurs when releasing the file.
- The Intrastat file cannot be released due to error /ECRS/UI_TD039.
Environment
- SAP S/4 HANA for International Trade
- SAP Global Trade Services, edition for HANA
- Intrastat
Reproducing the Issue
- Open transaction /ECRS/RP_EDIT or the app 'Manage Intrastat Declarations'.
- Select the POI.
- Enter the period (Month and Year).
- Check that the intrastat declaration is released. If not, hit the button 'Release'.
- Press the button 'Generate file'.
Cause
This error indicates that there are one or more aggregated items with negative key figures (Invoice value, net weight..). The declaration cannot be released as negative values are not allowed in the declaration. Its not possible to have negative values in declaration file.
In normal circumstances, the error due to negative key figure (i.e. invoice value, statistical value..) should never occur.
Resolution
- Please implement the following notes first:
- Afterwards you have to re-create the intrastat declaration.
- If the error still occurs, you have to check if there are still negative values in table /ECRS/RPIT. Following cases can lead to negative key figures:
- When a credit note is involved, you have to check if the invoice value in credit memo is higher than in the original invoice. The corresponding items will be aggregated and it will result in negative value after aggregation. But normally, key figures in credit note cannot be higher than in the Invoice it refers. In that case, you have to correct the credit memo values.
- If you have some negative correction items in declaration, but the original item they refer to are not available in declaration. Please check why the original document is not available. You can find the original document number from item detail screen of the negative correction item.
- If you have a correction and the characteristics of the original item and the correction item are not the same, then they cannot aggregated. Normally the characteristics will be taken over from the original item in the correction item. But it is possible to change the characteristics manually in the intrastat declaration.
You have to check the items that are aggregated.
See Also
Datei, Intrastatmeldung, MEIS, VE01, negative Werte, Freigabe, freigeben, Gutschrift, debit memo, aggregation,
Keywords
KBA , SLL-ITR-ISR , Intrastat Reporting , Problem
Product
SAP S/4HANA Cloud Public Edition 2408