Re: invoiceitems entries not created
Dale E. Reed Jr. ( (no email) )
Fri, 13 Feb 1998 00:59:05 -0800
emerald@nls.net wrote:
>
> Today we went to create invoices just like every day. For some reason though
> the invoices were created, and with the correct totals but the invoiceitems
> table doesn't have any items for these invoices. When we went to print the
> invoices it went thru the print process but came up with 0 invoices in the
> print window. If I go and look up one of the invoices it shows in the
> history tab but not in the open invoices tab and it can't be paid since it
> doesn't show there.
>
> Anyone seen this before? It was working fine yesterday and as far as I know
> nothing has been changed.
I have only seen a possible scenario like this where the invoiceitem
table's identity was off. Grab the checkdb.sql script from the FTP
site and run it against your database. See if that solves the problem.
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com