Product Information
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:
- 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.
- According to the .xsd schema the CustSupName cannot be longer then 50 characters, while in Business One they can have 100 characters.
- 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:
- XAF-V1.0 with the correct country codes, but with a validation on the lengths of CustSupBame and PostalCode
- 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:
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.
Jeroen,
Can you tell me where do you get red faillures. Can you add a screen shot?
Jeroen
landcode EL fout
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
The only advise I can give in this situation is contact support (and/or try a shorter period)
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
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.
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 screen shot
I am getting this error in version 10.0, as well as version 9.2
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.
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
The "Incompatible version" message you can ignore. I was too lazy to add the newest versions to the format.