Totalink Integrator Guide
The latest Integrator Guide can be found here.
The latest Integrator Guide can be found here.
Adjustments are helpful for one-time adjustments or for processing cards when the system is off-line or you just need to make a correction. We recommend that you do each step. Pay particular attention to the statement at the end of this document.
All adjustment steps are preformed from Credit Card Adjustments menu found at POS-5-1-4. The process is not complete until steps one and three have been performed.
POS-5-1-4
Before any other menu options in the Credit Card Adjustments menu can be used, you must enter the desired credit card adjustments. To do so, follow these steps.
POS-5-1-4-1
You can delete an adjustment by entering “D”.
The Credit Card Adjustments Report can be used to display information on adjustments that have been entered. It can be customized to select different adjustments based on several criteria.
POS-5-1-4-2
After you have entered an adjustment, it doesn’t take effect until you have posted the adjustment to the host. To do so, follow these steps.
POS-5-1-4-3
When you post an adjustment it is goes through the same authorization process as any other credit card. You will see the progress of the authorization on the screen and know if the charge is accepted or declined.
If the charge is accepted it is written into the open settlement file (TOTAL.CC.HOLD) where it will be settled along with all other credit card charges. This will impact your daily report, so be aware of this and be sure to print the adjustment report to help you with your reconciliation.
If the charge is declined it will stay in the adjustments file where you can fix the cause of the decline and try again or wait a few days and try again until you get an authorization or give up.
You can now view the results of all posted adjustments by printing the Posting Results report.
POS-5-1-4-4
Please remember. When you post an adjustment it is goes through the same authorization process as any other credit card. You will see the progress of the authorization on the screen and know if the charge is accepted or declined.
If the charge is accepted it is written into the open settlement file (TOTAL.CC.HOLD) where it will be settled along with all other credit card charges. This will impact your daily report, so be aware of this and be sure to print the adjustment report to help you with your reconciliation.
If the charge is declined it will stay in the adjustments file where you can fix the cause of the decline and try again or wait a few days and try again until you get an authorization or give up.
Wholesalers will periodically release guides with up to date buyback numbers. Simply downloading the guide file and placing it on the server is not enough.The data in these guides must be imported into the system and applied to the textbook records. There may be slightly different prompts depending on which guide is being imported but the process is essentially the same.
The wholesalers will typically send out an email with instructions on how to obtain the guide as well as a handful of ISBNs and their buyback amounts. Follow their instructions and place the downloaded files onto the local server’s hard drive. Please remember the path to the file on the hard drive as it is needed when importing. We recommend that these files be placed in C:\Guides\wholesalername. e.g. C:\Guides\Nebraska.
After you have sold books for your term, you can return extra books and books that were shipped incorrectly to the vendors, if the vendors allow this. This section covers the functions used in this process.
The Returns Menu contains functions dealing with the return of books to vendors. This section covers these functions.
To print a list of invoices that will be expiring shortly, follow these steps.
To create system suggested chargebacks, follow these steps. If you wish to delete one or more chargebacks, you can do so from the Chargeback Maintenance screen.
Note that system suggested returns exclude any quantity to cover for all open terms from being added to a return. If you purchased 10 of a title from the vendor and have a quantity to cover of 10, the suggested return will not include that title. If you have a QTC of 8 then the suggested return will only suggest 2.
If you want to override this behavior you may do so in TX-SU-2-5 (Return Parameters). If you place a Y in the “Suggest Returns Ignore QTC” field then the system will ignore any current/future need for a title and suggest a quantity up to the total amount you have purchased from that vendor.
To enter a chargeback into the system manually, follow these steps.
To print a picking document for your returns, follow these steps.
To print requests for your returns, follow these steps.
To print your returns, follow these steps.
To reprint your picking documents, follow these steps.
To reprint your permissions requests, follow these steps.
To reprint your chargebacks, follow these steps.
To print a list of open return permissions, follow these steps.
To delete chargebacks that have not yet been printed, follow these steps.
To print a list of chargebacks, follow these steps.
To print a writeoff list, follow these steps.
To set up buyback information for a book in your database, follow these steps.
If you buy back books to sell to wholesalers, you can use the functions in the Wholesale from Buyback menu to ship them to the wholesaler. This section covers these functions.
To create a suggested list of buyback items that should be sent to a wholesaler, follow these steps.
To create a shipping list by wholesaler, follow these steps.
To make changes to a wholesaler shipping list, follow these steps.
To print a shipping document for the books you are selling to a wholesaler, follow these steps.
To print a list of items you have on hand that cannot be sold to wholesalers, follow these steps.
The SmartText system contains extensive functions dealing with the buyback of textbooks. These functions are covered in this section.
Before textbooks can be bought back, you must set up the buyback parameters. To do so, follow these steps.
The Buyback Maintenance menu contains functions dealing with buyback parameters for individual items.
To set up buyback information for a book in your database, follow these steps.
If you buy back books at wholesale price, and later decide that you wish to sell them in your store rather than to wholesalers, you can shift the books to retail buyback. To do so, follow these steps.
To print a list of items that have been shifted from wholesale to retail buyback, follow these steps.
If you buy back books at retail price, and later decide that you wish to sell them to wholesalers, you can shift the books to wholesale buyback. To do so, follow these steps.
To print a list of items that have been shifted from retail to wholesale buyback, follow these steps.
The Wholesaler Database Maintenance Menu (TX-5-3) contains functions dealing with your wholesale buying guide(s). This section covers these functions.
To find information about a book by searching in the wholesale buying guide, follow these steps. This will search the default guide that is set up for your store as listed in the general store parameters.
If you wish to change the wholesale price listed in the wholesale buying guide for an item, follow these steps.
If you wish to install a new wholesale guide on your system, follow these steps. If you would like assistance in loading your wholesale guides, please contact Total Computing Solutions.
If you wish to update your master file with information from a new wholesale guide, you should coordinate the wholesale guide by following these steps.
If your store uses guaranteed buyback, you will need to use the functions in the Guaranteed Buyback Menu (TX-5-4). These functions are covered in this section.Pre-List Guaranteed Buyback (TX-5-4-1)
To generate a list of the books for which you will be offering guaranteed buyback, follow these steps.
To print a report of the books that you have bought back through guaranteed buyback, follow these steps.
The SmartText system allows you to manually create a list of books that will be included in the guaranteed buyback program or edit the list that has been created by the system. To do so, follow these steps.
To change the buyback limit flag to “G” for the books that are on your guaranteed buyback list, follow these steps.
To print tags for the guaranteed buyback items, follow these steps.
The Buyback Reports Menu (TX-5-21) contains reports that list information about buybacks. This section covers these reports.Non-Coordinated Books Report (TX-5-21-1)
The Non-Coordinated Books Report displays books in the master file that have not been coordinated to the current wholesale buying guide.
The Actual vs. Needed report displays information about the number of books you need to buy back compared to the number of books you have purchased.
The Buyback Need report displays information about the books you need to buyback.
To print a report that contains information on manual buybacks, follow these steps.
To print a list of the estimated buyback values you have entered, follow these steps.
The Actual vs. Expected Buyback Report prints information about the actual number of books you have bought back compared to the number of books you expected to buy.
To print a report to assist in auditing your buyback purchases, follow these steps.
The Retail Purchases report displays information on books that you have bought back at retail buyback price.
The Wholesale Purchases report displays information on books that you have bought back at retail buyback price.
To print a list of books you have bought for each wholesaler, follow these steps.
On the next page is a sample report.
If you buy back books to sell to wholesalers, you can use the functions in the Wholesale from Buyback menu to ship them to the wholesaler. This information has been previously covered in this manual. See section (TX-4-2-2).
To clear the buyback flags for all books in your system, follow these steps.
If you wish to print barcode tags for all books that you bought back at retail price, follow these steps.
The functions in the receiving menu are used to enter and modify receiving logs for shipments you receive from vendors. This section covers the use of these functions.
To enter a receiving log, follow these steps.
Before you begin, make sure that you Adoption Form Parameters has been created, as shown below, and the comments section has the wording you would like to print on each adoption.
TX-SU-2-1
You must also make sure that the “Future” term has been created in Term Maintenance.
TX-SU-1-2-1
To print the adoption forms
This document will walk Faculty and/or Staff through the process of creating an Adoption request via the campus bookstore’s website. Please keep in mind that this is a request. The bookstore staff will have to approve and enter the information that you request into their system for the course at the school.
All of the connection information should have been sent to you prior to you attempting to create an Adoption request.
Once your request(s) have been submitted the store’s staff will be informed via e-mail.
If you have any questions please contact the campus store.
The website will timeout if left unattended. If a session times out with inactivity you will have to restart the process from the beginning.
1. You will need to connect to your Campus Store’s website and Sign In.
2. Type in the user name and password you were provided into the “Log On” fields.
3. Create a Faculty Adoption Request.
4. Select Enter an Adoption
5. Enter in your information and the instructor’s information
6. Inputting Course information
7. Selecting the books for your section.
8. Select the textbook you wish to adopt.
9. Update Adoption book information.
10. Adopt the book for the section
11. Reviewing the Adoptions Request information
12. Verifying your recommended book.
13. Adoption Request complete
Faculty or department personnel will log in to the bookstore’s online faculty adoption website and submit their course requests or adoptions. These requests will be reviewed by the Department approvers and/or the Bookstore where the adoptions will be accepted and/or denied. Once the adoptions are accepted the TCS Textbook adoption system will be updated with the requests automatically. If they are denied the faculty will have the opportunity to modify the adoption and resubmit them for department/bookstore approval.
Each faculty and department member will need to sign into the campus WebStore system in order to enter the faculty adoptions. The account should be setup using the email address of the faculty/department personnel. The first time signing into the WebStore system the staff will need to choose the ‘forgot my password’ (Screen 1) option so a new password can be generated and emailed to the staff.
Once the new password is received via email continue to log into the WebStore system with the new password. The password can be changed by clicking on the ‘Account Details’ button (Screen 2) and by entering the old and new password information (Screen 3). Save the changes at the bottom of the page. This password will be used as long as the account is setup in the system (multiple terms).
Each faculty/department will be responsible for inputting their course requests/adoptions into the system. Signing into the WebStore system the personnel will be presented with three (3) options: Account Details, Order History or Faculty. Click on the Faculty button and then ‘Proceed to Faculty Adoptions’ to submit adoptions (Screen 4).
Select the desired term to submit the adoptions. Then a list of adoptions will display. The ‘Status’ column will display the current status of the adoption. The ‘New’ status adoptions will be at the top of the page, click on the ‘Begin Adoption’ (Screen 5) to continue with the adoption process.
The preliminary information about the adoption will be displayed on the screen for the faculty/department to update and review. (Screen 6)
Section A (Screen 6) will display the instructor name, email and estimated enrollment. The faculty/department will need to review and update this information if needed.
Section B (Screen 6) will give the options for attaching titles to the course adoption. The ‘Add Book’ has a drop down feature with search criteria for choosing the correct title to adopt to the section:
Section C (Screen 6) will give the staff the ability to apply the same titles that were added to the current section to other sections by using the ‘Apply to Other Adoptions’ link. They can also use the ‘Copy Adoption’ link to copy all of the Adoption details and title adoptions on the section and easily paste them to another section.
Once the adoption detail and title adoptions have been made, ‘SAVE’ the adoption by pressing the ‘Save Adoption’ button on the bottom of the screen. This will save and exit the currently selected adoption and return the staff to the Adoption listing.
The system is designed to allow the staff to modify many adoptions and then submit all the adoptions at one time. Once the staff has modified all adoptions and added the titles necessary, they must complete the adoption by scrolling to the bottom of the adoption listing and ‘Submitting the Adoption’ (Screen 7). If the adoptions are not submitted by clicking on the ‘Submit Adoption’ button all changes will be lost.
If the system is setup to require department “approvers” then proceed to the next steps.
Once the department approvers have logged into the online adoption system, they need to click on the faculty button and then ‘Proceed to Adoption Approvals’ (Screen 8).
The department approver will be presented with a page containing all adoptions waiting on approval. They can filter the listing by Campus, Term, Department or Course. If they would like to only approve one or all pending adoptions, the check boxes to the side of the screen can to be used. Once they have made their selection of the adoptions (by check marking the desired adoption) to be viewed, updated and approved they must add these to their “Queue” for processing (Screen 9).
To view, update and approve the adoption the department approver must review the “queued” adoptions and decide if the current adoption information is correct. Double check the following fields:
Once all information has been reviewed and/or updated, the department approver can either ‘Mark as Ready’ to continue with more approvals, or click on the button to save and exit out of the adoption queue.
Continue with the adoption approval process until all items in the queue have been updated and approved. Watch for any email notifications where other adoptions have been submitted for approval and continue the process.
Faculty or department heads will login to the bookstore’s online faculty adoption website and submit the course requests or adoptions. These requests will be reviewed by the Department approvers and/or the Bookstore where the adoptions will be accepted/denied. Once they are accepted the TCS Textbook adoption system will be updated with the requests automatically. If they are denied the faculty will have the opportunity to modify the adoption and resubmit them for department/bookstore approval.
Adoption Book Flag: Here you will put the code you want to use for the flag. Examples include
R – Required
O – Optional
Description: Enter the description for the flag here. Examples include
Optional
Required
Recommended
Required: This flag says if the book is required or not. Examples are
Y – Yes
N – No
Include on web: This allows you to show this flag on the Adoptions page.
Note: This flag does not affect adoption entry in the back office.
Blank – Display on Web
Y – Display on Web
N – Not Displayed on Web
Set Term and Store Notification emails – (POS 26.4.1)
Input your store number.
Choose ‘FA’ for Faculty Adoptions from the bottom options (the options on the first screen are not changed for faculty adoptions).
Ensure the Term is setup correctly for the active adoption term. Input the terms that are available for the faculty to submit adoptions. If a term is no longer needed, choose the line of the term and press the space bar and then press enter to remove the term.
Store Notification Email(s): Once the faculty/department has approved the adoption the bookstore will receive an email. Input the email address for the personnel to receive the notification emails where an adoption has been approved and is ready for the bookstore to process, enter one address per line.
Number of History Links to Show: This is how many terms to show the faculty when they are searching previous adoptions. If it’s blank it will default to 12 terms.
Online Faculty Adoption Structure
The store must determine how the faculty adoptions will be entered into the system. A couple of questions need to be answered:
If the instructors will be allowed to enter their own adoptions through the online adoption system, then all email addresses MUST be attached to the department/course/sections they are teaching. This can be done with a course import from the administration (TX 1.23.1) OR this can be done manually by the bookstore as they are entering in the department/course/section/instructor information (TX 1.1).
Each faculty/instructor staff member will need to have an account setup in the adoption system. If a file is being imported with the email addresses from an administrative import, follow the next steps, otherwise, the bookstore will need to manually input the email addresses as they are entering the adoptions (TX 1.1) and then run the Update Pref Customer from Adoptions process (TX.1.23.22).
You must have a file from your administration to proceed with this import. If not, please proceed to the next section. For more information on this import process, please contact the TCS Service Center.
Enter the Adoption term you will be importing. – The term will already have to exist in Term Maintenance (TX.SU.1.2.1).
Enter the path of file to import * – The name of the file must be “Adpt-Imp.txt” or “course.asc” for the Budgetext format. Please ensure that the path exists and the file is named correctly for the import to be successful.
Add Non-existing Departments and Courses * – Enter a ‘Y’ if you wish the program to automatically add Departments and Courses that are not currently on file, but are contained within the import file. If you enter ‘N’, then the program will warn you each time it finds a Department or Course that is not on file and will not add the adoption record.
Convert spaces in key fields to: Spaces are not allowed in the key fields of a store, term, department, course and/or section number. If your import file contains spaces enter the character you would like it converted to. If you leave it blank the spaces will be stripped out. Asterisks (*) are not allowed.
Create eCommerce records for faculty* – Enter a ‘Y’ so the system will automatically create the eCommerce records (Pref Customer record) so faculty can log into the faculty adoptions.
Update Processing Type* – Options are ‘R’ Report only, ‘I’ Import only and ‘B’ Import and Report
Once you are satisfied with your entries you MUST choose ‘R’ Run Procedure. If you need assistance with this process please contact the TCS Service Center.
*** Important ***
If you are doing multiple imports throughout the term, after the first import, choose ‘R’ report ONLY to see any changes that need to be MANUALLY input in the adoption system.
If department personnel are required to approve the submitted adoptions by the faculty, then their emails MUST be setup in the department/classes section (TX SU 1.6.2) Screen 1.
(Screen 1)
If more than one person in the department is allowed to input adoptions then email address of the additional personnel must be entered in the next screen. Once the department personnel email address has been entered into the department maintenance (Screen 1) press enter until the options at the bottom of the screen are displayed. Press the ‘A’ for adoptions and the screen will change to allow for entry of ‘Submittal Emails’ for additional Update and Submit personnel. They will be allowed to update and submit the adoptions submitted by the faculty staff for this department.
If the adoption policies requires an ‘Approver’ that person’s email address must be entered into the ‘Approval Emails’ section. They will be allowed to update and approve the adoptions submitted by the faculty staff for this department.
If you answered question 1 – YES – and question 2 – YES, then the approval level required for completion needs to be set to 1.
If you answered question 1 – YES – and question 2 – NO, then the approval level required for completion needs to be set to 0 (zero).
If the bookstore manually enters the faculty/instructors email addresses when building the adoptions (TX 1.1) then the preferred customer file must be created so the faculty can log into the online adoption website. Any department emails that are entered (previous section) will also be created by this process.
Enter the Store number.
Enter the active term for the online adoption period.
Optional – Enter a department or course to filter the update.
If the bookstore should need to change an email address, Name or Phone number for an instructor (i.e. Instructor get married/divorced or just wants to use a different email than the schools) you can make the change here and then run the process and that will change for all
courses the instructor is attached.
Enter Old Email
Enter New Email if it has changed.
Enter New Name if it has changed.
Enter New Phone # if it has changed.
Once a customer/faculty account has been created (steps above), they are automatically setup as an ‘F’ faculty member account status. This means they have the ability to input and/or approve adoptions. If you need to change their status at any time see the below steps.
POS 26.21 – Customer Maintenance
(Screen 2)
Name or ID: This will be the faculty/instructor’s email address.
Account Type: Options for the account type:
If you are setup as an administrator you can also change the account type for a customer online. Once logged in go to the Admin panel section, find the customer and change the account type.
This report is for those department/course/sections where an instructor email has been assigned to the section. The report can be generated to show the bookstore all the instructor email addresses that will be notified when running the email process.
This report will show the Department email addresses entered in to the primary contact field and the mail addresses for those entered in the Submittal- and Approval fields.
When the bookstore is ready to open the Online Faculty Adoptions website the faculty/departments must be notified that the term is open.
TX 1.23.5 – Adoption Notification Email – (Screen 3) – This will send an email to either the instructor or departments (your choice). This notification is setup by the bookstore (subject/email body).
(Screen 3)
Term: Input the term for which the adoptions are active.
Notifications can be filtered to only be sent to a particular department or for a particular course. These are not required fields.
Email Department: If you ONLY want to send the email out to the department emails setup on the department/classes, enter a ‘Y’. This will NOT send out a notification to the faculty/instructors.
Reply To Email: Enter the email address that the faculty/instructors/departments should use to send inquiries back to the bookstore.
Subject: Enter the subject of the email.
Email Body: Enter the body of the email.
Send Test Email: Enter a ‘Y’ to ONLY send a test email to the email address entered in the ‘Reply to Address’.
This report will show all of the adoptions and the status of waiting for Department or Bookstore approval.
Enter Store #– required.
Enter Term – required.
Department – this will filter and only show the department selected.
Course – this will only show those with the selected course number.
Pending – this will show only those with the status entered. Options are ‘D’ for Department, ‘S’ for Store, ‘B’ for Both.
This report will give you a list of the courses that have been submitted by with ‘NO TEXTBOOKS REQURED’ submitted by the Instructor/Department.
STORE – required
TERM – required
Department – this will filter and only show the department selected.
Course – this will only show those with the selected course number.
This report will show all of the adoptions that have been submitted by the faculty.
Enter Store #– required.
Enter Term – required.
Department – this will filter and only show the department selected.
Course – this will only show those with the selected course number.
Once the faculty/department has submitted an approved adoption the bookstore will receive an email notification. This should be a trigger for the bookstore to know that adoptions are pending their approval.
OPTIONAL: Report TX 1.23.6 – Adoption Pending Approval
This report can be run to see how many adoptions are pending approvals by the bookstore and/or the departments (if necessary). It is recommended to display to the screen/terminal for review.
Once the bookstore receives a notification that adoptions are pending approval, they must review and make any required changes to the adoption before the adoption will be added to the specified course. This step will allow the bookstore to cycle through all pending bookstore approval adoptions to view and update them into the TCS system.
(Screen 4)
Input the store and term to update the pending adoptions. You also have the ability to filter your selection by Department or Course. Run the Procedure. The system will show how many adoptions are pending, press continue.
(Screen 5)
The system will present the first approved adoption on the screen. If the faculty/instructor entered any comments, a window will display (Screen 5) with the comments. You have the option of Printing the comments, Canceling the acceptance or selecting OK to have the comments added to the “FacComments” field. These comments only for the bookstore personnel and will not display unless you add them to the “Web Comments” field or the “Shelf Tag Note” field.
(Screen 6)
Look for ANY ‘/’ slashes in the screen (Screen 6). These are the changes that were submitted by the faculty/instructor and will need to be updated by the bookstore. Update the record by removing the slashes and inputting the correct information in the field.
To help the bookstore with determining the quantity to cover (QTC), the ‘inq’ column is available so the bookstore can view historical information on this title. By putting a ‘Y’ in the ‘inq’ field, a screen will display with previous terms historical information and the bookstore can make a better determination on the quantity needed. The ‘EBB’ field is available for the bookstore to input estimated buyback figuresfor this title.
By clicking the ‘Save’ or pressing ‘ENTER’ the system will prompt with the fields that need to be updated and then exit the adoption screen. If you would like to proceed to the next pending record, press ‘N’ for next, this will save the currently displayed adoption and cycle the next pending adoption to the screen.
Be sure to SAVE the record or press ‘X’ to exit the record without saving your changes. By pressing ‘X’ or exit, the system will add the adoption back to the pending bookstore approval file for processing later.
Other options along the bottom of this screen allow the bookstore to navigate throughout the pending adoptions.
‘SP’ Skip to Previous – Allows the bookstore to bypass the currently displayed adoption and move to the previous adoption in the pending file.
‘SN’ Skip to Next – Allows the bookstore to skip to the next pending adoption and skip the currently displayed adoption.