2020 End of Year Programs in BSMGR

Periodic Programs to Run in Bookstore Manager RMS

As we approach the end of the year, there are some programs you may want to consider running to prepare for the new year.


APHU – Vendor History Update (Platinum users only)
• The APHU program moves year-to-date totals spent with each vendor to last year’s totals.
• The information shows on APM.
• This program is usually run in late December.

APVE – Vendor Invoice Edit/Delete
• Drops Accounts Payable invoices/credit memos that have been paid from 1 to 60 months, as set up in SYS | Config File | Change Misc. Configurations | # 3000.

ARHU – Customer History Utility
• The “Delete History” option deletes Accounts Receivable history prior to the date entered.

BVH – Rental/Library History Roll
• This program zeroes out current period rentals.
• Total rentals and total fees are not affected.

IVD – Delete Old P.O. #’s
• Deletes purchase orders by date.
• Deletes old purchase orders dated prior to the date entered.

IVSD – Delete Special Orders
• You specify the number of days to keep (up to 999).
• You specify (by status) which will be deleted. Options are “Received”, “Shelved”, “Picked Up”, “Unavailable” and “Shipped”.

MLD – Delete Customer by Date
• You can identify up to three customer types that will not be deleted. By default, churches (Customer Type “C”) will not be deleted.
• All other customers with a “last activity date” prior to the deletion date will be removed.

MLUL – Mailing Utilities
• The “History Roll” option moves current purchase totals and current transactions to last year’s purchase/transaction totals. Total purchases/transactions are not affected.
• The “Purge Tracking Detail” option will remove tracking records older than the input date.

SLTD – Transaction Deletions
• Since transactions saved for viewing through the SLTR program use up to 75 lines per transaction, you may periodically need to run this SLTD program to clear the file of older transactions.


Remember, you can use the SCHEDULE program to automate some of the periodically run programs. You will need to have SCHEDULE run from the Windows Task Scheduler.

For example,

  1. You need to consistently back up your store’s data. If enabled, the SCHEDULE program will do three backups.
    1. Up to 31 days of archives. This allows you to undo a mistake up to a month after the fact.
    2. Copy all BSMGR files to another computer. This other computer can be quickly changed to become a temporary server if the main server fails.
    3. Copy all BSMGR files to a removable backup device (normally a USB flash drive). This gives you an off-site backup in case your computers are stolen or damaged by flood or fire.
  2. You should run IVT daily to have a historic snapshot for comparing inventory totals.
  3. You can choose to have your inventory history rolled weekly and/or monthly.
  4. You can have IVD run every week.
  5. You can update the RFM (Recency/Frequency/Monetary) ranking of all customers.
  6. You can get database updates every night.
  7. You can submit sales data to EOI so you can take full advantage of the Best Seller data from IVDI.

For help adding SCHEDULE to the Windows Task Scheduler, click the appropriate link below. You only need to set this up on one computer per location (normally the server).


Please contact us if you have any questions or need help getting SCHEDULE set up.

Remember, you can view ECN notices and other emailed communications from Bookstore Manager at emails.bsmgr.com.

Your BSMGR Support Team
support@bsmgr.com | (800) 997-6724 (option 2)

2020 Christmas Blessing

Sometimes the holidays remind us of what we’ve lost, and we feel like we are all alone. While 2020 has been a difficult year, we are grateful for the reminder that Christmas provides of God’s great love and mercy, shown through sending his Son to live as one of us.

As we close this year, we wish to express our deep gratitude for the work you are doing for the Kingdom and the privilege we have in being a small part of your ministry. As the new year approaches, we pray that God’s grace and blessings will sustain you throughout 2021.

Merry Christmas!
From all of us at Bookstore Manager

All this took place to fulfill what the Lord had said through the prophet: “The virgin will conceive and give birth to a son, and they will call him Immanuel” (which means “God with us”).
– Matthew 1:22-23 (NIV)

Christmas 2020 and New Year’s Day 2021 Holiday Support Hours

Thursday, December 24th (Christmas Eve):
Our office will close at noon (Central time), but we will monitor our emergency support number that afternoon for critical issues, such as an inability to perform sales, accept credit cards, or burn discs. That number is 325-669-2381. Leave a message and your call will be returned as soon as possible. Non-emergency calls will be returned during normal business hours on Monday, December 28th.

Friday, December 25th (Christmas Day):
Our office will be closed. Any messages left will be returned during normal business hours on Monday, December 28th.

Saturday and Sunday, December 26th and December 27th:
We will be monitoring our emergency support number for critical issues, such as an inability to perform sales, accept credit cards, or burn discs. That number is 325-669-2381. Leave a message and your call will be returned as soon as possible. Non-emergency calls will be returned during normal business hours on Monday, December 28th.


Thursday, December 31st (New Year’s Eve):
Our office will close at 5:00 PM (Central time).

Friday, January 1st (New Year’s Day):
Our office will be closed, but we will be monitoring our emergency support number for critical issues, such as an inability to perform sales, accept credit cards, or burn discs. That number is 325-669-2381. Leave a message and your call will be returned as soon as possible. Non-emergency calls will be returned during normal business hours on Monday, January 4th.

Saturday and Sunday, January 2nd and January 3rd:
We will be monitoring our emergency support number for critical issues, such as an inability to perform sales, accept credit cards, or burn discs. That number is 325-669-2381. Leave a message and your call will be returned as soon as possible. Non-emergency calls will be returned during normal business hours on Monday, January 4th.


Remember, you can click the “Tech Support Information” button on the main page of BSMGR to find it along with other contact options.


Merry Christmas and Happy New Year from your BSMGR Support Team!
support@bsmgr.com | (800) 997-6724 (option 2)

Munce 2021 New Year New You Catalog

If you are sending the Munce 2021 New Year/New You Catalog, please download and process the data file that will prepare your inventory.

  1. Download the Zipped catalog data files by clicking here.
  2. When the download completes, open the Zip file and extract/copy the files to your BOOK folder.
  3. In BSMGR, run “IVPROMO” at the Enter Program Name prompt.
  4. At the “Enter File Name” prompt, type the file name that matches which one you are sending out (see below), then click the OK button.
  5. If you selected a flexible date file, you will be prompted for the start and end dates of the sale.
  6. Any products that are in the catalog and not in your inventory will open the IVM “Add” screen. Add the missing product(s) to your inventory. The catalog’s promo code, start date, end date, and sale price will be set for all the products in the catalog.
  7. If IVPROMO doesn’t do anything, make sure you copied/extracted the files from the current MunceCatalog.zip file to your BOOK folder.

Current file names to choose from for the IVPROMO program…

  • M-JAN-R.TXT = New Year/New You Catalog (Regular)
    (4-Jan-2021 thru 30-Jan-2021)
  • M-JAN-RF.TXT = New Year/New You Catalog (Regular/Flexible)
    (Flexible dates – you set when running IVPROMO)
  • M-DEC-R.TXT = Countdown to Christmas Catalog (Regular)
    (30-Nov-2020 thru 2-Jan-2021)
  • M-DEC-RF.TXT = Countdown to Christmas Catalog (Regular/Flexible)
    (Flexible dates – you set when running IVPROMO)

If you have any problems downloading the file or getting the file to process from within IVPROMO, please let us know.

Your BSMGR Support Team
support@bsmgr.com | (800) 997-6724 (option 2)