Strata sync - troubleshooting [in-depth guide]
Guide contents: Typical steps to resolving issues | Changing a station ID | Error codes/definitions | FAQ
Typical steps to resolving issues
1. Make sure you are running the latest Strata sync tool and try to sync again.
- Go to the StrataLink tool guide to download the current version.
2. Ensure you are making all new orders & revisions to existing orders in Strata only.
3. Did you change a vendor, station or publication ID in Workamajig and not in Strata?
- If so, please review the next section about how to change an ID.
4. Review the StrataLink error report.
- From the StrataLink > Sync results tab, click Open error report file.
- This report will describe the issue and/or provide "codes" associated with the error, you can then reference those codes with our definitions list below.
- Per the error code and description/resolution, you may be able to resolve the issue yourself.
5. If none of the above steps resolves your issue, please send an email to support@workamajig.com with ALL of the following information:
1. The version number of Strata and the Stratalink tool you are running.
2. Screenshot of the Modules tab, Options, and Settings tab of the Stratalink tool so that we can see the parameters used in the Stratalink tool.
3. From the StrataLink tool: Sync results tab: click Open reports folder and send us all .xml and .html logfiles with the date stamp associated with the sync.
NOTE: If you are on the hosted version of Strata, you can access the log files via your S:\Strata drive. Please follow the Sending StrataLink log files to Workamajig [in-depth guide] to get this info and send us those log files.
4. A specific order number or vendor invoice number in Workamajig that is showing incorrect information.
Changing a station ID
If you want all existing details to be part of the new station, then simply edit the station ID in Workamajig to match the new VendorID;StationID in the Billing code field on the station in Strata.
If you want the existing orders for the old station to stay with the old station and new orders for the new station with the new station ID to be separate, then you must edit the station in Strata with the new VendorID;StationID and when you sync new orders over to Workamajig, it will create the new station record in Workamajig and sync orders over under that new station ID.
NOTE: Do not make this change for orders that have already been synced into Workamajig or you will get an error. Please delete the original order and then sync it as a new order. If the old order has already been prebilled in Workamajig, close out the order using the old station.
Error codes & definitions
Common
1- A path to the Strata DB was not specified
Cause: A valid location for the Strata database was not specified on the Settings tab.
Resolution: Specify a valid location for the Strata database. Click the Test connection button to verify the location.
2 - Cannot create required 'data' directory
Cause: StrataLink needs to create a working directory and cannot. The directory called 'data' will be created in the same location where StrataLink was installed.
Resolution: Verify that the user using the workstation has sufficient rights to create a directory and that there is enough disk space available.
3 - The user ID on the Settings tab must be entered before attempting to connect to Workamajig
Cause: The 'user ID' is missing on the Settings tab.
Resolution: Enter your Workamajig user ID.
4 - The password on the Settings tab must be entered before attempting to connect to Workamajig
Cause: The 'password' is missing on the Settings tab.
Resolution: Enter your Workamajig password.
5 - The site address on the Settings tab must be entered before attempting to connect to Workamajig
Cause: The 'site address' is missing on the Settings tab.
Resolution: Enter your Workamajig website address. The HTTP:// prefix is not necessary.
114 - The version of the StrataLink you are using is no longer compatible with Workamajig. Please update your StrataLink software by downloading the current version. The minimum StrataLink version required is x.x.x Your version is y.y.y
Cause: The version of StrataLink you are using is no longer compatible with the current version of Workamajig.
Resolution: Download & install the latest version of StrataLink
115 - StrataLink cannot connect to the specified WORKAMAJIG server. Please verify that the local computer can access WORKAMAJIG and that StrataLink is not restricted from accessing remote computers by local policies or firewall rules.
Cause: Strata Link cannot establish a connection to the WORKAMAJIG web server. This is usually due to a local firewall rule restricting StrataLink.exe to the local computer only.
Resolution: Enable the StrataLink.exe with the ability to contact the WORKAMAJIG web server.
6 - Strata Link could not log into the Workamajig system using the information you provided
Cause: The User ID and/or Password are invalid.
Resolution: Enter a valid Workamajig User ID and Password that is active and working.
7 - The client list could not be retrieved from the Workamajig System
Cause: StrataLink failed to connect to the Workamajig system because it is not currently accessible.
Resolution: Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
8 - The client list returned from Workamajig is empty
Cause: Clients have not been set up in Workamajig.
Resolution: Set up clients in Workamajig or sync clients using StrataLink before trying to sync orders and invoices. The list is populated using Clients from Workamajig.
BROADCAST ITEMS
9 - The broadcast item [Item Name] could not be added
Cause: While the sync was running, a broadcast item was added to Workamajig with the same Item ID.
Resolution: Delete the manually added item and sync Broadcast Items.
10 - The broadcast item [Item Name] could not be updated
Cause: While the sync was running, the existing broadcast item was deleted from Workamajig.
Resolution: Sync Broadcast Items and the item will be added.
PRINT ITEMS
11 - The Print Media Item [Media Name] cannot be added because the ID is blank
Cause: The BCS Sales Class Code has not been entered in SBMS.
Resolution: Update the BCS Sales Class Code in SBMS. See the section titled SBMS Print Media Codes for further details.
12 - The print item [Item Name] could not be added
Cause: While the sync was running, a print item was added to Workamajig with the same Item ID.
Resolution: Delete the manually added item and sync Print Items.
13 - The print item [Item Name] could not be updated
Cause: While the sync was running, the existing print item was deleted from Workamajig.
Resolution: Sync Print Items and the item will be added.
Markets
14 - The Market [Market Name] cannot be added because the three letter code is blank
Cause: The Market Code has not been entered in SBMS.
Resolution: Enter a Market Code in SBMS. See the section titled Markets for further details.
15 - The Market [Market Name] could not be added
Cause: While the sync was running, a market was added to Workamajig with the same Market ID.
Resolution: Delete the manually added market and sync Markets.
16 - The Market [Market Name] could not be updated
Cause: While the sync was running, the existing market was deleted from Workamajig.
Resolution: Sync Markets and the market will be added.
CLIENTS
17 - The Client [Client Name] cannot be added because the Client ID is blank
Cause: The Client in SBMS does not have a Billing Code specified.
Resolution: Update the client with a unique billing code.
19 - The Client [Company Name] could not be updated because the client cannot be found
Cause: While the sync was running, the existing client was deleted from Workamajig.
Resolution: Sync Clients and the client will be added.
DIVISIONS
20 - The Division [Division Name] cannot be added because the Division ID is blank
Cause: The division Billing Code is blank.
Resolution: Normally divisions are not accessible in SBMS. If the First Export Link under Settings is set to BCS, Divisions will be available on the filing cabinet menu. Add the Billing Code to the division.
21 - The division [Division Name] could not be added because a division with this name already exists
Cause: There is already a division with the same name in Workamajig.
Resolution: Delete the manually added division for the client and sync Clients.
22 - The division [Division Name] could not be added because the client could not be found
Cause: The Client ID associated with this division has been changed or deleted.
Resolution: The Client ID in Workamajig must match the Client Billing Code in SBMS. Make sure the codes match in both systems and sync Clients.
23 - The division [Division Name] could not be updated
Cause: The database update could not be completed.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
24 - The division [Division Name] could not be updated
Cause: While the sync was running, the existing division was deleted from Workamajig.
Resolution: Sync Clients and the division will be added.
PRODUCTS
25 - The Product [Product Name] could not be added because a product with this name already exists
Cause: There is already a product with the same name in Workamajig.
Resolution: Delete the manually added product for the client and sync Clients.
26 - The Product [Product Name] could not be added because the client could not be found
Cause: The Client ID associated with this product has been changed or deleted.
Resolution: The Client ID in Workamajig must match the Client Billing Code in SBMS. Make sure the codes match in both systems and sync Clients.
27 - The Product [Product Name] could not be added because a product with this name already exists
Cause: While the sync was running, a product was added to Workamajig with the same Product ID (SBMS Billing Code).
Resolution: Delete the manually added product and sync Clients.
28 - The Product [Product Name] could not be updated
Cause: The database update could not be completed.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
29 - The Product [Product Name] could not be found
Cause: While the sync was running, the existing product was deleted from Workamajig.
Resolution: Sync Clients and the product will be added.
119 - The Product [Product Name] could not be added because a division with a LinkID of "1234" could not be found
Cause: The product in SBMS is associated with a division that does not exist in Workamajig.
Resolution: Resolve any sync errors concerning divisions.
BROADCAST VENDORS
30 - The Vendor [Vendor Name] cannot be added because the Vendor ID is blank
Cause: The SBMS vendors Billing Code is blank.
Resolution: Add the billing code to the vendor.
31 - The Vendor [Vendor Name] could not be added because a vendor with this ID already exists
Cause: While the sync was running, a broadcast vendor was added to Workamajig with the same Vendor ID (SBMS Billing Code).
Resolution: Delete the manually added broadcast vendor and sync Broadcast Vendors.
32 - The Vendor [Vendor Name] could not be updated because a vendor with this ID already exists
Cause: While the sync was running, the existing broadcast vendor was deleted from Workamajig.
Resolution: Sync Broadcast Vendors and the vendor will be added.
BROADCAST STATIONS
33 - The Station [Station Name] could not be added because a station with this ID already exists
Cause: While the sync was running, a station was added to Workamajig with the same Station ID (SBMS Billing Code).
Resolution: Delete the manually added station and sync Broadcast Vendors.
PRINT VENDORS
34 - The publication [Publication Name] cannot be added because the publication code is blank
Cause: The vendor SBMS Billing Code is blank.
Resolution: Add the billing code to the vendor.
31 - The Vendor [Vendor Name] could not be added because a vendor with this ID already exists
Cause: While the sync was running, a print vendor was added to Workamajig with the same Vendor ID (SBMS Billing Code).
Resolution: Delete the manually added print vendor and sync Print Vendors.
32 - The Vendor [Vendor Name] could not be updated because a vendor with this ID already exists
Cause: While the sync was running, the existing print vendor was deleted from Workamajig.
Resolution: Sync Print Vendors and the vendor will be added.
PRINT PUBLICATIONS
35 - The publication [Publication Name] could not be added because a publication with this ID already exists
Cause: While the sync was running, a station was added to Workamajig with the same Publication ID (SBMS Billing Code).
Resolution: Delete the manually added publication and sync Print Vendors.
BROADCAST ORDERS
36 - No broadcast estimates were found, broadcast orders cannot be synchronized
Cause: There are no broadcast estimates entered in SBMS.
Resolution: Verify correct SBMS database is specified and that broadcast orders exist in SBMS.
37 - No broadcast vendors were found, broadcast orders cannot be synchronized
Cause: There are no broadcast vendors entered in SBMS.
Resolution: Verify correct SBMS database is specified and that broadcast vendors exist in SBMS.
38 - No broadcast orders were found matching your selected parameters
Cause: The parameters specified for broadcast orders on the 'Modules' tab are too limiting, no orders meet the criteria.
Resolution: Change the selection criteria to include desired broadcast orders. The only criteria used to select orders is that the order lines must be in a (B)illed status and the flight day/week must fall within the broadcast dates specified.
39 - The estimate for [Estimate Name] could not be found
Cause: The internal Estimate ID on the SBMS order is referencing an estimate that no longer exists.
Resolution: Please contact Workamajig Support for assistance.
40 - The vendor for [Station] could not be found in the SBMS database - Verify the spacing and spelling in the call letters and band code. These must match the Vendor Record.
Cause: The station specified on the order cannot be located in the SBMS database. These messages are generally caused when stations change call letters or Ids or a Vendor is not added to the Vendors screen in SBMS.
Resolution: The utility is called Match Vendor/Station. Give it a try and then contact Strata Client Service at 1-800-9STRATA for additional help with this utility.
41 - The vendor for [Station] could not be found in the SBMS database. Please try running the Match Vendor/Station utility in SBMS and resync the vendors.
Cause: The station specified on the order cannot be located in the SBMS database. These messages are generally caused when stations change call letters or Ids or a Vendor is not added to the Vendors screen in SBMS.
Resolution: SBMS provides a utility called "Match Vendor/Station". Please run the utility and perform the sync again. If you receive the error again, please contact Strata Client Service at 1-800-9STRATA and let them know that there appears to be a Station/Vendor mismatch which is causing errors when syncing with Workamajig and that you have run the utility.
From Strata go to Tools and Utilities and click on Match Vendor/Stations:

Type in your estimate and pick the station on both sides and click Assign Vendor

42 - Error on Estimate [Estimate Name]
Cause: The estimate could not be updated in the Workamajig database.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
43 - The Client for estimate [Estimate Name] could not be found
Cause: The Client specified on the estimate cannot be located in Workamajig.
Resolution: Verify that the SBMS client Billing Code matches the Workamajig Customer ID and sync Broadcast Orders.
44 - The estimate [Estimate Name] could not be updated because the specified project number was not found or the current status does not allow purchasing activity
Cause: The Project Number specified in the SBMS estimate Job# (Estimate Billing Code in SBMS.Net version) field cannot be found in Workamajig.
Resolution: Verify that the SBMS estimate has a valid Job#/Estimate Billing Code that matches a valid Workamajig project Project Number and that the current project status is a status that allows expenses to be added to the project.
45 - The estimate [Estimate Name] could not be updated because an estimate with this ID already exists
Cause: While the sync was running, an estimate was added to Workamajig with the same Estimate. The format of the Workamajig Estimate ID is the SBMS Estimate # prefixed by a B.
Resolution: Delete the manually added estimate and sync Broadcast Orders.
46 - The estimate [Estimate Name] could not be updated because Task ID was not found for the specified project
Cause: In Workamajig under System Setup/Control Accounts, the Require Tasks on Expenses option is set and an invalid Task ID was specified.
Resolution: Verify that the task entered in the SBMS estimate Job # (Estimate Billing Code in SBMS.Net version) field matches a valid Task ID in the Workamajig project. See the section titled Configuring SBMS/Transactions/Estimates for further details.
47 - The vendor could not be found
Cause: The Workamajig vendor cannot be found.
Resolution: Verify that the SBMS vendor has been successfully synced or enter the vendor manually in Workamajig. The SBMS vendor Billing Code must match the Workamajig vendor Vendor ID.
48 - The estimate could not be found
Cause: The orders associated estimate cannot be located in Workamajig.
Resolution: Please contact Workamajig Support for assistance.
49 - A project is required and could not be found
Cause: The Workamajig system options indicate that orders are linked to clients through projects. The project entered in the SBMS estimate Job # (Estimate Billing Code in the SBMS.Net version) field must match a Project Number in Workamajig.
Resolution: Verify that the SBMS estimate has a valid Job#/Estimate Billing Code that matches a valid Workamajig project Project Number.
50 - A Task is required
Cause: In Workamajig under System Setup/Control Accounts, the Require Tasks on Expenses option is set and an invalid Task ID was specified.
Resolution: Verify that the task entered in the SBMS estimate Job # (Estimate Billing Code in SBMS.Net version) field matches a valid Task ID in the Workamajig project. See the section titled Estimates above for further details.
51 - An Item is required
Cause: Workamajig system options are set to require items on expenses and the item associated with this order cannot be found in Workamajig.
Resolution: Broadcast Items must be synced successfully before Broadcast Orders can be synced. Verify the SBMS estimate's Media Item exists as a Workamajig broadcast item.
52 - The specified project is set to a status that is closed to purchases
Cause: The Workamajig project is set to a status that does not allow new expenses to be added.
Resolution: If applicable, change the Workamajig project status to a status that allows expenses.
53 - The client could not be found
Cause: The client specified on the project or estimate is missing.
Resolution: Please contact Workamajig Support for assistance.
96 - The order has been approved and cannot be modified
Cause: The Workamajig system option Auto Approve External Orders under Admin > System setup > Transaction Preferences is not selected.
Resolution: If applicable, select this option and all orders will be set to a status of approved when synced and existing orders can be updated if they have not been billed and are not included in an active billing worksheet.
54 - The line item could not be updated because it has been billed
Cause: This existing order line in Workamajig has been included on a client invoice and cannot be updated.
Resolution: This is the default system behavior. Changes to lines can be made if the Allow Changes After Client Invoices option is selected in Workamajig. See the section Transaction Preferences for further details.
55 - The line item could not be updated because it is currently on an open billing worksheet
Cause: This existing order line in Workamajig is included on an open billing worksheet.
Resolution: Remove the order line from the billing worksheet or wait until the billing worksheet has been approved. If the worksheet has been approved, the line may now be on a client invoice. It can still be updated if the Allow Changes After Client Invoices option has been selected. See the section Transaction Preferences
116 -The Estimate could not be updated because the Class ID was not valid.
Cause: You entered an invalid Class ID in the Job # (Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Class ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
117 -The Estimate could not be updated because a Class ID is required.
Cause: You did not enter a Class ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but GL Classes are required in the GL Tracking Options system settings.
Resolution: Enter a valid Class ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
120 - The estimate could not be updated because the Company ID was not valid.
Cause: You entered an invalid Company ID in the Job # (Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Company ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
121 - The estimate could not be updated because the Company ID is required.
Cause: You did not enter a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but Companies are required in the GL Tracking Options system settings.
Resolution: Enter a valid Company ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
122 - The estimate could not be updated because Office ID was not valid.
Cause: You entered an invalid Office ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Office ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
123 - The estimate could not be updated because the Office ID is required.
Cause: You did not enter an Office ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but Offices are required in the GL Tracking Options system settings.
Resolution: Enter a valid Office ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
124 - The Company ID for an estimate cannot be changed once transactions are entered against it.
Cause: You entered a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate which is different from what is already on the Estimate in Workamajig.
Resolution: The Estimate you are trying to change the Company ID on has transactions entered against it; Company ID on an estimate cannot be changed once transactions are entered against it.
125 - The Company ID for estimate does not match the Company ID on the Project.
Cause: You entered a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate that does not match the Company ID on the Project.
Resolution: The Estimate and Project must belong to the same Company.
126 -The Office ID for estimate does not match the Office ID on the Project.
Cause: You entered an Office ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate that does not match the Office ID on the Project.
Resolution: The Estimate and Project must have to the same Office.
128 - The line item could not be updated because the department is required and has not been set on the item.
Cause: You are trying to use an Item on the Broadcast Order that doesn't have a department set but Departments are required in the GL Tracking Options system settings.
Resolution: Edit the Item in Workamajig and set a Department on the item.
BROADCAST INVOICES
56 - The vendor for invoice Station: [Station] Invoice: [Invoice Number] could not be found in the strata database
Cause: The vendor specified on the invoice cannot be located in the Strata database. These messages are generally caused when stations change call letters or Ids or a Vendor is not added to the Vendors screen in SBMS.
Resolution: Please contact Strata Client Service at 1-800-9STRATA and let them know that there appears to be a Station/Vendor mismatch which is causing errors when syncing with Workamajig. They will work with you to determine the cause of the problem and give you the steps to correct it.
57 - Error on Invoice [Invoice Number]
Cause: The estimate could not be updated in the Workamajig database.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
58 - The vendor for the invoice [Invoice Number] could not be found
Cause: The Workamajig vendor cannot be found.
Resolution: Verify that the SBMS vendor has been successfully synced or enter the vendor manually in Workamajig. The SBMS vendor's Billing Codes must match the Workamajig vendor's Vendor ID.
59 - The invoice date for the invoice [Invoice Number] was blank and is required
Cause: The invoice date in SBMS is missing.
Resolution: Enter an invoice date in SBMS and sync the Broadcast Invoices.
60 - The invoice number was blank and is required
Cause: The invoice number in SBMS is missing.
Resolution: Enter an invoice number in SBMS and sync the Broadcast Invoices.
61 - The invoice number [Invoice Number] already exists in the system
Cause: While trying to enter a new invoice into Workamajig, an invoice was found for the vendor with the same invoice number.
Resolution: If this is a duplicate invoice, delete the existing invoice in Workamajig. If this is a valid invoice, change the invoice number to enable the SBMS invoice to sync.
62 - The project is not currently accepting costs
Cause: The project associated with the order is not currently accepting costs.
Resolution: If applicable, change the project status of the project associated with the order to a status that allows costs to be added to the project.
63 - The vendor for the invoice could not be found
Cause: The Workamajig vendor cannot be found.
Resolution: Verify that the SBMS vendor has been successfully synced or enter the vendor manually in Workamajig. The SBMS vendors' Billing Code must match the Workamajig vendors' Vendor ID.
64 - The associated purchase order for the invoice [Invoice Number] could not be found
Cause: The order specified on the invoice is missing in Workamajig.
Resolution: Verify that the order has been successfully synced from SBMS.
65 - The associated purchase order for the invoice [Invoice Number] has not been approved
Cause: The Workamajig order has not been approved.
Resolution: The Workamajig must be in an approved status. Approve the order and sync Broadcast Invoices.
66 - A project was not found on the order tied to an invoice line item and is required
Cause: The broadcast order does not have a valid Workamajig project specified, and the client is linked to the order through the project.
Resolution: Enter a valid Workamajig project on the broadcast order and sync Broadcast Orders.
67 - A task was not found on the order and is required
Cause: In Workamajig under System Setup/Control Accounts, the 'Require Tasks on Expenses' option is set and the broadcast order does not have a valid Workamajig task specified.
Resolution: Enter a valid Workamajig task on the broadcast order and sync Broadcast Orders.
68 - An item was not found on the order and is required
Cause: Workamajig system options are set to require items on expenses and the associated order does not have a broadcast item specified.
Resolution: Enter a valid Workamajig broadcast item on the broadcast order and sync Broadcast Orders.
69 - An expense account was not found for an order line item and is required
Cause: The Workamajig system option Require GL Accounts under Admin > System setup > Control accounts is on. Both the broadcast item expense account and the company default expense account have not been specified.
Resolution: Specify expense accounts on broadcast items or specify a company default expense account.
70 - The invoice has already been posted and could not be updated or added to
Cause: The existing invoice has been posted and cannot be updated.
Resolution: If applicable, un-post the invoice.
71 - The project specified on an order line item is linked to a project that does not allow additional costs
Cause: The project associated with the order line is not currently accepting costs.
Resolution: If applicable, change the project status of the project associated with the order line to a status that allows costs to be added to the project.
72 - The system could not insert the invoice line item
Cause: The database update could not be completed.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
73 - An invoice line item was not tied to an order
Cause: The broadcast order line could not be found for an existing invoice line.
Resolution: Please contact Workamajig Support for assistance.
74 - An invoice line item has been billed and cannot be updated
Cause: The existing invoice line has been billed.
Resolution: If applicable, delete the invoice.
75 - Error on Invoice Detail -
Cause: The database update could not be completed.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
118 - The invoice [Invoice Number] has already been posted and could not be updated or added to
Cause: The existing invoice has been posted and cannot be updated.
Resolution: If applicable, un-post the invoice.
119 - One or more detail invoice lines on invoice [Invoice Number] have been billed or written off, the invoice cannot be updated.
Cause: One or more invoice lines have already been written off or billed to the client.
Resolution: This is the default system behavior. Issue a credit or enter a manual invoice to accommodate the change to the invoice.
120 - One or more detail invoice lines on invoice [Invoice Number] are currently on a billing worksheet, the invoice cannot be updated.
Cause: One or more invoice lines are on an open billing worksheet.
Resolution: Remove the invoice line from the billing worksheet or wait until the billing worksheet has been approved.
121 -One or more detail invoice lines on invoice [Invoice Number] could not be deleted.
Cause: One or more invoice lines could not be deleted due to an unknown system error.
Resolution: Please contact Workamajig Support for assistance.
122 -The associated purchase order lines for invoice [Invoice Number] could not be updated.
Cause: One or more purchase order lines could not be updated due to an unknown system error.
Resolution: Please contact Workamajig Support for assistance.
123 -A project was not found on an order line while trying to add a bottom-line invoice [InvoiceNumber] and is required.
Cause: One or more purchase order lines have a missing or incorrect project number and it is required.
Resolution: Verify that the Job# (Estimate Billing Code in SBMS.Net version) on the Strata campaign is correctly formatted and re-sync.
124 -A task was not found on an order line while trying to add a bottom-line invoice [InvoiceNumber] and is required.
Cause: One or more purchase order lines have a missing or incorrect task ID and it is required.
Resolution: Verify that the Job#(Estimate Billing Code in SBMS.Net version)on the Strata campaign is correctly formatted and re-sync.
125 -An item was not found on an order line while trying to add a bottom-line invoice [InvoiceNumber] and is required.
Cause: Workamajig system options require items on expenses and the Prod. Code on the Strata campaign is referencing a Workamajig broadcast item, item ID that does not exist.
Resolution: Verify a matching Workamajig broadcast item with the IItem ID exists.
126 -An expense account was not found while trying to add a bottom-line invoice [Invoice Number] and is required.
Cause: The Workamajig system option Require GL Accounts under Admin > System setup > Control accounts is on. Both the broadcast item expense account and the company default expense account have not been specified.
Resolution: Specify expense accounts on broadcast items or specify a company default expense account.
127-While adding the bottom line invoice [Invoice Number], an order line was tied to a project that does not allow additional costs.
Cause: The Workamajig project is set to a status that does not allow new expenses to be added.
Resolution: If applicable, change the Workamajig project status to a status that allows expenses.
128 - The system could not insert an invoice detail line while trying to add a bottom-line invoice [Invoice Number].
Cause: One or more invoice lines could not be added due to an unknown system error.
Resolution: Please contact Workamajig Support for assistance.
129 The bottom line invoice [Invoice Number] could not be added or updated. The invoice amount is greater than the total cost of the order.
Cause: The invoice amount is greater than the total cost of the order. The additional invoice amount cannot be applied to the order.
Resolution: Delete the invoice if it exists. Update the invoice to be equal to the total cost of the order.
137 - The vendor for the invoice [Invoice Number] is not active. The invoice could not be synced.
Cause: The active flag for this vendor has been turned off.
Resolution: If appropriate, re-activate the vendor and re-sync the invoice.
PRINT ORDERS
76 - No print estimates were found, print orders cannot be synchronized
Cause: There are no print estimates entered in SBMS.
Resolution: Verify correct SBMS database is specified and that print orders exist in SBMS.
77 - No print vendors were found, print orders cannot be synchronized
Cause: There are no print vendors entered in SBMS.
Resolution: Verify correct SBMS database is specified and that print vendors exist in SBMS.
78 - No print orders were found within the dates specified
Cause: The parameters specified for print orders on the 'Modules' tab are too limiting, no orders meet the criteria.
Resolution: Change the selection criteria to include desired print orders. The only criteria used to select orders is that the order lines must be in a (B)illed status and the insertion date must fall within the insertion dates specified.
79 - The estimate [Estimate ID] for the order on [Insertion Date] could not be found in the Strata database
Cause: The internal Estimate ID on the SBMS order is referencing an estimate that no longer exists.
Resolution: Please contact Workamajig Support for assistance.
80 - The publication [Publication Code] for the order on [Insertion Date] could not be found in the Strata database
Cause: The vendor specified on the order cannot be located in the Strata database. These messages are generally caused when stations change Ids or a Vendor is not added to the Vendors screen in SBMS.
Resolution: Please contact Strata Client Service at 1-800-9STRATA and let them know that there appears to be a Station/Vendor mismatch which is causing errors when syncing with Workamajig. They will work with you to determine the cause of the problem and give you the steps to correct it.
81 - Error on Estimate [Estimate ID]
Cause: The estimate could not be updated in the Workamajig database.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
82 - The Client for estimate [Estimate Name] could not be found
Cause: The Client specified on the estimate cannot be located in Workamajig.
Resolution: Verify that the SBMS client's Billing Code matches the Workamajig Customer ID and sync Broadcast Orders.
83 - The estimate [Estimate Name] could not be updated because the specified project number was not found or the current status does not allow purchasing activity
Cause: The 'Project Number' specified in the SBMS estimate's Job#(Estimate Billing Code in SBMS.Net version) field cannot be found in Workamajig.
Resolution: Verify that the SBMS estimate has a valid Job#/Estimate Billing Code that matches a valid Workamajig projects' Project Number and that the current project status is a status that allows expenses to be added to the project.
84 - The estimate '[Estimate Name] could not be updated because an estimate with this ID already exists
Cause: While the sync was running, an estimate was added to Workamajig with the same Estimate. The format of the Workamajig Estimate ID is the SBMS Estimate # prefixed by a B.
Resolution: Delete the manually added estimate and sync Broadcast Orders.
85 - The estimate [Estimate Name] could not be updated because Task ID was not found for the specified project
Cause: In Workamajig under System setup > Control accounts, the 'Require Tasks on Expenses' option is set and an invalid Task ID was specified.
Resolution: Verify that the task entered in the SBMS estimates' Job #(Estimate Billing Code in SBMS.Net version) field matches a valid Task ID in the Workamajigs project. See the section titled Configuring SBMS/Transactions/Estimates for further details.
86 - The vendor could not be found
Cause: The Workamajig vendor cannot be found.
Resolution: Verify that the SBMS vendor has been successfully synced or enter the vendor manually in Workamajig. The SBMS vendor's Billing Code must match the Workamajig vendor's Vendor ID.
87 - The estimate could not be found
Cause: The order's associated estimate cannot be located in Workamajig.
Resolution: Please contact Workamajig Support for assistance.
88 - A project is required and could not be found
Cause: The Workamajig system options indicate that orders are linked to clients through projects. The project entered in the SBMS estimate's Job #(Estimate Billing Code in SBMS.Net version) field must match a Project Number in Workamajig.
Resolution: Verify that he SBMS estimate has a valid Job#/Estimate Billing Code that matches a valid Workamajig Project Number.
89 - A Task is required and could not be found
Cause: In Workamajig under System setup > Control accounts, the 'Require Tasks on Expenses' option is set and an invalid Task ID was specified.
Resolution: Verify that the task entered in the SBMS estimates' Job #(Estimate Billing Code in SBMS.Net version) field matches a valid Task ID in the Workamajig's project. See the section titled Configuring SBMS/Transactions/Estimates for further details.
90 - An Item is required and could not be found
Cause: Workamajig system options are set to require items on expenses and the item associated with this order cannot be found in Workamajig.
Resolution: Print Items must be synced successfully before Print Orders can be synced. Verify the SBMS estimate's Media Item exists as a Workamajig print item.
91 - The specified project is set to a status that is closed to purchases
Cause: The Workamajig project is set to a status that does not allow new expenses to be added.
Resolution: If applicable, change the Workamajig project status to a status that allows expenses.
92 - The client could not be found
Cause: The client specified on the project or estimate is missing.
Resolution: Please contact Workamajig Support for assistance.
93 - The order has been approved and can not be modified
Cause: The Workamajig system option Auto Approve External Orders under Admin/System Setup/Transaction Preferences is not selected.
Resolution: If applicable, turn to select this option and all orders will be set to a status of approved when synced and existing orders can be updated if they have not been billed and are not included in an active billing worksheet.
94 - The line item could not be updated because it has been billed
Cause: This existing order line in Workamajig has been included on a client invoice and cannot be updated.
Resolution: This is the default system behavior. Changes to lines can be made if the Allow Changes After Client Invoices option is selected in Workamajig. See the section titled Transaction Preferences for further details.
95 - The line item could not be updated because it is currently on an open billing worksheet
Cause: This existing order line in Workamajig is included on an open billing worksheet.
Resolution: Remove the order line from the billing worksheet or wait until the billing worksheet has been approved. If the worksheet has been approved, the line may now be on a client invoice. It can still be updated if the Allow Changes After Client Invoices option has been selected. See the section titled Transaction Preferences for further details.
116 - The Estimate could not be updated because the Class ID was not valid.
Cause: You entered an invalid Class ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Class ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
117 - The Estimate could not be updated because a Class ID is required.
Cause: You did not enter a Class ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but GL Classes are required in the GL Tracking Options system settings.
Resolution: Enter a valid Class ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
129 - The estimate could not be updated because the Company ID was not valid.
Cause: You entered an invalid Company ID in the Job # (Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Company ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
130 - The estimate could not be updated because the Company ID is required.
Cause: You did not enter a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but Companies are required in the GL Tracking Options system settings.
Resolution: Enter a valid Company ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
131 - The estimate could not be updated because Office ID was not valid.
Cause: You entered an invalid Office ID in the Job # (Estimate Billing Code in SBMS.Net version) field of the Estimate.
Resolution: Enter a valid Office ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
132 - The estimate could not be updated because the Office ID is required.
Cause: You did not enter an Office ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate, but Offices are required in the GL Tracking Options system settings.
Resolution: Enter a valid Office ID in the Job #/Estimate Billing Code field of the Estimate and Sync again.
133 - The Company ID for an estimate cannot be changed once transactions are entered against it.
Cause: You entered a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate which is different from what is already on the Estimate in Workamajig.
Resolution: The Estimate you are trying to change the Company ID on has transactions entered against it; Company ID on an estimate cannot be changed once transactions are entered against it.
134 - The Company ID for estimate does not match the Company ID on the Project.
Cause: You entered a Company ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate that doesn'tt match the Company ID on the Project.
Resolution: The Estimate and Project must belong to the same Company.
135 - The Office ID for estimate does not match the Office ID on the Project.
Cause: You entered an Office ID in the Job #(Estimate Billing Code in SBMS.Net version) field of the Estimate that doesn't match the Office ID on the Project.
Resolution: The Estimate and Project must have to the same Office.
127 - The line item could not be updated because the department is required and has not been set on the item.
Cause: You are trying to use an Item on the Print Order that doesn'tt have a department set but Departments are required in the GL Tracking Options system settings.
Resolution: Edit the Item in Workamajig and set a Department on the item.
141 - The VendorID cannot be updated on the Estimate.
Cause: The Vendor on the revised order being synced from Strata no longer matches the Vendor on the original order in Workamajig.
Resolution: Revise the Billing Code in the Strata Vendor record to match the Vendor ID on the original order in Workamajig.
PRINT INVOICES
97 - The vendor could not be found
Cause: The Workamajig vendor cannot be found.
Resolution: Verify that the SBMS vendor has been successfully synced or enter the vendor manually in Workamajig. The SBMS vendors' Billing Code must match the Workamajig vendor's Vendor ID.
98 - The invoice date was blank and is required
Cause: The invoice date in SBMS is missing.
Resolution: Enter an invoice date in SBMS and sync the Print Invoices.
99 - The invoice number was blank and is required
Cause: The invoice number in SBMS is missing.
Resolution: Enter an invoice number in SBMS and sync the Print Invoices.
100 - The invoice number already exists in the system
Cause: While trying to enter a new invoice into Workamajig, an invoice was found for the vendor with the same invoice number.
Resolution: If this is a duplicate invoice, delete the existing invoice in Workamajig. If this is a valid invoice, change the invoice number to enable the SBMS invoice to sync.
101 - The project is not currently accepting costs
Cause: The project associated with the order is not currently accepting costs.
Resolution: If applicable, change the project status of the project associated with the order to a status that allows costs to be added to the project.
102 - The order tied to an invoice line item could not be found
Cause: The order specified on the invoice is missing Workamajig.
Resolution: Verify that the order has been successfully synced from SBMS.
103 - The order tied to an invoice line item has not been approved
Cause: The Workamajig order has not been approved.
Resolution: The Workamajig must be in an approved status. Approve the order and sync Broadcast Invoices.
104 - A project was not found on the order tied to an invoice line item and is required
Cause: The print order does not have a valid Workamajig project specified and the client is linked to the order through the project.
Resolution: Enter a valid Workamajig project on the print order and sync Print Orders.
105 - A task was not found on the order tied to an invoice line item and is required
Cause: In Workamajig under System Setup/Control Accounts, the Require Tasks on Expenses option is set and the print order does not have a valid Workamajig task specified.
Resolution: Enter a valid Workamajig task on the print order and sync Print Orders.
106 - An item was not found on the order tied to an invoice line item and is required
Cause: Workamajig system options are set to require items on expenses and the associated order does not have a print item specified.
Resolution: Enter a valid Workamajig print item on the print order and sync Print Orders.
107 - An expense account was not found for an order line item and is required
Cause: The Workamajig system option Require GL Accounts under Admin/System Setup/Control Accounts is on. Both the print item expense account and the company default expense account have not been specified.
Resolution: Specify expense accounts on print items or specify a company default expense account.
108 - The invoice has already been posted and could not be updated or added to
Cause: The existing invoice has been posted and cannot be updated.
Resolution: If applicable, un-post the invoice.
109 - The project specified on the order tied to an invoice line item is linked to a project that does not allow additional costs
Cause: The project associated with the order line is not currently accepting costs.
Resolution: If applicable, change the project status of the project associated with the order line to a status that allows costs to be added to the project.
110 - The system could not insert the invoice line item
Cause: The database update could not be completed.
Resolution: Ensure the Workamajig application is available. Verify the Workamajig system is functioning properly by logging in using a web browser from the machine where you are running Strata Link.
111 - An invoice line item was not tied to an order
Cause: The broadcast order line could not be found for an existing invoice line.
Resolution: Please contact Workamajig Support for assistance.
112 - The invoice line item has been billed and cannot be updated
Cause: The existing invoice line has been billed.
Resolution: If applicable, delete the invoice.
113 - The invoice has already been posted and could not be updated or added to
Cause: There are two or more print invoices for a vendor with the same Invoice Number. After the initial invoice was synced, it was posted and any other invoices with the same number cannot be synced once the original invoice was posted.
Resolution: Un-post the invoice, sync the remaining invoices and re-post the invoice.
136 - An expense account is required and has not been defined on the item, vendor or in the company defaults.
Cause: The system options are set to require an expense account. It must be defined at the item, vendor or company default level.
Resolution: Enter default expense accounts at the appropriate level or change system settings to not require expense accounts, if appropriate.
137 - The vendor for the invoice [Invoice Number] is not active. The invoice could not be synced.
Cause: The active flag for this vendor has been turned off.
Resolution: If appropriate, re-activate the vendor and re-sync the invoice.
FAQ
I need to change a Station ID:
If you want all existing details to be part of the new station, then simply edit the Station ID in Workamajig to match the new VendorID;StationID in the Billing Code field on the station in Strata.
If you want the existing orders for the old station to stay with the old station and new orders for the new station with the new station ID to be separate, then you must edit the Station in Strata with the new VendorID;StationID and when you sync new orders over to Workamajig, it will create the new Station record in Workamajig and sync orders over under that new station ID.
NOTE: Do not make this change for orders that have already been synced into Workamajig or you will get an error. Please delete the original order and then sync as a new order. If the old order as already been prebilled in Workamajig, close out the order using the old station.