Re: [Ledger-smb-devel] Question about placement of budgets on menu

2012-06-06 Thread Nigel Titley
On 06/06/2012 11:48, Chris Travers wrote: > Where do people think budgets should be on the menu? Right now in 1.4 > it seems I have set it up twice, once under Journal and once as a > top-level item. > It seems more logical as a top-level item. Nigel -

[Ledger-smb-devel] Question about placement of budgets on menu

2012-06-06 Thread Chris Travers
Where do people think budgets should be on the menu? Right now in 1.4 it seems I have set it up twice, once under Journal and once as a top-level item. Best Wishes, Chris Travers -- Live Security Virtual Conference Exclu

Re: [Ledger-smb-devel] Question regarding "Tax Included" on POS Invoice screen

2012-02-13 Thread Chris Travers
On Mon, Feb 13, 2012 at 6:21 PM, Steven Marshall < [email protected]> wrote: > > No. >> >> If tax is included the tax is taken out of the total purchase. If the >> tax is not included it is added to the total purchase. >> >> Best wishes, >> Chris Travers >> >> >> So if I understand corr

Re: [Ledger-smb-devel] Question regarding "Tax Included" on POS Invoice screen

2012-02-13 Thread Steven Marshall
> No. > > If tax is included the tax is taken out of the total purchase. If the tax > is not included it is added to the total purchase. > > Best wishes, > Chris Travers > > > So if I understand correctly, if the customer has the tax boxes checked on his customer account, taxes are applied on a sa

Re: [Ledger-smb-devel] Question regarding "Tax Included" on POS Invoice screen

2012-02-13 Thread Chris Travers
On Mon, Feb 13, 2012 at 7:36 AM, Steven Marshall < [email protected]> wrote: > I have setup a customer database using selecting Brazil COA. I have setup > two tax types (ICMS & Federal Nacional). I added a customer and checked > both taxes under Taxes on the Accounts page of the custom

[Ledger-smb-devel] Question regarding "Tax Included" on POS Invoice screen

2012-02-13 Thread Steven Marshall
I have setup a customer database using selecting Brazil COA. I have setup two tax types (ICMS & Federal Nacional). I added a customer and checked both taxes under Taxes on the Accounts page of the customer record. My question is this. When I go to Point of Sale/Sale which opens the Add POS Invo

Re: [Ledger-smb-devel] Question

2009-11-10 Thread shaker Khzym
Dear Chris, Thank you so much for your replay. Best wishes, Shaekir, Date: Tue, 10 Nov 2009 10:05:34 -0800 From: [email protected] To: [email protected] Subject: Re: [Ledger-smb-devel] Question On Tue, Nov 10, 2009 at 9:53 AM, shaker Khzym wrote: Dear

Re: [Ledger-smb-devel] Question

2009-11-10 Thread Chris Travers
On Tue, Nov 10, 2009 at 9:53 AM, shaker Khzym wrote: > Dear Chris, > > In is.pm , in post_invoice function, > > When the program try to save payment record in the acc_trans table. > > There are two fields , memo and cleared . the program try to save it. > > I know the memo,The user

[Ledger-smb-devel] Question

2009-11-10 Thread shaker Khzym
Dear Chris, In is.pm , in post_invoice function, When the program try to save payment record in the acc_trans table. There are two fields , memo and cleared . the program try to save it. I know the memo,The user add his/her comment but what about the cleared field. Ple

Re: [Ledger-smb-devel] Question related to acc_trans

2009-10-27 Thread Chris Travers
On Tue, Oct 27, 2009 at 9:10 AM, wrote: > Dear All, >I need to discuss a point that I face now. >Some Sales invoices have a lot of records in the acc_trans. These > records are not belong to it but share the same trans_id. >If I repost it, everything will be corrected. >

[Ledger-smb-devel] Question related to acc_trans

2009-10-27 Thread markus
Dear All, I need to discuss a point that I face now. Some Sales invoices have a lot of records in the acc_trans. These records are not belong to it but share the same trans_id. If I repost it, everything will be corrected. I don't know the reason until now, any help

Re: [Ledger-smb-devel] question about rolling back invoice repost transactions

2009-09-30 Thread Chris Calef
Okay, so, it was kind of ugly but we needed to get past this problem, so I ended up inserting a label "ROLLBACK_ALL" at the end of the post_invoice function, and then checking every query in the whole function for success - if anything fails, I simply rollback and exit, instead of failing right the

[Ledger-smb-devel] question about rolling back invoice repost transactions

2009-09-25 Thread Chris Calef
Hello, I have a question regarding commits and rollbacks, in lsmb and in general. We are running a modified version of 1.2.18, and are having some serious trouble with SQL errors that come up when reposting invoices. The errors are no doubt local to our implementation, but the critical problem is

Re: [Ledger-smb-devel] Question about 1.3

2009-07-29 Thread Chris Travers
On Wed, Jul 29, 2009 at 8:51 AM, shaker Khzym wrote: > Dear all, >Hello, I have a question about 1.3 , is it ready to work now or there > are some work . > Minor things need to be finished up/corrected for beta 1 Some things work very well. Other things don't work quite so well. If you ar

[Ledger-smb-devel] Question about 1.3

2009-07-29 Thread shaker Khzym
Dear all, Hello, I have a question about 1.3 , is it ready to work now or there are some work . My second question , what is the meaning of Milestone 1/2/3. Thanks a lot for your patience. Best wishes, Shaekir, _ More stora

Re: [Ledger-smb-devel] Question around exchange rate and taxes

2009-01-09 Thread shaker Khzym
Hi Chris, I send the patch , I hope to see it. waiting your advise, Best wishes, Shaekir, > Date: Fri, 9 Jan 2009 15:36:16 -0800 > From: [email protected] > To: [email protected] > Subject: Re: [Ledger-smb-devel] Question around exchange rate and t

Re: [Ledger-smb-devel] Question around exchange rate and taxes

2009-01-09 Thread Chris Travers
On Fri, Jan 9, 2009 at 3:27 PM, shaker Khzym wrote: > Hi Chris, > My boss monitoring that , > > The default currency in our program is Canadian dollar, so when I used > US$ They saw the amount in cash - payment form is not as the amount in the > vendor invoice if you post the invoice. Can

[Ledger-smb-devel] Question around exchange rate and taxes

2009-01-09 Thread shaker Khzym
Hi Chris, My boss monitoring that , The default currency in our program is Canadian dollar, so when I used US$ They saw the amount in cash - payment form is not as the amount in the vendor invoice if you post the invoice. I follow it, I find the taxes always adding without multi

Re: [Ledger-smb-devel] Question

2009-01-07 Thread Chris Travers
On Wed, Jan 7, 2009 at 3:34 PM, shaker Khzym wrote: > Dear Chris, >Thanks a lot for your advise, it's working now. > I did the same idea about the read of trigger that has the same > problem. > Is there any restricted about that. Nope. > Best Wishes, Chris Travers --

[Ledger-smb-devel] Question

2009-01-07 Thread shaker Khzym
ishes, Shaekir, > Date: Wed, 7 Jan 2009 15:03:12 -0800 > From: [email protected] > To: [email protected] > Subject: Re: [Ledger-smb-devel] Question > > On Wed, Jan 7, 2009 at 2:39 PM, shaker Khzym wrote: > > > > Hello

Re: [Ledger-smb-devel] Question

2009-01-07 Thread shaker Khzym
ishes, Shaekir, > Date: Wed, 7 Jan 2009 15:03:12 -0800 > From: [email protected] > To: [email protected] > Subject: Re: [Ledger-smb-devel] Question > > On Wed, Jan 7, 2009 at 2:39 PM, shaker Khzym wrote: > > > > Hello

Re: [Ledger-smb-devel] Question

2009-01-07 Thread Chris Travers
On Wed, Jan 7, 2009 at 2:39 PM, shaker Khzym wrote: > > Hello, > > > In sql folder - fixes > > > in transactions_foreign_key_fix.sql > > > > CREATE TRIGGER track_global_inserts BEFORE INSERT OR UPDATE ON partsgroup > > > FOR EACH ROW EXECUTE PROCEDURE track_global_seque

[Ledger-smb-devel] Question

2009-01-07 Thread shaker Khzym
Hello, In sql folder - fixes in transactions_foreign_key_fix.sql CREATE TRIGGER track_global_inserts BEFORE INSERT OR UPDATE ON partsgroup FOR EACH ROW EXECUTE PROCEDURE track_global_sequence(); CREATE TRIGGER track_global_inserts AFTER DELETE ON partsgroup

Re: [Ledger-smb-devel] question about modifying/deleting invoices

2008-09-16 Thread Chris Travers
> In my current build, I'm getting an SQL error when I try to change an > invoice, saying > that I'm trying to insert a transaction with a duplicate primary key. >From the release notes: "3.1: Reposting Invoices: Reposting invoices is known to cause inaccuracies cost of goods sold and inventory

[Ledger-smb-devel] question about modifying/deleting invoices

2008-09-16 Thread Chris Calef
Hello, I have a question about the process for modifying and deleting invoices. In my current build, I'm getting an SQL error when I try to change an invoice, saying that I'm trying to insert a transaction with a duplicate primary key. Looking into the code I see that reposting an existing invoi

Re: [Ledger-smb-devel] Question about import process from sql-ledger, and Rose::DB

2008-07-07 Thread turtle
Hi there I would like to comment that I have been using this function every day and it works great and it is a clean way to improt from newer sql-ledger installations or run parallel Sql-ledger / Ledgersmb test systems. We are still using sql-ledger 2.7.15 and this is the only way to cleanly imp

Re: [Ledger-smb-devel] Question about import process from sql-ledger, and Rose::DB

2008-06-09 Thread Chris Calef
Apologies for the delay, was out of town last week. Here are my code files: chriscalef.com/files/ledgerSMB/am_import_everything.pl chriscalef.com/files/ledgerSMB/lsmb_objects.tar.gz chriscalef.com/files/ledgerSMB/DB.pm * am_import_everything.pl is one huge "import_everything" function that

Re: [Ledger-smb-devel] Question on Addresses and Not Null constraints

2008-05-22 Thread Chris Travers
On Thu, May 22, 2008 at 5:23 AM, Roderick A. Anderson <[EMAIL PROTECTED]> wrote: > > Since I'm just getting started with LedgerSMB (after years away from > SQL-Ledger) I'm not sure what the installation base is nor what is it > going to be. > > If there is a need to send /reliably/ via. a postal s

Re: [Ledger-smb-devel] Question on Addresses and Not Null constraints

2008-05-22 Thread Roderick A. Anderson
Chris Travers wrote: > One thing that is remarkably hard to model relationally is address > data. In particular different places have different semantics. Some > countries have mail codes while some do not. Some places it makes > sense to track states and provinces while in some countries this >

Re: [Ledger-smb-devel] Question on Addresses and Not Null constraints

2008-05-22 Thread Jeff Kowalczyk
On Wed, 21 May 2008 19:00:40 -0700, Chris Travers wrote: > I suppose we could just drop the NOT NULL constraint from state... Is the only reason state is marked NOT NULL is to reference a tax table? If so, perhaps we should have a separate tax_zone, or table matching entity_id to any number of ta

Re: [Ledger-smb-devel] Question on Addresses and Not Null constraints

2008-05-21 Thread Chris Travers
On Wed, May 21, 2008 at 6:13 PM, Jeff Kowalczyk <[EMAIL PROTECTED]> wrote: > On Wed, 21 May 2008 11:44:05 -0700, Chris Travers wrote: >> One thing that is remarkably hard to model relationally is address data. >> In particular different places have different semantics. Some countries >> have mail

Re: [Ledger-smb-devel] Question on Addresses and Not Null constraints

2008-05-21 Thread Jeff Kowalczyk
On Wed, 21 May 2008 11:44:05 -0700, Chris Travers wrote: > One thing that is remarkably hard to model relationally is address data. > In particular different places have different semantics. Some countries > have mail codes while some do not. Some places it makes sense to track > states and prov

[Ledger-smb-devel] question around .tex file

2008-03-28 Thread shaker yasa
Dear All I find ap_workflow_ship.tex, I tried to open it by LED program but It always ask me about the .dvi file. any one can help me, How can I open this file to understand it. with my best wishes Shaekir Khzym _ News,

[Ledger-smb-devel] question

2008-03-20 Thread shaker yasa
"${module}_links"}{$key}} , {accno => $ref->{accno}, description => $ref-&g t;{description}} or this key belong to cache so no duplicated variable. Please, be patient with me Thanks for your cooperation Shaekir Khzym From: [EMAIL PROTECTED] To: ledger-sm

[Ledger-smb-devel] question

2008-03-20 Thread shaker yasa
Hello I need to understand , @{form->{"${module}_links"}{$key}} my question : if the $key = "IC" then {$key} will have a reference of location if the $key = "IC_tax" then {$key} will have a another reference of location if the $key = "IC" ag

Re: [Ledger-smb-devel] question

2008-03-19 Thread herman vierendeels
this is a 2-dimensional hash example my %hash2=(aa=>'aaa',bb=>'bbb',cc=>'ccc'); my $hash2_ref=\%hash2; print "$hash2_ref->{aa}\n"; my %hash1=(a=>\%hash2,b=>\%hash2,c=>\%hash2); my $hash1_ref=\%hash1; print "$hash1_ref->{a}{bb}\n"; Best is to put such pieces of code in a little file and test it

[Ledger-smb-devel] question

2008-03-19 Thread shaker yasa
Hello I need to understand , what is the meaning of theamount in this code at ic.pm $form->{amount}{"IC_$_"} It display the ref of the IC_... but what is the amount. Thanks for your cooperation Shaekir Khzym _

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-03 Thread Chris Travers
I need to check a few things about whitespaces around the ='s. When in doubt add it. Also, there is one slight issue here: On 12/3/06, Charley Tiggs <[EMAIL PROTECTED]> wrote: > login = username > password = mypassword > LOGIN So far so good. > MODULE CT > name=Jane Doe I need to doublechec

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-03 Thread Charley Tiggs
Chris Travers wrote: > Sorry, this got sent before I finished... > > On 12/1/06, Chris Travers <[EMAIL PROTECTED]> wrote: >> The main thing missing is the ability to loop through things. >> >> login = username >> password = mypassword >> LOGIN >> MODULE CT >> company = My Customer's company name >

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-01 Thread Chris Travers
Sorry, this got sent before I finished... On 12/1/06, Chris Travers <[EMAIL PROTECTED]> wrote: > The main thing missing is the ability to loop through things. > > login = username > password = mypassword > LOGIN > MODULE CT > company = My Customer's company name > zipcode = 123456 > [other fields

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-01 Thread Chris Travers
The main thing missing is the ability to loop through things. login = username password = mypassword LOGIN MODULE CT company = My Customer's company name zipcode = 123456 [other fields as appropriate] CALL CT->save(user, form) if !id On 12/1/06, Charley Tiggs <[EMAIL PROTECTED]> wrote: > Chris,

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-01 Thread Charley Tiggs
Chris, I played with ledgersmb_cli.pl a couple of weeks ago and had trouble figuring out exactly how to work it and the example wasn't clear to me and since I knew you were actively working to make it a bit smarter, I left it alone at that time. Can you give me another example of how the ledge

Re: [Ledger-smb-devel] Question about cli interface and invoices

2006-12-01 Thread Chris Travers
I would think so. The caveat is that the sales order is closed *before* the invoice is posted, so you really want to be able to ensure that this happens atomically. Unfortunately, I don't think the SL interface was really set up with that in mind so you could get sent HTML to the CLI that you the

[Ledger-smb-devel] Question about cli interface and invoices

2006-12-01 Thread Charley Tiggs
Hello, I'm creating sales orders via the command-line interface. If I later create an invoice off of the CLI for that sales order, will the CLI close the sales order? Charley - Take Surveys. Earn Cash. Influence the Futur