Finance ➝ Financial Management ➝ Other - Breeze Processes
Provided by David Crowe from ticket https://rdasystems.freshdesk.com/a/tickets/135858
As I outlined in https://app.basecamp.com/3393734/buckets/1329045/todos/10267028344#__recording_10269514209, the process goes through the following steps:
The Build Breeze Account Codes process has several reports that run in order with one button click:
1. CLEARBREEZEACCOUNTINGCODES - sets every accounting_code_id -- the link to Breeze's accounting codes -- in 4.0's FINALIAS table to zero. This is necessary for the next steps.
2. GETBREEZEACCOUNTINGCODES - Goes through non-deleted accounting codes in Breeze, gets their IDs, and writes the IDs to 4.0. If there are duplicate account codes, the last one wins. If the accounting code doesn't exist anymore in Breeze or is marked as deleted, 4.0 won't think it's still there and possibly will overwrite another accounting code.
3. DELETEBREEZEACCOUNTINGCODES - Turns on the delete flag for all accounting_codes in Breeze so that if an account code is not in 4.0, it will not be in Breeze anymore, either.
4. DELETEBREEZEACCOUNTINGCODEDIMENSIONS - same thing as 3 for accounting code dimensions.
5. BUILDACCOUNTINGCODES - Writes account codes from 4.0's FINALIAS table to Breeze's accounting code table. If the FINALIAS record has an accounting code ID, 40 uses that ID, with the net effect that the existing accounting code has its delete flag that was turned on in step 3 is turned off and any differences, like description, are updated in Breeze. If the FINALIAS record does NOT have an accounting code ID, then a new record is created.
6. BUILDACCOUNTINGCODEDIMENSIONS - similar to 5 but it uses the ID from step 5.
First, note that everything with Build Breeze Account Codes is done through FINALIAS, the alias file, not the normal expenditure (FINEACC), revenue (FINRACC) or balance sheet (FINBACC) masters.
Next, note if one of the reports stops the chain and someone reflexively runs the button again, it's not going to fix anything; it'll just end up removing all the accounting code IDs from FINALIAS, OpenRDA's link to Breeze's accounting_code table, and then stopping, probably earlier.