Workday – Gotchas
Workday is a leading provider of enterprise cloud applications for finance, HR, and planning. Founded in 2005, Workday delivers financial management, human capital management, and analytics applications designed for the world’s largest companies, educational institutions, and government agencies. Organizations ranging from medium-sized businesses to Fortune 50 enterprises have selected Workday.
15 gotchas across 7 resources
These are connector-specific behaviors and limitations to be aware of when integrating.
Categories2 gotchas
categoriesAllIt is required to pass the filter[type] parameter to the request. For supplier categories, use the supplier value. For resource/spend categories, use the expense value. For revenue categories, use the revenue value.
categoriesOneIt is required to pass the filter[type] parameter to the request. For supplier categories, use the supplier value. For resource/spend categories, use the expense value. For revenue categories, use the revenue value.
Departments1 gotcha
departmentsAllDepartments resource is not supported in Workday.
Invoice Items4 gotchas
invoiceItemsAllIt is required to provide transaction_type filter in the request parameters. If transaction_type is purchase, purchase-items will be returned. If transaction_type is sale, sales-items will be returned.
invoiceItemsAddIt is required to provide sold and purchased fields in the request body. If sold is true, sales-item will be created. If purchased is true, purchase-item will be created.
invoiceItemsOneIt is required to provide transaction_type filter in the request parameters. If transaction_type is purchase, purchase-item will be returned. If transaction_type is sale, sales-item will be returned.
invoiceItemsUpdateIt is required to provide sold and purchased fields in the request body. If sold is true, sales-item will be created. If purchased is true, purchase-item will be created.
Invoices2 gotchas
invoicesAddIt is required to provide tracking_categories.id in the line items, which corresponds to the worktag/cost_center_id in Workday. It is required to provide the item.id in the line items.
invoicesUpdateIt is required to provide tracking_categories.id in the line items, which corresponds to the worktag/cost_center_id in Workday. It is required to provide the item.id in the line items. Workday only supports sales_item and service types for line items and this is required.
Journal Entries2 gotchas
journalEntriesAddStatus should be set to "draft" or "posted". Default status is "draft".
Only Journal Entries with draft status can be updated.
It is required to provide Cost_Center_Reference_ID as worktag in the line items, otherwise the status will automatically be set to "draft".
journalEntriesUpdateStatus should be set to "draft" or "posted". Default status is "draft".
Only Journal Entries with draft status can be updated.
Purchase Orders3 gotchas
purchaseOrdersAllWhen using the supplier_id filter, the updated_since filter should also be included.
purchaseOrdersAddIt is required to provide supplier.id, issued_date, company_id. Required fields for line items: tracking_categories.id (maps to Workday worktag/cost_center_id), description, category_id, budget, total_amount and type (must be either sales_item or service). For sales_item type, it is required to provide quantity, unit_price and unit_of_measure.
To create a purchase order with a status draft, you need to provide the status field with a value draft. Default status is open (approved).
purchaseOrdersUpdateIt is required to provide supplier.id, issued_date, company_id. Required fields for line items: tracking_categories.id (maps to Workday worktag/cost_center_id), description, category_id, budget, total_amount and type (must be either sales_item or service). For sales_item type, it is required to provide quantity, unit_price and unit_of_measure.
Note: Only purchase orders with status draft can be updated.
Suppliers1 gotcha
suppliersAddIn Workday, the supplier_category, display_name, addresses, emails, company_id, currency, terms, and payment_method fields are required to create a supplier. display_name and company_id should be same.