Hi
The biggest issue you are going to have with this is rounding as all things are going to lead you back to debtor transactions and the general ledger which are by the default system setting two decimal places.
There is a system setting the number of decimal places on money but this is system wide and probably not the best recommended answer to the problem although it would be the simplest.
You can also set the number of decimal places on an item but this relates to how a quantity works, which may be a simpler and then have the system operate with a multiple of the product for instance ten widgets might be the SKU so when ordering 1 the quantity is entered as 0.1.
Whilst you could probably change, the number of decimal points on the grid/column/cell as this is possible with plugin code as shown below you'd just have to substitute for jgLines, the business logic behind the scenes is going to use the decimal places for money to recalculate everything on the line based upon that.
- Code: Select all
(jgLines.ActiveSheet.Columns["Price"].CellType as JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaCurrencyCellType).DecimalPlaces = 5;
So you are really back to the two setting mentioned above to try and solve your problem unless Mike or Scott can give you a better idea.