Hi,
Just realized want to export Multi-level BOM to excel for analysis, can anyone tell me how to do this ?
Thanks,
Amruth
Hi,
Just realized want to export Multi-level BOM to excel for analysis, can anyone tell me how to do this ?
Thanks,
Amruth
Would love to see this function as well. Iāve searched everywhere online and all I can find is an outdated method involving Report Builder that doesnāt apply to the latest version of ERPnext. Iām curious to know why something so simple would be omitted from the export functionality.
That would be extremely useful. Right now it is possible to export PDF but often it is useful to have BOM in Excel or CSV.
Concrete pointers - to posts, screenshots, code, bug reports and so on - will help resolve this mysteryā¦
Thanks Clarkj,
Unfortunately the lack of concrete pointers is the crux of the mystery and there isnāt a Butler in sight.
This simple truth is that I cannot find anywhere in ERPNext that I can do simple export of a BOM.
For the moment Iāve already manually made all my BOM in excel but that is extra work.
I mentioned above that I found an old post relating to āReport Builderā . Sadly I believe Report Builder has been shelved.
So, I wonder why it is that BOMās are not able to be exported as easily as, almost all other data. I assume that there is a good development reason.
To be clear, Iām not grumpy or complaining, Iām trying to understand how to extract the the data in this format to save myself time avoiding double data entry in the future
Cheers
No, Report Builder has not gone anywhere https://docs.erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports
I am not familiar with how BOMs are implemented that would prevent them from being exported as you say.
Thanks for your thoughts; do persist with your exploration, āwhy notā questions are how this tool evolves.
Ohh This is exciting!
I have gone to this page many times and not seen that option. I have full rights on the system, all roles.
Iāll look now to see what comes up. Iād be happy to see that it was just a doctype permission issue.
Thanks Kenneth
Yesssss that was it! The Doctype was not allowed to be exported by any user role. This must be a default setting because Iāve never changed it.
Iāve now set it to be exportable by the Manufacturing Manager Role. Iāve tested it and it does what I need.
Kenneth, thanks for taking the time to answer my question and solving my issue. Iāve learned a little more and will pass it on to the other threads where I saw similiar