Re: [Ledger-smb-devel] Beyond 1.5

in other tables? I think of the accounting system as an append-only log, there should never be any actual deletion, just correcting transactions added to the journal. So I'm failing to see why this is useful to us at all. Otherwise, I think we're all in violent agreement here... Cheers, John

Re: [Ledger-smb-devel] Proposal for 1.6 and above: small new-code-only developer release

al by itself. I see it simply as a means to move the LedgerSMB code base to a point where we can have a much better agility in bug-fixing, where we can be much more extensible and open to integration with surrounding systems. Agreed... Happy to add more later, but gotta run, camping weekend a

Re: [Ledger-smb-devel] Changes to the ledgersmb.org website

(resend from my subscribed email address...) Hi, I've made the following changes: * Allowed much bigger user pictures to upload, but set a server-side preset (the unused Square Thumbnail) to resize user pictures to 44x44, which is what 4em generated in Chrome) * Turned on "Panelizer" and

Re: [Ledger-smb-devel] LedgerSMB 1.4.27 released

Docker image for 1.4.27 is available, as ledgersmb/ledgersmb:latest, 1.4, and 1.4.27. On 04/10/2016 05:00 AM, Erik Huelsmann wrote: > The LedgerSMB development team is happy to announce yet another new > version of its open source ERP and accounting application. This release > contains the

Re: [Ledger-smb-devel] Deciding on a default company setup for BDD tests

er for the business logic testing -- integration testing... For those kinds of tests, having a clean/well-known starting point for the database seems necessary. Cheers, John Locke http://www.freelock.com -- Site24x7 A

Re: [Ledger-smb-devel] Deciding on a default company setup for BDD tests

shots. This will allow comparing version-on-version, as well as give you a place to go back to see "what did this look like in version x?" S3 storage seems to be built in to many test runners like Travis, I'm guessing that's the fastest/easiest to get up and running. The Matrix projec

Re: [Ledger-smb-devel] 1.5.0-beta4 over due / consequences for RC1?

n alpha and a beta release -- it's a ways from being a release candidate, as you can't actually get work done. It is coming along nicely, though, and may come together quickly. Bu

Re: [Ledger-smb-devel] Cleaning up the repository. How does the community feel about it?

Hi, On 01/01/2016 09:57 AM, Erik Huelsmann wrote: On Fri, Jan 1, 2016 at 6:45 PM, Robert James Clay > wrote: On Thursday, December 31, 2015 09:50:59 AM David G wrote: > > It is worth pointing out that it is undesirable to use an OS

Re: [Ledger-smb-devel] New branch: master-mc [a forward-port of 1.4-mc]

in the same org turns out to be impossible.] > I don't see why not... that's what branches are for! Is it drastic enough of a change to not work towards merging into 1.4/1.5 branches sooner than 1.6? Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Initial steps for 1.6, and some longer-term questions

is could be pretty minimal (as it currently is). Was going to write more about why we should focus on the API, but... I'm seeing the API as functional scaffolding to help with the financial rewrite, as well as being an end in itself... Agreed entirely. Enough said!

Re: [Ledger-smb-devel] Initial steps for 1.6, and some longer-term questions

affolding to help with the financial rewrite, as well as being an end in itself... Cheers, John Locke http://www.freelock.com -- ___ Ledger-smb-devel mailing list Ledger-s

Re: [Ledger-smb-devel] Enforce single line-ending style across source files?

+1. There's a .gitattributes setting we can do that will clean these up on commit -- probably something to do when there are no other changes being committed. Ah, here's a simple recipe for doing this: https://help.github.com/articles/dealing-with-line-endings/ Cheers, John On 09/18/2015

Re: [Ledger-smb-devel] [DESIGN] Proposed structure fol LedgerSMB web services

a custom header or a parameter (or both)? This would be one area that needs to be self-documenting, what resources can be excluded/included/expanded in which requests, and what is included by default. Cheers, John Locke http://freelock.com

Re: [Ledger-smb-devel] Request handling using routes, containers, (internal) services

On 06/22/2015 02:53 PM, Erik Huelsmann wrote: Hi Chris, John, In the other thread, John mentioned the structure that web apps are growing to in general to have these components to facilitate growth beyond a certain size: So... the patterns we're discussing I'm seeing put in widespread

Re: [Ledger-smb-devel] Proposal to use SASS for writing our CSS

On 06/22/2015 02:10 PM, Erik Huelsmann wrote: It sounds like you were using Compass for more than just it's 'watch' command for real-time compilation? I'm aware that compass has much more to offer than just real-time compilation. I value your feedback - which I interpret as go there when

Re: [Ledger-smb-devel] Proposal to use SASS for writing our CSS

, and far too much upkeep... Cheers, John Locke http://www.freelock.com -- Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices

Re: [Ledger-smb-devel] Proposal to differentiate between program and processing(precondition) errors

One more time! On 06/21/2015 01:41 PM, Erik Huelsmann wrote: Currently, all errors generated by LedgerSMB are being raised through 'die'. It's an effective way, but my feeling is that it bleeds through too many details of the internals. This is especially true when the error is really

Re: [Ledger-smb-devel] Writing code for master: paradigms that work

Hi, Erik, Great stuff, love to hear you're tackling these issues head-on. I'm totally in favor of everything I've read from your 3 mails of today... and will add comments from my perspective... On 06/21/2015 01:04 PM, Erik Huelsmann wrote: What I learned while coding on current master, i.e.

Re: [Ledger-smb-devel] Trouble on Perl 5.18.4 on Fedora, running Plack

of those check template bugs that still load from the demo templates). We could bundle the other dependencies in there as well, the Tex, headless LibreOffice, etc. Cheers, John Locke http://www.freelock.com On 04/18/2015 12:23 AM, Erik Huelsmann wrote: Hi Chris, everybody, While of course

Re: [Ledger-smb-devel] invoice time: templates and 1.4

some URL hacking to actually edit these in the database -- this is largely a missing menu entry... Cheers, John Locke http://www.freelock.com On 03/02/2015 11:01 AM, Nick Prater wrote: It's invoice time of month... oops 1.4 doesn't seem to have my templates in the right place... I tried taking

Re: [Ledger-smb-devel] Getting rid of frames in 1.5?

Hi, +1 for me too, I don't think it will be that difficult to do, either... Cheers, John On 10/17/2014 07:10 AM, Pongrácz István wrote: Seems easy, especially for me :) Fix me, but I assume this step should necessary to separate the UI with the core and able to use other frameworks, too,

Re: [Ledger-smb-devel] Proposal for infrastructure (feedback requested)

+1 I'm using Jenkins hooked up to our internal gitolite server for dev work for similar purposes, and it has greatly improved our release process -- we're now enforcing a bunch of policies when rolling release branches and have already caught a bunch of breakages before they reached

Re: [Ledger-smb-devel] Next step for invoice upload (2)

that as a draft... Cheers, John Locke http://www.freelock.com On 03/15/2014 03:54 PM, Pongrácz István wrote: Hi, This is a great step forward, really :) I read the workflow, for me it seems fine. I just wondering, how many invoices/orders (drafts) could we manage in this mass checkbox? I

Re: [Ledger-smb-devel] What's ahead for PGObject

to represent an entire invoice with line items and possibly payments as a single JSON object, post that to the web service, which in turn simply uses this interface... Cheers, John Locke http://www.freelock.com -- Flow

Re: [Ledger-smb-devel] Towards a rental tracking module

of value making it available to customers (or at least a broader range of staff/partners), so we would build those in a customer-facing system, not LSMB. Cheers, John Locke http://www.freelock.com On 02/25/2014 03:13 AM, Pongrácz István wrote: Hi, This seems a good one :) As I can see

Re: [Ledger-smb-devel] Towards a rental tracking module

Hi, Chris, On 02/25/2014 05:47 PM, Chris Travers wrote: On Tue, Feb 25, 2014 at 8:32 AM, John Locke m...@freelock.com mailto:m...@freelock.com wrote: Hi, While I haven't actually built something like this, we have done some preliminary planning and use case analysis

Re: [Ledger-smb-devel] proposal: xsrf protection for restful web services

already needs to supply authentication. Cheers, John Locke http://www.freelock.com Cheers, John Locke -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common

Re: [Ledger-smb-devel] 1.3: Taxes, sub cent invoice amounts and non sub-cent payments

specified otherwise, will be rounded to the default currency precision. The difference would need to be recorded against a rounding balance account (equity?). This should be sufficient to cover every case out there. Agreed, this seems like a fine approach. Cheers, John Locke http

Re: [Ledger-smb-devel] 1.3: Taxes, sub cent invoice amounts and non sub-cent payments

invoices. I don't want phantom fractional transactions appearing -- they should reflect exactly the transaction that took place, and any other behavior is wrong, IMO. -- John Locke Principal, Freelock Web Sites That Make Your Organization Run Better http://www.freelock.com On 02/20/2014 12:01

Re: [Ledger-smb-devel] 1.3.38-rc1 on Monday?

times as much as all the rest of them... Cheers, John Locke http://www.freelock.com On 02/15/2014 05:44 AM, Erik Huelsmann wrote: Hi Chris, No testing from my side yet, but looking at the list, I'd say this makes a nice release. Erik sent from my phone On Feb 15, 2014 2:17 PM, Chris

Re: [Ledger-smb-devel] 1.3.38-rc1 on Monday?

for open and closed, the report both you and I use) - Customer outstanding totals (outstanding summary, hopefully fixed to only include open transactions) - Items (Transaction detail report) Not sure the second one is necessary, with the aging report also available... Cheers, John Locke http

Re: [Ledger-smb-devel] What to do about accidental inclusion of Carp::Always

the code a bit more reliable in the sense that if something gets missed users don't get internal server errors. This sounds like reason enough to require it as a dependency -- internal server errors without explanation sound like a terrible user experience... Cheers, John Locke http

Re: [Ledger-smb-devel] 1.3.37: creating a 4-item invoice

Hi, Erik, I just tried this on my production install, updated to 1.3 HEAD this morning, and do not see this behavior -- all working fine here as far as I can tell. I did not post the invoice. Cheers John Locke http://www.freelock.com On 01/26/2014 03:53 PM, Erik Huelsmann wrote: Hi Chris

Re: [Ledger-smb-devel] Plans for financial rewrite in 1.5

to store and report on accounts stored in BTC would be an easy way to become an early accounting system with support for it... then we could add a digital wallet support later as an add-on or something... See some of my thoughts here: http://www.freelock.com/blog/john-locke/2014-01/bitcoin-future-e

Re: [Ledger-smb-devel] My post-1.4 priorities

in the database, as well as a REST API. Just a thought... Cheers, John Locke http://www.freelock.com On 01/22/2014 12:55 AM, Chris Travers wrote: On Wed, Jan 22, 2014 at 12:34 AM, Erik Huelsmann ehu...@gmail.com mailto:ehu...@gmail.com wrote: On Wed, Jan 22, 2014 at 9:14 AM, Chris Travers

Re: [Ledger-smb-devel] Looking at putting together an add-on for Washington State's sales tax

for different kinds of products -- but if there are it might be necessary to have multiple tax lines. One consideration is whether shipping/handling is taxable or not... Cheers, John Locke On 01/09/2014 02:55 AM, Chris Travers wrote: Hi everyone; I know we still have some users in Washington State. I

[Ledger-smb-devel] PNL report grouped by week/month/quarter/year

'; } $out .= '/tr'; $out .= '/tbody'; $out .= '/table'; return $out; } Cheers, John Locke http://www.freelock.com -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses

Re: [Ledger-smb-devel] Correct method to upgrade the database

If this is a field we need to add to core, I would add the field in sql/Pg-database.sql, and an ALTER in sql/modules/Fixes.sql . Cheers, John Locke http://www.freelock.com On 08/28/2013 08:15 AM, Pongrácz István wrote: Hi, I started to modify the database and the code to meet Hungarian

Re: [Ledger-smb-devel] Date input field enhancement by tavugyvitel.hu - worth to use it

Hi, On 08/10/2013 10:58 PM, Chris Travers wrote: On Sat, Aug 10, 2013 at 2:54 PM, John Locke m...@freelock.com mailto:m...@freelock.com wrote: Hi, In 1.4 trunk, there is a Dojo date widget currently hooked up to the Journal Entry screen. I've been planning to move

Re: [Ledger-smb-devel] Date input field enhancement by tavugyvitel.hu - worth to use it

available, we could even support custom formats as described here: http://dojotoolkit.org/reference-guide/1.9/dojo/date/locale/parse.html#dojo-date-locale-parse Cheers, John Locke http://www.freelock.com On 08/09/2013 05:36 AM, Erik Huelsmann wrote: Much of the new code has date fields being

Re: [Ledger-smb-devel] JS frameworks the future of the LSMB UI

think I should let you guys have it and draw up your plans! From there lets try to figure out how the plan fits best with the existing plans to rewrite the back-end. Great! Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Dojo tabs demo / using dojo in LSMB

charting library that can leverage the same data models we use for raw data display Cheers, John Locke http://www.freelock.com On 07/30/2013 08:47 AM, Mikkel Høgh wrote: Hi there, I've not been very involved with LedgerSMB development so far, since I'm not really a Perl guy, but I have

Re: [Ledger-smb-devel] JS frameworks the future of the LSMB UI

, and then perhaps look at new UI paradigms for the release after that. Cheers, John Locke http://www.freelock.com -- Get your SQL database under version control now! Version control is standard for application code, but databases

Re: [Ledger-smb-devel] Dojo tabs demo / using dojo in LSMB

. The tabs are on individual accounts, and the account selector is hooked up to journal entries (along with a date text box). I'd be happy to commit these changes if welcomed... Cheers, John Locke http://www.freelock.com On 07/27/2013 11:57 PM, Erik Huelsmann wrote: Hi John, Just a moment

Re: [Ledger-smb-devel] Dojo tabs demo / using dojo in LSMB

data structures. See https://www.freelock.com/blog/john-locke/2013-06/how-structure-dojo-based-dashboard-drupal for a more Drupal-centric description of what we're doing with charts -- it would be fantastic to get some of that going in LSMB too. Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Dojo tabs demo / using dojo in LSMB

without searching, because then the browser will cache that (and it's not going to be that big a data set). If someone can assist on the Perl side with getting those web services up and running, I can wire together the data handling on the dojo/browser side pretty quickly. Cheers, John Locke

Re: [Ledger-smb-devel] Proposal for 1.4: Removing taxable sales/non-taxable sales reports, consolidate under AR/AP Search

products on each invoice, rather than the invoice total that contains taxable products. As long as there's a straightforward way to get that taxable total amount reported by any time period, I'm good... Cheers, -- John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Proposal for 1.4: Removing taxable sales/non-taxable sales reports, consolidate under AR/AP Search

, happy to use another approach. Cheers, John Locke http://www.freelock.com -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your

Re: [Ledger-smb-devel] Status of 1.4 and call for involvement

Hi, Chris, Is there a migration path for 1.3 - 1.4 available yet? Would like to run the two versions side-by-side for a bit with real numbers... I'll definitely be happy to test, and I have a need for some cash-based income reports come January (and I know we'll have to do some adjustments

Re: [Ledger-smb-devel] Move to git?

Hi, I use git pretty much exclusively, and maintain a git mirror of LSMB here: * Browse at: http://git.freelock.com/?p=ledgersmb.git;a=summary * Clone from: git://git.freelock.com/git/ledgersmb.git This repo automatically updates from the SVN master every 6 hours, so it should be quite up to

Re: [Ledger-smb-devel] initial draft of PHP mapper class

I'd be interested in the PHP classes... Regarding separate SF projects, that sounds worse -- what about moving to Github or something more flexible/easier to use? Cheers, John Locke http://freelock.com On 07/28/2012 05:52 AM, Chris Travers wrote: On Sat, Jul 28, 2012 at 1:32 AM, herman

Re: [Ledger-smb-devel] Where to put the PHP interop classes

[Replying to more appropriate thread...] What about Github? Not just for the PHP classes -- the whole project? SF is annoying, by comparison... Cheers, John Locke http://www.freelock.com On 07/29/2012 01:57 AM, Chris Travers wrote: Hi all; I am trying to decide where to put the PHP interop

Re: [Ledger-smb-devel] Where we are at on the 1.4 changelog

totally slammed right now, don't see a spare moment before August the way things are looking... and I don't have a server set up with Postgres 8.4+ yet... Cheers, John Locke http://www.freelock.com On 07/15/2012 06:37 PM, Chris Travers wrote: I figured it would be worthwhile to send out

Re: [Ledger-smb-devel] Next development 1.4 release coming soon

Wow. Great stuff! Did the web services stuff make it in yet, or will that be coming after 1.4 solidifies? Cheers, John Locke http://www.freelock.com On 06/03/2012 07:38 PM, Chris Travers wrote: Hi all; Here's what's left to do on my side. 1) I want to move the customer/vendor history

Re: [Ledger-smb-devel] Web services revisited

total items exist: Content-Range: items 0-24/66 That's from here: http://dojotoolkit.org/reference-guide/1.7/dojo/store/JsonRest.html ... also some guidance on sorting on that page. Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Web services revisited

these exceptions very clearly, or remove them from the web service -- perhaps default to returning all invoices, and force a web service to specify open if that's all they want? Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Address formatting functionality

mailto:chris.trav...@gmail.com wrote: On Sun, May 6, 2012 at 8:30 PM, John Locke m...@freelock.com mailto:m...@freelock.com wrote: Drupal 7 has been addressing :-P these issues with an addressfield module ( http://drupal.org/project/addressfield ), which aims

Re: [Ledger-smb-devel] Address formatting functionality

module for extending the validation, with a complete city/canton/postal code validation routine for Switzerland... Cheers, John Locke http://www.freelock.com -- Live Security Virtual Conference Exclusive live event will cover

Re: [Ledger-smb-devel] Address formatting functionality

Drupal 7 has been addressing :-P these issues with an addressfield module ( http://drupal.org/project/addressfield ), which aims to incorporate the flexibility of xNAL - http://xml.coverpages.org/xnal.html . The challenge for xNAL is to provide the ability to handle the following: - About 36+

Re: [Ledger-smb-devel] Tentative Schedule for 1.4

structures there as both the documented API and the basis for XML and JSON formats. Excellent. Is this going to be available in 1.4? Cheers, John Locke http://www.freelock.com -- Virtualization Cloud Management Using

Re: [Ledger-smb-devel] Tentative Schedule for 1.4

people think? I think it sounds great! Thanks for all your hard work on this. Cheers, John Locke http://www.freelock.com -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use

Re: [Ledger-smb-devel] 1.3: 1099 reports?

Attached... I can find the item in the menu, and I can create a report -- which is just a label and a country and a checkbox for making it default. But no data shows up, and I don't understand what the checkbox is for or how to get data into this report. Also, on the menu_friendly view, when I

Re: [Ledger-smb-devel] 1.3: Check printing?

Hi, Erik, I use Cash - Vouchers - Payments, create a batch, and then print checks from the outstanding AP transactions. Cheers, John On 12/29/2011 03:32 PM, Erik Huelsmann wrote: Hi, This evening, I spent about a few hours looking for how to print checks in 1.3... I found how to print

Re: [Ledger-smb-devel] 1.3: 1099 reports?

My turn: I keep seeing svn updates for 1099 reports, but cannot find those anywhere in the system. How do I generate 1099 reports? On 12/29/2011 09:14 PM, John Locke wrote: Hi, Erik, I use Cash - Vouchers - Payments, create a batch, and then print checks from the outstanding AP transactions

Re: [Ledger-smb-devel] 1.3: 1099 reports?

PM, Chris Travers wrote: On Thu, Dec 29, 2011 at 9:18 PM, John Locke m...@freelock.com wrote: My turn: I keep seeing svn updates for 1099 reports, but cannot find those anywhere in the system. How do I generate 1099 reports? Tax Forms/Reports Best Wishes, Chris Travers

Re: [Ledger-smb-devel] The Great Licensing Discussion

Personally I prefer GPLv2 over GPLv3. I'm somewhat agnostic about GPL vs BSD -- I do like GPL v2 a lot, and like its mechanism for protecting end customers -- but I also work on some BSD-licensed projects and have no qualms about a license switch. I would agree with your assessment, Chris, about

Re: [Ledger-smb-devel] Web Services API: URL naming proposal

a PKI... Cheers, John Locke http://www.freelock.com -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity

Re: [Ledger-smb-devel] Web Services API: URL naming proposal

, it's possible to have that be the degraded version while allowing multiple, competing, richer web applications to coexist. Cheers, John On 11/21/2011 08:42 AM, John Locke wrote: Hi, On 11/21/2011 03:03 AM, Chris Travers wrote: First some general notes. One of the real headaches in web app

Re: [Ledger-smb-devel] Web Services API: URL naming proposal

Hi, On 11/20/2011 04:24 PM, Chris Travers wrote: I think John's points here raise some important questions I'd like to raise here for further discussion: On Sun, Nov 20, 2011 at 9:30 AM, John Locke m...@freelock.com wrote: On authentication, yes we can use http auth headers, but do we want

[Ledger-smb-devel] Proposal: Web Services API

that Chris has created, do the appropriate changes, and save. The old code is obviously much harder. Perhaps we can start with the new entities, customers and vendors that have already been done, and add more of the accounting objects as they get rewritten? Cheers, John Locke http://www.freelock.com

Re: [Ledger-smb-devel] Proposed framework changes for 1.4

Hi, Sounds like a good direction to me. Couple thoughts -- not being that active in Perl, don't know if these are realistic or not, but just what comes to mind, feel free to disregard. - Are there really no other date or number libraries available that do what we need, to the point we need to

Re: [Ledger-smb-devel] Budget add-on

Excellent. Where would I find it? I would think the Reports section might be appropriate... that's where I go for Income/Expense and Balance Sheet, seems like a similar strategic/business function... Cheers, John On 10/17/2011 03:42 AM, Chris Travers wrote: Hi; For those who are wondering,

Re: [Ledger-smb-devel] Proposed financial schema for financial info

I think the PO should be on the invoice header. In our scenario, we get a PO for a project, drop it into the Sales order, and have multiple invoices on that PO. Having the PO in a specified field makes it easier for our customers to find on the invoice when they go to pay it, and also for us to

Re: [Ledger-smb-devel] Proposal for database refactoring in 1.4

Hi, Initial thoughts: Sounds like a huge improvement, and it mostly makes sense to me. The one area I'm not clear on is inventory management, and whether oe and order_items should get rolled into the same tables as ar/ap/invoice. I may be totally off-base here, but I'm thinking that invoices

Re: [Ledger-smb-devel] Proposal for database refactoring in 1.4

. Invoices may not need this, if they're not supposed to get modified after creation. On 10/03/2011 11:22 AM, John Locke wrote: Hi, Initial thoughts: Sounds like a huge improvement, and it mostly makes sense to me. The one area I'm not clear on is inventory management, and whether oe

Re: [Ledger-smb-devel] Database updates

/version generate a file identical to #3 at that commitlevel, as we're currently doing. Does that all make sense, or am I missing something/overthinking this? Cheers, -- John Locke http://www.freelock.com -- AppSumo

Re: [Ledger-smb-devel] Database updates

. And as long as that's consistent, then I think diff is fine for now for seeing what's changed... can just run the dump script, direct the output to a tmp file, and compare against the one in the code tree. Cheers, John Locke http://www.freelock.com

[Ledger-smb-devel] Database updates

-database.sql into separate files -- but once that's done, it should be trivial to see how close the structure of your database is to the current release, and what needs to be altered to get it there. Which would be the first step to auto-generating update scripts. Thoughts? Cheers, John Locke http

Re: [Ledger-smb-devel] Employee search question for 1.3

On 06/21/2011 04:02 PM, Chris Travers wrote: Hi John; In terms of the duplication issue can you: SELECT p.id as person_id, e.id as entity_id FROM person p JOIN entity e ON (e.id = p.entity_id) order by p.id; db= SELECT p.id as person_id, e.id as entity_id db- FROM person p db-

Re: [Ledger-smb-devel] Tax account creation: how to 'detect' tax accounts?

be possible to leave percentage blank and provide an amount instead. Then in the tax report for that account, provide a spreadsheet download with the collected details. Cheers, John Locke http://freelock.com -- Simplify

Re: [Ledger-smb-devel] Tax account creation: how to 'detect' tax accounts?

an invoice today with a custom tax line? Cheers, John Locke http://freelock.com -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image

Re: [Ledger-smb-devel] Employee search question for 1.3

Ok, I was looking at svn #3301. Completely different now. Out of the available fields, I think I'd show employee number, first name, last name, role. My account is showing up 4 times in this list!?!? ... and an account I created a couple weeks ago has no employee id. Cheers, -- John Locke

Re: [Ledger-smb-devel] [Ledger-smb-commits] SF.net SVN: ledger-smb:[3290] trunk

defaults. For permissions-related updates, including any dropped/recreated items, #2 should regenerate the roles sql file and #3 should execute it. Cheers, -- John Locke http://freelock.com -- EditLive Enterprise

Re: [Ledger-smb-devel] Employee search question for 1.3

the upgrade/3297-employee_changes.sql and upgrade/3299-person_functions.sql scripts, but the result of a search is a table with Number, Startdate and Role showing up but all the rest of the columns blank. And Number is blank on the most recent employee I added... Cheers, John Locke http

Re: [Ledger-smb-devel] Tax account creation: how to 'detect' tax accounts?

Hi, To summarize what the system currently has available (and how I think it's supposed to work) the tax stuff is controlled at several levels: 1. COA account -- whether an account contains tax transactions (and which screens to make it available on) 2. Customer/Vendor account -- whether a

Re: [Ledger-smb-devel] Updating 1.3 RFC and small bugs

On 06/18/2011 04:23 PM, Chris Travers wrote: On Sat, Jun 18, 2011 at 12:55 PM, Erik Huelsmann ehu...@gmail.com wrote: Hi John, On Sat, Jun 18, 2011 at 8:10 PM, John Locke m...@freelock.com wrote: Hi, After a couple weeks away from bookkeeping, doing some catchup now. Just pulled down

[Ledger-smb-devel] Bug/Patch: email form not populated with emails from account

work correctly on my system.). This patch is against svn #3281, let me know if I need to re-roll against an updated trunk. Cheers, John Locke http://freelock.com diff --git LedgerSMB/Form.pm LedgerSMB/Form.pm index 21a6cac..fec0301 100644 --- LedgerSMB/Form.pm +++ LedgerSMB/Form.pm @@ -2432,6

[Ledger-smb-devel] Updating 1.3 RFC and small bugs

Hi, After a couple weeks away from bookkeeping, doing some catchup now. Just pulled down the latest trunk, and merged them in. I see the new sql/upgrade directory, which strikes me as a great direction to go. I like the naming of sql update scripts with svn id, and I'd like to take it one step

[Ledger-smb-devel] More 1.3 papercuts - Sales Tax edition

1. Save Info on AR invoice does not appear to do anything. I expect it to at least save updates to Internal Notes and also Notes. It does not save these things on existing invoices. 2. Tax Forms -- I'm seeing add tax form menu item, but no list tax form, and don't see how the whole tax system is

[Ledger-smb-devel] Bug/Patch: Allow fractional qty

We use fractional quantities all the time in invoices. In 1.3, the column is set to type Integer, which truncates all of the fractions. Patch for invoices attached -- might also need to be fixed in orders... Cheers, John Locke http://freelock.com diff --git sql/Pg-database.sql sql/Pg

[Ledger-smb-devel] Bug/Patch - Receipt voucher source start id irrelevant

December - January -- might be some missing parts to the patch. If it doesn't fully work, ping me to see what else I might've changed... (stored functions, most likely..) Cheers, John Locke http://www.freelock.com diff --git LedgerSMB/DBObject/Payment.pm LedgerSMB/DBObject/Payment.pm index dba0e9c

Re: [Ledger-smb-devel] Fwd: [PATCH] Save account headers to 'account_header' table (instead of 'account' table)

Attaching patch for account_get stored function -- the commit in #3187 doesn't load into my version of postgres. Cheers, John On 05/29/2011 09:53 AM, Erik Huelsmann wrote: Hi John, If you have a moment to check, I'm no longer able to reproduce your problems. Since Chris committed fixes in

[Ledger-smb-devel] Issue 3309519: Email fields not populated when sending AR invoice

included in this patch. We've been using this for months. Cheers, John Locke http://freelock.com diff --git UI/io-email.html UI/io-email.html index decb298..3435891 100644 --- UI/io-email.html +++ UI/io-email.html @@ -21,12 +21,8 @@ tr th align=right?lsmb text('Subject') ?/th

[Ledger-smb-devel] Issue 3309520: Email AR Aging statement patch

several months ago when I spoke to him about this, that there wasn't an equivalent in LSMB 1.3 to use, so for this and the previous patch, I just stripped the check for this access from the template, so it always shows bcc. Cheers, John Locke http://freelock.com diff --git LedgerSMB/RP.pm LedgerSMB

Re: [Ledger-smb-devel] Fix for customer search not working (trunk)

Hi, Did this one get committed? Didn't see the change in the last version pulled down... Huge relief to have this working, good one. One more change I'd suggest: s/like/ILIKE/ in the legal name searches, anyway... On 05/16/2011 06:06 AM, Erik Huelsmann wrote: Hi all, This afternoon I found

Re: [Ledger-smb-devel] Reconciliation in 1.3

Hi, Chris, I think the best way would be to add a payee column to cr_report_line , and modify reconciliation__pending_transactions to load it with either entity.name (with the joins on eca) or gl.description. I guess I had already modified the UI to show the payee column. I can put together a

[Ledger-smb-devel] Reconciliation in 1.3

being reconciled in the cash account, no longer shows up in pending transactions to reconcile on the credit card account. Not sure if this is an issue with imported data, or if this is a bug in 1.3. Cheers, -- John Locke Open Source Solutions for Small Business Problems published by Charles River

Re: [Ledger-smb-devel] [Ledger-smb-users] How functional is 1.3?

... try Chrome or something else if you can't view this). Most of the branches in there are old, but svn/trunk gets updated from SVN every 6 hours (or when I manually update), and freelock13 contains patches I'm making as I get things working. Cheers, John John Locke wrote: Hi, My notes

[Ledger-smb-devel] [PATCH] Misc patches for a bunch of little issues with 1.3

; + SELECT id INTO v_chart_id FROM chart WHERE accno = in_accno; INSERT INTO cr_coa_to_account (chart_id, account) VALUES (v_chart_id, in_accno||'--'||in_description); END IF; -- Already found, no need to do anything. =) -- 1.5.4.3 -- John Locke Open Source Solutions

[Ledger-smb-devel] Notes on updating to 1.3 trunk

, a few broken features (like all period boxes seem to have no effect, have to enter dates in the fields instead), reconciliation doesn't show up, etc. Will post more as we work through it... Cheers, -- John Locke Open Source Solutions for Small Business Problems published by Charles River Media, June

  1   2   >