Quickbooks Enterprise - ETL Transaction Pickup Issue
The nuts and bolt of the issue is our Quickbooks ETL logic is not picking up edits made by end users. We are wanting to pick up the latest transaction. We validate or process on the date and transaction number field. So say there is transaction number (TN) 123 on 1/29 and TN 124 on 1/30. If the user edits then edits 123 it is the latest transaction but the transaction number remains 123 and our logic doesn't pick that up. It still thinks 124 is the latest. Has anyone encountered this and solved this before?
Best Answer
-
From looking our QB ledger, I can see where you're coming from on this. Instead of using your logic to keep an eye out for the MAX() of TN#, I'd switch it to looking at the most recent Last Modified datetime stamp. You could also use the Rank & Window ETL to get it to rank the last #x transactions and that would allow you to always spot the most recent TN (with a Rank of 1), or would even allow you to view the last 10 edited transactions (if you set card filter to a Rank <= 10).
0
Answers
-
From looking our QB ledger, I can see where you're coming from on this. Instead of using your logic to keep an eye out for the MAX() of TN#, I'd switch it to looking at the most recent Last Modified datetime stamp. You could also use the Rank & Window ETL to get it to rank the last #x transactions and that would allow you to always spot the most recent TN (with a Rank of 1), or would even allow you to view the last 10 edited transactions (if you set card filter to a Rank <= 10).
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive