Skip to Content
Product Information
Author's profile photo Jeroen Waart

Issues validation Dutch XML Auditfile (XAF)

Issues concerning the export of Auditfile in Dutch localization.

The official .xsd schema from the ‘Belastingdienst’ has some validations with the export of the AuditFile:

  1. Countries needs to be according to the ISO3166 list.

There was an Issue with the first version(s) of the XSD schema. Not all country codes where accepted. Countries f.e.

Serbia (RS),

Montenegro (ME),

Curacao (CW),

Greece (GR),

etc.

were not included in the validation list.

  1. According to the .xsd schema the CustSupName cannot be longer then 50 characters, while in Business One they can have 100 characters.
  2. Same for the PostalCode, cannot be longer then 10 characters, but B1 can have more.

Result of this is the auditfile is not created and a log file is displayed. This logfile is not very clear.

The ‘real’ messages could be found in the system messages monitor of the B1 client (max. 50)

Therefore, two new .GEP files are created for the Dutch XML Auditfile:

  1. XAF-V1.0  with the correct country codes, but with a validation on the lengths of CustSupBame and PostalCode
  2. XAF-V1.0_NoValidation with the correct country codes, but without a validation on the lengths of CustSupBame and PostalCode. There will be a check and warnings in the system messages monitor of the B1 client

You can download the files on my GitHub: https://github.com/Jee1971/XAF

I also included the original .xsd file, which you can adjust to add the countries to the file and attach the newly created .xsd to the format with EFM.

To import the .GEP files, go to Administration – Setup – General – Electronic File Manager and upload the file(s) by pushing the right mouse button:

 

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jeroen Tadema
      Jeroen Tadema

      Dear Jeroen,

      I installed the no Validation version, but surprise i still get red faillures. Now I need solution for Countrycode of Greece. ISO/SAP is EL, but auditfile only want to accept GR.

      Author's profile photo Jeroen Waart
      Jeroen Waart
      Blog Post Author

      Jeroen,

      Can you tell me where do you get red faillures. Can you add a screen shot?

      Jeroen

      Author's profile photo Jeroen Tadema
      Jeroen Tadema

      landcode%20EL%20fout

      landcode EL fout

      Author's profile photo Alexander Poad
      Alexander Poad

      We get the error message "Not enough memory for operation" while trying to run the newest Audit File with no Validation.

      How can we handle this?

      Best regards,

      Alex

      Author's profile photo Jeroen Waart
      Jeroen Waart
      Blog Post Author

      The only advise I can give in this situation is contact support (and/or try a shorter period)

      Author's profile photo Pieter Hazewindus
      Pieter Hazewindus

      Hi Jeroen,

      I tried to create an audit file using your .GEP. I get some errors I can't explain. Maybe you can clarify?

      Best regards,

      Pieter

      Author's profile photo Jeroen Waart
      Jeroen Waart
      Blog Post Author

      Error has something to do with an issue in 9.2 PL08. See SAP Note: https://launchpad.support.sap.com/#/notes/2699595

      Is solved as of 9.2 Pl09.

      Author's profile photo Bradley Sharnock
      Bradley Sharnock

      Hi Jeroen

       

      Very useful post, thank you.

      Your files have helped me resolve an issue with my (HANA) customer.

       

      I have another customer with the same problem, but I am getting an error when trying to run the sale report.

      Could this be due to using the same files on SQL? If so, would you mind sharing the GEP files for SQL version?

      Error%20screen%20shot

      Error screen shot

       

      Author's profile photo Bradley Sharnock
      Bradley Sharnock

      I am getting this error in version 10.0, as well as version 9.2

      Author's profile photo Jeroen Waart
      Jeroen Waart
      Blog Post Author

      Hello Bradley,

      I don't have a specific version for MS SQL. If you use the original one, you can adjust it with the EFM. You can set the setting "Always Generated" to True:

      You can also adjust the .xsd from the github with the additional country codes and update the target.

      Author's profile photo Bradley Sharnock
      Bradley Sharnock

      Thank you very much.

      I will give it a try.

      I'm getting an "incompatable version" error so I hope this solves the problem. It's not a country error so I don't think its that.

       

      Thanks again

      Author's profile photo Jeroen Waart
      Jeroen Waart
      Blog Post Author

      The "Incompatible version" message you can ignore. I was too lazy to add the newest versions to the format.