Skip to content
  • There are no suggestions because the search field is empty.

Invalid column name "IsDutiesAsLineItem" There was a mismatch error in executing this application to fix this you will need to update your WD Software and upgrade your database on your primary computer.

This article helps Webgility Desktop users resolve the “Invalid column name ‘IsDutiesAsLineItem’” error in . It explains that this issue occurs when the Webgility Desktop database is outdated and may fail during re-indexing. The article provides step-by-step guidance to update Webgility Desktop to the latest version, upgrade the database using the “UnifyDBUpgrade” tool, and ensure all affected machines are correctly updated to restore proper functionality.

Reason:

This typically happens when the Webgility Desktop database hasn't been updated in a while and runs into problems during re-indexing.

Troubleshooting:

1). Make sure Webgility Desktop is running the latest version, if not then perform an upgrade on all the required machines. Follow the steps in this helpful article on How to Update Your Webgility Desktop Software Once finished, try to log in again to Webgility Desktop and perform your required operation.

2). If Webgility Desktop is already running the latest software version then you will need to follow below mentioned steps:

3). Close Webgility Desktop Software as well as Webgility Desktop Scheduler (if running) on all of your required machines.

4). Now go to the machine-facing issue, then go to the location C:\Webgility\UnifyEnterprise and look for a file with the name "UnifyDBUpgrade" and run it and wait for a success popup. (this may take a few minutes)

3). Once you see the success pop saying "Webgility Desktop database upgraded successfully" then close that popup and try to log in again.