Report Comparison Aptify vs Salesforce

VIDEO TRANSCRIPT | Recorded: 2025-10-09 | Verify against current system state

Abstract¶

Status update on the Aptify to Salesforce report comparison effort for finance. Gateway date field has been populated for all activated orders with legacy IDs. Demonstrates record count matching between systems (364 orders for test date). Next steps include modifying queries to use payment/gateway date instead of order date and comparing against Aptify deposit report.

Key Procedures¶

• Load gateway date values into Salesforce orders
• Verify gateway date exists for all activated orders with legacy ID
• Compare record counts between Aptify and Salesforce
• Update Trog's report to use gateway date field
• Rewrite validation queries to use payment date instead of order date
• Obtain and compare against Aptify deposit report

Notable Statements¶

• 0:00:16 "One of the issues is that... they wanted to use the gateway date, which is the date that the payment actually went to the gateway"
• 0:00:36 "They would be able to compare it against Braintree, our BluePay, and see the actual date that the payment went through"
• 0:00:56 "That didn't exist in Salesforce the way that they wanted it. So we had to actually load it up into the system"
• 0:01:10 "It exists for every single order that's been imported that is in the activated status and has a legacy ID"
• 0:01:24 "Trog is updating his report to use this new gateway date so that the numbers should match up to what finance expects"
• 0:02:14 "Everything that's an order master that has an order date of 5/17 is 364 records"
• 0:02:30 "There's also 364 records" (in Salesforce)
• 0:02:52 "What they want now is they want every order that was paid on this date, not just ordered on this date"
• 0:03:22 "It's not this, they're not wanting to see it by fulfillment date. They're wanting to see it by the gateway date, the payment date"
• 0:04:22 "This does not include cancellations. We still haven't been able to work with those"

Systems & Configurations¶

Systems Mentioned¶

• Salesforce (target system with new gateway date field)
• Aptify (source system, order master)
• Braintree (payment gateway)
• BluePay (payment gateway)

Specific Configurations¶

Credentials/Access Mentioned¶

None mentioned in this recording.

Vendor Contacts Mentioned¶

• Trog (updating Salesforce report)

Errors & Troubleshooting¶

• Issue: Cancellations not included
• Cause: Not yet worked into validation process
• Resolution: To be addressed in future work
• Timestamp: 0:04:22

Transcript Gaps & Quality Notes¶

• Brief status update (5 minutes)
• Screen sharing of queries not fully captured
• Trog's report update in progress
• Deposit report from Aptify needed for final comparison
• Payment date vs order date distinction critical for finance