🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #303

Re: cumulative balance field

#303
From: Isaac
Date: Sun, 18 May 2008 19:36
42 lines
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-mail
References: <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