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.
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