Re: [Ledger-smb-users] New User Anomalies

2013-07-14 Thread Bill Ott
Erik, I agree with your root cause. Your solution may be the right one, given the circumstances, although without looking at the actual join, i would have thought that the inner join with the additional "account type" restriction would have worked. I can tell you I was bothered by the fact tha

Re: [Ledger-smb-users] New User Anomalies

2013-07-14 Thread Erik Huelsmann
Hi Bill, On Sun, Jul 14, 2013 at 11:09 PM, Bill Ott wrote: > Erik, I looked the the "chart" view. It only lists the account and the > account_headings and all of the id's. No linking was apparent. There is no > monetary data shown in the view, as there is when looking at reports->COA > from the

Re: [Ledger-smb-users] New User Anomalies

2013-07-14 Thread Bill Ott
Erik, I looked the the "chart" view. It only lists the account and the account_headings and all of the id's. No linking was apparent. There is no monetary data shown in the view, as there is when looking at reports->COA from the web interface. If the intent of the report is to show monetary i

Re: [Ledger-smb-users] New User Anomalies

2013-07-14 Thread Erik Huelsmann
On Sun, Jul 14, 2013 at 10:29 PM, Bill Ott wrote: > > For example 1000 Current Assets lists only the checking account debit. > The AR debit > > appears in the Capital Assets debit heading. 1820 Office equipment > > appears under 3300 Share Capital. and so on. > > I have been digging around and

Re: [Ledger-smb-users] New User Anomalies

2013-07-14 Thread Bill Ott
> For example 1000 Current Assets lists only the checking account debit. The AR debit > appears in the Capital Assets debit heading. 1820 Office equipment > appears under 3300 Share Capital. and so on. I have been digging around and here is what I've found. in every case, where an amount is

Re: [Ledger-smb-users] New User Anomalies

2013-07-13 Thread Erik Huelsmann
> Hi, I am a new user to LedgerSMB, although in a previous life, I > contributed to SQLedger. Welcome! Are you running 1.2 or 1.3? If the latter, which version? > I have set up an accounting system for a > small rental property (less than 20 tenants) called SSN and have > obviously messed up so

[Ledger-smb-users] New User Anomalies

2013-06-05 Thread Bill Ott
Hi, I am a new user to LedgerSMB, although in a previous life, I contributed to SQLedger. I have set up an accounting system for a small rental property (less than 20 tenants) called SSN and have obviously messed up some part of LedgerSMB. Here are my questions and issues. Any guidance is a