Monday, December 31, 2018

Be able to export items' vendor prices without rounding off the figures to 2 decimal places.

A vendor price that has more than 2 decimal places in the item record shows up on item search results and exported CSV/Excel file rounded off in 2 decimal places.  Formatting cells to more than 2 decimal places does not work for this price on the exported file.

Alternate Solution for Vendor Price : Use a formula column to export the Vendor Price.

1. Create an item search via Lists > Search > Saved Searches > New > Item.

2. On the Saved Item Search page, navigate to Results tab > Columns sub tab.

3. Remove columns as necessary.

4. Add the following column:

a. Formula(Numeric)

Field: Vendor Price

Formula : ROUND({vendorcost}, x)

where x=the number of decimal places.

5. Give the column a custom label such as Vendor Price.

6. Give the search a unique title.

7. Save & Run.

8. Export the list via CSV. 

This is related to Enhancement#87550 : Lists > Accounting > Items > Export - Would like to be able to export 4 decimal places in item price.

No comments:

Post a Comment