Lost Taxes After Restore
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
Lost Taxes After Restore
by beamends
::
Rate this Message:
After recent events, I've done a pg_restore -d backup.sqlc
but the taxes have stayed at the default values. I've changed the 17.5% to 15% (thanks Gordon), but my 0% rate had gone (books and export) and I can't remember what account code I used for it. First off, have I used the correct flags for pg_restore (I created the dataset for the company to restore into before restoring), and Secondly - as the parts have all "lost" their tax catergory (15%) - are the numbers going to add up in reports? Cheers Richard ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-users |
|
|
Re: Lost Taxes After Restore
by Chris Travers-5
::
Rate this Message:
On Mon, Oct 19, 2009 at 5:30 AM, beamends <lrspares45@...> wrote: After recent events, I've done a pg_restore -d backup.sqlc Hi Richard; That is very strange. All of this should have been in the database and hence I have to wonder why the tax values disappeared. (You might try using pg_restore to restore the "tax," "customertax," "vendortax," and "partstax" tables only at this point.) If you need me to look at the backup to ensure everything is fine, I can do that (but would have to charge for it). Secondly, the numbers will add up because the financial data is stored separately. Hope this helps. Chris Travers
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-users |
|
|
Re: Lost Taxes After Restore
by beamends
::
Rate this Message:
On Mon, 2009-10-19 at 13:30 +0100, beamends wrote:
> After recent events, I've done a pg_restore -d backup.sqlc > > but the taxes have stayed at the default values. I've changed the 17.5% > to 15% (thanks Gordon), but my 0% rate had gone (books and export) and I > can't remember what account code I used for it. > > First off, have I used the correct flags for pg_restore (I created the > dataset for the company to restore into before restoring), and > > Secondly - as the parts have all "lost" their tax catergory (15%) - are > the numbers going to add up in reports? > > Cheers > Richard > Thanks for mail Chris. All sorted out now - I went one step too far and created a user before restoring using the -d flag. After a bit of faffing I found I should have not created a user, instead just created a dbase and then resored using the -C flag (I think!). All is nearly well - one little hiccup was that although the 0% VAT rate appeared ok, and is present on all Part pages, the books we sell (0% VAT) have all had their VAT set back to 15% - easily put right but could have easily been missed. The installation is otherwise ok, but it is a bit flakey - if it continues I'll post the error messages as and when. Cheers Richard > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Ledger-smb-users mailing list > Ledger-smb-users@... > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users I have become.......comfortably numb ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-users |
|
|
Re: Lost Taxes After Restore
by Luke-74
::
Rate this Message:
On Mon, 19 Oct 2009, Richard wrote:
> The installation is otherwise ok, but it is a bit flakey - if it > continues I'll post the error messages as and when. Something that only errors once in a while? Luke ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@... https://lists.sourceforge.net/lists/listinfo/ledger-smb-users |
| Free embeddable forum powered by Nabble | Forum Help |
