Re: [Ledger-smb-users] Using Sale on POS

7/31/07, Eduardo Huertas <[EMAIL PROTECTED]> > > > > > > wrote: > > > > --- Chris Travers <[EMAIL PROTECTED]> > > > > > > escribió: > > > > > On 7/31/07, Eduardo Huertas > > > > > > <[EMAIL PROTECTED]>

Re: [Ledger-smb-users] Currency payment issue

e correct (using the same exchange rate that was used on the invoice for the payment / even thought that was not reality). Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpowe

Re: [Ledger-smb-users] Currency payment issue

On Wednesday 01 August 2007 01:39, Chris Travers wrote: > On 7/31/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > > I'm trying to figure out how to deal with this situation. I had an > > invoice > > for $550USD, with an exchange rate of 1.0656 to make a CAD total o

[Ledger-smb-users] Currency payment issue

eipt, or the currency, or how do I reverse the payment? Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1270 005C EC73 4

[Ledger-smb-users] Best way to check for transactions associated with a specific customer ID or part number

ck if there are any transactions associated with a given customer, or part? I did try using the History module for the customer, but it shows no activity for the problematic Customer ID. Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpowe

Re: [Ledger-smb-users] Using Sale on POS

counts. Which chart of accounts are you using? Have you made > any modifications? > > Some background here: This error message is telling me that the subquery > did not return a valid account id, and that our database rules prevent this > from being inserted. SQL-Ledger does

Re: [Ledger-smb-users] Question about what to do on duplicated parts keys

On Thursday 28 June 2007 17:36, Leah Kubik wrote: > This gets us past that set of db updates, but now have a problem with > > ALTER TABLE partstax ADD PRIMARY KEY (parts_id, chart_id); > > If I don't set this primary key, I get stuck at the next lines: > > ALTER TABL

Re: [Ledger-smb-users] Question about what to do on duplicated parts keys

On Thursday 28 June 2007 15:56, Leah Kubik wrote: > I'd sent this in to the list, but still haven't seen it post, I might have > accidentally sent it to announce list... > > I'm running an update from SL, and have gotten past the customers dup key > problem

[Ledger-smb-users] Question about what to do on duplicated parts keys

parts problem... I can send some relevant dumps and so on... I'm guessing my stab at fixing the dup parts ID's isn't quite right. Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAI

Re: [Ledger-smb-users] Upgrading from SQL-Ledger and getting to 1.2

On Tuesday 26 June 2007 17:20, Chris Travers wrote: > On 6/26/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > > Hopefully quick question: > > > > As I remember, generally the process is to migrate SQL-Ledger to > > Ledger-SMB 1.1, and then to upgrade from that to Led

[Ledger-smb-users] Upgrading from SQL-Ledger and getting to 1.2

Hopefully quick question: As I remember, generally the process is to migrate SQL-Ledger to Ledger-SMB 1.1, and then to upgrade from that to LedgerSMB 1.2.x ... Am I correct, or is there now a more direct migration path? Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559

Re: [Ledger-smb-users] Tax Account Not Credited for Invoice Post

On Thursday 31 May 2007 12:37, Leah Kubik wrote: > With this fixed, the tax now posts, and the total on a printed invoice > shows the correct total amount, but the print function is still not showing > the tax name/number like it used to. This may be related to the expiring > tax ac

Re: [Ledger-smb-users] Tax Account Not Credited for Invoice Post

o. This may be related to the expiring tax accounts thing, so I'll look at that next. What revision did this above mentioned fix go in? Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EM

Re: [Ledger-smb-users] Crappy work-around for tax accounts with expiration

selected based on the form's transaction date. I'm not sure it is the best way to code it, but it seems to work for me (tm). Leah > On 5/27/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > > If you have tax accounts that expired at a specific date, only the first > &g

Re: [Ledger-smb-users] Log.pm example?

On Wednesday 30 May 2007 23:16, Seneca Cunningham wrote: > 13-log.t Thanks :) -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1

[Ledger-smb-users] Log.pm example?

Could someone give an example on how to use Log.pm in LedgerSMB? Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1270

[Ledger-smb-users] Tax Account Not Credited for Invoice Post

nvoice. I think I see it in IS.pm, but am having a hard time sorting out how to check what variables it has exactly. Idears appreciated. Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTEC

[Ledger-smb-users] Crappy work-around for tax accounts with expiration

been discussed somewhat in previous posts. Maybe I'll figure that out... Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1270

Re: [Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

Collected for the Client and for the service item), the tax fails to be calculated on the Invoice alltogether. Let me know what other information I can provide. I can give you a login to my system with the test data set too if needed. Leah -- Leah Kubik : d416-585-9971x692 : d416-703-

Re: [Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

ly send you access to a dump of the dataset, which might help. Leah > On 5/6/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > > On Saturday 05 May 2007 11:50, Seneca Cunningham wrote: > > > On Sat, May 05, 2007 at 02:16:59AM -0400, Leah Kubik wrote: > > > > I think

Re: [Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

es not register. I'm having to run out for a bit, but I can send back more details and an example broken dataset soon now. Maybe that helps to reproduce. Problem is, all my old accounts are set up this way... Leah > On 5/6/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > &

Re: [Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

On Saturday 05 May 2007 11:50, Seneca Cunningham wrote: > On Sat, May 05, 2007 at 02:16:59AM -0400, Leah Kubik wrote: > > I think that there was a fix for this, but when I have an invoice where > > an item was given some quantity, the tax shows up on the invoice view, > > but

Re: [Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

\N 0 1 10709 0.0860719907\N 0 1 I see a similarly odd behavior with another chart of accounts. Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: f

[Ledger-smb-users] Fix for tax not showing correcty when using quantity field for invoice items

clarification. Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1270 005C EC73 47C9 B7A6

[Ledger-smb-users] Tax rate changes and constraint "tax_pkey

t_id, rate, taxnumber, validto, pass, taxmodule_id) VALUES (?, ?, ?, ?, ?, ?) ERROR: duplicate key violates unique constraint "tax_pkey" Is the current solution to remove the primary key for tax? http://comments.gmane.org/gmane.comp.finance.ledger.smb.user/710 Leah -- Leah Kubik : d416-585

Re: [Ledger-smb-users] Permission error updating chart of accounts

On Friday 04 May 2007 22:12, Leah Kubik wrote: > So I failed to copy my last reply to the list, but I did check and the user > is loggin in as ledgersmb. I have tried creating a new database using this > one as a template as the ledgersmb user, but I get the same errors with the >

Re: [Ledger-smb-users] Permission error updating chart of accounts

is one as a template as the ledgersmb user, but I get the same errors with the new db. Doe anyone have an idea of how I can migrate this database data into a clean DB that doesn't have this permission error, or where to look? Leah > On 5/2/07, Leah Kubik <[EMAIL PROTECTED]> wrote:

Re: [Ledger-smb-users] Permission error updating chart of accounts

On Wednesday 02 May 2007 00:51, Chris Travers wrote: > On 5/1/07, Leah Kubik <[EMAIL PROTECTED]> wrote: > > Ok, so even though ledgersmb was the owner, it turned you you were > > correct, the admin privs weren't set... I've gotten past that and now > > I

Re: [Ledger-smb-users] Permission error updating chart of accounts

--- public | chart | table | {ledgersmb=arwdRxt/ledgersmb} (1 row) DBD::Pg::st execute failed: ERROR: permission denied for relation chart Error! INSERT INTO chart (accno, description, charttype, gifi_accno, category, link, contra) VALUES (?, ?, ?, ?, ?, ?, ?) ERROR: permissi

Re: [Ledger-smb-users] Permission error updating chart of accounts

On Tuesday 01 May 2007 17:21, Chris Travers wrote: > Check the owner of the table. It may be owned by Postgres while the > user is ledgersmb. The table is owned by the 'ledgersmb' user... So that's why I'm stumped... > On 5/1/07, Leah Kubik <[EMAIL PROTECTED]&g

[Ledger-smb-users] Permission error updating chart of accounts

here? I'm happy to provide any data needed. This was migrated from sql-ledger, and the database user was updated to 'ledgersmb', but perhaps something was missed? The user for the application is running as 'ledgersmb' and that user is the owner of the chart table. Leah

Re: [Ledger-smb-users] (apparently) cosmetic tax rounding bug

On Monday 30 April 2007 15:43, [EMAIL PROTECTED] wrote: > No, it's the Mysterious Case of the Appearing Penny. Aha! Yes, that missing penny. I've got it now! Muahahaha. (I've been wondering about this for years). -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-55

Re: [Ledger-smb-users] CCA / Depreciation of Capital Assets ?

> 1000.00 reversing entry > > As Chris said there's no way at the moment to automate this within > LedgerSMB so you'll have to use GL entries. -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 F

Re: [Ledger-smb-users] Upgrade Error

se problems elsewhere (probably) so I'd wait for an answer from Chris or someone who knows for sure... Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h

Re: [Ledger-smb-users] UPGRADE doc bugs

On Thursday 12 April 2007 01:34, Chris Travers wrote: > Thanks :-) Will look into that tonight. I made some new updates to the wiki doc just now to try to help distinguish version specific notes from generic upgrade steps. jFYI > On 4/11/07, Leah Kubik <[EMAIL PROTECTED]> wrote: &

[Ledger-smb-users] UPGRADE doc bugs

c at http://ledgersmb.frauerpower.com/index.php/HOWTO_Upgrading_LedgerSMB Others on the list, please feel free to modify the steps specific to your version to version upgrade(s). Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada M

[Ledger-smb-users] CCA / Depreciation of Capital Assets ?

have been depriciated, what is still left, etc. Has anyone come up with a nice way to handle this? CCA is the specific term used for Canadian Capital Cost Allowance deductions: http://sbinfocanada.about.com/cs/taxinfo/g/capcostallow.htm Thanks, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977

[Ledger-smb-users] Capital Cost Allowances

http://sbinfocanada.about.com/cs/taxinfo/g/capcostallow.htm Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada MSN: [EMAIL PROTECTED] | AIM: frauerpower | Yahoo: h3inous F9B6 FEFE 080B 8299 D7EA 1270 005C EC73 47C9

Re: [Ledger-smb-users] Permissions (unix) for running from svn checkout

hance to share > your opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > ___ > Ledger-smb-users mailing list > Ledger-smb-users@

Re: [Ledger-smb-users] Transition from sql-l to lsmb

; version of LedgerSMB were you working with? > > 1.2.0b5 Hmmn. The version I ran with for the docs was 1.1.7 . I tend to stick w/the stable versions for now. Made a not of that in the docs. -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauer

Re: [Ledger-smb-users] Transition from sql-l to lsmb

y good indeed. Sorry to reply to Chris's reply instead of yours directly. I lost the initial email. Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada F9B6 FEFE 080B 8299 D7EA 1270 005C EC73 47C9 B7A6

[Ledger-smb-users] Pesky CSS jumpy arrrrrr!

22:14:17.0 -0500 @@ -128,7 +128,7 @@ text-decoration: none; color: #ee; background: #004a80; - padding: 2px; + padding: 0; } .listtop { font-size: 10pt; background-color: black; color: white; } -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpowe

Re: [Ledger-smb-users] Rehash: LedgerSMB Wiki

On Thursday 01 February 2007 11:18, Chris Travers wrote: > Ok. Reworked the site a little. This link is now on the community page. Looks good, thanks. -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada F9B6 FEFE 0

Re: [Ledger-smb-users] Rehash: LedgerSMB Wiki

On Sunday 07 January 2007 02:42, Leah Kubik wrote: > On Saturday 06 January 2007 19:01, Chris Travers wrote: > > 1) You might as well make it a subdomain of Frauerpower.com. Since > > it is not run by the core team, this offers both of us opportunities. > > It offers

Re: [Ledger-smb-users] Rehash: LedgerSMB Wiki

one who has hacked custom functions into SQL-Ledger, I'm wholeheartedly in agreement that something had to be done about the terrifying code. Eek. Hopefully I can help out some, at least on the QA front, and I'm always writing documentation... Leah -- Leah Kubik : d416-585-9

Re: [Ledger-smb-users] Rehash: LedgerSMB Wiki

On Saturday 06 January 2007 14:05, Joshua D. Drake wrote: > On Fri, 2007-01-05 at 17:06 -0500, Leah Kubik wrote: > > I know that this topic has come up in the past, and it looks like you > > have a user-post-to-able site going up at wiki.ledgersmb.org, but this is > > not re

[Ledger-smb-users] Rehash: LedgerSMB Wiki

t I'd toss that out there as a possibility. Cheers, Leah -- Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511 Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada F9B6 FEFE 080B 8299 D7EA 1270 005C EC73