Menu
▾
▴
sql-ledger-users
|
From: Lenny L. <lle...@ma...> - 2007-01-16 15:07:06
|
I am looking for something similar but I also need the list of outstanding invoices (at that time) along with the actual figure. I guess this is seen as proof to back up the number. Anyone come across this yet?=20 -- Lenny Leblanc=20 628 Leila Avenue Winnipeg, Manitoba R2V 3N7 P: 204.338.0233 =20 -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Ashley J Gittins Sent: Tuesday, January 16, 2007 6:28 AM To: sql...@li... Subject: Re: [SL] Outstanding payments on a certain date in the past On Tuesday 16 January 2007 19:48, Dr Eberhard W Lisse wrote: > Hi, > > My auditors need the amounts from invoices that were created before (for > example) 2006-07-01 and paid after 2006-06-30. In other words, they need > the total amount outstanding on 2006-06-30. > > I can probably hack up a SQL statement to access the database directly, > but I wonder if SQL-Ledger can be coaxed into doing this from the front > end? Try the balance sheet report - you can do it as at a certain date, cash or=20 accruals basis. The figure I expect will be the one you want is "Accounts Receivable" (or your=20 local equivalent) in the "Assets" group - IANAA but I think that figure=20 should represent all unpaid receivable amounts at that point in time. You=20 should check with your auditor or accountant if it's actually what you need=20 though. --=20 Regards, Ashley J Gittins web: http://www.purple.dropbear.id.au jabber: agi...@pu... ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Lenny L. <lle...@ma...> - 2007-01-16 15:27:01
|
I guess this is what I will have to start doing as well. Thanks for the tip! -- Lenny Leblanc 628 Leila Avenue Winnipeg, Manitoba R2V 3N7 P: 204.338.0233 =20 -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of David Boyle Sent: Tuesday, January 16, 2007 9:25 AM To: sql...@li... Subject: Re: [SL] Outstanding payments on a certain date in the past On Tue, 2007-01-16 at 09:06 -0600, Lenny Leblanc wrote: > I am looking for something similar but I also need the list of > outstanding invoices (at that time) along with the actual figure. I > guess this is seen as proof to back up the number. >=20 This will not help you after the fact, but each month as part of my month end procedures I generate these reports and save as html. I haven't seen any method of bringing this information back (in itemized format) unless you had a backup from that time. David Boyle NAPCO > Anyone come across this yet?=20 >=20 > -- > Lenny Leblanc=20 > 628 Leila Avenue > Winnipeg, Manitoba R2V 3N7 > P: 204.338.0233 > =20 >=20 > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On Behalf Of > Ashley J Gittins > Sent: Tuesday, January 16, 2007 6:28 AM > To: sql...@li... > Subject: Re: [SL] Outstanding payments on a certain date in the past >=20 > On Tuesday 16 January 2007 19:48, Dr Eberhard W Lisse wrote: > > Hi, > > > > My auditors need the amounts from invoices that were created before > (for > > example) 2006-07-01 and paid after 2006-06-30. In other words, they > need > > the total amount outstanding on 2006-06-30. > > > > I can probably hack up a SQL statement to access the database > directly, > > but I wonder if SQL-Ledger can be coaxed into doing this from the > front > > end? >=20 > Try the balance sheet report - you can do it as at a certain date, cash > or=20 > accruals basis. >=20 > The figure I expect will be the one you want is "Accounts Receivable" > (or your=20 > local equivalent) in the "Assets" group - IANAA but I think that figure=20 > should represent all unpaid receivable amounts at that point in time. > You=20 > should check with your auditor or accountant if it's actually what you > need=20 > though. >=20 ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: Lenny L. <lle...@ma...> - 2007-01-16 17:25:21
|
Thanks for the tips David. It makes good sense to have these on hand for each month end and save some hassles in case something comes up. Thanks Dieter for mentioning the AR Outstanding report. This is what I was looking for. -- Lenny Leblanc=20 628 Leila Avenue Winnipeg, Manitoba R2V 3N7 P: 204.338.0233 =20 -----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of David Boyle Sent: Tuesday, January 16, 2007 9:29 AM To: sql...@li... Subject: Re: [SL] Outstanding payments on a certain date in the past On Tue, 2007-01-16 at 08:13 -0700, Dieter Simader wrote: > this is what the AR Outstanding report is for. >=20 My mistake...I hadn't tried that before. That report does indeed show items that were open as at the end date specified. As an aside, your jurisdictions will possibly differ, but I have gotten in the habit of generating needed reports at month end. These reports include A/R Aging, Inventory (extended) A/P Open, Open Receiving (received but no vendor invoice yet), my tax reports and a few others. Again, that's just me. David Boyle NAPCO ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D= DEVDE V _______________________________________________ sql-ledger-users mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sql-ledger-users |
|
From: David B. <dav...@sb...> - 2007-01-16 15:24:46
|
On Tue, 2007-01-16 at 09:06 -0600, Lenny Leblanc wrote: > I am looking for something similar but I also need the list of > outstanding invoices (at that time) along with the actual figure. I > guess this is seen as proof to back up the number. > This will not help you after the fact, but each month as part of my month end procedures I generate these reports and save as html. I haven't seen any method of bringing this information back (in itemized format) unless you had a backup from that time. David Boyle NAPCO > Anyone come across this yet? > > -- > Lenny Leblanc > 628 Leila Avenue > Winnipeg, Manitoba R2V 3N7 > P: 204.338.0233 > > > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On Behalf Of > Ashley J Gittins > Sent: Tuesday, January 16, 2007 6:28 AM > To: sql...@li... > Subject: Re: [SL] Outstanding payments on a certain date in the past > > On Tuesday 16 January 2007 19:48, Dr Eberhard W Lisse wrote: > > Hi, > > > > My auditors need the amounts from invoices that were created before > (for > > example) 2006-07-01 and paid after 2006-06-30. In other words, they > need > > the total amount outstanding on 2006-06-30. > > > > I can probably hack up a SQL statement to access the database > directly, > > but I wonder if SQL-Ledger can be coaxed into doing this from the > front > > end? > > Try the balance sheet report - you can do it as at a certain date, cash > or > accruals basis. > > The figure I expect will be the one you want is "Accounts Receivable" > (or your > local equivalent) in the "Assets" group - IANAA but I think that figure > should represent all unpaid receivable amounts at that point in time. > You > should check with your auditor or accountant if it's actually what you > need > though. > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X