Hello,
I need to see negative values in my declaration to record CreditNotes.
I have successfully updated the VAT Declaration format for Excel preview in ER (Electronic reporting) > Designer.
However, when I do the same steps for XML, it doesn't quite work.
Example, 057/066 UseTax + UseTaxCreditNote
Initially, negative values are prevented to be recorded in these boxes by Transformation formula:
- FormatNumberF2_Positive
Instead, value is recorded as correction in 067.
Client doesn't want such behaviour, that's why we are updating this.
I have removed this formula for 057 and 066 boxes. Also, updated the formula for 067 by removing boxes 057 and 066.
All works as expected for Excel preview.
Same steps don't work for XML format. I have additionally tried to use transformation formula instead of blank:
- FormatNumberF2
Still didn't work.
Could it be that XML does not support negative values or other solution is possible?
SOLUTION
Select the groupping above the String (E.g., KZ057) > Go to Mapping and remove the fucntion on the bottom right of the screen.
It conditions what is later on visible on XML.
Thank you in advance.
