Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

VAT Declaration XML - negative values (RESOLVED)

(4) ShareShare
ReportReport
Posted on by 8

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.
 
Categories:
  • Verified answer
    Gerardo Rentería García Profile Picture
    20,945 Most Valuable Professional on at
    VAT Declaration XML - negative values (RESOLVED)
     
    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.
  • RM-09090509-0 Profile Picture
    41 on at
    VAT Declaration XML - negative values
    Hi,
     
    I would suggest you firstly try to debug the XML format mapping and confirm that the value you are expecting is in negative.
    IF it does not show as negative while you are debugging, you need to adjust the formulas you are using.
     
    Please share a screenshot of the formula you are using to help you better on this point.
  • Adis Profile Picture
    5,143 Super User 2025 Season 1 on at
    VAT Declaration XML - negative values
    Hi,
     
    XML does support negative values. 
     
    The difference between the xml and the excel in this case can be the following. Please check them.
    • different version of configurations
    • different application setup (please also check that the setup is completed)
    • details in the (format) configuration (validations, transformations)
    • draft version is not completed or "Run draft" is not activated
    Apart from that, please show us what you have changed in the excel and in the xml regarding the transformation.
     
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Product updates

Dynamics 365 release plans