Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!border4.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: bilbod Newsgroups: comp.databases.filemaker Subject: Preventing Invoice Overpayment Date: Wed, 28 Mar 2012 09:41:18 -0700 (PDT) Organization: http://groups.google.com Lines: 11 Message-ID: <25610792.632.1332952878421.JavaMail.geo-discussion-forums@pbcjk1> NNTP-Posting-Host: 216.211.179.45 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1332952879 4945 127.0.0.1 (28 Mar 2012 16:41:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 28 Mar 2012 16:41:19 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=216.211.179.45; posting-account=gbyHPQgAAAC1VSBdjjDk3OdVyRu9xYDS User-Agent: G2/1.0 X-Received-Bytes: 1330 Xref: csiph.com comp.databases.filemaker:735 Hello, In FMP5: In an invoice where a total and taxes is calculated from parts & labor, sales taxes etc; there is a field that accepts cash amounts as payments and the amount owing displays accordingly. We need to keep the users from "overpaying" [they actually do it!] the invoice total in the payment fields since that totally bollockses reports etc. Would really appreciate any strategy suggestions. Bill