Revenue Management cant access Lytec Database
-
- Posts: 8
- Joined: Mon Dec 30, 2013 3:33 pm
Revenue Management cant access Lytec Database
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'Unique ID', table 'Health And Abundance Inc0.dbo.History Detail'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at LY11.Posting.ExecuteSQL(IDbCommand cm, String desc, String conflict)
INSERT INTO [History Detail] ( [Unique ID], [History Header ID], [Detail ID], [Billing], [Item], [Type], [Patient Code], [Guarantor Code], [Insurance Code], [Responsible], [Date Printed], [Method] ) Select MAX([History Detail].[Unique ID]) + 1 , @HeaderID, @DetailID, @Billing, @Item, @TypeCode,' ',' ',@Insurance, @Resp, @PostDate, 3 From [History Detail]
Any Help appreciated.
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Revenue Management cant access Lytec Database
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386
-
- Posts: 8
- Joined: Mon Dec 30, 2013 3:33 pm
Re: Revenue Management cant access Lytec Database
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Revenue Management cant access Lytec Database
Also, what version of Lytec is this? 2011?
-
- Posts: 8
- Joined: Mon Dec 30, 2013 3:33 pm
Re: Revenue Management cant access Lytec Database
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact:
Re: Revenue Management cant access Lytec Database
-
- Posts: 8
- Joined: Mon Dec 30, 2013 3:33 pm
Re: Revenue Management cant access Lytec Database
You rock !
-
- Posts: 3
- Joined: Fri Mar 15, 2013 11:00 pm
Re: Revenue Management generated file
- Gavin Walker
- Posts: 4626
- Joined: Wed Apr 04, 2007 10:11 pm
- Location: Springfield, MO
- Contact: