1

ADDING A VENDOR

ADDING A VENDOR

To add or create a new vendor in the system is the same process for General Merchandise and Textbook. If you have the Accounts Payable module then you will also need to create the vendor there and link it to the vendor that you created in GM or TX, keep in mind that GM and TX share the vendor file so if you create it in one then it will be available in the other.

Log to either GM or TX and then select the VM – Vendor Maintenance option

  • Vendor ID: Enter a period ‘.’ To create a new vendor number or enter 3 or more letters in the vendor’s name or sort code to bring up an existing vendor.
  • Sort Code: Enter a code that will help you find or reference this vendor. This code is used in cross-references and for sorting in reports.
  • Type: Enter the Vendor type.  Options here are D=Distributor, M=Manufacturer, P=Publisher, V=Vendor, W=Wholesaler.  Publisher and Wholesaler are normally used in Textbook (TX), Manufacture and Vendor are normally used in General Merchandise (GM) and Distributor is used in both.
  • BIP Code: Used is TX and stands for Books In Print Code, Books In Print is not commonly used anymore.
  • WBG Code: Used in TX and stands for Wholesale Buying Guide, this indicates what wholesale guide code to associate with this vendor.
  • Alt Order Vndr: This is used to indicate if an alternate vendor should be used for this Vendor, this is normally used when one vendor buys another.
  • Alt Rtn Vndr: This is used to indicate if an alternate vendor should be used for this Vendor, this is normally used when one vendor buys another.
  • Name: The name of the Vendor as it will show on reports and POs and Returns.
  • Enter Address, City, State, and other information as it is available.
  • Prepaid: Enter a ‘Y’ here if this vendor must be prepaid.
  • SAN #: This is a textbook field and stands for Standard Address Number.
  • Last Update: This field is maintained by the system
  • Average Ship Days: Enter in the average number of days it takes for shipping.
  • Minimum Order Qty: Enter the minimum order quantity that this vendor requires to process/ship an order, this is usually a GM vendor field.
  • Minimum Order Amt: Enter the minimum order amount that this vendor requires to process/ship an order, this is usually a GM vendor field.
  • Default Ship Code: Enter in the default ship code that will be used when creating a po for this vendor.
  • Backorder Code: Enter the default backorder code to use when processing a receiving for this vendor.
  • List/Net: Enter either ‘L’ or ‘N’ to set the default pricing type to use when creating a PO for this vendor. L=List pricing and N=Net pricing, List pricing usually includes a discount off of the List and Net is direct price of the item.
  • Store/Name/Account Number Enter in the store number and Account Number associated with that store
  • EDI/Wantlist/etc. This is used in TX for the electronic wantlisting.
  • Comments: Enter a ‘Y’ and then enter any comments that you would like to have associated with this vendor.

Next you should enter in the additional ordering information and the returns information.

Additional Ordering

To enter in the additional ordering information, select the ‘A=Additional Ordering’. The information on this page is used with the Accounts Payable (AP) module

  • Account Number: Enter in the Primary Account number
  • Payment Terms: Enter the default payment terms, normally net30
  • Delayed Billing Days: Enter if there is a default billing days for this vendor.
  • Discount Code: Enter a discount code to use for this vendor.
  • Discount Flag: Enter a discount flag to use for this vendor.
  • Discount Break Point: Enter a discount break point for this vendor.
  • Discount Value: Enter a discount value to use for this vendor.
  • A/P Vendor # Enter in the A/P vendor to associate this vendor to. If this is left blank and you have the AP module then the invoices will be associated with the AP Vendor 99999. You will need to navigate to the AP module and create the appropriate vendor there and then enter that vendor number here.

Returns

  • Name/Address Enter the Return address information for this Vendor
  • Contact/Phone/Fax#: Enter in the contact information for the Return information.
  • Allow Returns* Enter ‘Y’ if vendor allows returns or ‘N’ if they do not allow returns, this will affect the returns processing in TX.
  • Permission Required* Enter ‘Y’ if permission is required for returns or ‘N’ if no permission is required. This does affect the returns processing in TX.
  • Min/Max Months for Returns: Enter in the minimum and maximum number of months allowed for returns, maximum returns is required for the TX auto return process to work.
  • Return Penalty Amount: Enter in any penalty amount vendor will apply to returns.
  • Return Penalty Percent: Enter in any penalty percentage a vendor will apply to returns.
  • Invoice Copy Required:                 Enter in the number of invoices the vendor requires for each return.
  • Vendor Invoice Maximum: Enter the maximum dollar amount a vendor will allow you to return.
  • Percent Invoice Maximum: Enter the maximum invoice percentage that the vendor will allow to return.
  • Return Comments… Enter in any default return comments, these will print on every return created to this vendor unless overridden on the return.
  • Shipping Instructions…. Enter in any default shipping instructions that you would like to print on every PO.

 

Create the vendor in AP

Log to the AP module and select VM=Vendor Maintenance from the main screen.

  • Vendor ID:                 Enter a period ‘.’ to create a new vendor or enter 3 or more letters in the vendor’s name to edit an existing vendor. This vendor number will be used in the GM/TX vendor record in the ‘Additional Ordering’ information screen.
  • Sort Code:                 Enter 3 or more letters to use as a sort code for the vendor.
  • Name/Address/Contact Enter the vendor’s name, address, phone, contact information.
  • Status:                 This should normally be ‘A’
  • Terms:                 This is normally N30 but can be any payment term that you have created. You can use the ?? button to select from the available terms or from the selection screen you can select the ‘Maint’ button to jump to the terms maintenance screen and create a new one if needed.
  • Check Limit:                 Enter a check limit amount for this vendor or leave blank for normal
  • Hold Checks til:                 Enter a date if you wish to hold checks until a certain date.
  • Last Check Date: This is maintained by the system and will list that last date a check was created.
  • TL VAR:                 Enter ‘Y’ if this is a TotaLink VAR, enter ‘YN’ if no checks should print.
  • Account Num:                 Enter in the account number.
  • G/L Account: Enter the GL account number that this should be associated with.
  • 1099 Code: Enter any 1099 codes for this vendor
  • Priority: This will default to 90.
  • 1099 Amount: Enter any 1099 information.
  • Default Invoice Description: Enter any default description that you would like to display.
  • Miscellaneous Enter any miscellaneous information that you would like for this vendor.

 




Set or Reset a User Password

Some menus have been changed, please read carefully.

While the steps on how to change a user’s password are straight forward, there are a few points that need to be kept in mind.

  1. When you set a user’s password in User Maintenance (UU-5-1) or User-Cashier Maintenance (POS-22-1) the system automatically sets their password to reset when they first log in.
    1. This means that the password set in User Maintenance is temporary. Do not set the password to what the user would like to use long term.
  2. It is necessary to set the user’s password from the Host Connection. While these steps can be followed on an individual register, passwords that are changed on the cash register ARE NOT sent to the host or to all of the other registers.
    1. By setting the password on the host all registers will get the updated password.
    2. Check POS-6-2 to view which registers are communicating. Those who have a “To Be Xfered” amount of zero in the right hand column will immediately have the updated password.
      1. Steps to restart the register communications can be found in the Smartlane Communications video here.

To quickly reset the password for the logged in user

  1. Type PASSWORD into any menu prompt and press Enter
  2. A dialogue will appear prompting for the users password along with a Enter New Password and Confirm Password prompt
    1. Enter your current password into the “Enter Your Password” prompt
      1. This is to confirm the identity of the logged in user
    2. Enter a new password into the “Enter New Password” field.
      1. Passwords must be 8 characters long and include at least one letter and one number
        • g. 1234567A or ABCDEFG1 the password is NOT case sensitive, this means that ABCDEFG1 and abcdefg1 are both treated the same.
      2. Re-enter the new password into the “Confirm Password” field and press enter.
    3. The password has now been set for the logged in user and will update to all of the registers.

 

To reset the password for another user

  1. From any module, go to UU-5-1 or POS-22-1
  2. Enter the user ID of the user who’s password is going to be reset
  3. Navigate to the Password field and type in the new password
    1. Note that this new password is temporary. The user will be forced to set their own password after the log in with this temporary password.
    2. Passwords must be 8 characters long and include at least one letter and one number
      • g. 1234567A or ABCDEFG1. They can also include special characters. The password is NOT case sensitive, this means that ABCDEFG1 and abcdefg1 are both treated the same.
  4. Enter the temporary password again into the Confirm Password field
    1. Press Continue on the notification box. This is a notification that the password entered is temporary and the user will need to reset their password when they log in.
  5. Press ESC after reaching the Expires field
  6. Enter to save the password change.
  7. Have the user log in with their new temporary password.
    1. You can type in ID at the menu and press enter to display the login prompt or have them log into another connection.
  8. They will immediately get a prompt to reset their password
    1. They need to enter their new, permanent password into the Enter New Password and Confirm Password fields
    2. Passwords must be 8 characters long and include at least one letter and one number
      • g. 1234567A or ABCDEFG1. They can also include special characters. The password is NOT case sensitive, this means that ABCDEFG1 and abcdefg1 are both treated the same.
  9. After that is complete their password will update to all of the registers.

 

 




Getting a Report Into Excel

These instructions cover how to save your reports as a text file and then import it into Excel. Most reports are formatted in a way that allows this but there are a few exceptions. Exceptions occur when the report data doesn’t line up perfectly into columns, such as the Tender Register Summary report (POS-RP-2-21).

  1. First, run your report as normal and send the output to Terminal.
  2. Now we need to save the report as a text file on your computer to import into Excel.
    1. Click on the Save icon at the top of the Terminal Window
    2. Select where you want to save the file.
      • This can be anywhere on your computer. Typical locations will be Documents or Desktop
    3. Name the file
      • Keep it simple and preferably without spaces.
    4. Change the “Save as type” to “Text Files”
    5. Click on the Save button

Importing Into Excel

This assumes that the steps above have been performed and you have a copy of the report on your computer as a .txt file. Things can get a little confusing but if you watch the animated image in step 6 it will cover most of the non-intuitive steps.

  1. Open Excel
  2. Go to File > Open
    • Or press and hold the Ctrl key and then press O bring up the Open dialogue.
  3. Browse to where you saved the file in step 2.2 above
  4. Change the All Excel Files drop down box to All Files
  5. Select the .txt file saved in step 2.2 above
  6. In the Text Import Wizard (step 1 of 3) Select the Fixed width option
  7. In step 2 of 3, click and drag the arrows/lines to the edge of the text. These mark the columns to be used in the spreadsheet.
  8. In step 3 of 3, click on each column and asign the Text data format in the top left
    • You can select the first column, move the slider all the way to the right, press and hold SHIFT and click on the last column. With all columns selected click on the Text data format option on the top left.
    • Click Finish
  9. Now all of the data should be in the Excel document. The ISBN numbers should not look like a notation number (9.78129E+12) they should display as full ISBNs.
  10. Save the document.
    1. If sending to another organization (e.g. Redshelf ebook list, third party inventory company, etc.)
      1. Go to File > Save As.
      2. Browse to where you would like to save the document
      3. Enter a name in the File name field
      4. Click on the Save as type: drop down and select “CSV (Comma delimited) (*.csv)”
      5. Click on Save
      6. The file can now be sent as an attachment
    2. If saving for internal use
      1. Go to File > Save As.
      2. Browse to where you would like to save the document
      3. Enter a name in the File name field
      4. Choose whatever you would like as the file type. The default is typically .xlsx
      5. Click on Save



Accounts Payable Training

Getting Started

Utilities and A/P System Parameters

The Utilities/Setup menu allows you to establish basic static data about your organization. Generally this data is rarely changed. It also contains rarely used functions that are not part of normal daily or periodic processes.

As with all menus the Global Menu appears at the bottom allowing you to easily switch to common functions if necessary.

General Parameters

This is where you enter basic information about your organization.

  1. Business Name
  2. Address
  3. The Federal Tax ID is used when printing 1099 forms. If you will not be printing 1099 forms then this field is optional.
  4. The Current Account Period is the month that invoices that are being entered will be posted to. You may set this here or from Main Menu > 3. End of Month > 3. Change Accounting Period.
  5. The A/P Ledger Account Number is the “offset” account for all A/P transactions. This is the liability account that you set up in the G/L module.
  6. Show PM Menu. If you will be printing checks or spooling reports to hold files then enter a Y here. This will cause the Printer Mgmt menu to appear on the Main Menu.
  7. Some organizations set a minimum check amount to limit the number of checks that are sent for “insignificant” amounts. Usually a zero check would not be printed. Zero checks, or checks less than zero could occur if you have credits that offset or exceed invoice amounts.
  8. The check preview process lets you view the invoices and credits for each vendor prior to printing checks. (Or where implemented, prior to preparing payment vouchers.) This report can be sorted by Vendor Number of Vendor Name. Enter a “V” for Vendor Number, an “N” for Vendor Name.
  9. If you take Purchase Discounts then enter the appropriate G/L number.

Maintain Ledger Accounts

*** If you are using the SmartSuite G/L Module you should manage your G/L accounts in the G/L Module and not use this menu option.

  1. G/L Account Number.
  2. Enter a brief description of the account.
  3. Status. Enter “A” for active or “I” for inactive. Inactive accounts cannot be used when entering a new invoice. The description for invoices and reports come from this file. You can delete accounts if they will no longer be used for any reports.

To delete an account enter a “D” at the Options prompt.

  1. Indicate if the balance of this account is usually a Debit or a Credit balance by entering a “D” or a “C”.
  2. Indicate the general category of the account by entering “A” for asset, “L” for liability, “OE” for owner equity, “E” for expense or “I” for income.

Payment Terms

AP-UT-03

This table is used to automatically calculate due dates and discounts during invoice entry.

  1. Enter a brief code – no spaces allowed – that will represent your payment terms.
  2. Enter a brief description. There is limited space on the invoice enter screen for this description so make it as concise as possible.
  3. Indicate what date will be used for determining the age of an invoice. Use “I” for Invoice date or “R” for Received date.
  4. Discount Percent is the percentage (with two decimals) that will be applied for timely payments.
  5. Days for Discount is how many days after the Invoice or Receiving date that discounts are allowed.
  6. Specify the number of days following the Invoice or Receiving date that the invoice total is due for payment.

Rebuild Vendor Cross Reference

AP-UT-21
Select this option if you want to rebuild the vendor cross reference. This is a process that usually is only used after importing a vendor database.

When the process is complete simple press Enter or click on the “Done” button.

Check Formatting

AP-UT-22

Formatting checks to fit various check forms is accomplished by using this table. The system supports most standard check formats. It also allows for printing “supplemental” forms in the event that there are more invoices than what can be displayed on the check stub. Or, you can use up checks if the form limit is reached.

  1. Enter the printer number where this form will print. Use F6 for printer/form 6. You can also enter #of copies or HS, etc. If you are printing through Print Wizard then enter Wn where n is the printer number. Print Wizard is used whenever there is a need to print logos or signatures on the check stock.
    1. Options:
      1.  An.  The literal “A” followed by the “Auxport” printer sequence.  The printer sequence is based on the sequence in GUI Properties, Other, Printer Settings.  Most users use the same printer that is used for reports by just changing the paper in the printer to check stock.  Default printer settings are as follows:
        1. GUI Interfaces:
          1. Printer 1 is the Receipt Printer.
          2. Printer 2 is the Report Printer.
          3. Printer 3 is the Barcode Printer.
          4. Printer 4 is the Customer Display Pole.
          5. Printer 5-9 are Alternate  Printers.
          6. Printer 0 is for testing and sends the check “image” to the GUI viewer.
        2. Accuterm interfaces:
          1. Sends the check to the Auxport Printer.
      2. Wn.  The literal “W” followed by:
        1. ‘(‘printer filepath on the server’)’
        2. PDF.  Saves image to c:\spool\pdf\CheckNumber.pdf
        3. blank… Saves to NT:C:\SPOOL
  2. The Print Sequence specifies the order of printing the check stock. The system supports two and three section check stock. S=Stub, B=Body. Valid formats include “SB”, “SSB”, “BS”, “BSS”, “SBS”.
  3. If you wish to print a Form Feed after the last check (to eject the last form) then enter a “Y” otherwise enter “N”.
  4. The number of physical Lines on Body is how many total print lines are available on the Body of the form.
  5. The number of physical Lines on stub is how many total print lines are available on the Stub portion of the form.
  6. Lines on Supplemental is the number of lines that can be printed on a supplemental form before a new page starts.

Stub Factors

  1. Specify which row number on the stub you are referencing. If the number of Lines on Stub is 12 then this number should not exceed 12.
  2. Column is the physical column number on the stub where printing will begin.
  3. Attribute: This is a multi-function field. There are key words or free-form text. If what is entered here is not a keyword then the text will be printed. Key words and what they do include:
    1. “0” or “INVOICE” prints the invoice number
    2. “DATE” prints the invoice date
    3. “GROSS” prints the gross amount of the invoice
    4. “DISCOUNT” prints the discount taken on the invoice
    5. “NET” prints the net amount of the invoice (gross – discount)
    6. “Vnnn” prints field “nnn” of the vendor file
    7. “Cnnn” prints field “nnn” of the check file
    8. “Pnnn” prints field “nnn” of the check parameters file
    9. “COMMENTS” or “DESCxxx” prints the invoice check comments field
    10. “CHECK.GROSS” prints the check gross amount
    11. “CHECK.DISC” prints the check discount amount
    12. “CHECK.NET” prints the check net amount (check gross – check discount)
    13. “CK.ID” prints the check number
    14. “NAME” prints the vendor name
    15. “VENDOR” prints the vendor number
    16. “CHECK.DATE” prints the date of the check
    17. “nnn” prints field nnn of the check file
    18. Anything else prints what is typed in.
  4. Conversion is any valid “Pick” conversion code. Common codes include:
    1. D2/ – Date in mm/dd/yy format
    2. D4/ – Date in mm/dd/yyyy format
    3. MD2 – numbers with two decimals
    4. MD2 – numbers two decimals and commas where appropriate
  5. The Mask column is used the specify the justification and width of the field being printed.
    1. “L” indicates Left-justifed
    2. “R” indicates Right-justifed
    3. The symbol following the “L” or the “R” is fill character to use to complete fill up the width of the field.
      1. Use “#” to fill up the area with spaces.
      2. Use “%” to fill up the area with zeros.
    4. The number following “#” or “%” is how wide the field will be.
  6. TBM specifies Top, Middle or Bottom. On a check stub there are three areas 1) the Top row or heading, 2) the Bottom row or footing, and 3) the space between the top and bottom – the middle.
  7. Comments: This is free form text for you to note anything unique about the row of data.

Body Factors

  1. Specify which row number on the body you are referencing. If the number of Lines on body is 12 then this number should not exceed 12.
  2. Column is the physical column number on the body where printing will begin.
  3. Attribute: This is a multi-function field. There are key words or free-form text. If what is entered here is not a keyword then the text will be printed. Key words and what they do include:
    1. 0 or “CK.ID” prints the check number
    2. “DATE” prints the check date
    3. “NET” prints the check net amount
    4. “WORDS” prints the word representation of the check amount
    5. “VENDOR” prints the vendor number
    6. “NAME” prints the vendor name
    7. “ADDRESS” prints the vendor name, three lines of address, and one line with city, state, and zip code (blank lines are removed)
    8. “ADDRESS1” prints vendor address line1
    9. “ADDRESS2” prints vendor address line2
    10. “ADDRESS3” prints vendor address line3
    11. “CSZ” prints the city, state, and zip code
    12. “Vnnn” prints field “nnn” of the vendor file
    13. “Cnnn” prints field “nnn” of the check file
    14. “Pnnn” prints field “nnn” of the check parameters file
    15. “nnn” prints field nnn of the check recordd
    16. “SIG” prints a stored signature (only valid with Print Wizard)
    17. Anything else prints what is typed in.
  4. Conversion is any valid “Pick” conversion code. Common codes include:
    1. D2/ – Date in mm/dd/yy format
    2. D4/ – Date in mm/dd/yyyy format
    3. MD2 – numbers with two decimals
    4. MD2, – numbers two decimals and commas where appropriate
  5. The Mask column is used the specify the justification, fill character, and the width of the field being printed.
    1. “L” indicates Left-justified, usually used for words
    2. “R” indicates Right-justified, usually used for amounts
    3. The symbol following the “L” or the “R” is the fill character to use to completely fill up the width of the field that is not being used for data.
      1. Use “#” to fill up the area with spaces.
      2. Use “%” to fill up the area with zeros.
    4. The number following “#” or “%” is how wide the field will be.
  6. Comments: This is free form text for you to note anything unique about the row of data.

Merge Two Vendors

AP-UT-22

If you create two vendor records for the same vendor and there are invoices and payments made on both of them you can combine them into one vendor. This process also deletes the “Transfer From:” vendor.

You may use the cross reference in either Vendor field to search for the vendor by name.

After entering both vendors the following box appears:

If you select “Yes” then you will see the following box, with the appropriate information.

Press Enter or click on the “Continue” button to return to the menu.

Day-to-Day Functions

The day-to-day functions are accessed from the A/P Master Menu.

Vendor Maintenance

This menu option is at the bottom center of the screen and is accessed by click on the “hot spot” beginning with “VM” and ending somewhere after the words “Vendor Maintenance”.

  1. Vendor ID: This field functions to look up and existing vendor or to add a new vendor. To add a new customer you can enter a numeric value for the vendor or simple enter a period (“.”) and then press enter. If you typed in a number and the vendor record does not exist you will be prompted to add the customer or exit. If you used the period then can start to enter the information immediately.

To look up and exiting vendor simply type 3 or more letters of their name or the Sort Code. If there are more than on matches you will see a list to choose from. Here’s an example:

If there is more than one page of names then you can use the navigation at the bottom of the screen to move forward, back, etc., and to select a vendor. You can use your mouse and click on the row that their name is on to select the vendor.

  1. If it will be easier to look up a customer by a common abbreviation then enter that abbreviation in the Sort Code field. It may be easier to reference Prentice Hall by PH.
  2. Name, Address, etc. …..
  3. Valid Status codes include “A” for active, “I” for Inactive, “D” for delete.
    1. Active accounts allow you to enter invoices and process payments.
    2. Inactive accounts cannot have new invoices entered but they can receive payment s.
    3. Delete accounts are the same as Inactive.
  4. Enter the default payment Terms that will be used for this vendor. This can be overwritten during invoice entry.
  5. If you want to limit the maximum amount of checks for any given vendor then enter that amount in the Check Limit field. The check preparation/preview process use this limit as the maximum amount of the check that can be calculated. If an invoice will take the check over the limit then that invoice will be dropped from the calculation. No partial payments on an invoice will be made.
  6. Account Number is the vendor’s account number for you.
  7. If there is a default G/L account that will be used for most of the invoices from this vendor then enter it here. This account number will automatically populate the first G/L field during invoice entry.
  8. If this customer should receive a 1099 each year then put their federal tax id in the 1099 Code field. The amount that will appear on the 1099 is in the 1099 Amount field. This can be overwritten prior to preparing 1099’s
  9. The Priority field is used for reports to display the open invoices based on payment priority. It is seldom used but may be helpful for those vendors that must always be paid in a timely manner.
  10. Each invoice, when entered is required to have a description entered. You can set a default description in the Default Invoice Description field.
  11. You may enter any amount of miscellaneous information about the vendor in the are labeled Miscellaneous.

Invoices and Credits

AP-01

Invoices and credits are entered in the same screen. Credits are entered with negative amounts.

  1. Vendor: Enter the vendor number our enter 3 or more letters of the vendor name or sort code to access the vendor.
    1. If the vendor you want to use you can enter a period “.” in the Vendor field to add a new vendor. This will take you to the vendor maintenance screen.
  2. Enter an Invoice Number.
    1. If you enter an existing invoice number then the screen will be filled with the data pertaining to that invoice.
    2. If you want to get a list of invoices for this vendor simply enter “??”.  You will be presented with a small prompt for Invoice Status.  You can enter the invoice status that you want to see or you can enter “??” again and get a list of Invoice Status choices.  The Choices include:  
    3.  You can then select an invoice from the list.
    4. If the invoice is not on file then you can begin filling out the invoice information.
  3. Enter the Status of this invoice. The valid codes include:
    1. “O” – Open for Payment.
    2. “H” – Hold for Payment, do not pay until the status changes to “O”.
    3. “U” – Unreconciled. Same as “H” but it cannot be paid until the status changes to “O”. It cannot be journalized.
  4. Goods/Services, Taxes, Freight, Purchase Order, and Receiving ID are filled automatically from the receiving modules. These fields are not required for any processing but are informational so that you can research the original documents.
  5. Check Comments appear on checks, if part of the check template.
  6. Misc Comments do not appear on checks, unless you add it to your check template.
  7. If you want to see what check(s) paid this invoice you may enter “Y” in the View Payments field or you may enter a “P” at the Options prompt.
  8. After entering Terms the Due Date, Pay Date, and Discount, if any, is calculated and displayed. You may override this fields as needed.
  9. Enter a “Y” in Sub Ledger to entered detailed invoice information. This is especially helpful for credit card payments or similar items that have a lot of detail that you want to summarize by G/L account. After entering Sub Ledger data the account summaries and amounts are displayed in the G/L Account and Amount fields.
  10. If the G/L Account you enter is flagged for payment tracking then the Project field is required.
  11. To delete a transaction enter “D” at “Options prompt”.  If the transaction has been journalized or paid you will need to select the “V”=Void option.

Check Processing

Check and voucher processing is done in either Batches of one or more vendors or by Quick Checks of just one invoice on the check.

All check processes write to the local A/P check file.  If you have the SmartSuite General Ledger system then the check data is also written to the G/L Cash Disbursements file. The  G/L Cash Disbursements file is what is used to create the Disbursements Journal Entry.  There is no process in A/P to post a Journal Entry for any check processing.

Quick Checks

Use this method to print a check for a single invoice.

  1. Enter a new invoice or access an existing invoice from menu AP-02.
    1. Status should be “O” (open for payment).
    2. Credit memos will not print. Only a positive invoice will print.
  2. At the “Options” prompt choose “Q=Quick Check”.

  1. Get the physical check that will be printed

  1. Enter the check number twice.
  2. Enter the bank code the check belongs to.
  3. Select “F” for final run.
  4. Place the check (properly oriented) in the printer.
  5. Select “R=Run Process”
  6. The check will now print on the printer.

Batch Checks

Use this method to print one or more checks for one or more vendors.

  1. Enter all of your invoices using menu AP-01.
  2. Select Menu AP-02. (Check Processing Menu)
  3. Select option 1 – Create Check Preview. This creates pre-checks that can be edited, modified, or printed.

    1. Enter a payment cutoff date for invoices to include in the check preview.
    2. Enter the date that will be printed on the checks.
    3. Enter “Y” or “N” to clear the check preview file. Usually this is “Y”, but if you need to rerun this process and include more vendors than were automatically included on the previous run then enter “N”.
    4. Enter a “Y” or “N” for Recurring Payments
    5. Optional. Enter the vendor numbers that you want to include on this check preview. Leaving the vendors blank will select all vendors.
    6. Optional. You may use the cross reference of 3 or more characters of one or more words of the vendor name to get the customer number.
    7. Select “R=Run Process”. This will create the check preview records.
  1. Optional. Select option 3 to print a report of the pre-checks.
  2. Optional. Select option 2 to view, modify, or delete a pre-check.

You should do at least one of the above to ensure that the invoices you are processing are the correct ones.

Check Preview Edit

AP-02-03

  1. To delete an entire pre-check enter a “D” at the “Options” prompt.
  2. To delete an invoice from the check enter “M” at the “Options” prompt, then enter a space (or press the delete key) over the invoice number to be deleted from the pre-check.
  3. You can also modify the Gross Amount and the Discount.
  4. Repeat as often as necessary.

Print Checks

  1. Select option 4 to print the checks.
  2. Get the physical checks that will be printed.

  1. Enter the first check number twice.
  2. Enter the bank code the checks belong to.
  3. Select “F” for final run.
    1. (“T”rial printing is used for testing your check format and should be printed on plain paper to reduce the cost of wasting check stock.)
  4. Place the checks (properly oriented) in the printer.
  5. Select “R=Run Process”
  6. The checks will now print on the printer.

Void a Check

AP-02-21

Use this feature to void a check that has been printed. All invoices on the check will return to their open, ready to print, status. The invoices then are ready to be included on another check run. If you want to void/cancel the invoices then you will have to remove them in invoice maintenance.

  1. Enter the system Check Number. This may not be the physical check number.
  2. Enter the Bank Code associated with the check number.
  3. The date of the voided check will be today’s date.

The basic information about the check is displayed and then you can choose to void the check or to cancel the process.

Manual Check Entry and Vendor Payments

AP-02-22

If you manually prepared a check for a vendor then use this process to record the check and to update the invoices. This is also where you enter payments from vendors who send you a check for any credits.

  1. Enter a valid Vendor #. You may use the cross reference lookup here.
  2. Enter the physical Check Number that was used to pay the vendor.
  3. Enter the Bank Code associated with the check number.
  4. Enter the Check Date.
  5. You can next enter the invoices that were on the check. If you the invoice numbers then enter each one. You can use “??” to get a list of the open invoices for this vendor.
  6. After each Transaction # is entered you can override the gross and net amounts being paid for the invoice.

You cannot manually pay a transaction with an “H” status.

Note that a running total is being displayed in the upper right hand area of the screen as you add the invoices.

Check Inquiry

AP-02-23

Use the Check Inquiry process to look at checks that have been created. This is very useful when a vendor calls and wants to know information regarding a payment.

  1. Enter Vendor number (or name).
  2. Enter the check number and the bank code in the format of checknumber*bankcode.
    1. It is easiest to use the “??” here. It will give you a complete list of checks for the vendor with the most current check listed first.

Reprint Checks

AP-02-24

  1. Enter the First Check Number that you want to reprint. This is the actual system generate number.
  2. Enter the Last Check Number that you want to reprint. It you are just reprinting one check then use the same number as the First Check Number.
  3. Select “R” to run the procedure.

Posting Transactions to General Ledger

This is for customers who have the SmartSuite General Ledger module installed.  It posts ONLY A/P transactions (invoices and credits), it does not post checks.  Checks are posted in the G/L module.

Pre-Posting Report

AP-03-01

 

You may run this report repeatedly. It is just a report.

  1. Enter the Invoice Cutoff Date.  The process will select ALL A/P transactions that have not been journalized with a date older than or equal to this date.  This way all transactions will eventually be journalized.
  2. Enter a letter to indicate what kind of data you want to see on this report. S is for Summary, D is for Detail, and E is for transactions with invalid G/L account numbers (this could be a result of settings in your distributions codes).
  3. Select “R” to run the procedure.

Create Journal Entry

AP-03-02

  1. Enter the Invoice Cutoff Date. To keep things straight you should use the same date that you used in the Pre-Posting Report, although this is not mandatory.  Only one date for selecting the transactions is required.  All transactions that have not be journalized with this date or older will be included.
  2. Enter the Accounting Period to Post.  When the Journal Entry is created and written to the G/L module it will use this accounting period. Use a valid period.

Change Accounting Period (Optional)

AP-03-03

This process is optional.  The accounting period will be updated with the Accounting Period to Post from AP-03-02.

  1. Enter the current Accounting Period.

Remove Posting Flag

This process allows you to re-post transactions that have already been journalized.  Please make sure that you have reversed or deleted the Journal Entry from the G/L account or you will have a double posting.

AP-03-06

PICTURE

  1. Enter the Journal Code: This is generally in the format of AP*nnnn, where nnnn is the number portion of the original journal entry.

Frequently Asked Questions

Q. When does receiving update the invoice file?

A. Invoices are updated when the receiving is posted.

Q. What happens if the database vendor does not have an A/P vendor linked to it?

A. The invoice is still created but the vendor number that is used is 99999. When this happens you will want to do two things, 1) correct the database vendor. This is done in GM-VM in the Additional Ordering screen. 2) Transfer the invoice to the correct A/P vendor. This is done in AP-04 (Change Vendor or Invoice).

You can stay ahead of the game by entering vendor 99999 in invoice entry and then enter ?? to get a list of any unlinked invoices. You can also run the report AP-RP-02-01. Leave all fields blank except for the vendor field. Put 99999 in the vendor field. You will see specific details about the inventory vendor in the Misc. Comments field.

The A/P Master Menu will display a message whenever there are Suspense transactions to be reconciled.  It will look similar to this.

The invoice information will tell you what to do.

Q. How to write off a Credit Memo?

A. If a vendor sends you a check for their credit memo then instead of voiding the memo invoice simply do a manual payment against the invoice(s).