[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: POS Screen - Errors when posting an invoice



I think I have solved many of the issues resulting from the SQL-Ledger to 
LedgerSMB migration and want to post my steps here for others who have 
similar issues.  The main blocking issue was "ERROR:  permission denied 
for relation ar".  In addition, it appears that there is a bug in 
Pg-upgrade-2.6.17-2.6.18.sql which names a sequence incorrectly.  Here are 
the steps I have taken so far to resolve my issues.

1. Conected to my database via psql and issues the following command: 
"alter table acctrans_entry_id_seq RENAME TO acc_trans_entry_id_seq;".  It 
appears that Pg-upgrade-2.6.17-2.6.18.sql incorrectly names this sequence.

2. Via pgAdmin, I created individual backups (tar files) of the following 
tables
 
        - ar
        - parts
        - partstax

3.  Dropped the following tables

        - ar
        - parts (needed to use Drop Cascaded)
        - partstax

4.  Restored the following tables in order using the following command

        pg_restore -d <database name> <backup tar name>  (i.e. pg_restore 
-d tatylee partstax_backup.tar)

        - ar
        - parts
        - partstax

I can now post Sales invoices from the POS screen and no longer get the 
permission denied for relation error.  I still have one issue currently 
that I am aware of.  When I click the Print and Post button, although the 
sale gets posted, the receipt gets displayed in the browser window instead 
of being sent to the receipt printer.  Not sure if this is related, but I 
commented out the following line in my pos.conf.pl as advised to correct 
another issue.  Could this be related?

# Removed this as advised by Chris Travers to resolve a performance issue 
with updates on the POS screen- SLM 05/28/2008
#${'LedgerSMB::Sysconfig::printer'}{'Printer'} = "utils/pos/directnet.pl 
$pos_config{rp_host} $pos_config{rp_proto} $pos_config{rp_port}";

I would appreciate any help trying to resolve the receipt printing issue. 
I do have the printers setup ledgersmb.conf and can send print jobs via 
`lpr -P Star_TSP643U file.txt' using the command line from a Unix shell so 
I know this works outside of LedgerSMB.  In addition, SQL-Ledger is still 
installed on the same machine and I have no problems printing from there.  
This is LedgerSMB specific.

Best Regards,
Steven Marshall

Taty Lee Boutique
11705 Jones Bridge Rd., B206
Alpharetta, GA 30005
770-410-6964

"Once you experience the stylish comfort of Brazilian-cut jeans, you will 
demand nothing less!"