Re: Charges Button under Batch problem

Dale E. Reed Jr. ( (no email) )
Mon, 03 Mar 1997 10:20:00 -0800

Marvin Grill wrote:
> When I select the Charges button under Batch it populates the CallHistory table but the Charges table nothing goes in. When checking with SQL Trace it appears the INSERT INTO Charges transactions are getting droped because of a foreign key constraint on the ItemID column. Is that normal? What I'm trying to do is test the billing of the usage charges as the Renewals just have the subscription charges showing up on the invoice.

What does your Charges table look like? ItemID isn't relevant to the
until you do Invoicing/Renewal (when it actually associates a charge to
an Invoice). What was the SQL Statement you trapped?

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |