Time Tracking

Correcting WennSoft Time Track SQL Error During Data Export

Posted By
BDO

In WennSoft Time Track you were able to export the data from Commit window.

However, the following week you may be getting an error that states “[Microsoft][SQL Server Native Client 10.0][SQL Server] cannot insert the value NULL into column ‘COL02’, table ‘EDI.dbo.WS50000’, column does not allow nulls, UPDATE fails…” as shown below.

You may also be getting another message that states “The stored procedure wsADP_Fill_Export_Table returned the following results: DBMS: 515, Microsoft Dynamics GP.

SQL Error

Dynamics GP Error

Correcting the Issue

The following steps may correct the issue:

  • Check the transactions or batch date
  • Use the week end date where these transactions date falls
  • In Time Track Export Wizard > Company Code and File Pathname window > Period End Date field enter correct week end / period end date

Time Track Export Wizard

WennSoft Case Study

Learn how BDO Solutions helped Orangeville Hydro Limited integrate WennsSoft’s Job Cost with their existing Microsoft Dynamics GP solution.

Orangeville WennSoft Case Study

BDO eBook - The Cloud Changes the Game

There are times in the course of your business when you have the opportunity to dramatically accelerate growth and improve day-to-day efficiencies. Recognizing

Download