You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(68) |
Feb
(121) |
Mar
(59) |
Apr
(49) |
May
(110) |
Jun
(109) |
Jul
(146) |
Aug
(122) |
Sep
(83) |
Oct
(94) |
Nov
(90) |
Dec
(157) |
| 2002 |
Jan
(169) |
Feb
(186) |
Mar
(168) |
Apr
(353) |
May
(338) |
Jun
(278) |
Jul
(220) |
Aug
(336) |
Sep
(122) |
Oct
(183) |
Nov
(111) |
Dec
(265) |
| 2003 |
Jan
(358) |
Feb
(135) |
Mar
(343) |
Apr
(419) |
May
(277) |
Jun
(145) |
Jul
|
Aug
(134) |
Sep
(118) |
Oct
(97) |
Nov
(240) |
Dec
(293) |
| 2004 |
Jan
(412) |
Feb
(217) |
Mar
(202) |
Apr
(237) |
May
(333) |
Jun
(201) |
Jul
(303) |
Aug
(218) |
Sep
(285) |
Oct
(249) |
Nov
(248) |
Dec
(229) |
| 2005 |
Jan
(314) |
Feb
(175) |
Mar
(386) |
Apr
(223) |
May
(281) |
Jun
(230) |
Jul
(200) |
Aug
(197) |
Sep
(110) |
Oct
(243) |
Nov
(279) |
Dec
(324) |
| 2006 |
Jan
(335) |
Feb
(396) |
Mar
(383) |
Apr
(358) |
May
(375) |
Jun
(190) |
Jul
(212) |
Aug
(320) |
Sep
(358) |
Oct
(112) |
Nov
(213) |
Dec
(95) |
| 2007 |
Jan
(136) |
Feb
(104) |
Mar
(156) |
Apr
(115) |
May
(78) |
Jun
(75) |
Jul
(30) |
Aug
(35) |
Sep
(50) |
Oct
(44) |
Nov
(33) |
Dec
(35) |
| 2008 |
Jan
(90) |
Feb
(63) |
Mar
(47) |
Apr
(42) |
May
(72) |
Jun
(85) |
Jul
(25) |
Aug
(20) |
Sep
(14) |
Oct
(11) |
Nov
(25) |
Dec
(39) |
| 2009 |
Jan
(39) |
Feb
(46) |
Mar
(16) |
Apr
(27) |
May
(51) |
Jun
(66) |
Jul
(78) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(4) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gordon H. <gha...@ma...> - 2001-09-17 01:06:11
|
>> Next, I have run into a situation where my cost on purchasing >> something from a vendor has gone down (it turns out quite a bit, >> but I don't think the size of the decrement is involved). >> If I update the "parts" entry for the new price on the day I >> go to invoice the part, it invoices the part at the old price. >> If I move the day that the part price decrease took effect a >> day or a month, it still uses the old (higher) price. I can >> manually over-ride the price. > ... parts sold as FIFO This explanation doesn't work here. I sell the part as soon as it comes in, the inventory is only there for a few seconds. Gord |
|
From: Dieter S. <dsi...@sq...> - 2001-09-17 00:17:16
|
If you enter an invoice again it is recorded again. The internal link mechanism doesn't care whatsoever what you enter. For anyone who wonders how you can add more than one invoice with the same information, you go back in your browser's history and post it again. This is actually a shortcut to post similar invoices. The parts inventory works on a FIFO basies. What you put in first is taken out first. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Gordon Haverland wrote: > > I guess the concensus is I'm an idiot. Fine, lets move on. > > Entering all this old billing I have yet again, somehow I > ended up with 2 vendor invoices on the same date with the > same invoice number for the same amount. I would bet the > only thing different between the 2 entries was the PostgreSQL > OID. So, I deleted on of these duplicate vendor invoices, > and everything seems okay. Everything balances anyway. > > Next, I have run into a situation where my cost on purchasing > something from a vendor has gone down (it turns out quite a bit, > but I don't think the size of the decrement is involved). > If I update the "parts" entry for the new price on the day I > go to invoice the part, it invoices the part at the old price. > If I move the day that the part price decrease took effect a > day or a month, it still uses the old (higher) price. I can > manually over-ride the price. > > Gord > > |
|
From: Dieter S. <dsi...@sq...> - 2001-09-17 00:06:16
|
In your preference screen there is a section with default accounts. When you add parts or services from a vendor invoice, the very same accounts are used. If your default account for sales happen to be a "Hardware Sales Account" and you do not edit the part, then when you sell the item, income is recorded in "Hardware Sales". The proper way is to establish an inventory with goods and services. You do this by adding parts and services. This lets you setup the proper links for income, expense and taxes. This step does not add to physical inventory, it only establishes the inventory with descriptions and links. The inventory is *stocked up* by creating vendor invoices or in the case of assemblies by stocking the assembly. When you make a purchase, parts are added (the quantity in inventory is increased), expenses and income are posted, but only if the part has already been sold, taxes are recorded. When you stock assemblies, the individual items are taken out of stock (the quantity is reduced) and the quantity for the assemblies is increased. When you sell an assembly income is recorded, expenses for individual items are recorded, the inventory level is reduced and taxes are posted to the appropriate accounts. All this is available online, most of it in the screenshots page. It's a condensed version but nonetheless a starting point to look for clues how things work. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Gordon Haverland wrote: > > Maybe I am misunderstanding something. If I purchase a service > from someone else, and resell it at a (nominally) constant > markup; is that a service or is it a part? I thought that parts > had to be physical matter, and not something virtual. When I > set up some accounts to for me to buy and resell these services, > I must have done something wrong since when I looked at the > chart of accounts all the money from the invoices were going > in the "wrong" places (most of the income ended up in hardware > sales, and I hadn't made any hardware sales). > > So, I am starting to read code and see if I can figure out from > that where I should be adding stuff (accounts, services, parts, > etc.) as what I have read of the documentation isn't helping enough > in my case. > > Gord > > |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 23:12:46
|
I guess the concensus is I'm an idiot. Fine, lets move on. Entering all this old billing I have yet again, somehow I ended up with 2 vendor invoices on the same date with the same invoice number for the same amount. I would bet the only thing different between the 2 entries was the PostgreSQL OID. So, I deleted on of these duplicate vendor invoices, and everything seems okay. Everything balances anyway. Next, I have run into a situation where my cost on purchasing something from a vendor has gone down (it turns out quite a bit, but I don't think the size of the decrement is involved). If I update the "parts" entry for the new price on the day I go to invoice the part, it invoices the part at the old price. If I move the day that the part price decrease took effect a day or a month, it still uses the old (higher) price. I can manually over-ride the price. Gord |
|
From: Dieter S. <dsi...@sq...> - 2001-09-16 22:40:54
|
Use the GL and make an entry for the balance. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Greg Jetter wrote: > I can't seem to find any way of entering initaia values into accounts created > by the install process , any hints ? > > > Greg > > |
|
From: Matt B. <ma...@li...> - 2001-09-16 22:26:00
|
Agreed. Aesthetics aside (and I don't find it particularly clunky), SQL-Ledger is a wonderful package. Matt Matt Benjamin The Linux Box 206 South Fifth Ave. Suite 150 Ann Arbor, MI 48104 tel. 734-761-4689 fax. 734-769-8938 pgr. 734-431-0118 On Sun, 16 Sep 2001, Dieter Simader wrote: > Matt, > > You are correct, Gord does not know how to make it work for him. However, > I don't take it lightly if someone does not know why things work in a > certain way and renders a *clunky* verdict. > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sun, 16 Sep 2001, Matt Benjamin wrote: > > > > > Dieter, > > > > I do not think Gordon was hurling insults. I think he doesn't understand > > how to implement the system for his requirements. > > > > Matt > > > > > > Matt Benjamin > > > > The Linux Box > > 206 South Fifth Ave. Suite 150 > > Ann Arbor, MI 48104 > > > > tel. 734-761-4689 > > fax. 734-769-8938 > > pgr. 734-431-0118 > > > |
|
From: Greg J. <gr...@la...> - 2001-09-16 22:16:23
|
I can't seem to find any way of entering initaia values into accounts created by the install process , any hints ? Greg |
|
From: Dieter S. <dsi...@sq...> - 2001-09-16 22:01:36
|
Matt, You are correct, Gord does not know how to make it work for him. However, I don't take it lightly if someone does not know why things work in a certain way and renders a *clunky* verdict. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Matt Benjamin wrote: > > Dieter, > > I do not think Gordon was hurling insults. I think he doesn't understand > how to implement the system for his requirements. > > Matt > > > Matt Benjamin > > The Linux Box > 206 South Fifth Ave. Suite 150 > Ann Arbor, MI 48104 > > tel. 734-761-4689 > fax. 734-769-8938 > pgr. 734-431-0118 |
|
From: Dieter S. <dsi...@sq...> - 2001-09-16 21:54:01
|
You can select the customer at the same time you fill in the first item. Additionally you can specify a quantity for the item at the same time and even fill in the paid field and select the account. All of which will remain when you hit "Update Form". This saves two button clicks. Generally it goes like this. customer invoice 1. select customer 2. update form 3. enter part number or description and optionally a quantity and discount 4. update form 5. edit price, enter quantity, discount, change description 6. update form 7. repeat step 3 & 6 for as many items you have 8. enter amount in paid field 9. select account 10. post invoice Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Gordon Haverland wrote: > > Okay, I can see how the toggling of the tax included button > is working. Is then the correct procedure to create an > invoice: > 1) Pick a customer name, hit update, fill in rest of form, > hit update, hit post. > 2) Fill in form including choosing customer, hit update, > change tax included status if need be, update form, > post. > 3) Something else? > > Gord > > |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 21:01:50
|
Okay, I can see how the toggling of the tax included button
is working. Is then the correct procedure to create an
invoice:
1) Pick a customer name, hit update, fill in rest of form,
hit update, hit post.
2) Fill in form including choosing customer, hit update,
change tax included status if need be, update form,
post.
3) Something else?
Gord
|
|
From: Dieter S. <dsi...@sq...> - 2001-09-16 20:36:18
|
For anyone, Gord is Canadian, so his woes are related to the Canadian version of the Gouge and Screw Tax (GST) The tax is a rather complex matter on top of it too. To clarify a few things for you, Gord. a) invoices from companies in the US to you are subject to GST (it doesn't matter if you are registered or not) The company in the US does not levi the tax but you or your broker are responsible for it. b) since you are not registered, tax for you is *not* an input tax credit but is an expense Now to your tax included woes. you can check the box GST to indicate that a vendor / customer is taxable. When you first create an invoice you get a selection menu with names, etc. Everything is set for the initial vendor / customer. NOW, how do you think the tax included field is affected when you change the name? You created an invoice, selected a name, checked the box tax included, entered the item and pressed "Update Form". Hmm, three things happened at once here. The name changed from the initial, so we have to retrieve the information for the vendor / customer, the part number was entered, so we get the information for the part, we recalculate the prices in accordance to the tax included field. Do you understand now why the tax included field changed? Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Gordon Haverland wrote: > I did try to figure out how things worked, and I did ask questions. > And I did try to follow suggestions put forward. > > How is it that I am crying wolf, to notice that when I enter > the information for something I have been billed, that it > always undoes the setting of the tax included button? Is > this how an accounting program is supposed to work? Sorry, > I haven't been using them for long. Where is the insult > I've thrown? > > Heck, I've just come to the conclusion that all the stuff > which I have entered over the last 0.75 days needs to be > deleted and redone anyway. And it's going to be a long > process if I have to hit update twice before I post either > a vendor or a customer invoice. > > To avoid anyone thinking I'm crying wolf or throwing insults, > how do I redo this work? I am recieving bills from vendors > for 2 kinds of services: one from a US company where I never > was charged GST (maybe I should have been, but wasn't), the > other from a Canadian company where I was charged GST. These > are being forwarded to a customer, and I am not charging > GST (yet)? I will eventually have to charge GST, but until > I reach some magic number I don't need to. > > I think it's going to take me an hour or so to delete > all the stuff I've entered. If someone has some ideas as > to how I can do this correctly, I would be happy to hear them. > Otherwise, I'll continue to struggle and maybe things will > work out this time. > > Gord > > > |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 20:24:48
|
Maybe I am misunderstanding something. If I purchase a service from someone else, and resell it at a (nominally) constant markup; is that a service or is it a part? I thought that parts had to be physical matter, and not something virtual. When I set up some accounts to for me to buy and resell these services, I must have done something wrong since when I looked at the chart of accounts all the money from the invoices were going in the "wrong" places (most of the income ended up in hardware sales, and I hadn't made any hardware sales). So, I am starting to read code and see if I can figure out from that where I should be adding stuff (accounts, services, parts, etc.) as what I have read of the documentation isn't helping enough in my case. Gord |
|
From: Matt B. <ma...@li...> - 2001-09-16 19:58:52
|
Dieter, I do not think Gordon was hurling insults. I think he doesn't understand how to implement the system for his requirements. Matt Matt Benjamin The Linux Box 206 South Fifth Ave. Suite 150 Ann Arbor, MI 48104 tel. 734-761-4689 fax. 734-769-8938 pgr. 734-431-0118 On Sun, 16 Sep 2001, Dieter Simader wrote: > Gord, > > How do you expect an accounting program to work for you if you do not set > it up correctly. > > Before you cry wolf and hurl insults, where none are warranted, sit down > and figure out how things work. It's one thing to ask for help, it's > another to claim *this is weird*, and expect an answer. > > If you want your taxes treated as an expense then you have to set them up > as an expense. > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sun, 16 Sep 2001, Gordon Haverland wrote: > > > > > This is using version 1.6.0 > > > > Okay, I can generate invoices, but it's clunky. > > > > I hit the vendor invoice button, and get the appropriate > > screen showing. I select the correct vendor, hit the > > tax included button (because as yet, I haven't earned enough > > money to have a GST registration, and so any tax I pay is > > purely an expense to me). I fill in > > Number Desc Qty Unit Amount > > 1 some description 1 ea $X.xx > > > > If I hit post, I always get an error in line 1. If I hit > > update form, it comes back with a filled in form with space > > for another entry, but it has magically added GST. So, I > > hit the tax included button and re-update the form. Now > > things are filled in correctly and I can post it. > > > > > > On the customer invoice side, when I fill in the form > > (again, hitting the tax included button) and hit update, > > it shows another line to add another item to the invoice, > > but it erases the amount entered and unsets the tax included > > button. So, re-enter the amount and set the tax included > > button and re-update the form. Things okay, so I can now > > post the invoice. > > > > It seems like something screwy is going on. > > > > Gord > > > > > > > > |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 18:56:50
|
I did try to figure out how things worked, and I did ask questions. And I did try to follow suggestions put forward. How is it that I am crying wolf, to notice that when I enter the information for something I have been billed, that it always undoes the setting of the tax included button? Is this how an accounting program is supposed to work? Sorry, I haven't been using them for long. Where is the insult I've thrown? Heck, I've just come to the conclusion that all the stuff which I have entered over the last 0.75 days needs to be deleted and redone anyway. And it's going to be a long process if I have to hit update twice before I post either a vendor or a customer invoice. To avoid anyone thinking I'm crying wolf or throwing insults, how do I redo this work? I am recieving bills from vendors for 2 kinds of services: one from a US company where I never was charged GST (maybe I should have been, but wasn't), the other from a Canadian company where I was charged GST. These are being forwarded to a customer, and I am not charging GST (yet)? I will eventually have to charge GST, but until I reach some magic number I don't need to. I think it's going to take me an hour or so to delete all the stuff I've entered. If someone has some ideas as to how I can do this correctly, I would be happy to hear them. Otherwise, I'll continue to struggle and maybe things will work out this time. Gord |
|
From: Dieter S. <dsi...@sq...> - 2001-09-16 18:02:34
|
Gord, How do you expect an accounting program to work for you if you do not set it up correctly. Before you cry wolf and hurl insults, where none are warranted, sit down and figure out how things work. It's one thing to ask for help, it's another to claim *this is weird*, and expect an answer. If you want your taxes treated as an expense then you have to set them up as an expense. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 16 Sep 2001, Gordon Haverland wrote: > > This is using version 1.6.0 > > Okay, I can generate invoices, but it's clunky. > > I hit the vendor invoice button, and get the appropriate > screen showing. I select the correct vendor, hit the > tax included button (because as yet, I haven't earned enough > money to have a GST registration, and so any tax I pay is > purely an expense to me). I fill in > Number Desc Qty Unit Amount > 1 some description 1 ea $X.xx > > If I hit post, I always get an error in line 1. If I hit > update form, it comes back with a filled in form with space > for another entry, but it has magically added GST. So, I > hit the tax included button and re-update the form. Now > things are filled in correctly and I can post it. > > > On the customer invoice side, when I fill in the form > (again, hitting the tax included button) and hit update, > it shows another line to add another item to the invoice, > but it erases the amount entered and unsets the tax included > button. So, re-enter the amount and set the tax included > button and re-update the form. Things okay, so I can now > post the invoice. > > It seems like something screwy is going on. > > Gord > > > |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 16:07:11
|
This is using version 1.6.0 Okay, I can generate invoices, but it's clunky. I hit the vendor invoice button, and get the appropriate screen showing. I select the correct vendor, hit the tax included button (because as yet, I haven't earned enough money to have a GST registration, and so any tax I pay is purely an expense to me). I fill in Number Desc Qty Unit Amount 1 some description 1 ea $X.xx If I hit post, I always get an error in line 1. If I hit update form, it comes back with a filled in form with space for another entry, but it has magically added GST. So, I hit the tax included button and re-update the form. Now things are filled in correctly and I can post it. On the customer invoice side, when I fill in the form (again, hitting the tax included button) and hit update, it shows another line to add another item to the invoice, but it erases the amount entered and unsets the tax included button. So, re-enter the amount and set the tax included button and re-update the form. Things okay, so I can now post the invoice. It seems like something screwy is going on. Gord |
|
From: Gordon H. <gha...@ma...> - 2001-09-16 16:06:55
|
This is using version 1.6.0 Okay, I can generate invoices, but it's clunky. I hit the vendor invoice button, and get the appropriate screen showing. I select the correct vendor, hit the tax included button (because as yet, I haven't earned enough money to have a GST registration, and so any tax I pay is purely an expense to me). I fill in Number Desc Qty Unit Amount 1 some description 1 ea $X.xx If I hit post, I always get an error in line 1. If I hit update form, it comes back with a filled in form with space for another entry, but it has magically added GST. So, I hit the tax included button and re-update the form. Now things are filled in correctly and I can post it. On the customer invoice side, when I fill in the form (again, hitting the tax included button) and hit update, it shows another line to add another item to the invoice, but it erases the amount entered and unsets the tax included button. So, re-enter the amount and set the tax included button and re-update the form. Things okay, so I can now post the invoice. It seems like something screwy is going on. Gord |
|
From: <wm...@ne...> - 2001-09-15 15:22:53
|
Hi, Would like to check whether SQL-Ledger can handle partial payments for invoices? Richard __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ |
|
From: Don W. <das...@ya...> - 2001-09-14 23:48:50
|
Try this: Create a vendor invoice for the billed service of 205.67. Make sure the vendor and part for that service has been created. Then, create a customer invoice for 342.78 to bill your client. That should come out right. Don --- Gordon Haverland <gha...@ma...> wrote: > Hi! > I'm just getting used to SQL-Ledger (1.6.0) and > getting > nowhere. Someone billed me $205.67 for a service, > and > I want to turn around and bill my client $342.78 to > pay > for the service and my markup (yes, 40% markup). > I've > tried 3 or 4 different ways to enter stuff, and > everytime > it comes back and tells me I can't do it. Could > someone > lay down a procedure for me? > > Thanks, > Gord > __________________________________________________ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ |
|
From: Gordon H. <gha...@ma...> - 2001-09-14 22:37:20
|
Hi! I'm just getting used to SQL-Ledger (1.6.0) and getting nowhere. Someone billed me $205.67 for a service, and I want to turn around and bill my client $342.78 to pay for the service and my markup (yes, 40% markup). I've tried 3 or 4 different ways to enter stuff, and everytime it comes back and tells me I can't do it. Could someone lay down a procedure for me? Thanks, Gord |
|
From: <eli...@li...> - 2001-09-13 16:01:44
|
Hello i noticed that since the upgrade from release 1.4 to release 1.6 my ability to add G/L transaction to accounts with a number range above 4300 has dissapeared. it seems to be there when i first look up the accounts but then when i have to update the form to get the Source in, the ability to bring up *all* the accounts is gone. is this something that anyone else is experiencing or is there a new way to post transactions to g/l accounts in the 5000, 6000 range that i am missing? thanks elizabeth ziph the linux box corporation ann arbor, michigan |
|
From: adrian <ad...@sn...> - 2001-09-12 00:16:34
|
Firstly, Thanks for the solution to the calculation error NOW A date error in entering accounts payable. see attached. The date format has worked in the past and in other modules Adrian -- Adrian Blake Snowy Technology Pty Ltd 26b Bombala St Cooma, NSW 2630 Ph 2-64-524338 mobile 0407 232 978 |
|
From: Francois G. <fg...@ya...> - 2001-09-11 00:25:59
|
Hello,
Using floating point numbers in an accounting context is not optimal, and
some random bugs will appear from time to time. Personally, I have 0.01 baht
(currency in thailand, makes 0.0002 USD) sitting idle in credit of the
account receivable, following such rounding problems. Try to explain THAT to
an average financial controller...
There is a module at CPAN, Math::Currency, which address that issue by
creating a new class of numbers and providing overloaded operators so that
the actual code may run with minimal modifications.
Francois
PS: I'm new to accounting (I used to _hate_ accountants), and very, very
pleased to have found sql-ledger which "opened my eyes" ;-)
On Tuesday 11 September 2001 05:31, you wrote:
> Dieter Simader wrote:
> > This error is caused by how numbers are processed by your computer.
> > Somewhere along the line your machine thinks that the result of adding
> > 11.86 and 1.19 is 13.050000000001 and not 13.05 IMHO this should not
> > happen but apparently it does.
> >
> > The workaround. In GL.pm add the following before line 77
> >
> > $debit = sprintf("%.2f", $debit);
> > $credit = sprintf("%.2f", $credit);
>
> Should this be included in all future versions? And are there any other
> places where it may be necessary?
>
> Adrian
|
|
From: adrian <ad...@sn...> - 2001-09-10 22:51:27
|
Dieter Simader wrote:
>
> This error is caused by how numbers are processed by your computer.
> Somewhere along the line your machine thinks that the result of adding
> 11.86 and 1.19 is 13.050000000001 and not 13.05 IMHO this should not
> happen but apparently it does.
>
> The workaround. In GL.pm add the following before line 77
>
> $debit = sprintf("%.2f", $debit);
> $credit = sprintf("%.2f", $credit);
>
Should this be included in all future versions? And are there any other
places where it may be necessary?
Adrian
--
Adrian Blake
Snowy Technology Pty Ltd
26b Bombala St
Cooma, NSW 2630
Ph 2-64-524338 mobile 0407 232 978
|
|
From: Matt B. <ma...@li...> - 2001-09-10 18:10:24
|
Okay, as everyone must have known, this was entirely my error. I converted the users without checking their properties. I _did_ note one genuine oddity--on my first attempt to save user changes, I had forgotten to fix permissions on the user conf files. It would be handy if admin.pl checked this and reported before attempting the save. I immediately realized that the "user = HASH(0xddddde)" error I did get was related to file permissions, but with less sleep or without Unix experience, I might have been frustrated... Sorry to spam the list. Matt Matt Benjamin The Linux Box 206 South Fifth Ave. Suite 150 Ann Arbor, MI 48104 tel. 734-761-4689 fax. 734-769-8938 pgr. 734-431-0118 On Mon, 10 Sep 2001, Matt Benjamin wrote: > > Dieter and folks, > > We updated to 1.6.3, after finding that our invoice dates (%invdate%) and > due dates all printed as "0, 2000" (after updating to 1.6.2). > > Unfortunately, we're still seeing this with the 1.6.3 downloaded some > minutes ago. > > Is this the same date bug labelled "fixed dates for GL reports?" > > Matt > > Matt > > Matt Benjamin > > The Linux Box > 206 South Fifth Ave. Suite 150 > Ann Arbor, MI 48104 > > tel. 734-761-4689 > fax. 734-769-8938 > pgr. 734-431-0118 > > > |