[x] Google Sheet located in the DTS Google Drive > ROW Portal > COS folder
[x] Google Sheet updated by Finance
[x] Check Data on each tab
Confirm Counts:
[x] AE (Austin Energy) Number of records to update: 1191
[x] ACC (Austin Convention Center) Number of records to update: 0
[x] ATPWD (Austin Transportation & Public Works) Number of records to update: 2200
[x] AWU (Austin Water Utility) Number of records to update: 2657
[x] CPO (Corridor Program Office) Number of records to update: 0
[x] PARD (Parks and Recreation Department) Number of records to update: 0
[x] WPD (Watershed Protection & Development) Number of records to update: 54
[x] Total Number of records being updated: 6102
Import Data:
[x] Import (Update) records, match on Combined ID & import Journal Voucher ID, Department Comment, and Payment Memo. Set Import Date to today (Review Instructions)
[x] Make sure the number of records being updated matches for all spreadsheets
[x] Filter records by Import Date and make sure the total number of records updated matches
Error Checking:
[ ] If inaccurate, check backend filter to see if any of the unmatched records are archived records and marked as Archived. The AMANDA data may be inaccurate, the script may be running incorrectly, or the Combined ID may be incorrect if the record amount does not match the number of Archived records.
[x] Also check for duplicate Combined IDs which could be duplicate records or have the wrong Combined ID, Fee Number, or Payment Number. These need to be reconciled with Finance.
[x] Notify Finance that the update task is complete (Teams or Email)
Confirm Data:
Confirm Counts:
Import Data:
Combined ID
& importJournal Voucher ID
,Department Comment
, andPayment Memo
. SetImport Date
to today (Review Instructions)Import Date
and make sure the total number of records updated matchesError Checking:
Archived
. The AMANDA data may be inaccurate, the script may be running incorrectly, or theCombined ID
may be incorrect if the record amount does not match the number of Archived records.Combined IDs
which could be duplicate records or have the wrongCombined ID
,Fee Number
, orPayment Number
. These need to be reconciled with Finance.