GaleForce Media setup [in-depth guide]
GaleForce Media system setup
NOTE: Before starting, please contact your Workamajig account manager via support@workamajig.com to turn on the Media plan and other settings in Workamajig.
Step 1: Populate accounting API Link
Under the Agency module > Settings, click the third Integrations tab and scroll down to the Workamajig section. Click Connect an account and enter the information from the Workamajig API guide section (Media plans and Media plan vendor invoices).
To find the API tokens in Workamajig, go to:
Admin/manager > System setup > Connections > API
NOTE: This screen will provide the company API token and the ability to reset the personal/user API token. The personal/user token is visible by clicking on your name in the top right corner > API user token.
Complete all fields and click Submit
Step 2: Populate vendor ID and station/pub ID fields
Link the codes from Workmajig to MediaForce by going to Agency > Vendors. Locate the vendor, click Edit, and enter the vendor ID and station/pub ID from Workamajig.
Step 3: Populate the Job number field in the campaign
Link the project number code from Workmajig to MediaForce by entering the code into the Campaign settings in MediaForce.
Add the project in Workamajig to generate a project number code:
Populate the Job number field in Campaign settings in MediaForce with the WMJ code: Copy the text exactly, including special characters. Do not add spaces.
Billing Considerations for Advertisers/Clients
Workamajig allows you to bill your media clients based upon the Order Gross, Net or Commission Only.
This settings is at the Workamajig Client Level. However, in this integration, the Workamajig Client settings are ignored. Workamajig will use the Amount To Bill field value to define how much to bill the client for the order line. To bill the client using Net or Commission Only, you will need to adjust the Advertiser/Client record in MediaForce.
Edit Bill At Setting
Open the Advertiser>Accounting tab: Client Gross (WMJ)
Bill at Gross: By default the system is setup to bill using Gross which is a standard 15% commission. There is no setup needed.
Bill at Net: select Gross up Media Net> set % to 0
This will set the Amount To Bill on the order to the same value as Net
Bill at Commission Only: select Discount on Media Gross> set % to 85
This will set the Amount to Bill on the order to the commission value. Ex. 100 Gross > 15% Commission>Amount to Bill = 15. If you only want to bill 10% commission, set % to 90 >Amount to Bill = 8.5 >>Net = 85 > (Net/Commission%) > 85/10 = 8.5
Exporting orders (billables)
Step 1: After creating orders, click the “My orders” tab (shopping cart icon).
Step 2: Use the “Search Orders” drop-down or the Search field to locate the desired Orders. Check the box next to the orders you wish to export (you can export multiple orders simultaneously).
Step 3: Click the Accounting exports button and choose 'Workamajig API'
Step 4: Once the file is prepared, click Send to Workamajig and wait for the 'success' notification.
Exporting invoices (payables)
Step 1: After the invoices have been reconciled in the platform, elect to 'archive' the matched invoices.
Step 2: From the Archived invoices tab, use the Search invoices drop-down or the Search field to locate the desired invoices. Check the box next to the invoices you wish to export (you can export multiple invoices simultaneously).
Step 3: Click the Accounting exports button and choose 'Workamajig API'
Step 4: Once the file is prepared, click Send to Workamajig and wait for the 'success' notification.
Once the transactions are sent to Workamajig, they will be available via the Menu > Media > Media plan Screen.