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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 605 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 696 Beast Mode
- 43 App Studio
- 39 Variables
- 660 Automate
- 170 Apps
- 442 APIs & Domo Developer
- 42 Workflows
- 6 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 31 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive