Article View: borland.public.interbase.sql
Article #303Re: cumulative balance field
From: Isaac
Date: Sun, 18 May 2008 19:36
Date: Sun, 18 May 2008 19:36
42 lines
2739 bytes
2739 bytes
WillR wrote: > Isaac wrote: >> - Ok my business rules to this part is to give the user feature to >> change the transaction record at any time then I want to display the >> correct running balance in a form and also I can print it at any time. >> >> - What you mean by "open Item", please explain more. >> >> Thanks >> > > > Open Item: You post against an invoice -- say -- instead of an account > balance. When the set of transactions that belong to an invoice are > balanced -- you can close the transaction set for the order, invoice, > packing list etc.. > > Balance forward would work against the entire customer account -- like a > credit card. Payments are applied against the outstanding _account_ > balance -- not an invoice. > > Generally open item is the way to go. > > I have seen systems that create open item invoices -- but then post > payments balance forward. The resulting chaos was not funny. Customers > were cut off due to non-payment of invoices etc... People thought there > was a massive A/R to show the bank etc. (to support a big operating line > of credit). > > If you don't know this stuff you better get an accountant to help. > > These are not SQL questions btw. :-) > > Many manufacturing systems do not maintain integrity at the order level > either -- stuff disappears into a "cloud" at the factory, and then parts > are tagged as belonging to an order when the _apparently_ correct stuff > appears at the output. > > So maybe your question is easy -- maybe not. > > yes I am defiantly need an accountant, appreciate your help
Technical Details
Message-ID:
<4830854b$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4822380f@newsgroups.borland.com> <48235cbc@newsgroups.borland.com> <4823871c$1@newsgroups.borland.com> <4824d924@newsgroups.borland.com> <4825b126$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,7fe0f2b0b1ac1758 X-Google-Attributes: gid114a0e,domainid0,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Date: Sun, 18 May 2008 22:36:24 +0300 From: Isaac <no@no.com> User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: cumulative balance field References: <4822380f@newsgroups.borland.com> <48235cbc@newsgroups.borland.com> <4823871c$1@newsgroups.borland.com> <4824d924@newsgroups.borland.com> <4825b126$1@newsgroups.borland.com> In-Reply-To: <4825b126$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 41.234.198.204 Message-ID: <4830854b$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1211139403 41.234.198.204 (18 May 2008 12:36:43 -0700) Lines: 42 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail