Renewing the City Business License: Difference between revisions
Jump to navigation
Jump to search
TJSomething (talk | contribs) (Fix SQL formatting) |
TJSomething (talk | contribs) (Censor email) |
||
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<ol> | |||
<li>Open https://aca-prod.accela.com/ONE/Default.aspx in Chrome. The site just works in Chrome.</li> | |||
<li>Login with the account for chair@.</li> | |||
<li>Open the '''Business Licensing and Events''' tabs.</li> | |||
<li>Click '''Renew License''' on the line with the most recent license that starts in "R".</li> | |||
<li>Click '''Add Gross Receipts'''.</li> | |||
<li>Run the following SQL query, with XXXX for last year and YYYY for the current year.</li> | |||
<pre>SELECT SUM(amount) FROM `payments` | |||
date > ' | WHERE | ||
date < ' | date > 'XXXX-10-01' AND | ||
status = 'Completed'</pre> | date < 'YYYY-10-01' AND | ||
status = 'Completed'</pre></li> | |||
<li>Enter the resulting amount under '''Gross Receipts'''.</li> | |||
<li>Set the beginning date to 10/01/XXXX where XXXX is last year.</li> | |||
<li>Click '''Continue Application'''.</li> | |||
<li>Click '''Continue Application'''.</li> | |||
<li>Click '''Check Out'''.</li> | |||
<li>Click '''Checkout'''.</li> | |||
<li>Enter the name of a checking account signer, the email `[email protected]`, their contact info, and Wells Fargo checking account info.</li> | |||
<li>Click '''Pay $XX.XX Now''', but with the actual amount.</li> | |||
<li>Click '''Print receipt'''.</li> | |||
<li>Save that as a PDF.</li> | |||
<li>Click '''Continue'''.</li> | |||
</ol> |
Latest revision as of 21:21, 23 September 2023
- Open https://aca-prod.accela.com/ONE/Default.aspx in Chrome. The site just works in Chrome.
- Login with the account for chair@.
- Open the Business Licensing and Events tabs.
- Click Renew License on the line with the most recent license that starts in "R".
- Click Add Gross Receipts.
- Run the following SQL query, with XXXX for last year and YYYY for the current year.
- Enter the resulting amount under Gross Receipts.
- Set the beginning date to 10/01/XXXX where XXXX is last year.
- Click Continue Application.
- Click Continue Application.
- Click Check Out.
- Click Checkout.
- Enter the name of a checking account signer, the email `[email protected]`, their contact info, and Wells Fargo checking account info.
- Click Pay $XX.XX Now, but with the actual amount.
- Click Print receipt.
- Save that as a PDF.
- Click Continue.
SELECT SUM(amount) FROM `payments` WHERE date > 'XXXX-10-01' AND date < 'YYYY-10-01' AND status = 'Completed'