Skip to main content
Solved

BOM Export to Excel

  • Apr 20, 2022 9:28 PM UTC
  • 4 replies
  • 579 views
  • Translate All

Forum|alt.badge.img

I am trying to export a full part list with quantities for a specific BOM to excel that we can easily compare with our SolidWorks BOM to ensure they match on a new product line. Anyone have a helpful idea to do so without exporting each OP ID and phantom BOM individually and then combining into one excel spreadsheet?

Best answer by hstone

You can use a multi-level BOM under Bill of Materials category to pull up the entire BOM with all of it’s subassemblies and export from there. Hope this helps!

View original

4 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • Apr 20, 2022 10:39 PM UTC

This topic may be of help:  

 

Translate

jdobish
Captain II
Forum|alt.badge.img+2
  • Captain II
  • Apr 22, 2022 11:28 PM UTC

I just posted a GI in the Bom Export Scenario link. It basically pulls all of the operations and materials by line. 

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Apr 28, 2022 5:07 PM UTC

Hi @mpowell have you been able to resolve your issue? Thank you!

Translate

hstone
Freshman II
Forum|alt.badge.img
  • Freshman II
  • Answer
  • Jun 1, 2022 6:49 PM UTC

You can use a multi-level BOM under Bill of Materials category to pull up the entire BOM with all of it’s subassemblies and export from there. Hope this helps!

Translate