Kuali Cloud Internal test 1-Maint-Pur, AP, Vend, PDP, Checks


Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?

Purchasing-Accounts Payable-Vendor

Maintenance







Billing Address
EMicahTested search criteria. Able to edit (Edoc 12646292)
Yes 11/20/23
Capital Asset System State
Tested search criteria. Able to edit (Edoc 12646292)Alton

Yes (4/10/2023)
Capital Asset System Type

MicahTested search criteria. Able to edit (Edoc 13761329)
Yes 11/20/23
Carrier
Tested search criteria. Able to edit (Edoc 12646293)Alton

Yes (4/10/2023)
Delivery Required Date Reason

MicahTested search criteria. Able to create new and edit (Edoc 13761343)
YEs11/27/2023
Electronic Invoice Item Mapping
Tested search criteria. Able to edit and copyAlton

Yes (4/10/2023)
Electronic Invoice Upload


ignore - replaced by HuskyBuy interface
N/A
Funding Source

On Hold - Not Ready for Testing

6/7/23:  Funding Source was removed from Kuali base on 8/8/2022 release.




N/A
Item Reason Added

Micah

3/17/23
Item Type
Tested search criteria \. Able to edit and copyAlton

Yes (4/10/2023)
Method of PO Transmission

Bruce

Y 4/5/23
Negative Payment Request Approval Limit

Search results match PRD. Able to create, copy, deactivate.

Trouble testing limits, payment request isn't auto-approving, could be because initiated in KFS not HB?Brett tested oka

Organization and Account shows up as '...' in search results when populated. ok? 

Brett tested okay 7/5/23

Bryon

Y 7/5/23
Organization Parameter

Bruce

Y 4/5/23
Payment Request Auto Approve Exclusions

Bruce

Y 4/5/23







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Purchase Order Batch Defaults
tested add, copy, edit, search - all workedBruce

Y 4/4/23

Purchase Order Contract Language
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Purchase Order Quote Language
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Purchase Order Quote List
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Purchase Order Quote Status
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Purchase Order Type
tested add, copy, edit, search - all workedBruce


Y 4/4/23
Purchase Order Upload
ignore - replaced by HuskyBuy interface


N/A
Purchase Order Vendor Choice
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Receiving Address

Bruce

Y 4/5/23
Receiving Threshold
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Recurring Payment Frequency

Bruce

Y 4/5/23
Recurring Payment Type

Bruce

Y 4/5/23
Requisition Source
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Sensitive Data
tested add, copy, edit, search - all workedBruce

Y 4/4/23
Vendor Stipulation

Bruce

Y 4/5/23







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Vendor Maintenance
Not sure how important the Export Options are below.



Address Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Y 4/7/23
Campus Parameter
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Y 4/7/23
Chapter 3 Status
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/7/23
Chapter 4 Status
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Y 4/7/23
Commodity Code

Alton or Micah

Y 4/7/23
Contact Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/7/23
Contract Manager
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Y 4/11/23

Cost Source
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/11/23
Ownership Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/11/23
Ownership Type Category
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/11/23
Payment Terms Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Y 4/11/23
Phone Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Y 4/11/23







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Shipping Payment Terms
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (4/17/23)
Shipping Special Conditions
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (4/17/23)
Shipping Title
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (4/17/23)
Supplier Diversity
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (4/17/23)
Vendor Inactive Reason
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (4/17/23)
Vendor Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah


Yes (4/17/23)
Vendor Hold Code

Alton or Micah

Yes (4/17/23)
Vendor Exclusion


No data in the system for this.

8/15/23 this is not a separate process.  not needed.


N/A
Vendor Exclusion Debarred Unmatched

Alton or Micah8/15/23  debar flag is tested within Vendor maint.  exclude and unmatched not used.
N/A
W-8 Type
The Export Options for this item only includes CSV. No XML or Spreadsheet option. Same as Monsters.Alton or Micah

Yes (5/9/2023)







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Purchasing Administration





Purchase Order Upload (XML)
ignore - replaced by HuskyBuy interface


N/A
Purchase Order Upload (CSV)
ignore - replaced by HuskyBuy interface


N/A
Electronic Invoice Upload
ignore - replaced by HuskyBuy interface


N/A
Electronic Invoice Test File Generation
ignore - replaced by HuskyBuy interface


N/A
Vendor Exclusion Upload
ignore - replaced by HuskyBuy interface


N/A


Huskybuy classification CSV UploadN/A

Under Vendor > Administration

ignore

Brett - Is this on our list to externalize to KFS and put in Financial Web APIs?




N/A







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
PDP / Check Maintenance





Accounting Change CodeMedium

Brett/ Micah




Yes, 5/2/2023
ACH BankMedium
Brett/ Micah

Yes, 5/2/2023
ACH Transaction CodeMedium
Brett/ Micah

Yes, 5/2/2023
ACH Transaction TypeMedium
Brett/ Micah

Yes, 5/2/2023
Customer ProfileMedium
Brett/ Micah

Yes, 5/2/2023
Disbursement Number RangeMedium
Brett/ Micah

Yes, 5/2/2023
Disbursement TypeMedium
Brett/ Micah

Yes, 5/2/2023
Format Checks/ACHHighSequence # for the Process ID seems to be out of order/reset.   Process will not finish and had to be cleared.   Opened Jira.Brett/Bruce


https://kualico.atlassian.net/browse/FINUCONN-492 (resolved)

7/25: format checks working for variety of types. also did cancel/reissue and this worked properly.

Y 7/25/23
Format ResetHigh
Brett

Yes 7/5/2023
Format SummaryHighScreen mostly works except if you do a search on process id and try to return value.  Opened a Jira for thatBrett/Bruce

https://kualico.atlassian.net/browse/FINUCONN-493 (resolved)

7/25/23:  tested search by date and search by process ID, both worked successfully.

7/25/23







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Payee ACH AccountHigh

Search results match PRD. No option to create/edit. 

Batch Bypass Indicator is a filter field available in PRD but not sandbox.

used chn08005 - feature was not available for user, ahl05001 worked

Bryon


Y

4/7/23

Payee TypeMedium

Search results match PRD. No option to create. Editing was successful.

use btp98001 - did not need

Bryonable to edit successfully.  cannot create new but this is not available in KFS-UAT either.

Y

4/7/23

Payment Bank HistoryMedium

Search results match PRD. No option to create/edit.

use btp98001 - did not need

Bryon

can't edit or create new,

view only - works same as KFD-PRD


Y

4/7/23

Payment ChangeMedium

Search results match PRD. No option to create. Editing was successful.

use btp98001

Bryon able to edit successfully.  cannot create new but this is not available in KFS-PRD either

Y

4/7/23

Payment File Batch UploadMedium5/3 (bruce):  tried to upload a Concur xml file.  Payee is in the payee file and was able to see prior payments (search for pmts).  upload failed with 'customer not found' error.  payee was not in Person file.  not sure if this requires a Jira ticket?

7/5 - Still Broken - Looks like there is a problem between the chart and campus change that they did.   Opened Jira.
Brett/Bruce

https://kualico.atlassian.net/jira/software/c/projects/FINUCONN/issues/FINUCONN-498 (resolved)

https://kualico.atlassian.net/browse/FINUCONN-446 (not sure if this is still an issue)

8/16:  retested with three payment files - all taken from Concur PRD SAE's.  changed the XML header "chart" tag to be "campus" on all three.  On two files, I left the "campus" value as "UC", on the third file I changed the "campus" value to be "01".  All three were successfully processed through all pdp steps and posted correctly to the GL.  Base accepted the "UC" code even though it's not in the campus code table.  Passed.

Will ask Lesley and Brett about FINUCONN-446.  Also, I am creating a Jira for Paul Morano to change the SAE account batch job to create the xml with the "campus" tag rather than "chart", but to still use the "UC" as the value in that tag.


Y 8/16/23
Payment Spreadsheet UploadLowused for settlement and one off paymentsBruce


7/24: payment xls uploaded successfully.  test file name is XLS-Pmt-Upload_test_reimbursement-072423.xlsx.  But upon checking GL postings the next morning, found that GL entries were NOT created for the object code identified on the spreadsheet, but rather to 2100-Accounts Payable.  See FINUCONN-508


Payment Terms? TypeMediumSearch results match PRD. Able to create/copy/edit/deactivate. Tested with Payment Request.Bryoncan edit OK but can't create new.  SAME AS 5.3

Y

4/11/23

Payment StatusMedium

Search results match PRD. No option to create. 

should we create JIRA for description length - although works the same in UAT, 5.3

5/3 (bruce):  I retested in both sandbox and UAT.  got the same exception error when entering description GT 25 char.  No warning msg was given.  re-entered w/ 25 char. and that went final.  No "Create" function is in UAT.  I'm passing this since it works that same way as current.  If a longer description is needed, we can create a ticket for KualiCo, but since we've been ok with 25 char. limitation so far, that should be OK.

Bryon

Bruce retest

can edit OK but can't create new.  Also, description limit is 25 char but does not check for that in entry.  causes exception error.  But is SAME AS 5.3

Y

5/3/23

Search for BatchHighIn sandbox, this search includes Campus in the lookup instead of Chart. Alex

FINUCONN-427

7/24/23: This was not yet changed to resolved, but I tested since it's the same issue as 428, Search for Payment.  Tested successfully for several combinations of search fields.  Same note as Search for Payjment, that the campus code contains our chart (UC) for pre-cloud batches.

Y 7/24/23
Search for PaymentHighIn sandbox, this search includes Campus in the lookup instead of Chart. It also includes Disbursement Bank Code as a searchable field.Alex

FINUCONN-428 (resolved, ready to retest using campus code)

7/24/23:  retested successfully. tested 11 different combinations of search fields, all worked successfully.  note that campus code contains our chart code for pre-cloud payments (UC).  this can be entered and found when searched on.  passed

Y 7/24/23







Maintenance/Reference/Admin eDoceDoc codeCommentsAssigned ToNotesJIRAComplete?
Check Administration





Check LayoutLowStack trace when initiating.  5/25:  OK - submitted eDoc fine, went to final status w/ no issues.Alex/Bruce


FINUCONN-414 (fixed) retest OK


Y

5/25/23

Check Reconciliation Bank UploadHigh

Gateway timeout when adding file.

voided checks

marked checks as stale

tested scenario where check # or amount provided does not exist.

Alex

FINUCONN-415  (Deployed 7/6, ready to retest)