Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Item Cost - Decimal Places
02-20-2018, 12:54 AM (This post was last modified: 02-20-2018 01:44 AM by VortecCPI.)
Post: #4
RE: Item Cost - Decimal Places
Thank you so much Andy. I knew somebody out there had to have a similar issue. Perhaps we need to incorporate this into the main trunk?

Do you have any rounding issues in GLTrans or ChartDetails tables or related GL reports?
Was it all easier with slide rules and only three decimal places???
(02-20-2018 12:33 AM)afcouling Wrote:  We buy nuts and bolts in thousands, so use 5 decimal places for standard costs.

To enable this I made mods in scripts:
SystemParameters.php - around lines 51 and 749.
PO_Items.php - around lines 738 to 743.
SelectProduct.php - around line 347.

And in the DB schema, allowed 5 decimal places in these columns:
stockmaster.actualcost
stockmaster.lastcost
stockmaster.materialcost
stockmaster.labourcost
stockmaster.overheadcost
purchdata.price

Hi Andy...

I have identified all the above except "SelectProduct.php - around line 347"

Can you give me a little extra help with this one?

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Item Cost - Decimal Places - VortecCPI - 02-15-2018, 08:54 AM
RE: Item Cost - Decimal Places - TurboPT - 02-16-2018, 12:43 PM
RE: Item Cost - Decimal Places - afcouling - 02-20-2018, 12:33 AM
RE: Item Cost - Decimal Places - VortecCPI - 02-20-2018 12:54 AM
RE: Item Cost - Decimal Places - afcouling - 02-21-2018, 09:36 PM
RE: Item Cost - Decimal Places - falkoner - 02-21-2018, 09:45 PM
RE: Item Cost - Decimal Places - afcouling - 02-21-2018, 09:53 PM
RE: Item Cost - Decimal Places - falkoner - 02-21-2018, 11:37 PM
RE: Item Cost - Decimal Places - VortecCPI - 02-21-2018, 10:17 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)