Menu
▾
▴
sql-ledger-users
|
From: J.P. P. <jp...@pi...> - 2009-06-24 02:18:46
|
Hello I had posted this in the message board on the site about 3 weeks ago and no response; not sure if this is more active or not. So I will ask here: I have a number of items that when I entered into sql ledger, I picked the wrong income account. When going back to editing these items, I do not see all of my income accounts even though I know they exist. I know this because I see them in the Chart of Accounts and when I add a new item I get the full list. Is this a bug or is it like that for a reason? I can simply delete and re-add the item with the correct income account but I am wondering if this will affect any reports or previous invoices I made with that item. I would be keeping everything exactly alike except the income account. Would this be ok? So bug or is it like that for a reason? Thanks JP |
|
From: Jeff R. <je...@jr...> - 2009-06-24 03:16:37
|
/I can simply delete and re-add the item with the correct income account but I am wondering if this will affect any reports or previous invoices I made with that item. / If you've used/sold the item in an invoice I don't think you'll be able to delete it. Check again, you shouldn't be able to delete an item you've sold. Once you have sold an item you will not be able to change the account it is attached to either, it sort of becomes written in stone. If you want to change the account you must delete all invoices that used/sold that item, then change the account or delete the item and then re-enter all the invoices. This is not a bug, it is the way it should be. Jeff J.P. Possenti wrote: > Hello I had posted this in the message board on the site about 3 weeks > ago and no response; not sure if this is more active or not. > > So I will ask here: > > I have a number of items that when I entered into sql ledger, I picked > the wrong income account. When going back to editing these items, I do > not see all of my income accounts even though I know they exist. I know > this because I see them in the Chart of Accounts and when I add a new > item I get the full list. > > Is this a bug or is it like that for a reason? > > I can simply delete and re-add the item with the correct income account > but I am wondering if this will affect any reports or previous invoices > I made with that item. I would be keeping everything exactly alike > except the income account. Would this be ok? > > So bug or is it like that for a reason? > > > Thanks > > JP > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: J.P. P. <jp...@pi...> - 2009-06-24 03:42:45
|
Yes I started trying to remove just one time and yes as you say it is not possible. I understand because of the reporting. I have not done many invoices with the products so I assume it would be better to do this sooner than later before it really becomes a hassle to do. Are you certain if I replace all of the old invoices and ap's with the new items in the correct accounts that I will be able to delete them? I do not wish to have page full of obsolete items for now if not necessary and if they are really not being used even in reports after I switch them over. Thanks for the response. On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: > /I can simply delete and re-add the item with the correct income account > but I am wondering if this will affect any reports or previous invoices > I made with that item. / > > > If you've used/sold the item in an invoice I don't think you'll be able > to delete it. Check again, you shouldn't be able to delete an item > you've sold. > > Once you have sold an item you will not be able to change the account it > is attached to either, it sort of becomes written in stone. If you want > to change the account you must delete all invoices that used/sold that > item, then change the account or delete the item and then re-enter all > the invoices. > > This is not a bug, it is the way it should be. > > Jeff > > > J.P. Possenti wrote: > > Hello I had posted this in the message board on the site about 3 weeks > > ago and no response; not sure if this is more active or not. > > > > So I will ask here: > > > > I have a number of items that when I entered into sql ledger, I picked > > the wrong income account. When going back to editing these items, I do > > not see all of my income accounts even though I know they exist. I know > > this because I see them in the Chart of Accounts and when I add a new > > item I get the full list. > > > > Is this a bug or is it like that for a reason? > > > > I can simply delete and re-add the item with the correct income account > > but I am wondering if this will affect any reports or previous invoices > > I made with that item. I would be keeping everything exactly alike > > except the income account. Would this be ok? > > > > So bug or is it like that for a reason? > > > > > > Thanks > > > > JP > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Jeff R. <je...@jr...> - 2009-06-24 04:36:27
|
Hi You need to have the authority to actually delete an invoice, you can't just reverse it. Can you view an old, posted invoice and delete it? Jeff J.P. Possenti wrote: > Yes I started trying to remove just one time and yes as you say it is > not possible. I understand because of the reporting. > > I have not done many invoices with the products so I assume it would be > better to do this sooner than later before it really becomes a hassle to > do. > > Are you certain if I replace all of the old invoices and ap's with the > new items in the correct accounts that I will be able to delete them? I > do not wish to have page full of obsolete items for now if not necessary > and if they are really not being used even in reports after I switch > them over. > > Thanks for the response. > > > On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: > >> /I can simply delete and re-add the item with the correct income account >> but I am wondering if this will affect any reports or previous invoices >> I made with that item. / >> >> >> If you've used/sold the item in an invoice I don't think you'll be able >> to delete it. Check again, you shouldn't be able to delete an item >> you've sold. >> >> Once you have sold an item you will not be able to change the account it >> is attached to either, it sort of becomes written in stone. If you want >> to change the account you must delete all invoices that used/sold that >> item, then change the account or delete the item and then re-enter all >> the invoices. >> >> This is not a bug, it is the way it should be. >> >> Jeff >> >> >> J.P. Possenti wrote: >> >>> Hello I had posted this in the message board on the site about 3 weeks >>> ago and no response; not sure if this is more active or not. >>> >>> So I will ask here: >>> >>> I have a number of items that when I entered into sql ledger, I picked >>> the wrong income account. When going back to editing these items, I do >>> not see all of my income accounts even though I know they exist. I know >>> this because I see them in the Chart of Accounts and when I add a new >>> item I get the full list. >>> >>> Is this a bug or is it like that for a reason? >>> >>> I can simply delete and re-add the item with the correct income account >>> but I am wondering if this will affect any reports or previous invoices >>> I made with that item. I would be keeping everything exactly alike >>> except the income account. Would this be ok? >>> >>> So bug or is it like that for a reason? >>> >>> >>> Thanks >>> >>> JP >>> >>> ------------------------------------------------------------------------------ >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>> >>> >>> >>> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: J.P. P. <jp...@pi...> - 2009-06-24 04:49:31
|
Since I am the only user I have enabled this feature. However I would not recommend it for multi-user environment with unknown users accessing the data. Just for the sake of innovative accounting if you get my drift I would not trust others to delete random old invoices or edit them. On Tue, 2009-06-23 at 21:35 -0700, Jeff Roberts wrote: > Hi > > You need to have the authority to actually delete an invoice, you can't > just reverse it. > > Can you view an old, posted invoice and delete it? > > Jeff > > > J.P. Possenti wrote: > > Yes I started trying to remove just one time and yes as you say it is > > not possible. I understand because of the reporting. > > > > I have not done many invoices with the products so I assume it would be > > better to do this sooner than later before it really becomes a hassle to > > do. > > > > Are you certain if I replace all of the old invoices and ap's with the > > new items in the correct accounts that I will be able to delete them? I > > do not wish to have page full of obsolete items for now if not necessary > > and if they are really not being used even in reports after I switch > > them over. > > > > Thanks for the response. > > > > > > On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: > > > >> /I can simply delete and re-add the item with the correct income account > >> but I am wondering if this will affect any reports or previous invoices > >> I made with that item. / > >> > >> > >> If you've used/sold the item in an invoice I don't think you'll be able > >> to delete it. Check again, you shouldn't be able to delete an item > >> you've sold. > >> > >> Once you have sold an item you will not be able to change the account it > >> is attached to either, it sort of becomes written in stone. If you want > >> to change the account you must delete all invoices that used/sold that > >> item, then change the account or delete the item and then re-enter all > >> the invoices. > >> > >> This is not a bug, it is the way it should be. > >> > >> Jeff > >> > >> > >> J.P. Possenti wrote: > >> > >>> Hello I had posted this in the message board on the site about 3 weeks > >>> ago and no response; not sure if this is more active or not. > >>> > >>> So I will ask here: > >>> > >>> I have a number of items that when I entered into sql ledger, I picked > >>> the wrong income account. When going back to editing these items, I do > >>> not see all of my income accounts even though I know they exist. I know > >>> this because I see them in the Chart of Accounts and when I add a new > >>> item I get the full list. > >>> > >>> Is this a bug or is it like that for a reason? > >>> > >>> I can simply delete and re-add the item with the correct income account > >>> but I am wondering if this will affect any reports or previous invoices > >>> I made with that item. I would be keeping everything exactly alike > >>> except the income account. Would this be ok? > >>> > >>> So bug or is it like that for a reason? > >>> > >>> > >>> Thanks > >>> > >>> JP > >>> > >>> ------------------------------------------------------------------------------ > >>> _______________________________________________ > >>> sql-ledger-users mailing list > >>> sql...@li... > >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>> > >>> > >>> > >>> > >> ------------------------------------------------------------------------------ > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Jeff R. <je...@jr...> - 2009-06-24 04:56:08
|
I agree, I am the only user of my system as well. I would make a list of all of the invoices that this item was used on. Print a copy of each of these invoices. Delete each of these invoices Once all transactions relating to this item are deleted you should be able to edit it and change the account. Then re-create each of the deleted invoices using the printouts as guides. That should correct your situation. Jeff J.P. Possenti wrote: > Since I am the only user I have enabled this feature. However I would > not recommend it for multi-user environment with unknown users accessing > the data. Just for the sake of innovative accounting if you get my drift > I would not trust others to delete random old invoices or edit them. > > On Tue, 2009-06-23 at 21:35 -0700, Jeff Roberts wrote: > >> Hi >> >> You need to have the authority to actually delete an invoice, you can't >> just reverse it. >> >> Can you view an old, posted invoice and delete it? >> >> Jeff >> >> >> J.P. Possenti wrote: >> >>> Yes I started trying to remove just one time and yes as you say it is >>> not possible. I understand because of the reporting. >>> >>> I have not done many invoices with the products so I assume it would be >>> better to do this sooner than later before it really becomes a hassle to >>> do. >>> >>> Are you certain if I replace all of the old invoices and ap's with the >>> new items in the correct accounts that I will be able to delete them? I >>> do not wish to have page full of obsolete items for now if not necessary >>> and if they are really not being used even in reports after I switch >>> them over. >>> >>> Thanks for the response. >>> >>> >>> On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: >>> >>> >>>> /I can simply delete and re-add the item with the correct income account >>>> but I am wondering if this will affect any reports or previous invoices >>>> I made with that item. / >>>> >>>> >>>> If you've used/sold the item in an invoice I don't think you'll be able >>>> to delete it. Check again, you shouldn't be able to delete an item >>>> you've sold. >>>> >>>> Once you have sold an item you will not be able to change the account it >>>> is attached to either, it sort of becomes written in stone. If you want >>>> to change the account you must delete all invoices that used/sold that >>>> item, then change the account or delete the item and then re-enter all >>>> the invoices. >>>> >>>> This is not a bug, it is the way it should be. >>>> >>>> Jeff >>>> >>>> >>>> J.P. Possenti wrote: >>>> >>>> >>>>> Hello I had posted this in the message board on the site about 3 weeks >>>>> ago and no response; not sure if this is more active or not. >>>>> >>>>> So I will ask here: >>>>> >>>>> I have a number of items that when I entered into sql ledger, I picked >>>>> the wrong income account. When going back to editing these items, I do >>>>> not see all of my income accounts even though I know they exist. I know >>>>> this because I see them in the Chart of Accounts and when I add a new >>>>> item I get the full list. >>>>> >>>>> Is this a bug or is it like that for a reason? >>>>> >>>>> I can simply delete and re-add the item with the correct income account >>>>> but I am wondering if this will affect any reports or previous invoices >>>>> I made with that item. I would be keeping everything exactly alike >>>>> except the income account. Would this be ok? >>>>> >>>>> So bug or is it like that for a reason? >>>>> >>>>> >>>>> Thanks >>>>> >>>>> JP >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> _______________________________________________ >>>>> sql-ledger-users mailing list >>>>> sql...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>>> >>>>> >>>>> >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> _______________________________________________ >>>> sql-ledger-users mailing list >>>> sql...@li... >>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >>>> >>> ------------------------------------------------------------------------------ >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>> >>> >>> >>> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: J.P. P. <jp...@pi...> - 2009-06-24 05:44:47
|
I am guessing it would be possible to delete those transactions and then when adding them again to use the same invoice #'s and such to maintain everything as much in place as possible? I assume I would just put in the manual invoice number instead of an automatically generated one? If so would it let me use one that was already in use (deleted already)? On Tue, 2009-06-23 at 21:55 -0700, Jeff Roberts wrote: > I agree, I am the only user of my system as well. > > I would make a list of all of the invoices that this item was used on. > > Print a copy of each of these invoices. > > Delete each of these invoices > > Once all transactions relating to this item are deleted you should be > able to edit it and change the account. > > Then re-create each of the deleted invoices using the printouts as guides. > > That should correct your situation. > > Jeff > > > J.P. Possenti wrote: > > Since I am the only user I have enabled this feature. However I would > > not recommend it for multi-user environment with unknown users accessing > > the data. Just for the sake of innovative accounting if you get my drift > > I would not trust others to delete random old invoices or edit them. > > > > On Tue, 2009-06-23 at 21:35 -0700, Jeff Roberts wrote: > > > >> Hi > >> > >> You need to have the authority to actually delete an invoice, you can't > >> just reverse it. > >> > >> Can you view an old, posted invoice and delete it? > >> > >> Jeff > >> > >> > >> J.P. Possenti wrote: > >> > >>> Yes I started trying to remove just one time and yes as you say it is > >>> not possible. I understand because of the reporting. > >>> > >>> I have not done many invoices with the products so I assume it would be > >>> better to do this sooner than later before it really becomes a hassle to > >>> do. > >>> > >>> Are you certain if I replace all of the old invoices and ap's with the > >>> new items in the correct accounts that I will be able to delete them? I > >>> do not wish to have page full of obsolete items for now if not necessary > >>> and if they are really not being used even in reports after I switch > >>> them over. > >>> > >>> Thanks for the response. > >>> > >>> > >>> On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: > >>> > >>> > >>>> /I can simply delete and re-add the item with the correct income account > >>>> but I am wondering if this will affect any reports or previous invoices > >>>> I made with that item. / > >>>> > >>>> > >>>> If you've used/sold the item in an invoice I don't think you'll be able > >>>> to delete it. Check again, you shouldn't be able to delete an item > >>>> you've sold. > >>>> > >>>> Once you have sold an item you will not be able to change the account it > >>>> is attached to either, it sort of becomes written in stone. If you want > >>>> to change the account you must delete all invoices that used/sold that > >>>> item, then change the account or delete the item and then re-enter all > >>>> the invoices. > >>>> > >>>> This is not a bug, it is the way it should be. > >>>> > >>>> Jeff > >>>> > >>>> > >>>> J.P. Possenti wrote: > >>>> > >>>> > >>>>> Hello I had posted this in the message board on the site about 3 weeks > >>>>> ago and no response; not sure if this is more active or not. > >>>>> > >>>>> So I will ask here: > >>>>> > >>>>> I have a number of items that when I entered into sql ledger, I picked > >>>>> the wrong income account. When going back to editing these items, I do > >>>>> not see all of my income accounts even though I know they exist. I know > >>>>> this because I see them in the Chart of Accounts and when I add a new > >>>>> item I get the full list. > >>>>> > >>>>> Is this a bug or is it like that for a reason? > >>>>> > >>>>> I can simply delete and re-add the item with the correct income account > >>>>> but I am wondering if this will affect any reports or previous invoices > >>>>> I made with that item. I would be keeping everything exactly alike > >>>>> except the income account. Would this be ok? > >>>>> > >>>>> So bug or is it like that for a reason? > >>>>> > >>>>> > >>>>> Thanks > >>>>> > >>>>> JP > >>>>> > >>>>> ------------------------------------------------------------------------------ > >>>>> _______________________________________________ > >>>>> sql-ledger-users mailing list > >>>>> sql...@li... > >>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>> ------------------------------------------------------------------------------ > >>>> _______________________________________________ > >>>> sql-ledger-users mailing list > >>>> sql...@li... > >>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>>> > >>>> > >>> ------------------------------------------------------------------------------ > >>> _______________________________________________ > >>> sql-ledger-users mailing list > >>> sql...@li... > >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >>> > >>> > >>> > >>> > >> ------------------------------------------------------------------------------ > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Jeff R. <je...@jr...> - 2009-06-24 06:46:20
|
Yes you can just manually put the same invoice numbers in and it will accept them. I've done this before many times. Jeff J.P. Possenti wrote: > I am guessing it would be possible to delete those transactions and then > when adding them again to use the same invoice #'s and such to maintain > everything as much in place as possible? > > I assume I would just put in the manual invoice number instead of an > automatically generated one? If so would it let me use one that was > already in use (deleted already)? > > > On Tue, 2009-06-23 at 21:55 -0700, Jeff Roberts wrote: > >> I agree, I am the only user of my system as well. >> >> I would make a list of all of the invoices that this item was used on. >> >> Print a copy of each of these invoices. >> >> Delete each of these invoices >> >> Once all transactions relating to this item are deleted you should be >> able to edit it and change the account. >> >> Then re-create each of the deleted invoices using the printouts as guides. >> >> That should correct your situation. >> >> Jeff >> >> >> J.P. Possenti wrote: >> >>> Since I am the only user I have enabled this feature. However I would >>> not recommend it for multi-user environment with unknown users accessing >>> the data. Just for the sake of innovative accounting if you get my drift >>> I would not trust others to delete random old invoices or edit them. >>> >>> On Tue, 2009-06-23 at 21:35 -0700, Jeff Roberts wrote: >>> >>> >>>> Hi >>>> >>>> You need to have the authority to actually delete an invoice, you can't >>>> just reverse it. >>>> >>>> Can you view an old, posted invoice and delete it? >>>> >>>> Jeff >>>> >>>> >>>> J.P. Possenti wrote: >>>> >>>> >>>>> Yes I started trying to remove just one time and yes as you say it is >>>>> not possible. I understand because of the reporting. >>>>> >>>>> I have not done many invoices with the products so I assume it would be >>>>> better to do this sooner than later before it really becomes a hassle to >>>>> do. >>>>> >>>>> Are you certain if I replace all of the old invoices and ap's with the >>>>> new items in the correct accounts that I will be able to delete them? I >>>>> do not wish to have page full of obsolete items for now if not necessary >>>>> and if they are really not being used even in reports after I switch >>>>> them over. >>>>> >>>>> Thanks for the response. >>>>> >>>>> >>>>> On Tue, 2009-06-23 at 19:50 -0700, Jeff Roberts wrote: >>>>> >>>>> >>>>> >>>>>> /I can simply delete and re-add the item with the correct income account >>>>>> but I am wondering if this will affect any reports or previous invoices >>>>>> I made with that item. / >>>>>> >>>>>> >>>>>> If you've used/sold the item in an invoice I don't think you'll be able >>>>>> to delete it. Check again, you shouldn't be able to delete an item >>>>>> you've sold. >>>>>> >>>>>> Once you have sold an item you will not be able to change the account it >>>>>> is attached to either, it sort of becomes written in stone. If you want >>>>>> to change the account you must delete all invoices that used/sold that >>>>>> item, then change the account or delete the item and then re-enter all >>>>>> the invoices. >>>>>> >>>>>> This is not a bug, it is the way it should be. >>>>>> >>>>>> Jeff >>>>>> >>>>>> >>>>>> J.P. Possenti wrote: >>>>>> >>>>>> >>>>>> >>>>>>> Hello I had posted this in the message board on the site about 3 weeks >>>>>>> ago and no response; not sure if this is more active or not. >>>>>>> >>>>>>> So I will ask here: >>>>>>> >>>>>>> I have a number of items that when I entered into sql ledger, I picked >>>>>>> the wrong income account. When going back to editing these items, I do >>>>>>> not see all of my income accounts even though I know they exist. I know >>>>>>> this because I see them in the Chart of Accounts and when I add a new >>>>>>> item I get the full list. >>>>>>> >>>>>>> Is this a bug or is it like that for a reason? >>>>>>> >>>>>>> I can simply delete and re-add the item with the correct income account >>>>>>> but I am wondering if this will affect any reports or previous invoices >>>>>>> I made with that item. I would be keeping everything exactly alike >>>>>>> except the income account. Would this be ok? >>>>>>> >>>>>>> So bug or is it like that for a reason? >>>>>>> >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>>> JP >>>>>>> >>>>>>> ------------------------------------------------------------------------------ >>>>>>> _______________________________________________ >>>>>>> sql-ledger-users mailing list >>>>>>> sql...@li... >>>>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> _______________________________________________ >>>>>> sql-ledger-users mailing list >>>>>> sql...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>>>> >>>>>> >>>>>> >>>>> ------------------------------------------------------------------------------ >>>>> _______________________________________________ >>>>> sql-ledger-users mailing list >>>>> sql...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>>> >>>>> >>>>> >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> _______________________________________________ >>>> sql-ledger-users mailing list >>>> sql...@li... >>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >>>> >>> ------------------------------------------------------------------------------ >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>> >>> >>> >>> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > |
|
From: Paul T. <pt...@wa...> - 2009-06-24 04:09:41
|
To answer your other question, only income accounts that are defined as such AND have the 'show in browser' tag checked will show up. TIP: open new window or two, and check account details for one income account that shows up and another for one that does not. See what differs, has helped me quite a lot to deduce the deeper business logic of SQL-Ledger. hth 2009/6/24 Jeff Roberts <je...@jr...> > /I can simply delete and re-add the item with the correct income account > but I am wondering if this will affect any reports or previous invoices > I made with that item. / > > > If you've used/sold the item in an invoice I don't think you'll be able > to delete it. Check again, you shouldn't be able to delete an item > you've sold. > > Once you have sold an item you will not be able to change the account it > is attached to either, it sort of becomes written in stone. If you want > to change the account you must delete all invoices that used/sold that > item, then change the account or delete the item and then re-enter all > the invoices. > > This is not a bug, it is the way it should be. > > Jeff > > > J.P. Possenti wrote: > > Hello I had posted this in the message board on the site about 3 weeks > > ago and no response; not sure if this is more active or not. > > > > So I will ask here: > > > > I have a number of items that when I entered into sql ledger, I picked > > the wrong income account. When going back to editing these items, I do > > not see all of my income accounts even though I know they exist. I know > > this because I see them in the Chart of Accounts and when I add a new > > item I get the full list. > > > > Is this a bug or is it like that for a reason? > > > > I can simply delete and re-add the item with the correct income account > > but I am wondering if this will affect any reports or previous invoices > > I made with that item. I would be keeping everything exactly alike > > except the income account. Would this be ok? > > > > So bug or is it like that for a reason? > > > > > > Thanks > > > > JP > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: J.P. P. <jp...@pi...> - 2009-06-24 04:35:48
|
Right I have those checked as they should. However I had not added that income account at the time, so right now I cannot change it. Thanks for your response! Is this also the correct place to put suggestions? Or is there another mailing list for that? On Wed, 2009-06-24 at 06:08 +0200, Paul Tammes wrote: > To answer your other question, only income accounts that are defined as such > AND have the 'show in browser' tag checked will show up. TIP: open new > window or two, and check account details for one income account that shows > up and another for one that does not. See what differs, has helped me quite > a lot to deduce the deeper business logic of SQL-Ledger. > > hth > > 2009/6/24 Jeff Roberts <je...@jr...> > > > /I can simply delete and re-add the item with the correct income account > > but I am wondering if this will affect any reports or previous invoices > > I made with that item. / > > > > > > If you've used/sold the item in an invoice I don't think you'll be able > > to delete it. Check again, you shouldn't be able to delete an item > > you've sold. > > > > Once you have sold an item you will not be able to change the account it > > is attached to either, it sort of becomes written in stone. If you want > > to change the account you must delete all invoices that used/sold that > > item, then change the account or delete the item and then re-enter all > > the invoices. > > > > This is not a bug, it is the way it should be. > > > > Jeff > > > > > > J.P. Possenti wrote: > > > Hello I had posted this in the message board on the site about 3 weeks > > > ago and no response; not sure if this is more active or not. > > > > > > So I will ask here: > > > > > > I have a number of items that when I entered into sql ledger, I picked > > > the wrong income account. When going back to editing these items, I do > > > not see all of my income accounts even though I know they exist. I know > > > this because I see them in the Chart of Accounts and when I add a new > > > item I get the full list. > > > > > > Is this a bug or is it like that for a reason? > > > > > > I can simply delete and re-add the item with the correct income account > > > but I am wondering if this will affect any reports or previous invoices > > > I made with that item. I would be keeping everything exactly alike > > > except the income account. Would this be ok? > > > > > > So bug or is it like that for a reason? > > > > > > > > > Thanks > > > > > > JP > > > > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > > > sql-ledger-users mailing list > > > sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Dieter S. <dsi...@sq...> - 2009-06-24 16:51:50
|
On Wed, 24 Jun 2009, J.P. Possenti wrote: > Right I have those checked as they should. However I had not added that > income account at the time, so right now I cannot change it. > > Thanks for your response! > > Is this also the correct place to put suggestions? Or is there another > mailing list for that? To change account links go to Goods & Services -> Changeup DS |
|
From: J.P. P. <jp...@pi...> - 2009-06-24 20:29:15
|
Oh wow really? This will let me change the income account apparently. Is this still the suggested method instead of deleting and re-adding and remaking the old invoices or transactions that had to do with those items? Thanks On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > On Wed, 24 Jun 2009, J.P. Possenti wrote: > > > Right I have those checked as they should. However I had not added that > > income account at the time, so right now I cannot change it. > > > > Thanks for your response! > > > > Is this also the correct place to put suggestions? Or is there another > > mailing list for that? > > To change account links go to > > Goods & Services -> Changeup > > DS > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: J.P. P. <jp...@pi...> - 2009-06-25 22:38:44
|
Since I never got a reply from anyone else confirming this statement. Although I see I can change it, is this the correct way to do this? Is this still the suggested method instead of deleting and re-adding and remaking the old invoices or transactions that had to do with those items? On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > On Wed, 24 Jun 2009, J.P. Possenti wrote: > > > Right I have those checked as they should. However I had not added that > > income account at the time, so right now I cannot change it. > > > > Thanks for your response! > > > > Is this also the correct place to put suggestions? Or is there another > > mailing list for that? > > To change account links go to > > Goods & Services -> Changeup > > DS > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Jeff R. <je...@jr...> - 2009-06-25 23:16:55
|
I don't know JP I'm way back on 2.6.22 and I don't have that function so I can't tell. Jeff J.P. Possenti wrote: > Since I never got a reply from anyone else confirming this statement. > Although I see I can change it, is this the correct way to do this? > > Is this still the suggested method instead of deleting and re-adding > and > remaking the old invoices or transactions that had to do with those > items? > > > On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > >> On Wed, 24 Jun 2009, J.P. Possenti wrote: >> >> >>> Right I have those checked as they should. However I had not added that >>> income account at the time, so right now I cannot change it. >>> >>> Thanks for your response! >>> >>> Is this also the correct place to put suggestions? Or is there another >>> mailing list for that? >>> >> To change account links go to >> >> Goods & Services -> Changeup >> >> DS >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Paul T. <pt...@wa...> - 2009-06-26 04:05:53
|
It is a way to change the income account for certain goods (COGS). I am not sure it will change previous sales as well, I rather think not. I suggest you open a test-firm and do some trial and error before making errors in the actual accounting program. in sql-ledger, backup to file. Unzip the file and rename to test.sql Then in /admin.pl create TESTFIRM with accompanying user test. su postgres psql TESTFIRM < test.sql /login and choos TESTFIRM. Now you have a copy of the recent accounts to test to your hearts desire. Once you knwo what to do and how to do it, replicate those actuions in the actual database and Bob is a close relative. 2009/6/26 Jeff Roberts <je...@jr...> > I don't know JP > > I'm way back on 2.6.22 and I don't have that function so I can't tell. > > Jeff > > > J.P. Possenti wrote: > > Since I never got a reply from anyone else confirming this statement. > > Although I see I can change it, is this the correct way to do this? > > > > Is this still the suggested method instead of deleting and re-adding > > and > > remaking the old invoices or transactions that had to do with those > > items? > > > > > > On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > > > >> On Wed, 24 Jun 2009, J.P. Possenti wrote: > >> > >> > >>> Right I have those checked as they should. However I had not added that > >>> income account at the time, so right now I cannot change it. > >>> > >>> Thanks for your response! > >>> > >>> Is this also the correct place to put suggestions? Or is there another > >>> mailing list for that? > >>> > >> To change account links go to > >> > >> Goods & Services -> Changeup > >> > >> DS > >> > >> > ------------------------------------------------------------------------------ > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: J.P. P. <jp...@pi...> - 2009-06-26 15:51:12
|
Thanks, I will try this and report back. On Fri, 2009-06-26 at 06:05 +0200, Paul Tammes wrote: > It is a way to change the income account for certain goods (COGS). > I am not sure it will change previous sales as well, I rather think not. > I suggest you open a test-firm and do some trial and error before making > errors in the actual accounting program. > > in sql-ledger, backup to file. Unzip the file and rename to test.sql > Then in /admin.pl create TESTFIRM with accompanying user test. > su postgres > psql TESTFIRM < test.sql > > /login and choos TESTFIRM. > > Now you have a copy of the recent accounts to test to your hearts desire. > Once you knwo what to do and how to do it, replicate those actuions in the > actual database and Bob is a close relative. > > 2009/6/26 Jeff Roberts <je...@jr...> > > > I don't know JP > > > > I'm way back on 2.6.22 and I don't have that function so I can't tell. > > > > Jeff > > > > > > J.P. Possenti wrote: > > > Since I never got a reply from anyone else confirming this statement. > > > Although I see I can change it, is this the correct way to do this? > > > > > > Is this still the suggested method instead of deleting and re-adding > > > and > > > remaking the old invoices or transactions that had to do with those > > > items? > > > > > > > > > On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > > > > > >> On Wed, 24 Jun 2009, J.P. Possenti wrote: > > >> > > >> > > >>> Right I have those checked as they should. However I had not added that > > >>> income account at the time, so right now I cannot change it. > > >>> > > >>> Thanks for your response! > > >>> > > >>> Is this also the correct place to put suggestions? Or is there another > > >>> mailing list for that? > > >>> > > >> To change account links go to > > >> > > >> Goods & Services -> Changeup > > >> > > >> DS > > >> > > >> > > ------------------------------------------------------------------------------ > > >> _______________________________________________ > > >> sql-ledger-users mailing list > > >> sql...@li... > > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > >> > > > > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > > > sql-ledger-users mailing list > > > sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Paul T. <pt...@wa...> - 2009-06-27 07:05:20
|
As a work-around, if the change works for future and income is wrong but the COGS are handled ok, you could make a Journal Entry moving the income from wrong account x to right account y. 2009/6/26 J.P. Possenti <jp...@pi...> > Thanks, I will try this and report back. > > On Fri, 2009-06-26 at 06:05 +0200, Paul Tammes wrote: > > It is a way to change the income account for certain goods (COGS). > > I am not sure it will change previous sales as well, I rather think not. > > I suggest you open a test-firm and do some trial and error before making > > errors in the actual accounting program. > > > > in sql-ledger, backup to file. Unzip the file and rename to test.sql > > Then in /admin.pl create TESTFIRM with accompanying user test. > > su postgres > > psql TESTFIRM < test.sql > > > > /login and choos TESTFIRM. > > > > Now you have a copy of the recent accounts to test to your hearts desire. > > Once you knwo what to do and how to do it, replicate those actuions in > the > > actual database and Bob is a close relative. > > > > 2009/6/26 Jeff Roberts <je...@jr...> > > > > > I don't know JP > > > > > > I'm way back on 2.6.22 and I don't have that function so I can't tell. > > > > > > Jeff > > > > > > > > > J.P. Possenti wrote: > > > > Since I never got a reply from anyone else confirming this statement. > > > > Although I see I can change it, is this the correct way to do this? > > > > > > > > Is this still the suggested method instead of deleting and re-adding > > > > and > > > > remaking the old invoices or transactions that had to do with those > > > > items? > > > > > > > > > > > > On Wed, 2009-06-24 at 10:23 -0600, Dieter Simader wrote: > > > > > > > >> On Wed, 24 Jun 2009, J.P. Possenti wrote: > > > >> > > > >> > > > >>> Right I have those checked as they should. However I had not added > that > > > >>> income account at the time, so right now I cannot change it. > > > >>> > > > >>> Thanks for your response! > > > >>> > > > >>> Is this also the correct place to put suggestions? Or is there > another > > > >>> mailing list for that? > > > >>> > > > >> To change account links go to > > > >> > > > >> Goods & Services -> Changeup > > > >> > > > >> DS > > > >> > > > >> > > > > ------------------------------------------------------------------------------ > > > >> _______________________________________________ > > > >> sql-ledger-users mailing list > > > >> sql...@li... > > > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > >> > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > > > > sql-ledger-users mailing list > > > > sql...@li... > > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > > > sql-ledger-users mailing list > > > sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: Armaghan S. <sa...@le...> - 2009-06-29 11:34:45
|
Here is how the whole thing works: 1. You can edit the account links only if there is no transaction referencing this part. 2. If you use the 'Change up' menu, you can edit the accounts links. However a new part with same part number is created with you save. This might add to the confusion because now there are two parts with same number. 3. You can mark a part obsolete and it will not appear in parts lookups during transaction entry. To mark a part obsolete, its onhand should be zero. You can add a new part again with same part number but with different account links. You can correct the account postings for past transactions for that part using a GL transaction. The 3rd point seems the best way to change any account inaccuracies without mucking around with existing transactions. Hope this helps. Let me know if I am not clear. On our sql-ledger hosting, we can allow the user to change the account links any time he or she likes to. There is a reposting script which, when run, corrects all past transactions. Regards Armaghan -- - free sql-ledger hosting, documentation, support - http://www.ledger123.com - http://wiki.ledger123.com - http://help.ledger123.com |
|
From: <je...@ix...> - 2009-07-09 18:16:38
|
Here's my issue. Our current earnings is off by 54,300.03 its been off by this number for years. I'd would like to correct it, but I am not seeing how to affect current earnings without putting my income statement out of wack. I tried modifying retained earnings and using long term loans as the offesetting account, but it had zero effect on current earnings. Any suggestions? Jeff On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> wrote: > Hello I had posted this in the message board on the site about 3 weeks > ago and no response; not sure if this is more active or not. > > So I will ask here: > > I have a number of items that when I entered into sql ledger, I picked > the wrong income account. When going back to editing these items, I do > not see all of my income accounts even though I know they exist. I know > this because I see them in the Chart of Accounts and when I add a new > item I get the full list. > > Is this a bug or is it like that for a reason? > > I can simply delete and re-add the item with the correct income account > but I am wondering if this will affect any reports or previous invoices > I made with that item. I would be keeping everything exactly alike > except the income account. Would this be ok? > > So bug or is it like that for a reason? > > > Thanks > > JP > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: <sql...@li...> - 2009-07-10 20:30:19
|
Did you have anybody with basic book keeping skils look at your files? Current earnings would be the difference between expenses and income for any given period. Also known as result. Now if my result was off by 50k, personally I would start to wonder what is going on. Basic sanity check: 1) Do you have more or less than expected? 2) If less, would it be possible somebody is doing something with funds that is not entirely the way it should be? (Also known as fraud). 3) Wild guess: did you do any year-end processing at all? If not, all results from day one till now would be seen as current earnings. At year end, it is a good habit to add any profits to the available reserves (equity) and start over for the new year. If we skip that, how is SQL-Ledger to know the period for which we want to calculate profit has ended? HtH Paul 2009/7/9 <je...@ix...> > Here's my issue. Our current earnings is off by 54,300.03 its been off by > this number for years. I'd would like to correct it, but I am not seeing > how to affect current earnings without putting my income statement out of > wack. I tried modifying retained earnings and using long term loans as the > offesetting account, but it had zero effect on current earnings. > > Any suggestions? > > Jeff > > > On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> wrote: > > Hello I had posted this in the message board on the site about 3 weeks > > ago and no response; not sure if this is more active or not. > > > > So I will ask here: > > > > I have a number of items that when I entered into sql ledger, I picked > > the wrong income account. When going back to editing these items, I do > > not see all of my income accounts even though I know they exist. I know > > this because I see them in the Chart of Accounts and when I add a new > > item I get the full list. > > > > Is this a bug or is it like that for a reason? > > > > I can simply delete and re-add the item with the correct income account > > but I am wondering if this will affect any reports or previous invoices > > I made with that item. I would be keeping everything exactly alike > > except the income account. Would this be ok? > > > > So bug or is it like that for a reason? > > > > > > Thanks > > > > JP > > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: <sql...@li...> - 2009-07-10 22:25:45
|
Yes, we have someone with basic book keeping skills. No we have not found anything to suggest why it keeps occurring every year for the same amount. What we do know is that this amount has been off since 2004 maybe 2003. Its an error that occurred many years ago. 1. Current Earnings is 50k, more than expected. 2. We do not suspect fraud. 3. We have done several year end closes. 2002 was off my 17k, 2003 was off by I think 53k, and its been the same number every year. I'm not concerned so much why we are off by 53k, we believe its an error that was created in the system during one of the version upgrades. I want to make Current Earnings match our Income Statement (As in, if I the only way to do it, is to manipulate the database, then tell me how, and I'll do it) thoughts on how to fix it? Jeff On Fri, 10 Jul 2009 22:30:10 +0200, sql...@li... wrote: > Did you have anybody with basic book keeping skils look at your files? > Current earnings would be the difference between expenses and income for > any > given period. Also known as result. > > Now if my result was off by 50k, personally I would start to wonder what > is > going on. Basic sanity check: > > 1) Do you have more or less than expected? > 2) If less, would it be possible somebody is doing something with funds > that > is not entirely the way it should be? (Also known as fraud). > > 3) Wild guess: did you do any year-end processing at all? If not, all > results from day one till now would be seen as current earnings. At year > end, it is a good habit to add any profits to the available reserves > (equity) and start over for the new year. > If we skip that, how is SQL-Ledger to know the period for which we want to > calculate profit has ended? > > HtH > Paul > > 2009/7/9 <je...@ix...> > >> Here's my issue. Our current earnings is off by 54,300.03 its been off > by >> this number for years. I'd would like to correct it, but I am not seeing >> how to affect current earnings without putting my income statement out > of >> wack. I tried modifying retained earnings and using long term loans as > the >> offesetting account, but it had zero effect on current earnings. >> >> Any suggestions? >> >> Jeff >> >> >> On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> > wrote: >> > Hello I had posted this in the message board on the site about 3 weeks >> > ago and no response; not sure if this is more active or not. >> > >> > So I will ask here: >> > >> > I have a number of items that when I entered into sql ledger, I picked >> > the wrong income account. When going back to editing these items, I do >> > not see all of my income accounts even though I know they exist. I > know >> > this because I see them in the Chart of Accounts and when I add a new >> > item I get the full list. >> > >> > Is this a bug or is it like that for a reason? >> > >> > I can simply delete and re-add the item with the correct income > account >> > but I am wondering if this will affect any reports or previous > invoices >> > I made with that item. I would be keeping everything exactly alike >> > except the income account. Would this be ok? >> > >> > So bug or is it like that for a reason? >> > >> > >> > Thanks >> > >> > JP >> > >> > >> >> > ------------------------------------------------------------------------------ >> > _______________________________________________ >> > sql-ledger-users mailing list >> > sql...@li... >> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> >> >> > ------------------------------------------------------------------------------ >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited time, >> vendors submitting new applications to BlackBerry App World(TM) will > have >> the opportunity to enter the BlackBerry Developer Challenge. See full > prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full > prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: <sql...@li...> - 2009-07-11 05:26:21
|
I do not think updating can have caused this kind of anomalies in the accounts. Been using this package for years and never found anything to that effect. Two more ideas: 1) if you use reports with headers inbetween (you can see by different colors and subtotals) in your General Ledger scheme: remove those and rerun report. That might do the trick, especially since you say that the accounts are actually balanced. 2) If the COGS in the opening balance (when you started using SQL-Ledger) is not entered correctly, the opening stock will be sold with a sales price of x, and a COGS of ZERO. That might explain te extra income. Hope you did not have to pay tax on that, since it is not actual income, just a bookkeeping error! As a last resort, if you want to you can do a backup to file and personal mail me the zip. I can then restore over here local and have a look if I can find anything from the accounting point of view. Cheers, Paul 2009/7/11 <sql...@li...> > Yes, we have someone with basic book keeping skills. No we have not found > anything to suggest why it keeps occurring every year for the same amount. > What we do know is that this amount has been off since 2004 maybe 2003. Its > an error that occurred many years ago. > > 1. Current Earnings is 50k, more than expected. > 2. We do not suspect fraud. > 3. We have done several year end closes. 2002 was off my 17k, 2003 was off > by I think 53k, and its been the same number every year. > > I'm not concerned so much why we are off by 53k, we believe its an error > that was created in the system during one of the version upgrades. I want > to make Current Earnings match our Income Statement (As in, if I the only > way to do it, is to manipulate the database, then tell me how, and I'll do > it) > > thoughts on how to fix it? > > Jeff > > > > On Fri, 10 Jul 2009 22:30:10 +0200, sql...@li... > wrote: > > Did you have anybody with basic book keeping skils look at your files? > > Current earnings would be the difference between expenses and income for > > any > > given period. Also known as result. > > > > Now if my result was off by 50k, personally I would start to wonder what > > is > > going on. Basic sanity check: > > > > 1) Do you have more or less than expected? > > 2) If less, would it be possible somebody is doing something with funds > > that > > is not entirely the way it should be? (Also known as fraud). > > > > 3) Wild guess: did you do any year-end processing at all? If not, all > > results from day one till now would be seen as current earnings. At year > > end, it is a good habit to add any profits to the available reserves > > (equity) and start over for the new year. > > If we skip that, how is SQL-Ledger to know the period for which we want > to > > calculate profit has ended? > > > > HtH > > Paul > > > > 2009/7/9 <je...@ix...> > > > >> Here's my issue. Our current earnings is off by 54,300.03 its been off > > by > >> this number for years. I'd would like to correct it, but I am not seeing > >> how to affect current earnings without putting my income statement out > > of > >> wack. I tried modifying retained earnings and using long term loans as > > the > >> offesetting account, but it had zero effect on current earnings. > >> > >> Any suggestions? > >> > >> Jeff > >> > >> > >> On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> > > wrote: > >> > Hello I had posted this in the message board on the site about 3 weeks > >> > ago and no response; not sure if this is more active or not. > >> > > >> > So I will ask here: > >> > > >> > I have a number of items that when I entered into sql ledger, I picked > >> > the wrong income account. When going back to editing these items, I do > >> > not see all of my income accounts even though I know they exist. I > > know > >> > this because I see them in the Chart of Accounts and when I add a new > >> > item I get the full list. > >> > > >> > Is this a bug or is it like that for a reason? > >> > > >> > I can simply delete and re-add the item with the correct income > > account > >> > but I am wondering if this will affect any reports or previous > > invoices > >> > I made with that item. I would be keeping everything exactly alike > >> > except the income account. Would this be ok? > >> > > >> > So bug or is it like that for a reason? > >> > > >> > > >> > Thanks > >> > > >> > JP > >> > > >> > > >> > >> > > > > ------------------------------------------------------------------------------ > >> > _______________________________________________ > >> > sql-ledger-users mailing list > >> > sql...@li... > >> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > >> > >> > >> > > > > ------------------------------------------------------------------------------ > >> Enter the BlackBerry Developer Challenge > >> This is your chance to win up to $100,000 in prizes! For a limited time, > >> vendors submitting new applications to BlackBerry App World(TM) will > > have > >> the opportunity to enter the BlackBerry Developer Challenge. See full > > prize > >> details at: http://p.sf.net/sfu/Challenge > >> _______________________________________________ > >> sql-ledger-users mailing list > >> sql...@li... > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > ------------------------------------------------------------------------------ > > Enter the BlackBerry Developer Challenge > > This is your chance to win up to $100,000 in prizes! For a limited time, > > vendors submitting new applications to BlackBerry App World(TM) will have > > the opportunity to enter the BlackBerry Developer Challenge. See full > > prize > > details at: http://p.sf.net/sfu/Challenge > > _______________________________________________ > > sql-ledger-users mailing list > > sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > |
|
From: <sql...@li...> - 2009-07-11 06:31:05
|
Hi Jeff, I've seen (reconciliation?) balances that remain affected by phantom transactions --transactions that were deleted but some aspect of the transaction remains hidden in the system. I'm not sure of the cause, because there were numerous people entering and reconciling data in multiple databases. From what I recall, the problem is associated with transactions that have been at least partially reconciled against one or more of the accounts associated with it prior to the transaction being deleted. Fixing has been arduous: 1. making a backup of the database 2. tracking down and deleting the transaction detail in the database tables that are associated with the error. Identifying the offending transaction can be tricky. I would verify the balance on the account from beginning of the account and note the month (or approximate date) where the balance is not accurately reflecting balance of shown transactions. Then I would examine the transaction detail for every transaction with at least a date in that time frame, looking for inconsistencies with associated transaction dates or transactions that show up in the database but not through the web. Try repairing any problem first by using the web-based UI. If unsuccessful, then you may have found the culprit! If so, carefully go through the various tables noting and removing the fragments of the transaction. Be sure to check the data returned from DELETE criteria (where...) by using a Select before deleting, or you might accidentally remove a portion of a transaction that was previously okay (thereby compounding the problem). 3. verify the balance accurately reflects transactions shown 4. regenerate the removed transaction (if need be) 5. regenerate any year end GL transactions that occurred after the transaction Wouldn't it be nice to have an AUDIT button that identified transaction inconsistencies in the DB? Some day.. cheers, Torben sql...@li... wrote: > I do not think updating can have caused this kind of anomalies in the > accounts. > Been using this package for years and never found anything to that effect. > > Two more ideas: > > 1) if you use reports with headers inbetween (you can see by different > colors and subtotals) in your General Ledger scheme: remove those and rerun > report. That might do the trick, especially since you say that the accounts > are actually balanced. > > 2) If the COGS in the opening balance (when you started using SQL-Ledger) is > not entered correctly, the opening stock will be sold with a sales price of > x, and a COGS of ZERO. > > That might explain te extra income. Hope you did not have to pay tax on > that, since it is not actual income, just a bookkeeping error! > > As a last resort, if you want to you can do a backup to file and personal > mail me the zip. I can then restore over here local and have a look if I can > find anything from the accounting point of view. > > Cheers, > Paul > > 2009/7/11 <sql...@li...> > >> Yes, we have someone with basic book keeping skills. No we have not found >> anything to suggest why it keeps occurring every year for the same amount. >> What we do know is that this amount has been off since 2004 maybe 2003. Its >> an error that occurred many years ago. >> >> 1. Current Earnings is 50k, more than expected. >> 2. We do not suspect fraud. >> 3. We have done several year end closes. 2002 was off my 17k, 2003 was off >> by I think 53k, and its been the same number every year. >> >> I'm not concerned so much why we are off by 53k, we believe its an error >> that was created in the system during one of the version upgrades. I want >> to make Current Earnings match our Income Statement (As in, if I the only >> way to do it, is to manipulate the database, then tell me how, and I'll do >> it) >> >> thoughts on how to fix it? >> >> Jeff >> >> >> >> On Fri, 10 Jul 2009 22:30:10 +0200, sql...@li... >> wrote: >>> Did you have anybody with basic book keeping skils look at your files? >>> Current earnings would be the difference between expenses and income for >>> any >>> given period. Also known as result. >>> >>> Now if my result was off by 50k, personally I would start to wonder what >>> is >>> going on. Basic sanity check: >>> >>> 1) Do you have more or less than expected? >>> 2) If less, would it be possible somebody is doing something with funds >>> that >>> is not entirely the way it should be? (Also known as fraud). >>> >>> 3) Wild guess: did you do any year-end processing at all? If not, all >>> results from day one till now would be seen as current earnings. At year >>> end, it is a good habit to add any profits to the available reserves >>> (equity) and start over for the new year. >>> If we skip that, how is SQL-Ledger to know the period for which we want >> to >>> calculate profit has ended? >>> >>> HtH >>> Paul >>> >>> 2009/7/9 <je...@ix...> >>> >>>> Here's my issue. Our current earnings is off by 54,300.03 its been off >>> by >>>> this number for years. I'd would like to correct it, but I am not seeing >>>> how to affect current earnings without putting my income statement out >>> of >>>> wack. I tried modifying retained earnings and using long term loans as >>> the >>>> offesetting account, but it had zero effect on current earnings. >>>> >>>> Any suggestions? >>>> >>>> Jeff >>>> >>>> >>>> On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> >>> wrote: >>>>> Hello I had posted this in the message board on the site about 3 weeks >>>>> ago and no response; not sure if this is more active or not. >>>>> >>>>> So I will ask here: >>>>> >>>>> I have a number of items that when I entered into sql ledger, I picked >>>>> the wrong income account. When going back to editing these items, I do >>>>> not see all of my income accounts even though I know they exist. I >>> know >>>>> this because I see them in the Chart of Accounts and when I add a new >>>>> item I get the full list. >>>>> >>>>> Is this a bug or is it like that for a reason? >>>>> >>>>> I can simply delete and re-add the item with the correct income >>> account >>>>> but I am wondering if this will affect any reports or previous >>> invoices >>>>> I made with that item. I would be keeping everything exactly alike >>>>> except the income account. Would this be ok? >>>>> >>>>> So bug or is it like that for a reason? >>>>> >>>>> >>>>> Thanks >>>>> >>>>> JP >>>>> >>>>> >>>> >> ------------------------------------------------------------------------------ >>>>> _______________________________________________ >>>>> sql-ledger-users mailing list >>>>> sql...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >>>> >>>> >> ------------------------------------------------------------------------------ >>>> Enter the BlackBerry Developer Challenge >>>> This is your chance to win up to $100,000 in prizes! For a limited time, >>>> vendors submitting new applications to BlackBerry App World(TM) will >>> have >>>> the opportunity to enter the BlackBerry Developer Challenge. See full >>> prize >>>> details at: http://p.sf.net/sfu/Challenge >>>> _______________________________________________ >>>> sql-ledger-users mailing list >>>> sql...@li... >>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >>>> >> ------------------------------------------------------------------------------ >>> Enter the BlackBerry Developer Challenge >>> This is your chance to win up to $100,000 in prizes! For a limited time, >>> vendors submitting new applications to BlackBerry App World(TM) will have >>> the opportunity to enter the BlackBerry Developer Challenge. See full >>> prize >>> details at: http://p.sf.net/sfu/Challenge >>> _______________________________________________ >>> sql-ledger-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> >> >> ------------------------------------------------------------------------------ >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited time, >> vendors submitting new applications to BlackBerry App World(TM) will have >> the opportunity to enter the BlackBerry Developer Challenge. See full prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users >> > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: <sql...@li...> - 2009-07-10 20:49:11
|
A few questions: Is your trial balance in balance? You say that your income is out of whack- is the balance sheet out of whack? Normaly two accounts would be off as debits equals credits. Unless a transaction is dated in the future. Sent from my phone On Jul 9, 2009, at 1:49 PM, <je...@ix...> wrote: > Here's my issue. Our current earnings is off by 54,300.03 its been > off by > this number for years. I'd would like to correct it, but I am not > seeing > how to affect current earnings without putting my income statement > out of > wack. I tried modifying retained earnings and using long term loans > as the > offesetting account, but it had zero effect on current earnings. > > Any suggestions? > > Jeff > > > On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> > wrote: >> Hello I had posted this in the message board on the site about 3 >> weeks >> ago and no response; not sure if this is more active or not. >> >> So I will ask here: >> >> I have a number of items that when I entered into sql ledger, I >> picked >> the wrong income account. When going back to editing these items, I >> do >> not see all of my income accounts even though I know they exist. I >> know >> this because I see them in the Chart of Accounts and when I add a new >> item I get the full list. >> >> Is this a bug or is it like that for a reason? >> >> I can simply delete and re-add the item with the correct income >> account >> but I am wondering if this will affect any reports or previous >> invoices >> I made with that item. I would be keeping everything exactly alike >> except the income account. Would this be ok? >> >> So bug or is it like that for a reason? >> >> >> Thanks >> >> JP >> >> > --- > --- > --- > --------------------------------------------------------------------- >> _______________________________________________ >> sql-ledger-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > --- > --- > --- > --------------------------------------------------------------------- > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited > time, > vendors submitting new applications to BlackBerry App World(TM) will > have > the opportunity to enter the BlackBerry Developer Challenge. See > full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: <sql...@li...> - 2009-07-10 22:32:33
|
For what it's worth we've had several problems with the summary reports completely missing accounts resulting in totally incorrect values. The actual account balances are correct though so we gave up trying to figure out why the summaries were off and just do our own reports based on that. In all fairness even though we had a support contract with Dieter we never bothered to ask him, so there could have been a simple answer - might be worth it! Thanks, Michael ----- Original Message ----- From: je...@ix... To: sql...@li... Sent: Thursday, July 9, 2009 10:49:57 AM GMT -08:00 US/Canada Pacific Subject: [SL] How can I affect Current Earnings without Changing my net income? Here's my issue. Our current earnings is off by 54,300.03 its been off by this number for years. I'd would like to correct it, but I am not seeing how to affect current earnings without putting my income statement out of wack. I tried modifying retained earnings and using long term loans as the offesetting account, but it had zero effect on current earnings. Any suggestions? Jeff On Tue, 23 Jun 2009 20:32:40 -0400, "J.P. Possenti" <jp...@pi...> wrote: > Hello I had posted this in the message board on the site about 3 weeks > ago and no response; not sure if this is more active or not. > > So I will ask here: > > I have a number of items that when I entered into sql ledger, I picked > the wrong income account. When going back to editing these items, I do > not see all of my income accounts even though I know they exist. I know > this because I see them in the Chart of Accounts and when I add a new > item I get the full list. > > Is this a bug or is it like that for a reason? > > I can simply delete and re-add the item with the correct income account > but I am wondering if this will affect any reports or previous invoices > I made with that item. I would be keeping everything exactly alike > except the income account. Would this be ok? > > So bug or is it like that for a reason? > > > Thanks > > JP > > ------------------------------------------------------------------------------ > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X