AutoCAD Electrical General Discussion

AutoCAD Electrical General Discussion

Reply
Member
faraj1357
Posts: 4
Registered: ‎02-14-2013
Message 1 of 7 (492 Views)
Accepted Solution

Adding Price to Bill of Material Report

492 Views, 6 Replies
02-17-2013 03:10 PM

I m using Autocad Electrical 2012 SP1 and i wanna know how can i add the price of items to the report generated by Autocad for the BOM. i need to do it in Excel. i can generate a report in Excel format but i couldn't find any field for the price. how can add that field and how can modify the Excel file generated by report so it always has the format i want, i dont want to modify the Excel file everytime after generating report.

 

thank you in advance for taking time.

Hi

Save your report in CSV format first, then open it in Excel - all the apostrophes will have gone away.

 

Keith H

Valued Contributor
metal_pro2
Posts: 70
Registered: ‎07-04-2007
Message 2 of 7 (444 Views)

Re: Adding Price to Bill of Material Report

02-19-2013 10:45 AM in reply to: faraj1357

Don't add a field just edit the component catalog Data and use one of the existing "USER 1, 2, or 3" fields for your price Data. The price information will then be available in a BOM report.

Member
faraj1357
Posts: 4
Registered: ‎02-14-2013
Message 3 of 7 (433 Views)

Re: Adding Price to Bill of Material Report

02-19-2013 04:08 PM in reply to: metal_pro2

thank you metal pro2 but i ve already tried that. the problem with it is that Autocad report puts an Apostrophe sign in front of the number so, for example, when i put 15.65 in user on in the report file i ve '15.65 and when i try to change the format of the cells in Excell to Currency this ' sign prevents the number to be shown like $15.65. what can i do to fix this issue?

Active Contributor
kghew1
Posts: 34
Registered: ‎04-28-2011
Message 4 of 7 (415 Views)

Re: Adding Price to Bill of Material Report

02-20-2013 02:24 AM in reply to: faraj1357

Hi

Save your report in CSV format first, then open it in Excel - all the apostrophes will have gone away.

 

Keith H

Member
faraj1357
Posts: 4
Registered: ‎02-14-2013
Message 5 of 7 (394 Views)

Re: Adding Price to Bill of Material Report

02-20-2013 09:27 PM in reply to: kghew1

Thank you kghew1

this solves the Apostrophe problem.

Mentor
algerj
Posts: 219
Registered: ‎02-25-2010
Message 6 of 7 (381 Views)

Re: Adding Price to Bill of Material Report

02-21-2013 10:44 AM in reply to: faraj1357

Hi Faraj,

 

You can export as CSV, or you could fix the database...

You can change the Cell type in the Access Database directly...

Select the column, then Go to Datasheet > Data Type & Formatting > Data type Drop down

(change it from "text" to "currency").

Then when you export to excel its already in the format you wanted. 

 

I hope this helps,

 

James Alger

SolidCAD

 

Member
faraj1357
Posts: 4
Registered: ‎02-14-2013
Message 7 of 7 (368 Views)

Re: Adding Price to Bill of Material Report

02-21-2013 08:22 PM in reply to: algerj

i dont have Access in my machine so i can't try it

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.