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.
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
WennSoft Case Study
Learn how BDO Solutions helped Orangeville Hydro Limited integrate WennsSoft’s Job Cost with their existing Microsoft Dynamics GP solution.