NRAO Home  >  Green Bank  |  Wiki Topic:    GB > Software > PlanOfRecordC72006 > BusinessOfficeSystem
   Changes | Index | Contents | Search | Statistics | Go

Business Office System



Introduction

This is the new page for the Business Office System project, previously referred to as the Reservations project.

Background and Documentation

The Business Office System Project Charter can be found at the bottom of this page.

The old wiki pages for this project can be found here:

BOS v1.0 options (replacing BARS without external interfaces)

The idea has been floated to go ahead and replace BARS without the external interface requirements (People Soft and the NRAO User Database). In order to determine the efficacy of this idea, work estimates need to be made for completing such a replacement. Below we outline three different options and their work estimates:

1. Reservations Only

2. Reservations, Invoicing, & Receipting

3. Reservation, Invoicing, Receipting & People Management

MetaMR for BOS

ModificationRequest9C107

Status

To Do

All

Item note Priority done?
Upgrade SQLAlchemy Ray's working on it - are there speed issues? 1 DONE
Pagination A-Z menu on Contact Management page done. 2  
Refactor code to share between modules better   3  
start some docs other then schema! See BosDocs 2 DONE
speed optimizations wait to see if production server is as slow. Ray's lazy=True fix 1 DONE
include Bill's graphics   1 DONE
work on main menu   1 DONE
make titles and headers consistent User and Res done; now Trans too 1 DONE
Run through examples ourselves before submitting to official sponsor testing   3  
User account creation for a person already in the database. Do we still need to do this? 2  
Use benchmarks in TG   2  
create cronjob for int unit tests   2 DONE
get unit tests to work from top of branch   2  
reconcile constants in InitTestDB.py with out of date InitDB.py   3  

Bugs

Discovered after sponsor testing began.

Item note done?
Socorro mispelled in Site table Just change it in InitTestDB? DONE

Sponsor Suggestions

Item Response done?
Required fields known to user before Entering Perhaps by bolding required labels?  

Res Management MR

Bugs

Discovered after sponsor testing began.

Item note Priority done?
End dates before Starts date Fixed in about 10 forms using validators.Schema, however, the feedback needs to be cleaned up. The manage res page was an exception: simply swapping dates when they are backwards. 1 DONE
'finalized' mispelled in main res screen Oops! Wonder who did that? 2 DONE
external visitors should not be able to create Invoices from res fixed with a simple if statement 1 DONE
Cancel Redirects doesn't know how to get from a Travel Info edit form back to viewJourney Add this case to Root.cancelRedirect() 1 DONE
Auto-created accounts (using Root.requestUserAccount()) allow for empty person records. This causes errors in Make new res   1 DONE
Creating new reservation as Admin allows creation of an empty reservation. This causes a crash when this reservation's ID is used to create an invoice. Fixed with a new validator method in ValidResForDebit? to check for finalized reservation 1 DONE
Buildings and Rooms for assignment aren't linked to a specific site   1  

User Management MR

Item note Priority done?
Deleted contact records and person records is not good for referential integrity. All remove controllers should enable a hidden flag but keep the record. 1 DONE

Bugs

Discovered after sponsor testing began.

Item note done?
International Provinces can't be specified Solution not ideal, but was a quick fix: new field in form, w/ clarifying instructions. Only checks that both US State and Intl Province arent being used at the same time DONE
Is Postal Code being a required field bad for Int'l addresses? maybe not a bug  
Auto-created accounts (using Root.requestUserAccount()) confirmation email contains wrong link for account activation.   DONE
SOC needs more buildings in DB BUG: buildings should be associated with sites DONE
Buildings printed at bottom of phone list   DONE
Adding new contact with same user name as existing contact crashes    

Sponsor Suggestions

Item Response done?
Time Zones confusing - seems that are validated, but what's the correct format? Drop down? Yes and done. DONE
Add Observatory to Organization type easy enough - that's what we are after all. Its table driven so just add it to InitTestDB?. DONE
Assigning a user name and password to each employee. They don't have to do this now.    
Edit and/or add a new location when a new employee is entered.    
All the information needed for a new employee in one add person form.    
The single page phone list prints last name and first name on 2 lines. Make the columns wider?    
Get all Socorro buildings in table found at bottom of BARS printout DONE
User Manual: guidelines for username & password creation when adding new person, and procedures (like notifying them via email) perhaps we can add tools to make this easier (auto-generated email notification?)  

Transactions MR

For Sponsors

Item note done?
Use LEFT JOIN in manage trans query need latest SQLAlchemy DONE

Finish Reports though there are questions on some DONE
Manage Transactions: filter by type   DONE
Manage Transactions: filter by Org Name, Person First Name need First Name? DONE
Manage Transactions: diplay Org Name   DONE
Manage Transactions: make BOS ID link to printable transactions   DONE
Add more Reservations, Transactions in InitTestDB? to make Reports more realistic    
Run through examples before submitting for Sponsor Testing    
make templates prettier - imporve CSS usage   DONE
test out on ie browser done for version 0.2.1 DONE
For Int Dept Sale printout, print Charge Accounts   DONE
When Customer is selected for transaction, init contacts w/ their defaults needs better unit tests DONE
Need way to blank out customer name in transaction   DONE
Printables of transactions need dollar format   DONE
Undeposited Receipts ready for deposit should also be only Ready and/or Entered   DONE
Journal Entries: put in additional check that only transactions from the site of the admin can be put in a JE   DONE
Receipts Summary Report: include site "All"   DONE
Include site and type for Item Definition screens no way to manage Item Definition Types - thats OK DONE
Validate transactions as they move from Not Ready to Ready   DONE

Refactoring

Item note done?
split up widgets.py into separate modules   DONE
improve widget reuse see New Transactions DONE
replace all identity.not_anonymous to identity.inAdminGroup   DONE
update schema doc    
more unit tests!    
bug with default browse transactions kwargs - prob w/ datetimes   DONE
grep through code and look for BUG and see if it can be addressed    
implement accounts cronjob, with possible use of valid flag in table   DONE
get all files, classes, objects to use consistent nameing scheme only a few offendors  
some things in templates could be refactored out using widgets, like title and error msgs in transactions    
Unit tests not working for JEs in sqlite only at model layer DONE

Bugs

These have been found since sponsor testing began

Item note done?
JE's for A/R receipts wrong see updated MR - this has not yet been fixed, but JE now has unit tests DONE
JE's for Receipts die when there is no customer new unit test DONE
Accounts not being updated valid flag not being set for new accounts DONE
An Int'l address doesn't show up in customer contacts for transaction it was problem with no state specified DONE
Item Defs that use invalid accounts shouldn't show up in Item Definition searches   DONE
Add more Item Def Types see email from Lisa DONE
Browse Item Definitions has mispelled Definition   DONE
Item form Qty -> Qty/Charge to match transaction printout DONE
First line of Remit Address should be NRAO   DONE
'Debt' in JE CSV file should be 'Debit'   DONE
AR Receipt created from Invoice w/ out contact info crashes wrote unit test for this, but doesn't crash!  
AR Receipt should use same contact info used by Invoice   DONE
In all printout headers, 'science' mispelled   DONE
Receipt Summary Report: multiple payments need to be shifted to right by 2 columns   DONE
Bank Deposit crashes if bilss + coins != cash done! DONE

Sponsor Suggestions

Item Response done?
Default Note text per site would be nice and pretty easy DONE
Include next to Transaction Print button, Create JE and Delete Delete done, JE a bit trickier  
Printouts: Notes should be bold and up top   DONE
Charge Account authorizations was talked about in meetings, but did not make it into any MR It's in the reservation request DONE
In Manage Transactions, searching by range of BOS ID would be good    
Dates in reports should have form Month/Date/Year   DONE
For User Manual: before deleting a transaction, add why in the Note    
Receipt Summary Report: add payment detail easy DONE
Receipt Summary Report: get rid of item total easy, but left in until add item accounts is done  
Receipt Summary Report: add item accounts this will be a big rework  
"View Undepositied Receipts" -> "Create Bank Deposits" button   DONE

Questions for Sponsors

Q A
Need input on exact format of transaction printouts no major comments yet, except above bugs
Do we need to validate transactions before they go from Not Ready to Ready? this will save problems of trying to enter incomplete Transactions into PS Yes! - send Christine notes on what gets validated.
No mention of the Payor in MR Requiements. Needed?  
Due Date for Invoice? (again , not in reqs.)  
Item Definitions can make life easier. What's the best way to manage them? include site, type in filter
Do the reports, specifically the receipts one, make sense? If not, how to improve? discussed, see above changes, and below future changes

Features for future BOS Releases

Refactored To Do List

Can be found here.

Dec 6, 2007, BOS Meeting with new To Do List

Summary of meeting with resulting To Do List.

Attachment: sort Action: Size: Date: Who: Comment:
ReservationSystemV3_5.doc action 8011264 29 Sep 2006 - 21:53 PaulMarganian  
BusinessOfficeSystemV1.doc action 8114688 13 Dec 2006 - 16:24 PaulMarganian  
BusinessOfficeSystemV3_1.doc action 7983104 15 Dec 2006 - 16:46 PaulMarganian  
BusinessOfficeSystemv4.doc action 5864960 22 Dec 2006 - 19:56 AmyShelton Business Office System Project Charter, v4.0

Topic BusinessOfficeSystem . { Edit | Attach | Ref-By | Printable | Diffs | r1.59 | > | r1.58 | > | r1.57 | More }
Revision r1.59 - 08 Dec 2007 - 11:32 GMT - PaulMarganian
Parents: PlanOfRecordC72006
Content copyright © 1999-2007 by the contributing authors.
All material on this collaboration platform is the property of the contributing authors.