Bryan Beck

1. Community
2. Feature Requests
3. Connector Improvement: Workday Financial Management Need Key to Join Purchase Order Goods Line and Receipt Line Goods Item tables

Our customer needs to be able to identify which items from a purchase order have been received from the vendor.  The FiveTran ERD (https://docs.google.com/presentation/d/1BLjww5562F4iEf8NulgOCcMsQS...

• View comment
• Bryan Beck
• June 23, 2025 19:45
• 0 votes

1. Community
2. Feature Requests
3. Connector Improvement: Support processing_fee In Square Payments Table

Is there an update to this request to have processing_fee supported in the Payments table? Thank you!

• View comment
• Bryan Beck
• June 12, 2025 15:59
• 0 votes

1. Community
2. Feature Requests
3. Connector Improvement: Workday Financial Management Supplier Invoice Adjustment table and Supplier Invoice JOIN Yields Too Many Rows - Suggest Using GUID

I just found another field that we can join on (see highlights in SQL below).  This is not intuitive based on what is shown in the ERD, but it works.  This ticket can be closed.   SELECT count(*) F...

• View comment
• Bryan Beck
• May 19, 2025 16:13
• 0 votes

1. Community
2. Feature Requests
3. Connector Improvement: Workday Financial Management Purchase Supplier Item and Supplier Table Join Results in Zero Purchase Items Mapped to a Supplier

Yes, there is data in both tables (the supplier id fields contain guid values).  The two queries below both return 0 records (the second one is my attempt at a workaround).   SELECT * FROM shca_sou...

• View comment
• Bryan Beck
• May 19, 2025 16:13
• 0 votes

1. Community
2. Feature Requests
3. Connector Improvement: Workday Financial Management Need Key to Join Purchase Order Goods Line and Receipt Line Goods Item tables

Yes, we have access to the goods_purchase_order_line_id field in the PURCHASE_ORDER_GOODS_LINE table.  However, this field does not contain values that would allow for a join to the RECEIPT_LINE_GO...

• View comment
• Bryan Beck
• May 19, 2025 16:12
• 0 votes