Background

This page will track the answers that we received from the TouchNet experts.

UCI's TEST TouchNet Operation Center URL: https://test.secure.touchnet.net:8443/centraltest

Bookmark the original "clean" URL. Always use this URL, as the URL with all the parameters appended will stop working as time passes, since it includes a dynamic parameter that facilitates single-sign-on.
Realm: C21570
Usernames are prefixed with realm (e.g. C21570.doct)
Use Firefox or IE.
1. TouchNet Operation Center is not officially supported on Chrome. Has known issues running on Chrome
2. Note that the browser restriction is only for the Operation Center
3. Per Mathew Lindley, the mall/store/payment pages work on all browsers

TouchNet Users Guide

You can access TouchNet User Guides here: https://drive.google.com/open?id=1M0tH7DAR6DfPaLozfcTOt4J2dpwQn7Kb . This requires a UCI account.

The documentation includes:

Marketplace Users Guide - guide for both uStore and uPay
uStores Layout Guide - specific layout guide for uStores
uPay Technical Guide - specific guide for uPay

Credit Cards

Accepted Credit Cards

MasterCard
Visa
AmEx
Discover
1. Diners
2. JCB
3. China UnionPay

Test Credit Cards

Use future expiration date and any CVV code.

Card Type	Card Number	TouchNet Payment Gateway Report Card Type Display	TouchNet Marketplace Report Payment Method Display
MasterCard	5454545454545454	MC	MasterCard
Visa	4111111111111111	VISA	Visa
AmEx	343434343434343	AMEX	AmEx
Discover	6011111111111117	DISC	Discover
Diners	30333333333333	DINE	DinersClub
JCB	3553355335533553	JCB	JCB
China UnionPay	6223344556677888	CUP	ChinaUnionPay

uStore

How do I view my store?
1. You can view your store by going to “Marketplace Home” at the top of your left hand bar. Look for your store under the “Stores” section, and there is a “View Store” link towards the right.
(Cecilia Do) Is there only one shopping mall for our Marketplace account? Or can we freely create however many malls we need and include whichever stores in each mall?
1. 20150825 Mathew Lindley: Each customer had one mall. To have a separate mall you would need to purchase a separate instance of Marketplace.
(Cecilia Do) Configure store payment at:
1. Group Payment Methods
2. Store default payment methods
3. Product
(Cecilia Do) Configure shipping:
1. Must always create a shipping class
2. Even no shipping for store, must still create a shipping class a "None" option.
(Cecilia Do) Configure tax:
1. Use "default tax rate"
2. Store => Store Settings
  1. Turn on "Use Tax Service"
  2. Select "California" option
3. Can configure tax on the shipping
4. Can configure tax per product
(John Romine) How do I set the units for each item? For example, a product is a "box of 12 widgets" which costs $5. It's sold as $5/bx. The website only shows the $5 price, and doesn't indicate the units, which could be confusing for the buyer as to whether she's purchasing one unit or one box of 12.
1. 20150818 Mathew Lindley: On this I would use the short/long description to notify the customer that one box contains 12 widgets
(John Romine) How can I sell fractional quantities. For example, I sell jelly beans for $8/lb. Our smallest quantity sold is 1/4 lb, but we will sell any increment of that amount (e.g., 3-3/4 lbs).
1. 20150818 Mathew Lindley: There isn’t any really good way to do this in uStores. Again you could notify the customer in the descriptions that 1 unit =.25 lbs at $2/unit. Or you could even make the product as a donation product type and let the customer enter their price rather than having to choose a number of units, then simply say that the customer can enter as much money as they would like to pay and the rate is $8/lb.
(John Romine) How do I differentiate price by customer type. For example, we offer a student price, a staff price, a faculty price and an outside (public) price. This is different from offering per-item variable pricing/discount, since each customer can only purchase items of the correct type (no mixing selections) and the income goes into different accounts.
1. 20150818 Mathew Lindley: Since I-Rong has request an LDAP connection to make a private uStore, I would have a private student faculty and staff store, then also a public store that offer the same items. A more manual approach would be to have one store with one product for sale, then use modifiers to ask if the customer is a student, faculty, staff or n/a. collect name and credentials students and faculty/staff and manually validate this against reports. Whether one or the other is more feasible would depend on volume of transaction
(John Romine) For donation items, how do I add description next to the various donation amounts, for example: Gold $2500, Silver $1000, Bronze $500?
1. 20150818 Mathew Lindley: I would use the short/long product descriptions to describe the various donations amounts for example:
```
Thank you for your interest! Please choose from the donation values described below
Gold- $2500
Silver- $1000
Bronze- $500 
```
(John Romine) How do I have a multi-line input field, for example the lettering to be printed on a shirt is three lines long. Can I have a single text area input or do I need to have three single-line input fields?
1. 20150818 Mathew Lindley: It would be best to have three single line input fields limited in their characters to the limit offered on the t-shirts
(John Romine) For a job fair, companies who purchase our "Gold" package are allowed to bring an unlimited number of representatives. We need to collect the names of each representative so we can print badges for them. How do I add a text input field where the representatives names can be entered with an 'Add More' button where the customer can add as many additional input fields as needed.
1. 20150818 Mathew Lindley: uStores can’t do the ‘add more’ option. Depending on the largest possible amount of attendees anticipated, you could have as many optional text fields for ‘Attendee 1, Attendee 2, 3, 4, etc… and the customer could fill out as many as needed then leave the rest blank.
(John Romine) When we sell conference registrations, we want to optionally sell parking passes. The customer can buy as many parking passes as she wants, but only if she is buying a conference registration item. How do I set this up?
1. 20150818 Mathew Lindley: Offer these items only as additional items at checkout. This will still allow the customer to purchase as many as they would like.
(John Romine) How do I associate the "additional items" with their primary item? For example, if you pay for a conference registration, an additional item might be a conference t-shirt. The t-shirt purchase is only available to conference attendees. I tried adding an "additional item", but it shows up at checkout regardless of what items are in your cart (i.e., whether or not the conference registration was purchased).
1. 20150923 Mathew Lindley: That is correct. In this case the parent product would need to have it's own store to exclusive sell the child product.
(Cecilia Do) Can you delete a uStore/uPay as long as it hasn’t taken payments yet? And once a payment is taken, the store/site can only be disabled, not deleted?
1. 20150825 Mathew Lindley: Correct.
(Cecilia Do) It looks like uStore and uPay names are not required to be unique.
1. 20150825 Mathew Lindley: Correct.
(Cecilia Do) When a store is no longer used, we can only disable it? And it will forever show up on the Revenue by Merchant reports with 0 amounts?
1. 20150825 Mathew Lindley: Correct, although it will only show up with zero depending on how far you search back. If you haven’t used the store or site you can delete it.
(Cecilia Do) When a uStore's name is changed, the reports will display the new name, even for transaction data before the name change.
(Linda Snyder) 20150918 CD: Select "No" for Perform General Ledger Updates. That feature does not work for us since we do not have Banner or PeopleSoft.
(Cecilia Do on behalf of Chris Wong) A department is requesting to confirm with you that the store and product templates is a feature that will be rolled out this year. By templates, we mean that there is a store skeleton that we can copy/clone to make another store. The same concept applies to cloning products.
1. 20150917 Mathew Lindley: We have no plans to published pre-formatted templates, we are actually looking rather at cloning. We have no set date for store cloning, the answer right now I get is “maybe in the future”. On the other hand, product cloning is scheduled to roll out in late October. In a sense, being able to clone a product allows you to create your own templates rather than relying on TouchNet to create the template you want, so I think this should be very helpful to our schools.
  
  -Note: The TouchNet can do product clone in the same store since 20161123. However, it is not possible to clone products across the stores.
How to clone product in a Store?
First go to your Store and then select the Product on the left menu-bar. After that, select the corresponding product to clone as shown in the picture below:
(Cecilia Do on behalf of Linda Snyder) I understand that TouchNet has monthly maintenance. Are we able to request for uninterrupted service during our peak payment period? For example, the period 2-3 weeks where students make an SIR (Student Intent to Register) payment is critical. Can we request for uninterrupted service during those weeks?
1. 20150916 Michelle Sullivan: You are correct, we do have monthly maintenance that occur on Wednesday. Unfortunately it is a datacenter-wide activity and we cannot pull certain schools from this. I apologize for any inconvenience this may cause.
(Dianne Bean) 20150928 Mathew Lindley: Adding new merchants / uStores / uPay sites does NOT require any kind of restart. As soon as they are created, they will show up.
How to view reversals (voids/refunds) in reports
1. Marketplace Reports » Stores » <store name> » By Product
 1. Input date range
 2. Product drilldown will list out individual transaction and refund lines
(John Romine) 20150922: I'm having some problems with TouchNet Marketplace on the Chrome browser. This is with Chrome version 45.0.2454.99 on Windows 7 but I have encountered the same issue under ChromeOS. Both these operations work correctly under Firefox 38.
1. In the Engineering Store, under FABWorks, attempting to add a product to the cart results in the product not being added, and a message saying You have no items in your cart.
2. In the admin interface, in Engineering Store General Settings, attempting to change any setting does not work. The selected form control is simply reset and loses focus. For example, trying to change Store Home Page Layout results in the select box immediately closing without allowing a selection change.
3. (John Romine) 20150923: Yes, I was able to verify that you have fixed the problems both with adding items to the cart, and with making changes in the the admin interface (in the TEST store). This was tested with Chrome 45.0.2454.99 on Windows 7, and also with Chrome 45.0.2454.86 (64 bit) on ChromeOS.
(Cecilia Do) Regarding going live. 20150930 Mathew Lindley (in red)
1. For uStore, there is a preview mode that allows us to see the stores look-and-feel without it being accessible by customers? Correct
2. Is there a way to test to the point of authorization and viewing reports? I’m guessing the store needs to be enabled, and the department can use their own real card to make an authorization, view the reports, and do a same-day reversal.
  1. That is also correct. Since you are launching, it is fairly safe to enable the store to make some test runs since none of your students will know how to get to the stores until you start making the store URLs available.
(Linda Snyder) The “Site Email Address” item in “General Settings” of the Miscellaneous page…. Is this for administrator announcements/alerts? Or is this for users to submit queries?
1. Used as the contact e-mail address on e-mail confirmation messages to the customer. In addition, warning messages for posting URL failures, GL update failures, and recurring payment failures are sent to this e-mail address.
(Cecilia Do) For the “Registered Users” functionality in Marketplace, are these accounts on the Marketplace level? Or is it for each individual store? For example, when I register and create an account on uStore A, can I use this same account in uStore B? In the mall?
1. 20151009 Mathew Lindley: Registered Users are system wide.
2. 20151009 Mathew Lindley: That means any store where Peter the Anteater can gain access and where you are allowing Registered users to log in (in your Single Stores settings) that Peter would be able to use his saved payment methods and shipping address. Register Users really don’t have so much to do with access as they do with saved information for return shopping.
Department notification for product sold?
1. 20151012 Mathew Lindley: There are two ways to do this which offers different granularity:
  1. A store manager can opt to receive emails on all products by going to "Edit My Profile" on the left hand menu.
  2. At the product configuration level, can add email addresses for "Product Notification". Can be configured for each option combination (e.g. stock number)
    1. Department emails do not contain modifiers, but customer emails do.
20151012 Mathew Lindley: The end user and school each receive an email saying payment failed on CC recurring failures.
1. 20151012 Cecilia Do: In this case, department may want to cancel the future recurring transactions and contact the customer to make a new recurring payment.
20151012: Regarding collecting checks/alternative payment methods besides credit cards:
1. Offer $0 products that collect the customer information, and instruct customers to submit alternative payment.
2. Can have product options for each type of payment and different prices.
20151105 CD: Single store URL
1. http://[server]/[context]/web/store_main.jsp?STOREID=[ID#][&SINGLESTORE=true]
2. https://test.secure.touchnet.net:8443/C21570test_ustores/web/store_main.jsp?STOREID=[ID#][&SINGLESTORE=true]
20151207 CD: If do not have an image for a product, may consider using just a white square.
12 May 2016 Promotional codes for packages do not work.
Per Lindsay Carroll's email to Rhett Lowe from Education: Unfortunately, the current functionality of promotion codes doesn’t allow promo codes to be set up on packages, only individual products. They are currently working on a case with another University that has the same concerns but a resolution date is indefinite. Their only advice to me was to submit an enhancement request to increase the functionality of promotion codes. I will do this today, however, if and when this gets resolved is unknown.
07 Jun 2016 Product fulfillment
1. Authorization & settlement
  1. Credit card is authorized at order time
  2. If order is fulfilled within 72 hours, the authorization is still active and the transaction will be submitted to the credit card batch for settlement
  3. If order is not fulfilled within 72 hours, the authorization will be automatically reversed/cancelled
    1. Upon fulfillment, the credit card will be authorized again, and if successful, will be submitted to the credit card batch for settlement
2. There are no partial fulfillments (e.g. have 5 products, ship 3 products, and later ship the remaining 2). Entire shipment is sent, or the quantity can be decreased.
3. Marketplace revenue reports are based off the fulfillment date for products requiring manual fulfillment
4. Fulfilled order transactions will be submitted for the day's credit card batch for settlement
  
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.
08 Jun 2016 Free shipping if order amount exceeds X - Work arounds
1. Staff reverse shipping charges same day
  1. For manual fulfillment, can reverse after fulfillment
    1. Authorization amount will be adjusted
    2. Settlement ill be for the adjusted amount only
    3. Department assessed expense on adjusted amount
  2. If next business day or after, then reversal will be a separate refund line item
    1. Multiple line items will be seen on customer card account
    2. Department assessed expense on each item
2. Unique promo code
  1. Call department to retrieve
3. Create shipping class for free shipping
  1. No validation on amount
  2. Honor system with customers
(Chris Wong) how to set up variable pricing for a product
1. set the product type as Donation
2. check ‘User entered amount’ in the Donation amount section

uPay

uPay test page: https://test.secure.touchnet.net:8443/C21570test_upay/ext_site_test.jsp

uPay posting URL: https://test.secure.touchnet.net:8443/C21570test_upay/web/index.jsp

uPay posting URL
1. Location that department storefront will initiate request post and redirect
2. (Sean Lee) 20150807 Mathew Lindley: The uPay posting URL is where you post the parameters and the user redirect occurs in that single operation. There is an example posting in the uPay Technical Guide. This is the only method of posting to a uPay site.
(Sean Lee) Department postback
1. Send TouchNet the IPs and ports to allow postbacks through the TouchNet firewall
2. (Rich Martucci) So when we are ready to move to the production server we will need to send you the ssl certificate .cer renamed as .txt for that server too correct?
  1. 20151014 Adam Stambaugh: More than likely. If wildcards are used than it may not be needed but to be on the safe side sending in the cert is the best bet.
3. 20160226 Cecilia Do: For troubleshooting the postback, go here
(Sean Lee) I have noted two additional postback parameters with corresponding value in postback result: __VIEWSTATE and __VIEWSTATEGENERATOR. What are these values for and is there a way that we can exclude them in postback?
1. 20150818 Mathew Lindley: The two parameters are not part of TMS. If they are being posted to the posting URL, it is because they are being passed to TMS on entry. The school needs to change their application to not pass them.
(Sean Lee) VALIDATION_KEY
1. Alphanumeric plus special characters
2. Sample: hX0r0Huchc9gv+ReALWrkQ
3. 20150817 Sean Lee: Now I know that we cannot have hyphen as part of validation key. I have tried to include hyphen in ExtTransId and TouchNet complains.
(Sean Lee) The other question I have is related to validation key. I have setup HousingTest uPay site with a validation key. Let’s say my campus web application is not configured or is configured with incorrect validation key for posting. TouchNet will redirect user to this page (see attachment), and stay on that page if user clicked the “Please click here to return” button. Is there a way that we can configure this scenario in uPay setting with an external URL similar to the way we configure for success/error/cancel page?
1. 20150818 Mathew Lindley: The ‘Please click here to return’ button is not configurable. It returns the user back to the location they were sent from.
(Sean Lee) What is the maximum field length return by uPay postback for the following fields:
VALIDATION_KEY
tpg_trans_id
CREDIT_ACCT_CODE
CREDIT_ACCT_AMT
CREDIT_ACCT_CODE_2
CREDIT_ACCT_AMT_2
All of them have field type ALPHANUMERIC and FIELD LENGTH Unlimited. What is the maximum “possible” return value for unlimited length? We want to limit the field length but at same time try to prevent truncation to occur. This is especially important for tpg_trans_id and CREDIT_ACCT_CODE/CREDIT_ACCT_CODE_2.
1. 20150821 Mathew Lindley:
  1. The maximum length allowed to be entered into the Op Center when creating an accounting code is 50. So their maximum length is defined by what they use for accounting codes.
  2. Validation key is not passed back to the posting url, but it is calculated and passed by the school, so they should be able to see the length, but I believe that it is 24.
  3. tpg_trans_id is defined by payment gateway, but I believe for credit cards the format is always year, month, day and 6 numbers for a total of 14. Ach is just a one up number, so that can grow over time.
(Cecilia Do) Can you confirm what will happen when we transmit an invalid account code (CREDIT_ACCT_CODE) in uPay?
1. We're seeing:
  1. uPay session is successful. Customer can make payment.
  2. Transaction shows up in:
    1. uPay reports
    2. Payment Gateway reports
  3. Transaction does not show up in Marketplace Accounting Code report
  4. The transaction shows up under GL Exception
    1. We can correct the Accounting Code and mark it as complete
    2. After which transaction will show up in Marketplace Accounting Code report under the newly selected Account Code
2. 20150820 Mathew Lindley: We have confirmed that yes, payments are taken and completed before attempting to send to G/L. If an exception occurs, payments are not reversed, G/L error notifications are sent.
(Cecilia Do) 20150825 Mathew Lindley (in red)
1. For the uPay payment reversals (same day VOID and subsequent refunds), will a postback be sent? No
2. Is this the “Post data when payment is cancelled:” parameter under “Posting Settings”? Post data when payment is cancelled controls whether we post back to you when the customer hits the cancel button
3. If a transaction had multiple partial refunds, will a postback be transmitted for each one with the appropriate refunded amount? No
4. And what about recurring payments? Will a postback be sent out for each payment that is processed on the scheduled payment date? Yes
(Cecilia Do) Can you delete a uStore/uPay as long as it hasn’t taken payments yet? And once a payment is taken, the store/site can only be disabled, not deleted?
1. 20150825 Mathew Lindley: Correct.
(Cecilia Do) It looks like uStore and uPay names are not required to be unique.
1. 20150825 Mathew Lindley: Correct.
(Cecilia Do) When a store is no longer used, we can only disable it? And it will forever show up on the Revenue by Merchant reports with 0 amounts?
1. 20150825 Mathew Lindley: Correct, although it will only show up with zero depending on how far you search back. If you haven’t used the store or site you can delete it.
2. They will stay there for reporting. We do allow the deletion of uStore products though.
(Cecilia Do) When a uPay site's name is changed, the reports will display the new name, even for transaction data before the name change.
(Sean Lee) Does uPay support postback encryption? I am a bit concerned on postback security and wondering if it has any methods to encrypt the postback string.
1. 20150908 Mathew Lindley: I’m not aware of any post back encryption, although it should be noted that we would never receive a post or send a post back that contains payment data; that information is entered on the uPay pages and is only saved within our datacenter at that point.
(Cecilia Do on behalf of Linda Snyder) I understand that TouchNet has monthly maintenance. Are we able to request for uninterrupted service during our peak payment period? For example, the period 2-3 weeks where students make an SIR (Student Intent to Register) payment is critical. Can we request for uninterrupted service during those weeks?
1. 20150916 Michelle Sullivan: You are correct, we do have monthly maintenance that occur on Wednesday. Unfortunately it is a datacenter-wide activity and we cannot pull certain schools from this. I apologize for any inconvenience this may cause.
(Sean Lee) It occurs to me that I need some ways to verify user’s identity for those that visit success page, cancel page, and error page via uPay redirect. Is there a way that we can append parameters (e.g., campus identifier, tpg_trans_id, user-defined parameters, etc.) from post string at the end of redirect URL so the referred page can parse and verify?
1. 20150917 Mathew Lindley: Posted parameters are not added to the Success Link. If they want the posted parameters passed back to them, they need to use a posting url. UPAY_SITE_ID and EXT_TRANS_ID are added to the success url unless they have turn this off in the Payment Settings page with the “Transaction ID Settings - Show External Transaction Id in URL” setting.
(Markus Quon) With the UPAY_SITE_ID and EXT_TRANS_ID, we are able to identify the record (person) being redirected, however, there is no trust that the redirect URL was tampered with because it lacks trust/validation information. Is there a way to include one more item such as the VALIDATION_KEY which the external user would not know, but TouchNet does know (Cecilia: this is comparable to the session id key in our current world).
1. 20150917 Mathew Lindley: This is not possible in our current environment.
2. (Markus Quon) I'm a bit concerned about the lack of the VALIDATION_KEY as part of the redirect process. There's a big disconnect that breaks trust and actually would open the door for someone to brute force if a uPay client blindly trust the EXT_TRANS_ID to continue to process assuming they still are handling the same “customer.” Our only saving grace for the UX is that we are able to check for our session and if it exists correlate that with the EXT_TRANS_ID to validate if we have the same user; and in all other cases force reauthentication.
(Dianne Bean) 20150928 Mathew Lindley: Adding new merchants / uStores / uPay sites does NOT require any kind of restart. As soon as they are created, they will show up.
(Cecilia Do) Regarding going live. For uPay, there’s no preview mode, right? If a department wants to test to the point of authorization, postback, and viewing reports, do we enable the uPay site, go through the local storefront, make a payment with a personal card, check for the postback, view the reports, and do a same-day reversal?
1. 20150930 Mathew Lindley: That would be the best way to test it front-to-back. You can also use the TEST uPay page to simply test transactions without involving the posting application.
(Linda Snyder) The “Site Email Address” item in “General Settings” of the Miscellaneous page…. Is this for administrator announcements/alerts? Or is this for users to submit queries?
1. Used as the contact e-mail address on e-mail confirmation messages to the customer. In addition, warning messages for posting URL failures, GL update failures, and recurring payment failures are sent to this e-mail address.
How to view reversals (voids/refunds) in reports
1. Marketplace Reports » uPay Sites » <uPay name>
 1. » Revenue
 1. Input date range.
 2. Lists out individual transaction and refund lines.
 2. » By Product
 1. Input date range.
 2. Product drilldown will list out individual transaction and refund lines.
20151012 Mathew Lindley: The end user and school each receive an email saying payment failed on CC recurring failures.
Department notification for transactions processed?
1. 20151013 Mathew Lindley: A uPay site manager can opt to receive emails by going to "Edit My Profile" on the left hand menu.
Email receipt signature block uses uPay site name by default. Can override by configuring "Payment Notification Signature Text" under "Miscellaneous" section
User's browser might show insecure red lock icon in the https URL in uPay site.
1. The SSL certificate for secure.touchnet.net, is certainly valid and secure. This warning is most only being seen by certain older operating systems (generally MAC) and internet browsers that are having issues recognizing new SSL certificates. Therefore, if those users can visit the site in Safari and permanently trust the root certificate as shown in the attached image, it should resolve future warnings in Safari and Chrome as well.
(Cecilia Do) 11 May 2016 Per TouchNet Customer Care, there is no way to repost a postback if it is not in the posting exceptions list. The department will need to perform manual updates.
(Cecilia Do) 07 Dec 2016 For passing parameters to your uPay site, can we define our own fields for input? Do these self-defined fields come back to us in the postback? Can we pass over fields not defined in the Technical Guide? Say I pass over fields called student_id = '12345678' and term_code = 'F2017'. Will I get these value pairs in the postback so my web system can further process this data? Or does uPay only accept the parameters defined in the uPay Technical Guide?
1. Yes, allowed! Cecilia confirmed on TEST environment 07 Dec 2016.
2. 07 Dec 2016 TouchNet Customer Care: You can pass any parameter you like, we will pass them back to the posting url. Take a look at section 10.4 of the Marketplace Users guide. or the uPay Technical Guide Section 1.0 “uPay will accept any parameters that you pass and in turn pass the parameters back to your campus web application after the transaction is processed”.
04 Dec 2020 VALIDATION_KEY details: https://secure.touchnet.com/help/tms/79/default.htm#Marketplace%20User%20Guide/Creating_a_VALIDATION_KE.htm
1. Encode value before putting onto uPay test page: https://test.secure.touchnet.net:8443/C21570test_upay/ext_site_test.jsp

TouchNet Ready Partners

Process overview
1. Department contacts Payment Card Services and the Student Financial IT team regarding their request to add a TouchNet Ready Partner
2. CUSTOMER - Contact TouchNet Customer Care
3. CUSTOMER - Submit executed contract
4. CUSTOMER - Provide partner contact to TouchNet
5. TouchNet - Schedule kick-off call
  1. UCI liaison (Student Financial IT), department technical contact, TouchNet Ready Partner contact
6. TouchNet - Provide project plan and data gathering guide
7. CUSTOMER/PARTNER - Provide TouchNet with the Public IP address(es) to the partner server(s) for Test and Production
8. CUSTOMER - Configure the TouchNet Payment Gateway with Merchant/Bank account
  1. We (TouchNet) can provide training or assistance
9. TouchNet - Allow the IP addresses provided in our firewall
10. TouchNet - Provide the Basic Authentication Username and Password to the person configuring the partner application
11. CUSTOMER - Create your uPay site(s) and provide the Site IDs to those involved
  1. We (TouchNet) can provide training or assistance
12. CUSTOMER/PARTNER - Configure the partner application with uPay URL, uPay Site ID, TLink Web Service URL and Username/Password
(Cecilia Do) 03 May 2016 I believe that TouchNet Ready Partners integrate with the Marketplace uPay module?
1. The tlink webservice integrates with Marketplace\Upay.
(Cecilia Do) 03 May 2016
1. Will TargetX integrate with the existing Payment Gateway setup for the department? Or does it require a new setup? It can do either, it's dependent on where you want the funds to go.
2. Will the reporting for TargetX transactions be exactly the same as non-TouchNet Ready Partner uPay transactions? Yes, reporting is the same.
  1. Will they still show up in the Marketplace Reports (i.e. Marketplace --> Revenue By Merchant, Merchant Reports, uPay Site Reports, etc.)? Yes, reporting is the same.
  2. Will they show up in the Payment Gateway Reports (i.e. Payment Transactions, Credit Card, Batch Settlement, etc.)? Yes.
    1. 07 Dec 2016 This is not completely correct. TNReady Partner transactions do not show up under the "Marketplace" application. They show up under the "TNReady Partners" application.
  3. This is essential as we have ledger and reconciliation processes that depend on these reports. You can configure uPay to have default GL codes but the partner also has the capability to override the default if you are doing split payments. I would reach out directly to Target X and verify they pass GL codes if you plan to have multiple GL codes per payment.
    
    Irrelevant as we do not transmit GL codes.
(Cecilia Do) 19 Jul 2016 Per the Slate (Technolutions) documentation "Specific Payment Providers":
TouchNet UPay
We need the URL and the UPay site ID or IDs. If you have multiple UPay sites, we can certainly send a different site ID for different
transactions; just let us know what criteria to use to decide which site ID to send.
You will need to configure TouchNet to send a silent postback to Slate at your Slate host name followed by /apply/payment?
cmd=touchnet
Be aware that TouchNet is encouraging institutions to switch to their "TouchNet Ready" program.

TouchNet Ready/TLink
Slate is a TouchNet Ready Partner, which means that we can support connecting to TouchNet using their TLink service (this is
similar to connecting to a UPay site, but there's a web service component as well). At present, TouchNet prefers to kick off a project
for each TouchNet Ready implementation, with one or more phone meetings and a project document called a Data Gathering
Guide. We are happy to join a kickoff phone meeting if they prefer. The Data Gathering Guide contains all of the URLs and IDs that
we need.
As with TouchNet UPay, if there are multiple sites, we need to know how to determine which site ID to send (e.g. send a particular
site ID based on the selected round or program).
08 Mar 2018 Each Ready Partner has the same username / password

HTML Cheatsheet

Line break
```
 
```

Color

<font color="red">Hello, this is red.</font>

Miscellaneous

Configuration

(Cecilia Do) 20230207: Configure time zone in local user profile
1. To set the time zone for how data is displayed in the uCommerce, please follow these steps:
  1. Log into uCommerce > in the upper right, click your name > Then select "Edit Profile"
  2. Once that page comes up, set the time zone to desired settings. > Then click "Save"
  3. The setting to change the time zone for reports in your user profile will be on an individual basis for each user.
    It will not have any effect on realm C21570.
2. CD: This impacts the Payment Gateway reports. Marketplace reports already reflect Pacific time, regardless of profile Time Zone setting
(Cecilia Do) 20230216: What does the Time Zone under Administration > System Configuration > Default Localization Settings control? [ Does this ] impact the whole “realm” C21570?
1. Do not change the settings in Administration unless necessary. They control a lot of internal processes.
03 Apr 2023 (Cecilia Do)
At our campus, we tie Marketplace transactions to the Payment Gateway credit card settlement. We get discrepancies when authorizations come in close to the settlement time. For example, we have our settlement scheduled for 10pm. When a person is making a payment right at 10pm, the transaction may go straight to settlement, instead of going into the next day's batch. This causes a reporting discrepancy.
Does TouchNet have recommendations / suggestions to handle this?
I am thinking that we can mitigate these timing discrepancies if we can schedule a window, say daily between 9:55pm - 10:05pm, of downtime, so people are unable to make submit a payment during this critical window. Is there a mechanism to schedule a window or recurring window of downtime for our Marketplace instance?
1. At this time the only way to schedule downtime in uStores is at Store Settings > Status Management. However that only allows to schedule from Enable to Disable status, or Disable to Enable Status, and wouild also require manual intervention on a store by store basis. uPay sites don't contain a Status Management scheduler similar to uStores and would require manual intervention on a site by site basis as well.
  The only other alternative would be to navigate to Marketplace Home, and in each table for uStores and uPay, on the header row, check the box in the far left next to the "Name" column. Then on the far right, select the Gear drop-down, and select "Disable Web". But that also would require manual intervention.
  Sorry that there aren't better alternatives at this time.

Reports

(I-Rong Lin) Credit card transaction data is kept indefinitely (e.g. not purged or limited)
All reports are available via CSV
Marketplace reports
1. Query Dates
 1. (Cecilia Do) For the query date parameters, is the “From” date starting at the beginning of the day? And the “To” date is the end of the day? For example, if I entered 8/4/15 for both, the criteria would be 8/4/15 12:00:00.000AM through 8/4/15 11:59:59.999PM.
 1. 20150806 Mathew Lindley: Correct
 2. (Cecilia Do) Is this Central Time? (which is ok because the transaction dates are Central Time anyways?)
 1. 20150806 Mathew Lindley: Correct
2. Dates
 1. 20150804 Mathew Lindley: If the transaction is auto-fulfill, the report is based on activity for that transaction. If the transaction is not auto-fulfill, the report is based on the fulfillment date (which works, because we wouldn’t send the transaction to the batch until fulfillment either way).
3. Revenue by Accounting Code Report
 1. (Cecilia Do) How do voids (or same day reversals) look in this report? Are they two separate line items with a positive amount and a negative amount with two separate timestamps? Or is it one line that was originally a positive amount, and then gets zeroed out? (relates to #3-b below)
 1. 20150806 Mathew Lindley: The report will show the total for each accounting code but you can also view the report in detail which will show all the transactions that make up the totals
 2. Cecilia Do: Authorization comes in as one credit line. Same day reversal comes in as a debit line. If the void comes in the second day, then the first day will have the credit, the second day will have a debit.
 2. (I-Rong Lin) Does Revenue by Accounting Code report only contain settled transactions?
 1. 20150806 Mathew Lindley: No, It contains all completed transactions in Marketplace, including transactions which may not have yet settled for their daily batch. Cecilia and I discussed this as well and I would recommend comparing the Batch Detail Report to the Revenue by Accounting Detail Report, using the first and last transactions from the Batch report to define the list of Accounting updates for that batch. Very slow in all likelihood but the only way to ensure accurate manual GL updates using these reports.
 3. (Cecilia Do) Suppose we configured our batches to close for settlement at 5PM daily (which we do in our current system). Then I run a report for 8/4/15.
 1. Will it include the settled transactions that were auto-fulfilled/fulfilled from 8/4 12AM through 8/4 5PM, and the not-yet-settled transactions auto-fulfilled/fulfilled from 8/4 5PM through 8/4 11:59PM?
 1. 20150806 Mathew Lindley: Correct, but if you compare to batch detail as described above you can sort this out.
 2. How will the data look if an authorization goes in on 8/4 6PM, and then on 8/5 8AM I void it?
 1. 20150806 Mathew Lindley: You will see both transactions in the accounting code report, neither of the transactions will show in the batch detail report
 4. ~~(Cecilia Do) Settlement cutoff is 5PM. $100 authorization for account code MISC at 6PM last night. Same transaction was voided 8AM this morning.~~
 1. ~~When I pull a report for yesterday, the accounting code report (summary) will show~~
 1. ~~MISC - $100 - credit?~~
 2. ~~When I pull a report for today, the accounting code report (summary) will show~~
 1. ~~MISC - $100 - debit?~~
 3. ~~When I pull a report for yesterday through today, the accounting code report (summary) will not show MISC, since it netted out to $0?~~
 5. (Cecilia Do) We found that the Revenue by Accounting Code Detail Report CSV is missing the fulfillment date column.
 1. 20150813 Mathew Lindley: Product Development says this is not intended and is a bug. I am entering a ticket to get this fixed.
 6. (Cecilia Do) The Accounting Code report is pulled by fulfillment date.
 1. If there was a GL Exception say yesterday, and the exception was not processed until today, the Accounting Codes amounts are still tied to the original date: yesterday, e.g. they will not show up on today's date, the date you marked the exception as complete.
4. (Cecilia Do) 20150825 Mathew Lindley (in red): For the Revenue by Merchant:
 1. How do recurring payments show up? I’m guessing they show up on the date that a payment is scheduled to be made? Yeah, this is only revenue in a timeframe, without projected recurrences factored in.
 2. This report will show a summary including same-day reversals and refunds? I don’t think so but just to be sure I would recommend doing it, that should be easy to test.
 1. 20150828 Cecilia Do: Reversal, same-day or not, is a new line with a negative amount. The summary amount totals the net as expected.
5. How do we view a list of products and all the modifiers?
 1. 20151012 Mathew Lindley: Go to Marketplace Reports » Stores » <Store> » By Product.
 1. Drill-down to specific product.
 1. Displays transactions with all modifiers
 2. Option to "Export to CSV". Can pick-and-choose modifiers to export.
6. 13 Jun 2016 For the "By Stock No." report, it does differ from the Totals report for the same store because the totals includes the taxes, whereas By Stock No. does not. The By Product, By Stock No., and By Product Type all reference the same amount.
Payment Gateway reports
1. (I-Rong Lin) Batch Settlement report is broken down by MID
2. The Credit Card Type Usage Report is based off the batch settlement time.
3. (I-Rong Lin) One batch per MID?
  1. 20150806 Mathew Lindley: No, you can send multiple batches to a single MID (with each have their own reports).
07 Jun 2016 Product fulfillment
1. Marketplace revenue reports are based off the fulfillment date for products requiring manual fulfillment
2. Fulfilled order transactions will be submitted for the day's credit card batch for settlement
  
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.

Payment Processing

(Cecilia Do) How do we know when settlement completes? Are we notified? Or does settlement always complete, say, within 1 hour?
1. 20150804 Mathew Lindley: Batch settlement completes on the same time every day, based on when you configure your Credit Card Merchant to settle its batch. Transactions flow from Marketplace to Payment Gateway upon fulfillment real-time.
2. 20150904 Cecilia Do: Configured batch settlement for 2AM (Central). The batch settlement time is 2:00:01AM.
  1. 30 Jun 2016 Each batch is submitted for settlement one at a time.
    1. Each batch holds up to 1,000 transactions - about 3 minutes to complete settlement transmission
    2. Settlement transmission duration
      1. 100 transactions - 15-20 seconds
      2. 300 transactions - 1 minute
      3. 1,000 transactions - 2.5-3 minutes
(Cecilia Do) And just to confirm, the “Batch time” parameter controls this. It is configured at the individual Payment Gateway Credit Card Merchant level. It is in military time, Central Time. If left at the default value “off” then settlement is manual.
1. 20150903 Mathew Lindley: Correct!
(Dianne Bean) Is there a cutoff for when a department can do a refund through MarketPlace? In other words, if I made a MarketPlace payment today (8/25) at a School of Medicine store, how long does the SOM have to refund me when I make a request before the transaction is no longer accessible to refund? 30 days? 90 days? 120 days? 6 mos?
1. 20150825 Mathew Lindley: We do not create a limit, we allow the schools to dictate that per store. The system will allow a refund at any time after purchase.
(Cecilia Do) How do debit card types show up in reports? For example, a debit card with the Visa credit card logo, does it show up as “VISA” or “Visa Debit” (Payment Gateway Business User Guide, p.210)
1. 20150806 Mathew Lindley: This shows up as Visa and will be listed as a Signature Debit payment rather than Credit Card in TPG reporting.
(I-Rong Lin) I understand uPay user receive post-back in real time for credit card authorization. For uStore, is it true “order confirmation” is equal to credit card authorization is completed successfully?
1. 20150807 Mathew Lindley: When you set up your Marketplace Merchants, it is configurable whether or not to authorize at order time for the uStores in that Marketplace Merchant. I always recommend turning this on as an Administrator. Otherwise the authorization would occur at batch closure.
2. (I-Rong Lin) I take the default is blank or no for uStore authorization at the time the client places an order.
  1. 20150807 Mathew Lindley: Yes, that is the default. This can be edited by Admins and Merchant Managers in the General Settings of each Marketplace Merchant.
(Cecilia Do) Is the fulfillment/auto-fulfillment date (in the Marketplace reports) the same as the authorization date (in the Payment Gateway reports)?
1. 20150811 Mathew Lindley: The authorization will either occur at order time or at batch closure time, depending on how your admins choose to set that in Marketplace. Also if an authorization passes 72 hours without fulfillment, the fulfillment will put a fresh authorization encumbrance on the card statement (to replace the one that fell off after 72 hours) prior to that day’s batch closure.
(I-Rong Lin) Theoretically if we set up our settlement time from 12 a.m. - 11:59:59 p.m., this will coincide with the date range of information in Revenue by Account Code report even if this report doesn't only list settled transactions, right?
1. 20150813 Mathew Lindley: It should be really close to that, yes. You may have one transaction end up being on one day or the other by a fraction of a second depending on the timing and the communication between marketplace and payment gateway but that should be rare.
(Cecilia Do) Carte Blanche
1. Card type in Payment Gateway reports: "CB"
2. 20150811 Mathew Lindley: No test Carte Blanche number in TouchNet TEST. No plans to add to PaySim.
3. 20150813: Per the MID setup conference call with Mathew Lindley, he said that Carte Blanche is folded into AmEx and there will be no processor on the backend to process Carte Blanche payments. Per discussion with Dianne afterwards, we will not allow Carte Blanche in Marketplace.
(Cecilia Do) We have settlement configured for 12am (2am Central). I have some test recurring payments and I’m seeing that the recurring payments are authorized around 12am, and they’re going straight into the settlement batch. Is this correct behavior? It should be the following day’s data, shouldn’t it? As a result, we’re seeing discrepancies between the Merchant Revenue and the Batch Settlement. For example, if you look at the batch details for 9/7’s batch, you’ll see this:
And here’s one from 9/10:
Can we change the time that recurring payments are fired off for authorization? Say if we can make them come in at 3:00 Central, then it would mitigate the discrepancies.
1. 20150917 Mathew Lindley: Recurring payment authorization times are not configurable. We fix a bug if it is determined that this is not working as expected but anything else would be an enhancement request.
  1. I confirmed with Product Development that the time it runs is not configurable. All payments are scheduled for midnight (00:00) and TMS recur runs payments that have a scheduled date that is less than its current run time. That is why the first time tmsrecur runs starting after midnight, payments for the current day start to be processed.
07 Jun 2016 Product fulfillment
1. Authorization & settlement
  1. Credit card is authorized at order time
  2. If order is fulfilled within 72 hours, the authorization is still active and the transaction will be submitted to the credit card batch for settlement
  3. If order is not fulfilled within 72 hours, the authorization will be automatically reversed/cancelled
    1. Upon fulfillment, the credit card will be authorized again, and if successful, will be submitted to the credit card batch for settlement
2. There are no partial fulfillments (e.g. have 5 products, ship 3 products, and later ship the remaining 2). Entire shipment is sent, or the quantity can be decreased.
3. Marketplace revenue reports are based off the fulfillment date for products requiring manual fulfillment
4. Fulfilled order transactions will be submitted for the day's credit card batch for settlement
  
  07 Jun 2016 Marketplace Revenue reports and Payment Gateway credit card reports are in sync for ledger posting of manually fulfilled orders.
23 Mar 2018 Payment Gateway Failed Credit Card Batch
1. (Cecilia) In the Payment Gateway - Batch Settlement Report, we see 3 transactions authorized and all voided yesterday, leaving the batch with no authorized transactions totaling $0. I am thinking we can disregard this notice. Can you please confirm this is correct?
2. (TouchNet) You are correct. Since there were actual transactions and then successful voids, we are still going to attempt to close and process the batch since there are records present. However, since the net of the batch comes to $0 and all of the transactions were voids of each other, an error is generated with the processor since the batch is "empty".
15 Jun 2022 (Cecilia Do) We are exploring possibly changing the Payment Gateway credit card settlement schedule. Can we make this change on our own? Can you please advise on where this configuration is? Once the change is made, when does it take effect?
1. (TouchNet) Is your question in regards to the batch closure time? If so, the timing of the batch can be set on each Merchant here:
  Payment Gateway > Payment Processing Setup > Credit Card > Merchant Configuration > Select the Merchant > General Configuration > Batch time
  After changing the time, I believe a Restart of the Payment Module would need to happen. That can be found here:
  Payment Gateway > Payment Processing Setup > Credit Card > System > at the bottom is "Restart Payment Module".
2. (Cecilia Do) When the "Restart Payment Module" is run, does this interrupt service? How long does the restart last?
  1. (TouchNet) The Restart Payment Module is instant and does not cause any down time at all.
3. (Cecilia Do) Say currently my batch close time is 12AM midnight, and I change it to 11PM for all my merchants, and run "Restart Payment Module." Will the new close time apply to all my current batches? In other words, if a merchant already had an open batch, will this batch close at the new 11PM cutoff?
  1. (TouchNet) As long as you change the time before that batch is run, it should take effect immediately.
03 Apr 2023 (Cecilia Do) For the credit card settlement process in the Payment Gateway, is there a way to change the merchant settlement order/priority? For example, can we move "SLATE GRAD SIR" to be first before the "ARTS" settlement?
1. The batch settlement goes in order of the SubTransCode in Payment Processing Setup. This order is set by merchant creation time. So for example the first batch to processed was ARTS which is SubTransCode 0 the first merchant created. There is no way to change how the SubTransCodes are numbered as they are created as new merchants are created. The only way to prioritize a batch settling time would be to change the batch closure time to be before the other merchants. If prioritizing batches is something you would like to see in the further my suggestion would be to add an enhancement request in the Ideas portion of the client community. I will close this case on our end but please let me know if you have any further questions or concerns regarding this case.

Credit Card In-taking Error for User

How to find out the reason (Error Code) for a credit card rejection by TouchNet when user tries to make a payment by using a credit card?
Sometimes, a user don't know why his/her credit card is not working on TouchNet and Touchnet normally shows user a generic error message. The user will likely to call us for help.
a. go to Payment Gateway
b. go to Reports
c. Select Credit Card and activity
d. select the closest time frame
e. Search for the user's name and you will find the related Error Code as shown below.

f. You can find the Error Code meaning at TouchNet Exception Error Codes

User Authorization

(Dianne Bean) Does MarketPlace keep an audit trail of the roles and names in which the roles were granted for each store? If so, how far back does it go and are we able to query them and run a report?
1. 20150812 Mathew Lindley: Marketplace does not have an audit report, only Payment Gateway.
  1. The Audit log for Payment Gateway is in the Users Section of Payment Gateway.
  2. Retention: As do all TouchNet reports. They stay as long as you have the software.
(Cecilia Do) 20150830 Mathew Lindley (in red):
1. We want to know when someone grants a role to someone (e.g. MP Manager A grants B as a fellow MP Manager; uStore Manager C grants D as a uStore Clerk). Is an email sent out when a user is granted access? There is no email that is sent out for user permissions granted in Marketplace.
2. Does Marketplace keep an audit trail? No
3. Is there a report/log that we can view? No
4. Is this something that we can request from customer support? If so, what is the procedure to go about it? I have never seen this done, although we do have the data in our log files. I would say the request would have to related to something specific (i.e. “can you tell me what user gave a user this permission”) along with a timeframe small enough to be able to narrow the action down to the right session log. Once this session log is found it would be easy to tell when who granted a certain permission, the only trick is sufficiently narrowing the timeframe around when the action would have occurred for us to find the session.
(Cecilia Do) 20150902 Mathew Lindley (in red)

Since there is no audit trail or notification for Marketplace authorization, we are thinking of performing monthly audits. We will need to get the users granted for each of the Marketplace user roles: Marketplace Chief Administrators, Marketplace Administrators, Marketplace Accounts, Merchant Managers, uStore Managers, …, uPay Managers, …, etc. Can we see when they were granted the access? There is no way to see this in Marketplace
Is there a simple way to export all the authorized users and roles for Marketplace? This functionality does not exist for Marketplace It looks like we have to drill down to each area to pull the access (i.e. at the Marketplace level, Merchant level, uStore level, uPay level). If we have 30 merchants and 100 stores, then we have to drill down to each of the 30 merchants and 100 stores to view the user access? That is correct Can customer support pull reports? I assume that Customer Support could find out when someone was added via a log file that tracks activity in the Operations Center. These log files are based on when you log in however and we need specificity to find the right activity. An example of what would work to find the right log file would be, “Can you see who gave this permission? I know that they were grant access on this time and date”. Something that would not work in this system would be, “Can you tell me when all the current users gained access”. There are just too many file to go through.
The best way I can think to do this in Marketplace is to track this internally. Train your users to only request access and not to grant access to users on their own. Keep a list of all users, their permissions and the dates they were added in a spreadsheet. Then periodically compare the list to the Operations Center and delete any permission that doesn’t match.

(Markus Quon) 20150922: So is the “Marketplace uPay Site Manager” KSAMs role the appropriate role for IT? And the uPay Payment Clerk and uPay Accountant the appropriate roles for HSG A/R (Sarah)?
1. Cecilia Do: For the uPay manager, there are parameters that are business-related (like credit card validation settings) and others that are storefront-related, so it should be a collaborative effort. At this time, we will leave it to the department to determine how they want this done. Do they want to assign both parties? Or one party, who will work closely with the other? My recommendation at this time is to have IT configure it, with the business side input on the business parameters.
2. The Payment Clerk is definitely a business role.
3. You may want to grant IT with the accountant role in case you need to look up transaction information for system troubleshooting. Also, note that this role also views the postback exceptions.

Payment Gateway Credit Card Merchant (MID)

(Cecilia Do) 20150810 Mathew Lindley: Any time you add a new Merchant, TEST or PROD, we have to conduct a Payment Gateway restart on our side to activate the new addition (or edits).
1. Does NOT cause disruption to Marketplace. Does NOT disrupt the merchants that are already functional and active.
2. 20151009 Mathew Lindley: [Restart is only required] when you create/edit Payment Gateway Merchants for Credit Card or ACH.
(Cecilia Do) 20150811 Mathew Lindley (in red): I wanted to ask you about the relationship between the Credit Card Merchants (MIDs), Payment Gateway Host System Accounts, and Marketplace Business Units. We plan to create MIDs at the campus school/unit level, which may or may not require additional breakdown. We want to verify that this is possible in TouchNet Marketplace.
1. Between Credit Card Merchants (MIDs) and Payment Gateway Host System Accounts
  1. It can be 1-1 CORRECT
    1. For example, we have an “Engineering” MID, and under it an “Engineering” Host System
  2. It can be 1-many CORRECT
    1. For example, we have a “Student Affairs” MID, and under it “Housing” and “Admissions” Host Systems
  3. We plan to use both (i) & (ii)
2. Between Payment Gateway Host System Accounts and Marketplace Business Units
  1. It can be 1-1 CORRECT
    1. For example, we will have “Engineering,” “Housing,” and “Admissions” Marketplace Business Units tied to the corresponding Host System
  2. It can be 1-many CORRECT…
  3. We plan to use (i)… BUT I STRONGLY RECOMMEND THIS
(Kathy Gorelick) 20170221 Update the Merchant Name: in Payment Gateway by logging in to U.Commerce -> Payment Gateway -> Payment Processing Setup -> Credit Card -> Merchant Configuration -> Description -> Select SubTransCode: 17 -> Short Description Name.
This doesn't require any module restarts on TouchNet side, it takes effective right after save the change.
(Cecilia Do) 20230203 I changed host system account names. I do not see the new names reflected on the Marketplace merchant Settings screen for “Payment Gateway Host System Account Name”.
1. In order for the changes to a merchant to stick you will need to reload the host system account. This can be done by navigating to Marketplace> System Administration>Settings> General> select Reload Host System Account Information.

Ledger Integration

UCI will NOT be utilizing TouchNet Accounting Codes and Ledger Integration for Marketplace

Cannot configure "Generic" Ledger Integration for TouchNet (e.g. not tied to a system, like Banner) without running into issues.

Outstanding issues:

Payments go straight to GL Exception list
1. Transaction must be marked as complete
2. Requires manual intervention
Payments do not show up in Accounting Code report until after processed in GL Exception list

(Cecilia Do) We want to post only the data that has settled with the bank. Do you have suggestions on the details of how we can use the Accounting Code report for our ledger posting?
1. 20150806 Mathew Lindley: I would start with the Payment Gateway Batch Detail report, which will give you the first and last transaction of each batch. Then compare that to a day’s (or two days if your CC Batches do not close at midnight) and find those transactions to bookend a day’s updates.
2. Cecilia Do: This wouldn't work since the transaction - account code relationship is not necessarily one-to-one.

TouchNet Accounting Codes

NOT Utilizing

We will NOT be utilizing TouchNet Accounting Codes.

(Cecilia Do) Accounting Codes are not required to be unique across Marketplace
1. 20150804: Per Mathew Lindley, it is required to be unique. However, confirmed the contrary in Marketplace TEST.
2. 50 character length
Accounting Code Names are required to be unique within Marketplace Business Unit / Merchant
1. 20150813: Per Mathew Lindley, it is required to be unique across all of Marketplace. However, confirmed the contrary in Marketplace TEST.
2. Overlap with Admin Common Accounting Codes is also allowed
3. 25 character length
(Cecilia Do) 20130813: How do you configure the tax account code? My product taxes are going to a blank code. I couldn’t consistently recreate it, but sometimes, the tax accounting code override list in the GL Exception detail screen only displayed the Marketplace “common” account codes.
1. 20150819: Fixes applied on TEST; works correctly
(Cecilia Do) 20150811 Mathew Lindley (in red): Are accounting codes editable? If so, what happens to the transactions that were already made tied to the original code? Are the codes retroactively changed, or do they reflect the new codes after the change was made? I would recommend trying this in the TEST environment. I’m not sure how it will work with your situation since there is no integration in place.

~~Suppose I have a product using accounting code <1-Income>.~~
~~Yesterday I settled $100.~~
~~Today I made an authorization for $50.~~
~~Then I changed accounting code to <2-Income>.~~
~~Then I make another authorization for $20.~~

TouchNet Generic Ledger Integration