Exercises
Vendor
Create A vendor
- Go to Vendor under Core
- Click on
- Let the Vendor # auto assign
- Vendor Name = Sara's Training Service
- Default Payment Type = electronic
- 1099 ID = 123-45-6789
- 1099 Type = Nonemployee compensation
- Email address = glore@nwoca.org
- Create a Default PO Location
- Click on Create (under locations section)
- Name 1 = Sara's Training Service
- Address Line 1 = 123 NWOCA Drive
- City = Archbold
- State = OH
- Zip = 43502
- Phone = 419-267-2547
- Check PO box
- Create a Default 1099 Location
- Click on Create
- Name 1 = Sara Glore
- Address Line 1 = 123 Sara Drive
- City = Archbold
- State = OH
- Zip = 43502
- Phone = 419-234-5678
- Check 1099 Box
- Click on Save
Vendor Search
- In filter row type in 'Sara' under Primary Name
- Click the X next to Sara in the Primary Name filter row
Find Active vendors
- In filter row type in 'true' under Active
- Click the X next to true in the Active filter row
Edit a Vendor
- In filter row type '%Kitchen% under Primary Name
- Click on to edit Kuston Kitchen Kleaners
- Change Default Payment Type to electronic
- Click on Save
Distribution/Error Correction
Create a Distribution
- Go to Distribution/Error Correction under Transaction
- Click on
- Let the number auto assign
- Date = 09/01/2016
- Description = Correcting Entry
- Click on to add line item
- Description = correcting account
- Amount = 100 (increasing expended by $100)
- Account, start typing in 200 – select Student Council Expenses
- Click on to add line item
- Description = correcting account
- Amount = -100 (decreasing expended by $100)
- Account, start typing in 200 – select Student Council Admissions
- Click on Save
Role
Create a Role
- Go to Role under Admin
- Click on
- ID = Student Activity Advisor
- Description = Student Activity Advisor
- Permissions
- USAS_REQUISITION
- USAS_VENDOR_REPORT & VIEW
- Permissions
- Click on Save
Account Filter
Create an Account Filter
- Go to Account Filters Under Admin
- Click on
- Filter = HS Student Council
- Order = 1
- TI = 00
- Fund= 200
- SCC = 9004
- Check mark R and P (R=read, P= Pre-encumbrance)
- Click on Save
User
Create a User
- Go to User Under Admin
- Click on
- Username = NWOCA_SG
- Name = Sara Glore
- Title = HS Student Council Advisor
- Email = glore@nwoca.org
- Assigned Roles = Student Activity Advisor
- Filters = HS Student Council
- Click on Save
Receipts
Create a Receipt
- Go to Receipts under Transaction
- Click on Create
- Receipt # = Let it Auto Assign
- Receipt Date = 09/09/2016
- Received from = Betty Crocker
- Description = Cafeteria Receipts
- Click on +
- Amount = 238.32
- Type = Receipt
- Description = Student Type a Lunch
- Account = 006 1512 0000 000000 000
- Click on +
- Amount = 6.45
- Type = Receipt
- Description = Student Milk
- Account = 006 1514 0000 000000 000
- Validate
- Post
Refunds
Create a Refund with check
- Go to Refunds under Transaction
- Click on Create
- Refund # = Auto Assign
- Refund Date = 09/08/2016
- Create a check = Yes
- Check # = Auto Assign
- Check Date = 09/08/2016
- Vendor # = 1113 Jack Jones
- Click on +
- Amount = 10.50
- Description = Over payment class fees
- Account = 001 1740 0000 00000 002
- Validate
- Post
Check number states 0 – physical check number is assigned when printed
Print Refund Check
- Go to Disbursements under Transaction
- In filter row type 'Jack' under Primary Name
- Check box beside Jack Jones' Refund
- Click on Print Batch
- Output type = pdf
- Start number = leave blank to auto assign physical check number
- Click on Print
Requisitions
Create a Requisition without a vendor
- Go to Requisitions under Transaction
- Click on Create
- Requisition # = TEST0022
- Vendor = do not add one
- Requested PO Date = 09/21/2016
- Deliver to Vendor # = 1000
- Attention = Mr. Principal
- Click on +
- Qty = 3
- Price = 7.89
- Description = Toner Cartridge Black
- Account = 001 2421 512 0000 000000 001 00 000
- Click on +
- Qty = 1
- Price = 33.95
- Description = Toner Cartridge Magenta
- Account = 001 2421 512 0000 000000 001 00 000
- Click on +
- Qty = 1
- Price = 7.99
- Description = Shipping
- Account = 001 2421 512 0000 000000 001 00 000
- Click Validate
- Click Post
Create a Requisition without an account code
- Click on Create
- Requisition # = TEST0023
- Vendor # = 2005
- Requested PO Date = 09/21/2016
- Deliver to Vendor # = 1000
- Attention = Mrs. Treasurer
- Click on +
- Qty = 1
- Price = 256.30
- Description = Computer Table #4349
- Account – leave blank
- Click Validate
- Click Post
Convert a Requisition
- Go to Requisitions under Transaction
- Search for Requisition with a date between 09/01/2016 and 09/30/2016
- Sort by Date
- Click on Requisition #TEST0022
- Click on Convert
- Add vendor = #2000, Office Max
- Click Validate
- Click Post
Mass Convert Requisitions
- Go to Requisition under Transaction
- Search for Requisition with a date between 09/01/2016 and 09/30/2016 and that has not been converted
- Check box beside TEST0021, TEST0014 and TEST0015
- Click on Convert
- Starting PO Number – Auto assign
- PO Date = Requisition Date
- Click on continue
- Shows summary of converted requisitions and PO #
- Click on Print
- Output Type = PDF
- Click Print beside the output type
- Click Return to Query Page
Purchase Order
Create a Purchase Order that is non-vendor specific
- Go to Purchase Order under Transaction
- Click on
- PO # - Auto Assign
- Date = 09/01/2016
- Vendor = Leave Blank
- Delivery Address = Sampleville City Schools, 389 Maple Lane, Sampleville, OH
- Attention = Mrs. Café
- Click on +
- Qty = 1
- Description = Dishwasher Repair
- Unit Price = 34.57
- Charge = 006 3120 423 0000 000000 000 00 000 – Equipment Repair
- Click on Save
Create a Purchase Order with Split Items
- Click on
- PO# = Auto Assign
- Date = 09/01/2016
- Vendor = %Office% - choose Office Max
- Delivery Address = Sampleville City Schools, 389 Maple Lane, Sampleville, OH
- Attention = Mr. Smith
- Click on +
- Qty = 30
- Description = Reading books
- Unit Price = 10
- Click on to split Quantity
-
- Qty = 15
- Unit Price = 10
- Account = 001 1132 520 0000 0000000 003 05 000
- (use hyphens between dimensions)
- Click on +
- Qty = 15
- Unit Price = 10
- Account = 001 1132 520 0000 000000 003 06 000
- (use hyphens between dimensions)
- Click on Accept
- Close pop up box
-
- Click on +
- Qty = 1
- Description = Printer
- Unit Price = 75
- Click on to split Price
-
- Qty = 1
- Unit Price = 25
- Account = 001 2421 512 0000 000000 001 00 000
- (use hyphens between dimensions)
- Click on +
- Qty = 1
- Unit Price = 50
- Account = 001 2421 512 0000 000000 002 00 000
- (use hyphens between dimensions)
- Click on Accept
- Close pop up box
-
- Click on Save
Modify a Purchase Order
- In filter row type in '09/01/2016' under Date
- In filter row type in 'true' under Invoiceable
- Click on PO# in filter row to sort by PO#
- Click on beside 2900017
- Clear out vendor – type in % S
- Choose 2007 – S & F Bus Parts
- Click on Save
AP Invoice
Create an invoice for a non-vendor specific PO
-
-
-
- Go to AP Invoices from Transaction
- PO # = 2900045
- Click on Invoice
- Invoice # = 12-3456
- Vendor # - 2003 Kuston Kitchen Cleaners
- Invoice Date = 09/10/2016
- Payment Due Date = 09/10/2016
- Amount = 5.69
- Status – partial
- Validate
- Post
-
-
Invoice Listing
- Go to Detail under Report
- Choose InvoiceItem
- Check mark the following:
- Amount
- Outstanding
- Expand Account – full account code
- Expand Invoice - number
- expand source – purchaseOrderNumber
- expand vendor – primary name
- Click Next
- Sort by Vendor: Primary Name =1
- Control Break
- Sum Invoiceitem Amount
- Click Next
- Filter by Primary Name = COMPUTER RESOURCE CENTER
- Click Next
- Format – PDF
- Letter
- Portrait
- Click Generate Report
- Check mark the following:
Payables
- Go to Payables under Transaction
- Click Vendor tab
- Verify COMPUTER RESOURCE CENTER to InvoiceItem Report
- Check mark the box beside COMPUTER RESOURCE CENTER
- Click Post Selected
- Disbursement Date = 09/15/2016
- Grouping options = Vendor
- Sorting options = Vendor Number
- Bank Account = 1- Default Bank Account
- Click on Post
- Click Print
- Check Mark desired disbursements
- Click Print Batch
- Output Type = PDF
- Start Number = leave blank to auto assign
- Click on Print
- Uncheck mark Physical check # 5016 for Computer Resource center
Disbursement
Reconcile
- Go to Disbursement under Transaction
- In the filter row type 'Dunham' in the Primary Name
- Check Mark all
- Click on Reconcile
- Reconcile date= 09/30/2016
- Click Reconcile
- Uncheck mark all
Unreconcile
- X out the text in 'Primary Name' in the filter row
- In the filter row type 'Reconciled' in the Status
- Check Mark physical check # 5013
- Click on unreconciled
Void
- X out the text in 'Status' in the filter row
- In the filter row type '5012' in physical check number
- Check Mark physical check # 5012
- Click on Void
- Void Date = 09/30/2016
- Check Mark Void invoice Items
- Click on confirm
- Uncheck mark physical check #5012
Resequence
- X out the text in 'Physical Check #' in the filter row
- Click on Resequence
- Original Start Number = 5015
- Original End Number = 5015
- New Start Number = 5017
- Validate
- Close the informational box
- Post
- Close the informational box
- Close the resequence pop up
Report
-
-
-
- Create a similar report to BUDSUM, REVSUM and FINSUMM
- Go to Detail under Report
- See Classic USAS Report page handouts
-
-