search

kutting / msexcel-builder

A simple and fast library to create MS Office Excel(>2007) xlsx files.
MIT License
0 stars 0 forks source link

Track Cadre Per Diems & Payments: GSA Rates II #44

Closed kutting closed 9 years ago

kutting commented 9 years ago

Add GSA rates to Payments table, initialize GSA rate for all Paid invoices and start tracking the info

Upload historical data from Zac, if he provides it

kutting commented 9 years ago

Set the rate columns in [Cadre].[PerDiemsUpdateInvoiceFlags] when @IsInvoiceReadyForPayment is = 1. Use technique from [Cadre].[PerDiemsSearch]. XXXXXXXXXXXXXXXXXXXXX Doesn't work, because then there's no way for user to enter rates. Even if we restricted setting the rate to CONUS locations, still need way for users to enter non-CONUS rates...XXXXXXXXXXXXXXXXXXX Better approach is to initialize rates when creating records in [Event].[EventUpdateCadreAssigned], except pull it out to separate sproc in Cadre namespace. Allow updates to rates in Cadre.PerDiemUpdate. Modify PerDiem Update UI

Change [Cadre].[PerDiemsSearch] to lookup values from Cadre.PerDiem table instead of dynamically.

Maybe change [Cadre].GetPerDiem to look up the state code itself instead of relying on it as a parameter

kutting commented 9 years ago

New sproc: Cadre.EventCadreInvoicesDelete Cadre.EventCadreInvoicesInsert Cadre.EventCadreInvoicesUpdate

Modified sprocs: Cadre.PerDiemGet Cadre.PerDiemsSearch Cadre.PerDiemInsert??????????? No changes yet; probably need to allow user to enter rate as well as Days, or prevent user from entering Days. Cadre.PerDiemUpdate Event.EventUpdateCadreAssigned Event.EventUpdateCadreDeclined Event.EventUpdateCadreNotRequested

kutting commented 9 years ago

The effect of these changes is that now all GSA information is actually stored in Event Manager. In cases where payment doesn't actually include the GSA, it can be entered and stored in Event Manager. SO now Event Manager can figure out exactly the amount paid for every invoice.