I've created an XML reader for SAP Commissions

[PerforsN]

Not actually a question.. Just wanted to share my project.

I've created an Excel workbook with a few macro's that reads from a SAP Commissions xml file and load the contents of it into an easy to read, Excel format.

I've personally used this file many times to assess new requirements, check my plan design for errors and many other things.

If you have any suggestions for improvements, please make use of the GitHub Issues and/or Pull Requests.

https://github.com/niro1987/SAP-Commissions-XML

[KameshwarNukala]

When we Hit the Debug this error Page comes Up

[PerforsN]

Hi kameshwar.nukala

Would you be willing to share the xml file with me so that I can debug the issue?

[KameshwarNukala]

Niels, Can we have a discussion on this.

[KameshwarNukala]

Hi perforsn,
Getting this issue when we use Credit rules

[PerforsN]

Hi kameshwar.nukala ,

Would you be willing to share the xml file with me so that I can debug the issue?

[Yogananda]

HI perforsnIt's a really good idea for you to write a blog post of your achievement with explaining each step, so many SPM experts will make use of your macro converting XML to Spreadsheet in Plan Extract...

you have to lock your VBA Script which is now open to everyone.
I just had a look and found a few things in your VBA script and that can be improved. Some of the currency types are hardcoded to EUR.., let's discuss in case if you need to make to enhancement based on my observation.

[PerforsN]

I’ve deliberately published the project with an GPL-license. The code is open for everyone to use and adapt for their own purposes.

I’ve now also added the separate VBA modules to make it easier for those applicable to send a pull-request. Other users who do not have the knowledge can submit an issue on the GitHub page.

Thank you for looking at the code, I’ve added the currency issue to the GitHub page already. Please feel free to submit an issue for other improvements you found.

[PerforsN]

Hi yoganandamuthaiah

Would you be willing to publish a blog post about this project?

p.s. I've also removed the hardcoded 'EUR'.