Re: pos screen posts, but doesn't print

[Bob Miller <..hidden..>]

Greetings list,
I have gotten past the null entry for chart_id.  I am not sure if there was a better way to do it, but my solution was to change this line in pos.conf.pl:

$pos_config{till_accno} = "$pos_config{coa_prefix}.$pos_config{till}";

to

$pos_config{till_accno} = "$pos_config{coa_prefix}";

I noticed at the svn repository a newer version of the file bin/pos.pl, so I have used it to replace the one I had.  However, I am still getting the error "Attempt to free unreferenced scalar: SV 0x94a1718, Perl interpreter: 0x8170008 at bin/pos.pl line 967" at the top of the frame when I post something in the POS=>Sale window.  So far, I cannot determine a problem to associate with it, transactions seem to be recorded, inventory is adjusted, etc.  Googling has led me to believe that I am going to have to learn more about dissecting pearl in order to solve it.  Any clues would be graciously appreciated.

I would also note, though I am just diving into this one, that the printer is not printing from the POS=>Sale button.  I see the printing options are different than under AR=>Invoice, and it works there, I figure there is one more thing to configure in pos.conf.pl.


-----Original Message-----
From: Bob Miller <..hidden..>
Reply-To: ..hidden..
To: ..hidden..
Subject: [Ledger-smb-users] pos screen does not update
Date: Sun, 29 Jun 2008 18:11:18 -0700

Hello all,
My problem is all about the POS module.  It started with a post I made some time ago, and there was a good deal of information provided.  thanks for that.  I have now obtained a receipt printer and a cash drawer, and am trying to get the POS module working correctly with it.
I have put quite a bit of time into this, fiddling with pos.conf.pl, ledgersmb.conf and bin/pos.pl, as well as a number of other things.  I also created way to many invoices, and finally got to a point where I couldn't keep track of what I had done to create errors that were showing up, so I have now restored an original copy of pos.conf.pl and bin/pos.pl, and restored the database back to the beginning of the process.  Here I go again.

What I have done so far:
- in ledgersmb.conf, I have modified the printer section as follows:
   [printers]
   # Available printers
   #Laser      = lpr -Plaser
   #Epson      = lpr -PEpson
   Star     = lpr -P Receipt-1
   This creates a 'Star' option to print from in POS=>sale and AR=>invoice.
- I have changed near the top of the bin/pos.pl file from USD to CAD to avoid the exchange rate field (matching the system).
- I have commented all lines in pos.conf.pl $pos_config{'pd_*'}.  On the assumption that pd is pole display, and since I have no pole display, it seems reasonable to comment them out.

What works as expected:
- from command line, the command lpr -P Receipt-1 /home/bob/test.txt prints and opens the cash drawer.
- under AR=>sales invoice I can enter one or more items into an invoice, and the print button prints and opens the cash drawer, though the invoice does not fit onto the paper in width.
- under AR=>sales invoice, entering items and posting them affects inventory
- under POS=>sale, entering part of a description, pressing 'update,' then 'print and post,' I get some open transaction information, and inventory is affected, though I get an error (see below).

What does not work;  
- under POS=>sale, entering part of a description, pressing 'update,' then 'print and post,' though inventory is affected correctly, I get an error at the top of the page:
  Attempt to free unreferenced scalar: SV 0x949c508, Perl interpreter: 0x8170008 at bin/pos.pl line 966.
  Content-Type: text/html; charset=utf-8

- under POS=>sale, entering part of a description and entering an amount in the 'Amount' field, pressing 'update,' then 'print and post,' I get the following error:
Attempt to free unreferenced scalar: SV 0x94a1718, Perl interpreter: 0x8170008 at bin/pos.pl line 966.
DBD::Pg::st execute failed: ERROR: null value in column "chart_id" violates not-null constraint at LedgerSMB/IS.pm line 1306.
Error!
INSERT INTO acc_trans 
(trans_id, chart_id, amount, 
transdate, source, memo, cleared)
VALUES (?, (SELECT id FROM chart
WHERE accno = ?),
?, ?, ?, ?, ?)
ERROR: null value in column "chart_id" violates not-null constraint
Inventory is not affected when this error happens, however the invoice number does auto-increment.

What I have tried:
- creating a Chart of Accounts entry for account 1300
- creating a Chart of Accounts entry for account 1300.2 (as per a post I found on the net that says the default schematics is 1300.[employeenumber].  I have a feeling that maybe I have the definition of account incorrect in this context.)

I have been trying to figure it, but between following code and trying to interpret the database calls, progress is beyond slow for me.  I suspect there is a configuration in the POS module  somewhere that I am missing, since things seem to work ok in AR.  I am not scared of documentation, but I have looked over all the relevant stuff I have found so far (the wiki being down at the moment), and I have come up blank.  If someone could offer a nudge in the right direction, I would really appreciate it...

Bob Miller
334-7117/633-3760
http://computerisms.ca
..hidden..
Network, Internet, Server,
and Open Source Solutions

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Bob Miller
334-7117/633-3760
http://computerisms.ca
..hidden..
Network, Internet, Server,
and Open Source Solutions