|
I don't know what a spql is.
I was hoping there was a setting on the System/Defaults screen that would set "Decimal Places for Money" that worked on the Item Price field like it does on the Extended Price field.
I guess setting the Sell Price will work for now. If somebody would make that adjustment it would save my girls a little bit of typing.
Thanks and this is a great program.
Bob
>>> "R. Ransbottom" <..hidden..> 8/6/2015 12:05 PM >>> On Thu, Aug 06, 2015 at 08:31:22AM -0700, Bob Crandell wrote: > We don't do pennies so I'm trying to figure out how to either > truncate the dollar amount or round up so that $74.29 > shows up on an invoice or receipt as either $74.00 or $75.00. > I don't care which. > How do I make the pennies go away when I sell something? You could use psql to execute something like: update parts set sellprice=round(sellprice); (or trunc()) to set all your prices as you like. After that, if necessary, you could add a sql trigger that would round the sellprice on an update or insertion to parts. This should set your default prices in invoice forms and such, but would probably allow users to enter decimals if they so choose. Which sounds "good enough" because the direction of useless effort is reversed. Be warned: I'm just a beginner here. Rob ------------------------------------------------------------------------------ _______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users |
------------------------------------------------------------------------------
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users