Post

2 followers Follow
1
Avatar

Export Bill of Materials - we need the product description

Exporting a BOM to csv yields this kind of result:

*Assembled Product Code *Component Product Code *Quantity Wastage Quantity Unit Cost Total Cost Can Auto Assemble Can Auto Disassemble IsObsoleted Expense Account Comments
20010 20002 5 0 6.6677 33.3384 No No No    

Unfortunately with only product codes, we can't do any human analysis with this.

We need the product description to exist in the line too.

I've tried copying and pasting from a PDF export (which does have the description) but without delimiters it's impossible to wrangle.

Are there any other workarounds I'm missing?

I feel like I shouldn't need the API for this :-)

Thanks,

Ed

 

Ed

Please sign in to leave a comment.

1 comment

0
Avatar

We would really like this too.  I have to keep on doing VLOOKUPs to get the product name in the Bill Of Materials export.

Lkrisanski 0 votes
Comment actions Permalink