Re: [SL] Once an item is added, the income account cannot be changed.

[J.P. P. <jp...@pi...>]

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