Accounting Link - Sage 100

PDF

About Prism Accounting Link
Prism Accounting Link serves as an information bridge between Prism and your accounting software.
Using Accounting Link, you can:

• Export transaction data from Prism and post it to the accounting software in the appropriate module (GL, AP, or AR).
• Transfer Accounts Receivable (AR) customer and Accounts Payable (AP) vendor information from Prism to the accounting software AR and AP modules and update current records and create new records for any new customers and vendors.
• Transfer AR customer account status information from the Accounts Receivable module of your accounting software to Prism customer records.

About this Topic
This topic is customized for the Sage 100 accounting software and includes the following information:

• Configure Prism settings related to Accounting Link: Permissions, Customer AR flag, Vendor AP flag and Fee types
• Install Accounting Link
• Configure Accounting Link General Preferences and Preferences specific to Sage 100
• Sage 100 configuration notes
• Use Accounting Link to view and post Prism data to Sage: Initialize Customers and Vendors, Read batches and    Post batches

Accounting Software Version Compatibility
This version of Accounting Link has been tested for use with Sage 100 standard desktop version only (2019-2021). Web version is not supported.
Limitations
Prism Accounting Link does not support global customers.
Configure Prism for Accounting Link
The following sections explain how to configure different areas of Prism that are used by Accounting Link, including:

• Assign security permissions to allow members of specific employee groups to use specific features of Prism Accounting Link.
• Set the Accounts Payable flag on Vendor records.
• Set the Accounts Receivable flag on Customer records.
• Define Fee types to ensure fees are properly recorded in the accounting software.

Accounting Link Security
In Prism 2.0 and later, you can control employee access to different features and areas of Prism Accounting Link by assigning permissions to user groups. To assign security permissions for Accounting Link, navigate to Admin Console > Store Operations > Employees > Groups. Select a group, and then click Edit > Details. Set individual permissions to Allow, Deny or Override as needed.

Permission	Description
Acct Link - Batches - Delete	Allow group members to delete accounting batches.
Acct Link - Batches - Error Log	Allow group members to view accounting link error log.
Acct Link - Batches - Post	Allow group members to post batches.
Acct Link - Batches - Read/Unmark	Allow group members to read data from Prism as well as unmark batches.
Acct Link - Batches - Update Information	Allow group members to update customer, vendor, and associate information.
Acct Link - Batches - View	Allow group members to view batches.
Acct Link - Options - Initialize Information	Allow group members to initialize customers and/or vendors.
Acct Link - Options - Preferences	Allow group members to save changes to Accounting Link preferences.

Sample Accounting Link permissions available in Prism 2.0 and later:

Accounts Receivable Flag on Customer Records
For each accounting customer record, you must select either Export or Yes in the Accounts Receivable field. Records set to Export or Yes are included when using Initialize Customers. Records set to Export are included when using Update Customer. Receipts involving an AR customer and containing an AR tender will be read for later posting to both the GL and AR accounting modules.
The following table explains the difference between the Export and Yes settings.

Accounts Receivable Flag	Description
Export	Select this option to establish a new AR account for the customer in the accounting software. The Export flag indicates that the customer record is to be exported to your accounting software during the next Accounting Link Customer Update. Once exported to the accounting software, the AR flag is automatically changed from "Export" to "Yes."
Yes	Select this option if the customer already has an AR account in the accounting software. After a customer's information is exported for the first time, the AR flag is automatically changed from "Export" to "Yes."
No	The customer's information is not included when sending customer information to Accounting Link.

Sample Customer record showing Accounts Receivable flag set to Export:
 
Accounts Payable Flag on Vendor Records
For each accounting vendor record, you must select either Export or Yes in the Accounts Payable field. Records set to Export or Yes are included when using Initialize Vendors. Records set to Export are included when using Update Vendor.

Accounts Payable Flag	Description
Export	Select this option when you want to establish an AP account in your accounting software for a vendor. The flag indicates that the vendor record is to be exported to your accounting software during the next Accounting Link Vendor Update. Once exported to the accounting software, the flag on the Prism vendor record is automatically changed to Yes.
Yes	Select this option to indicate that the vendor has an AP account in your accounting software. Vouchers involving this vendor will be read for later posting to Accounts Payable. After a vendor's information is exported for the first time, the AP flag is automatically changed from "Export" to "Yes."
No	The vendor is not exported using Accounting Link

Vendor record showing Accounts Payable flag set to Export:

Fee Types
If Accounting Link reads a receipt or voucher that contains a fee type, it assigns the fee amount to the account defined for the fee in Accounting Link Store Account Manager. If a corresponding fee type is not detected, Accounting Link assigns the fee amount to the Fee 16 field (the ‘catch all' fee field for Accounting Link). This catch-all fee field accommodates fee types that may have been used on older receipts and vouchers but are no longer defined in Prism.
Fee types for Prism transactions are defined in Admin Console > Node Preferences > Transactions > Fees/Shipment. Fee types for vouchers are defined in Node Preferences > Purchasing > General.
Note: In Prism 1.14.7 and earlier, define Fee Types in V9/RIL preferences and import into Prism using the V9/Prism Data Replication Service.
Payments on Account (POA) Fee Type in Prism
A Payment on Account (POA) fee type should be defined if you are going to accept payments on in-store charge accounts. A POA fee type allows a customer to make a payment on an Accounts Receivable account through Prism. (Such a transaction will have an Accounts Receivable Fee and customer instead of an Accounts Receivable tender and customer.)
Add a POA fee type in Admin Console > Node Preferences > Transactions > General: Fees/Shipment. Fee types must be defined at the Subsidiary level or lower. When defining fee types, be sure to select the Req. Customer flag for Accounts Receivable fee types, such as POA.
When you define Accounting Link general preferences (AR Options), you will select those AR Fee Types so that Accounting Link will pull the data from Prism.
The fee amounts will then be assigned to the account defined in Store Account Manager.

Install Prism Accounting Link
Navigate to the location where the Prism Accounting Link install files are located.
Right-click PrismALInstaller.exe and select "Run as Administrator."
 
After clicking through the User Access Control message, the End User License Agreement is displayed. Click the radio button for "I accept the agreement" and click Next.

On the next screen, you can change the default install location, if needed. By default, Accounting link is installed to C:\PrismAcctLink but you can choose any location.
 
The next screen shows the Accounting Link instances that will be installed, one instance per subsidiary. Select or clear individual subsidiaries as needed. The screen will also detect and mark each subsidiary whether it's a "new install" or "already installed -update needed". By default, all items will be checked.
Click Next.
 
The Accounting Link Configuration screen is displayed only for a "fresh" installation. It allows users to provide Prism webserver information to configure the acctlink.ini for all selected instance(s).
Enter the Fully Qualified Domain Name (FQDN) of the Prism server where Prism Accounting Link will be installed. The Port number should be "80" and the Protocol should be "http."

Click Install to start the installation.
 When installation is finished, click OK, then click Finish to exit the wizard.

Note: Installer Logs and other related files can be found at C:\Program Files (x86)\Retail Pro\PrismAcctLink folder.
Backup option for over-the-top installs
Backup is ON by default to restore the INI files during over-the-top installs and upgrades. The backup is stored as backup_[current timestamp].zip file in the install directory.
Launch Accounting Link
Navigate to the folder where Accounting Link was installed (default= C:\PrismAcctLink\AcctLink_{{Sub#}})
Note: The first time you launch Accounting Link, you must launch it using the "Run as Administrator" option. After that, you can double-click AcctLink.exe to launch.

Enter the User Name and Password of a Prism user (default =sysadmin/sysadmin) and click OK.
Upon successful login, the Accounting Link home screen is displayed.
 
Accounting Link Navigation Buttons and Modules
Accounting Link contains the following navigation buttons and modules:

Button	Description
	Click the Batches button to display buttons for accessing modules (Receipts, Vouchers, Slips, Memos). Select one of the document types to see a list of all batches created for that document type. By default, only batches that have not been sent to the accounting system (batches flagged as Marked or Preview) are displayed. You can optionally include batches that have been sent to the accounting system (archived batches).
	Click the Options button to access the Preferences button.
	Click the Preferences button to access Accounting Link Preferences. Refer to the Configuring Accounting Link section for details.
	In the Receipts module, read and post receipt batches.
	In the Vouchers module, read and post voucher batches.
	In the Slips module, read and post transfer slip batches.
	In the Memos module, read and post adjustment memo batches.

Status Bar
The status bar at the bottom of the screen displays the logged in user and the current subsidiary number.
Accounting Link General Preferences
This section has information about the following "general" preferences in Prism Accounting Link:

• Select the accounting software (Sage) for each accounting module needed (GL, AR, AP) in Preferences > Prism Accounting Link.
• In Preferences > GL Accounts and GL Accounts > Options, configure the account and sub-account mapping to match the structure used in Sage.
• Configure Accounts Receivable options (Preferences > AR Options). This tells the system what tenders to track and how to handle customer names, addresses, and IDs.
• Configure Accounts Payable settings (Preferences > AP/TC Options). This tells the system how to handle vendor names, vendor addresses and vendor payment terms.
• Configure system options and print settings (Preferences > System Options and System Options > Printing).
• Define Store Accounts (Preferences > Store Account Manager).

Select Accounting Software
Select Options > Preferences and select the top-level node - Prism Accounting Link. On the right, a set of dropdowns is displayed.
Choose your version of Sage accounting software version for each module (GL, AR and AP), and then save the changes.
Accounting Link GL, AR and AP modules configured to use Sage:

General Ledger Accounts
In Preferences > GL Accounts, define the account ID format used in Sage. For example, if accounts in Sage are numbered nnnn-nnn-nnn, this translates to a main account with a length of four and two sub-accounts each with a length of three. The format defined in Accounting Link must match that used by the accounting software for information to post successfully.
Sample Accounting Link GL Accounts preferences showing main account with a length of 4 and two sub-accounts each with a length of 3:

General Ledger Options
In Preferences > GL Options, select the receipt tenders you want Accounting Link to recognize. Only tenders that are selected will be recognized by Accounting Link and posted to the General Ledger module in Sage. By default, all tenders are selected. Clear those tenders not used by your company.

Accounts Receivable Options
In Preferences > AR Options, specify which Prism tenders and fees should post to Accounts Receivable. To be posted to Accounts Receivable, a Prism transaction MUST include an Accounts Receivable tender or an Accounts Receivable fee, AND an Accounts Receivable customer.
A Prism transaction cannot be posted to Accounts Receivable if either of the following conditions exists:

• Transaction contains both an AR tender and an AR fee.
• Transaction includes an AR tender or fee, but not an AR customer.

Note: The "Convert customer ID" is of special importance to Sage users.
Refer to the following table for information about the Accounts Receivable settings:

Option	Description
AR Tenders	Select each tender that you want posted to AR.
Fees	Select each Fee that you want posted to AR. Fees are transaction charges in Prism that need not be associated with a particular line item. They are often used for services, such as gift-wrapping or alterations. One fee is commonly set up as a Payment on Account (POA). A POA allows a customer to make a payment on an AR account through Prism.
Writing aging code to customer INFO2	The aging code is an indication of how tardy the customer has been in making payments. The stages of aging status must be defined in the accounting software. If this option is selected, the aging code will be imported to the Info 2 field in Prism.
Use external default terms	If selected, Accounting Link will not post any Prism customer terms information, including due date and discount available, when sending AR batches. If you choose to use the values generated in Prism, then you can further specify a due date for the COD tender. The COD due date is defined as the number of days following the transaction date. The minimum that can be set is 1 day and the maximum is 99 days. This date applies only to AR transactions using COD, when COD has been configured as an AR tender.
Import customer balances	Select to import customer credit balances into Prism from the Accounting software when updating customers. The balance is the positive or negative dollar value associated with the Customer Accounts Receivable account.
COD Due Date	If using terms defined in Prism instead of external terms, define the COD due date (the default is 7 days).
Customer name order	In Prism, a customer's name can be entered into separate First Name and Last Name fields each with a 30-character maximum. Depending on the accounting software, the two Prism Name fields may be combined, and, if necessary, shortened for posting. The Name fields can be combined as either: Last First - Last Name followed by First Name First Last - First Name followed by Last Name
Convert customer ID	This setting enables you to convert customer IDs to a certain fixed length. This setting is primarily for Sage 100 users because of differences in how customer IDs are handled in Sage 100 and Prism, but it can be used by users of other accounting packages. More information about each available selection is in the "Convert Customer ID" section which follows this table.
Retail Pro Address 1-3	Prism supports three general address fields and a ZIP code field. The various accounting programs support a variety of address fields. As a result, the Prism address fields need to be configured to populate the accounting address fields, as appropriate. The accounting address fields to which you can configure your Prism customer address fields are: None Accounting Address 1 Accounting Address 2 Accounting City/State If you are using only Address fields 1 and 3 in Prism, you will want to configure the addresses so that a blank line does not appear on accounting bills for the unused address field. In this case, Prism Address 1 and Address 3 must be configured to populate specific accounting address fields and Address 2 configured to None. Note: City and State are normally combined in the Prism Address 3 field. To accommodate accounting programs that store this information in two separate fields, separate City and State with a comma when entering that information in Prism. If the Node Preferences > Customers > Allow Duplicate Customer IDs preference is enabled, two or more customers can have the same Customer ID. This will create a problem with A/R customers who share an ID. Information associated with the Customer ID is sequentially merged during updating via Accounting Link. As a result, amounts (such as balances) end up being combined and recorded for each customer who shares the Customer ID. As such, it is recommended that retailers who use the Accounting Link do not select this Prism preference.

Convert Customer ID
The Convert Customer ID setting is used by Sage 100 users because of differences in how customer IDs are handled in Sage 100 and Prism. Sage 100 uses seven-character customer IDs. Prism supports Customer IDs of up to nine characters. Therefore, the Prism Customer ID on records may need to be converted when read into Accounting Link.
Here are requirements for Sage 100:

• If the customer ID is fewer than seven characters, the ID is padded (on the left) with zeros (0) until it is seven characters. Customer IDs of more than seven characters ARE allowed.
• If you are a new user of Prism and Accounting Link, with no history in the Sage 100 database, the best choices are Convert to 7 or Convert to 9.
• If you want all customer IDs to have the same length in Sage 100, select Convert to 9.
• DO NOT select the Do not Convert setting.
• Once you pick a conversion method, you should not change.

Option	Description
Do not convert	Do not select the Do not convert setting. If selected, Accounting Link will read the Customer ID exactly as it currently exists in Prism. If an error is generated during posting, the Customer IDs of such records and receipts must be manually edited before they can be posted. To maintain uniqueness, you can use the customer's phone number as the Customer ID. Note: Non-AR receipts will be read regardless of the Customer ID length.
Convert 9 characters to 7	This converts any Prism Customer ID to seven characters. First, if necessary, leading zeros are added to the ID to make a total of nine digits. Then the first and fourth characters of the nine-digit ID are removed. (The nine-digit customer ID may consist of two segments: a three-digit installation ID and a six-digit sequence number. Stripping the first digit from both segments produces the least chances of two customers having duplicate customer IDs in Sage 100.) This type of conversion supports unique Customer IDs for up to 99 single-station (A) stores with a maximum of 99,999 customers for each store.
Convert to 9 characters	Convert the current Prism Customer ID to nine characters, padding with leading zeros if necessary.
Convert to 7 characters	Convert the current Prism Customer ID to seven characters, padding with zeros, if necessary. If the ID is seven characters or more, it will be left intact (no padding and no stripping).

System Options
In Preferences > System, define options that include defining batch deletion and purging instructions, choosing the placement of the side toolbar, and specifying the default web page that is to be displayed in the Accounting Link.

Option	Description
Send all active marked batches when posting	If selected, Accounting Link sends all marked batches when posting batches, instead of just the current batch being viewed.
Automatically delete batches after logging in	There are two "housekeeping" functions in the Link, Delete and Purge. Only Preview and Posted batches are affected by these functions. Marked batches cannot be deleted/purged. They remain in the Link until posted or unmarked. Delete removes a batch from Link use and flags it as purge-ready. The Purge function permanently removes a previously deleted batch from the system. Deleting unneeded batches helps keep the Link working efficiently. Select "Automatically delete batches after logging" to enable other delete and preview options.
Delete preview batches when they are older than how many days?	(Only available if "Automatically delete batches after logging" is selected). You can configure the system to automatically delete Preview batches after a specified "age" is reached. Enter the number of days, such as 90. Preview batches are deleted when they become older than the entered value.
Delete posted batches when they are older than how many days?	(Only available if "Automatically delete batches after logging" is selected). You can configure the system to automatically delete Posted batches after a specified "age" is reached. Enter the number of days, such as 180. Posted batches are deleted when they become older than the entered value.
Ask for confirmation for automatic deleting	(Only available if "Automatically delete batches after logging" is selected). If selected, user confirmation is required for automatic deletion to proceed.
Ask for confirmation for purging	If selected user confirmation is required for purge to proceed when Link preferences are accessed and purge-ready batches exist. (Be sure to enter preferences on a regular basis to trigger this purge action.)
Toolbar at the right side	You have the option to have the Accounting Link side toolbar on the right or left side of the window. This feature can be used to accommodate a right- or left-handed user or simply personal preference. Select this option to display the toolbar on the right side of the window. If not selected, the toolbar is displayed on the left side of the window by default.
Web Page URL	You can define the address for a web page that you want to display in the Accounting Link window. For the page to be displayed, you must have Internet access and have Internet Explorer installed on the computer. If a web address is specified, the Accounting Link will attempt to establish Internet access immediately after login. If access is not available, a message is shown stating that a link to the page was not possible. If a web address is not specified, the area where the web page is normally displayed will be blank.
View browser controls	If enabled, browser controls like the Back, Forward, Home and Refresh buttons are displayed on the UI.

Store Account Manager Options
In Options > Preferences > Store Account Manager, define the following settings:

• Indicate active stores by selecting the "Use" checkbox.
• Identify accounting companies.
• Define account IDs for individual stores and/or the whole company.
• (optional) Combine certain tenders for posting.

Notes

• The company COA should already be defined in the accounting software. In this area, use the Check COA feature to make sure account numbers in Accounting Link match account numbers in Sage, or the Reset feature to reset accounts to the account numbers specified in the defaults.ini file in Sage.
• Accounting Link automatically creates the list of stores and store records by reading the information from Prism.

Sample Store Account Manager preferences:
 
Store Profiles
1.    For every store, enter the Company code for the accounting company you want to use with the related store. The Company code is defined in the accounting software. Be sure to enter the accounting company code, not the company name.
2.    Select the Use checkbox to indicate that the store is active for use with the Accounting Link.
If the Use flag is selected, Accounting Link will attempt to post information to the accounts you have defined. If an account does not exist, Accounting Link will not be able to post the related information. Instead a message is generated for the batch log. Additionally, a store must be active (and have a code defined in Prism) for AR status information to be sent from the accounting software to Prism during a customer update. If the Use flag is not selected, Accounting Link will not attempt to post information for the store nor retrieve AR status information from the accounting software for that store.
Delete Old Stores
If you have a store defined in Accounting Link that is no longer in use in Prism, delete the store so that it is no longer listed in the Store Account Manager preference. Deleting the store ensures that no attempt will be made to process information for the store. Click Delete Old Stores. Any former Prism stores are removed from the list. Save the changes.
Account IDs
Account IDs are usually numerical but in some accounting programs they can be descriptive names. Account IDs can be defined for selected stores as well as for the entire company. When you select a store in the upper field, the COA for that store is displayed in the table.
If a COA has not yet been defined, the default Link COA is displayed. If Entire Company is selected, account IDs that differ between stores are not displayed. For example, Store 001 has Cash assigned to account ID 1010-00 and Store 002 has Cash assigned to 1020-00. When Entire Company is selected, the account ID field for Cash contain *VARIES* because the stores differed for this account ID. Conversely, if all stores have Cash assigned to 1010-00, that account ID is displayed when Entire Company is selected.
Mapped segments of an account ID cannot be edited. If you want to remove segment mapping, do so through the GL Accounts preference, but remember that the accounts you define here must be defined for the relevant accounting company as well. (The Check COA function determines if any accounts are needed in the accounting company COA.)
Assigning Accounts for Multiple Stores at One Time
If most of your stores are to have the same Account IDs assigned to them, assign those IDs by selecting Entire Company. This populates the Account IDs for every store. Then select individual stores and make any necessary store-specific assignments.
1.    Click an account's Account ID field to enter edit mode.
2.    Provide the account information using one of the following methods:

• Enter or edit the Account ID.
• Copy an account from the accounting software's COA:
• Click the selection button to display the accounting software COA. Select the particular account from the list that you want to copy and click OK. (Alternatively, you can double-click the account to copy it.) The Account ID in the table now matches the account in the accounting software COA.

During posting, Accounting Link will attempt to post information to these accounts (structured and mapped as you have defined in GL Accounts and with the proper accounting software separators). If those accounts do not exist in the accounting software, an error message is generated, displayed, and temporarily stored in a batch log.
Access to the Accounting Software Chart of Accounts
For Accounting Link to display the accounting software's Chart of Accounts in the above step, the following must be completed:
1.    All necessary General Ledger configurations for the accounting company are complete in the accounting software.
2.    The path to the accounting software is defined in Options > Preferences > Accounting Software.
3.    The selected store is flagged as active and a valid accounting company is defined in Options > Preferences > Store Account Manager.
The COA that is displayed is for the accounting company assigned (per your earlier Store Account Manager preference setting) to the selected store. Use the displayed accounting company COA to modify your Link accounts or simply to confirm that an account exists in the accounting company COA.
Sample Chart of Accounts in Sage:

Consolidating by Company, Region, or Store
Assigning the same Account ID to a particular account type allows custom consolidation options. For example, assigning the same inventory account to a group of stores can provide a regional consolidation within your accounting software. Within the same accounting company, each store's accounts are tracked individually. As a result, you can combine the various consolidation options. Within the same accounting company, inventory can be combined for all stores, sales can be tracked on a regional basis, and adjustments can be tracked on a store-by-store basis - all at the same time.

Multi-Store - Multiple Companies or Multiple Accounts
Many accounting programs can maintain accounting records for more than one company. Each company's records are separate, and each company has its own balance sheet and income statement. Alternatively, within an accounting company, you can assign each store (or group of stores) a different sub-account value. This would allow you to maintain separate inventory sub-accounts for each of your stores. You can then generate reports for a particular store and still report on the entire company.
Options (Tender Consolidations)
You have the option to handle certain multiple tenders as a single tender for accounting purposes. This commonly applies to the combination of Cash and Checks because their combined value is what is deposited at the bank each evening. When the bank statement is later received, the deposit amounts can be quickly scanned to compare with the combined cash and check totals - without having to manually add the values. This feature can also be applied to certain credit card tenders.
Check COA
Once accounts are defined in Prism Accounting Link, check to see if any accounts are missing in the accounting software. The Check COA function scans the related accounting company's COA and compares it with the Accounting Link COA for the selected store. If Entire Company is selected then Check COA scans the accounting software COAs for all active stores that have a defined accounting company code. 
Every account in Accounting Link COA must have a match in the accounting company COA - including all sub-accounts. (The accounts listed here in the Store Account Manager preference are the accounts to which the structure and mapping, as defined in the GL Accounts preference, are applied. The structure, mapping, and account IDs are compared when Check COA is selected.)
If any discrepancies are detected, the missing accounts are listed. (Sample information is shown in the log example below.) Re-enter your accounting software and create the needed accounts. Use Check COA again to make sure that all necessary accounts were created.
Sample message displayed when accounting do not match:

Reset COA
If necessary, you can reset the list of accounts for the currently selected location (entire company or an individual store) to the default COA as defined in the defaults.ini file in Sage. As with any Accounting Link Preference modification, you must select Save when exiting Preferences to retain the change.
The default COA for Sage is stored in Defaults.ini in the GL module of the accounting software's directory in the Accounting Link. For example: …\PrismAcctLink\AcctLink_1\Modules\Sage100 5.2+\GL\Defaults.ini.

Accounting Link Sage 100 Preferences
This section has information about configuring Accounting Link settings that are specific to individual versions of Sage 100:

• Set the path to Sage 100 Installation and enter the login credentials and company code.
• Define Accounts Payable settings (Options > Preferences > Sage > AP).
• Define Accounts Receivable settings (Options > Preferences > Sage > AR).
• Define General Ledger journal labels (Options > Preferences > Sage > GL).

Sage 100 Path and Login Info
Launch AcctLnk.exe and log in. Select Options > Preferences.
In Preferences, navigate to the settings for the desired version of Sage and highlight  the top node for the desired version (e.g., Sage100 5.2+).
In the "Path to MAS 90 installation" field, click the folder icon and navigate to the MAS90 folder for the Sage installation. Click OK.
Save the changes.
Next, enter the MAS 90 user name, password and company code. If you are unsure of the company code, display the Chart of Accounts in Sage.
Save the changes again.
Sample Sage 100 company information:

Sage - AP
1.    Select Options > Preferences and navigate to the AP node for your specific software version (Ex. Preferences > Sage100 5.2+ > AP).
2.    Select from the available options for your accounting software. (The options in the table below are for Sage100 5.2+)
3.    Save the changes.
Sample Accounting Link Sage 100 5.2+ AP preferences:
 
Refer to the following table for information about the available settings:

Option	Description
Include what information in AP voucher comment	You have the option to write certain information to the voucher Comment field. Select from the following options: None PO#/Store/Controller Arrival Date/Store/Controller Voucher #/Store/Controller
Generate AP Batch #	If selected, the AP Batch # is generated.
Uppercase invoice #	If selected, the invoice number is put in uppercase.
Identify store in comment as	Select how to identify the store, which will be written to the voucher Comment field: Store number (001, 002, etc.) or Store ID.
Use external discount terms	If this option is checked AND the "Use External Default Terms" option (located elsewhere in the AP/TC area of preferences) is also checked, when sending vouchers to Sage 100, Accounting Link will ensure the Discount Due Date field is blank. When Sage 100 receives a voucher with a blank Discount Due Date, the discount due date and available discount amount will be recalculated based on the payment terms defined for the vendor in Sage 100.

Sage - AR
In Preferences > [Sage Version] > AR, you can define various settings related to vouchers and accounts receivable.
Sample Accounting Link Sage100 5.2 + AR preferences:

Option	Description
Include what information in AR Receipt comment	Select to write information to the AR Receipt Comment field: None Comment 1/Store/Controller Comment 2/Store/Controller Voucher #/Store/Controller Cust PO/Store/Controller Year/Month/Store/Controller/Receipt #
Credit Limit	Customer credit limit. For AR customers in Prism, the limit specified here will be assigned to that customer. The Credit Limit is updated from Accounting Link to Sage 100. Accounting Link then updates the credit limit in Prism.
How to generate AR receipt number	This option defines how AR transactions should be numbered in the accounting software. The four options for AR transaction numbering are: As Is: Use the same number as Prism. Select this only if duplicate document numbers do not exist in Prism. Prepend Store #: Create a unique number by adding the store number (2-digits only) to the beginning of the document number. Example: Store 001, document number 48 would be numbered Transaction 0100048. Append Store #: Create a unique number by adding the Prism store number (2-digits only) to the end of the Prism document number. Example:  Store 001, document number 48 would be numbered 0004801 Sequential #: Use 7-digit sequential numbering not associated with Prism.
Generate AR Batch #	If selected, the accounting link will generate a number for the AR batch based on the options you specified. If not selected, a sequential number will be assigned.
Identify store in comment as	Select how to identify the store, which will be written to the receipt Comment field: Store number or Store ID.

Sage - GL
The General Ledger is a group of accounts that store the current balances of various accounts.  In many accounting programs, one or more journals record the detailed information about how the balance of a particular account was derived. Based on the transaction type, you can specify the code of a journal through which to post data.  Each transaction type may be assigned to the same or a different journal as any of the other transaction types. Journal codes are four characters max.
Transaction types are:

• Receipts journal
• Return Receipts journal
• Vouchers journal
• Slips journal
• Memos journal

To assign a journal code, you must know which journals are available, and applicable.  The default code is zero, but you can define your own source journal codes.  Please refer to your Sage documentation for additional information on journals and their codes.

Sage 100 Configuration Notes
The following sections have information related to how information sent from Prism Accounting Link is handled in the accounting software. Please refer to the Sage 100 manual for complete and detailed instructions for all Sage 100 procedures.
AR Customer Information
Sage 100 supports a Customer ID of 7 characters. The customer's full name is stored in Sage 100 in a single field with a 30-character maximum.
Address fields supported by Sage 100 are three general address fields, and individual fields for City, State, ZIP code and Count. (Note: City and State are normally combined in Prism Address 3. When entered in Prism, this information must be separated by a comma is order for it to be exported as separate field entries for Sage 100.)

AR Setup Options	Setting	Notes
Accounts Receivable Options > Main > Sales Tax Reporting	Checked	Checked = feature is on. Sales Tax Code RP must be defined as described below.
Additional > Salesperson Commission Reporting	Checked	Checked = feature is on. Salesperson Code 0000 must also be defined as described below.
Integrate > Post Cost of Goods Sold to General Ledger	Checked	Checked = feature is on. Sales Code RPRO must also be defined, with correct account numbers, as described below.
Division Maintenance > Division No.	00	The default division for all A/R entries is 00. If you use additional divisions, all customer accounts posted from Accounting Link will have a division of 00. All G/L accounts must be correctly defined for this division.
Bank Code Maintenance > Bank Code	R	All cash receipts entries posted from Prism will default to Bank Code R. Sales Tax Account Maintenance > Tax Code    RP    All receipt entries posted from Prism will default to Sales Tax Code RP.
Salesperson Maintenance  >Salesperson No.	0000	All receipt entries posted from Prism will default to Salesperson Code 0000.
Sales Code Maintenance >Sales Code Or Miscellaneous Item Maintenance>Item code		RPRO. All receipts posted form Prism will have a default Sales Code RPRO. Define this sales code as follows: Description: Prism Link Sales Account: AR account number COG Account: AR account number Inventory Account: AR account number Unit of Measure: (leave blank) Standard Cost: (.000) Standard Price: (.000) Tax Class: TX or NT Calculate Commission: (do not select) Enter Description: (do not select) Enter Cost Amount: (do not select)

Batch Option Settings for General Journal Entries
Sage 100 includes special batch processing options for general journal entries. To use these options with Accounting Link, you must first select the Batch Processing/General Journal Entry Enable checkbox.
NOTE: The below only applies if Batch Processing / General Journal Entry Enable checkbox is checked.
Import General Ledger transactions from Prism as normal.
Launch Sage 100.
Select Modules > General Ledger.
Select Main > General Journal Entry.
At the Batch Number prompt, press the magnifying glass button. A list of active batches of all existing General Journal Entries will show, including a new one representing your recently imported General Journal Entries.
Sample Batch Number prompt with magnifying glass button:

From this point onward, you may proceed to access your Prism Accounting Link General Journal Entries in all batch related features, including maintenance, printing, and posting.
Technical Notes
To set up the Batch Enable option for General Journal Entry (where the Accounting Link imports General Ledger activity from Prism):
1.    Launch Sage 100.
2.    Select General Ledger from the Modules menu.
3.    Select General Ledger Options from the General Journal Setup menu.
4.    Select the 2. Entry tab.
5.    Check the checkbox under the Enable column next to General Journal Entry.

NOTE: The Next Batch number will be the next Batch Number used when you import your General Ledger Transactions. Each import will cause this number to increment by one (1). You can change this number in General Ledger Options settings.
Prism Vendor Payment Terms and Due Dates
If in AP/TC Options you selected to use external default terms (i.e., terms defined in Prism), those terms and due dates will be sent to Sage 100 and can be viewed there: Invoice Due Date, Discount Due Date and Discount Amount.

Using Accounting Link
Initialize (and Update) Customers and Vendors
About Initialize and Update of Customers and Vendors
There must be records in your accounting software for AR customers and AP vendors before any transaction information can be posted for the customer or vendor.
Because of the high chance of data input errors, it is not recommended that you enter this information into your accounting software directly. Instead, use the Initialize feature to automatically create records in your accounting software for Prism AR customers and AP vendors. You can then edit the records in the accounting software to enter additional information, if necessary. After the Initialization is performed, you can use the Update feature to update new or changed records.
Initialize
The Initialize feature transfers information from all AR customer or AP vendor records. Initialize sends the AR customer or AP vendor information to the accounting software for all the records that are flagged as Yes or Export. These buttons are available by clicking the Options button on the main screen of Accounting Link.

Button	Action
	If selected, Prism customer records with the Accounts Receivable field set to "Export" or "Yes" are sent to the accounting software.
	If selected, Prism vendor records with the Accounts Payable field set to "Export" or "Yes" are sent to the accounting software.

Update
The Update feature updates customer and vendor information in the accounting software. These buttons are available in the different batch areas as needed:

Button	Action
	Sends Prism customer information for records that have the Accounts Receivable field set to "Export." Note: For Sage, only Customer information is sent, not Associate information
	Sends Prism vendor information for records that have the Accounts Payable field set to "Export."

When updating or initializing, Accounting Link sends the AR customer or AP vendor information to all accounting companies currently defined for all of the active stores (Options > Preferences > Store Account Manager). This ensures that users who have different companies for different stores will not lose AR or AP information.
A progress bar displays to indicate the data transfer. When the data transfer is complete, click OK.
Customers and Vendors Not Yet Defined in Accounting Software
If a new customer or vendor is yet to be defined in the accounting software but is reflected in a batch transaction, Accounting Link can transfer the minimum amount of information necessary so that the batch can be posted.
Read Batches from Prism
The Read function imports selected information from Prism to the Accounting Link.  All data is tracked and later posted by batches.  Each batch is a collection of documents read into Accounting Link.  A Batch includes one of the following transaction types: Receipts, Vouchers, Slips and Memos.
Note: Receipts and vouchers include return receipts and return vouchers, respectively.  Information is read according to the selected transaction type and a specified date range.
The major features of the Read function are:

• Each transaction type is read as a separate action.  You control what is imported:  receipts, vouchers, slips, memos, or payroll information.
• Data is read for a selected date range.
• Imported data is stored in sequentially numbered batches. The same counter is used for all of the transaction types, giving each batch in Accounting Link database a unique identification.
• In addition to the Batch #, there is a sequentially numbered Batch ID located in the Batch Description that is transaction-type specific. The Batch ID can be modified to a more descriptive ID, thus making the batch easier to identify at a later time.
• Within a transaction type, individual batches can be created for each store.

Data can be read in Preview mode or in Marked mode. In Preview mode, (i.e. not flagged as having been read), the data is only available for preview.  In Marked mode, the appropriate data is marked as having been read, enabling the data to be posted into Accounting.

• Data read in Preview mode cannot be posted. This is to help prevent the same data from being posted more than once. To post the data, the Batch must be read in Marked mode.
• Data read in Marked mode can be unmarked if it is determined that corrections need to be made before the information can be posted. (Note:  Posted batches can also be unmarked, but manual cancellation of the posted data in the accounting software must be done before the data is re-read and re-posted.)

Select Batches from the top menu.
Select Receipts, Vouchers, Slips, Memos, or Payroll from the side menu. Note: If data has been previously read for the transaction type, the latest batch is displayed.
Click Read. The Read Batch dialog is displayed.
Enter or select from the following options and then click OK to begin the Read process.

Option	Description
Read Batch as	A batch can be read in one of two modes:  Preview or Marked.  The choice determines whether the related Prism transactions can be posted to the accounting software. Marked transactions are flagged in Prism and the batch can be posted. Preview transactions are not flagged and the batch cannot be posted.  To post the data, you must re-read the information in Marked mode. Preview mode allows you to check a batch for errors before reading it in as Marked.
Batch Description	A Batch Description is automatically assigned to the batch but can be edited. Batches for each transaction type are sequentially numbered.  You may choose to retain this number or not. To edit the Batch Description, click in the field and make your changes.
Create single batch for each store	Select to have a separate batch created for each store's transactions (all will have the same Batch Description).  This will allow you to review and post batches on a store basis.
Document Date Range	Define the Start and End dates for the transactions you want to read.  To specify the date range, do one of the following: Accept the default range (last used End Date to current date). Type the beginning and ending dates in the appropriate date fields.  Enter month, day, and year as separate inputs. For each date field, click the drop-down arrow to display a calendar.  Choose the date you want by selecting it on the calendar.

Note: If no transactions are found for your selected transaction type within the specified date range, the following message is displayed:  "There is nothing to read for this date range."  Since there was no information to import, no batch was created.
Central Tenders
Accounting Link treats the following as if they are the same tender types: Central gift cards and regular gift cards, Central gift certificates and regular gift certificates, Central store credit and regular store credit, Central store credit adjustments and regular store credit adjustments
In addition:

• Store credit adjustment receipts for conversion of old store credit to central store credit are treated the same as old style store credit adjustment (i.e. the one with SC_ADJ fee). Accounting Link records these as a ZERO fee amount and opposite amounts for old store credit and central store credit tenders. To Accounting Link, it is read as a receipt with a zero total and zero tenders.
• Store credit adjustment receipts for expiring central store credit are treated the same as old style store credit adjustment (i.e. the one with SC_ADJ fee).
• When a transaction discount is used by loyalty programs, Accounting Link reads both the global discount amount and transaction discount amount fields, adds them together, and adds the sum to the discount account, making it look like a single combined discount.

Batch Screen Information
The batch screen includes information about the batch, the documents included in the batch, and the amounts posted to specific accounts. General batch information is displayed as well as information specific to each batch type. The batch screen has 1) Batch Info, 2) A/R Info and 3) Receipt Info
Sample Receipt Batch screen:
 
Batch Info

Field	Description
Batch Description	A description of the batch.
Batch type	The type of batch (e.g., vouchers).
Batch #	The sequential number assigned to the batch.
Transaction Count	The number of documents in the batch.
Out of Balance

GL Accounts Info
Each batch screen has a table that lists how the documents in the batch impact the general ledger:

Field	Description
Account #	The account number to which the amount is applied.
Doc Debit	The amount the doc debits the GL account.
Doc Credit	The amount the doc credits the GL account.
Batch debit	The amount the batch debits the GL account
Batch credit	The amount the batch credits the GL account.

Voucher Batch Screen
Refer to the following table for information about the available fields on the Vendor Batch screen. (Not all fields available for all accounting software programs)

Field	Description
Batch #	The number assigned to the batch.
Batch type	The type of batch: preview or marked.
Transaction count	The number of documents in the batch.
Read Date	The date the batch was read into Accounting Link.
Doc#	The sequential number assigned to the voucher.
Doc Date/Time	The date and time the voucher was created.
Vendor Code	The Vendor Code of the vendor from whom the merchandise was ordered.
Vendor Name	The name of the vendor's company.
Invoice #	The vendor invoice number for the voucher. Important! All Invoice #s be 10 digits or less. If the Invoice # is more than 10 digits, the invoice will not be posted.
Invoice Date	The date the vendor invoice was created.
Terms	The payment terms for the voucher.
Payable Amount	The amount to be paid to the vendor.
Due Date	The date the payment is due

About Multiple Vouchers Sharing One Invoice
When you receive an order, the merchandise may arrive in several different packages over several days. However, when the billing invoice for that order is finally received, the entire order is listed along with the total cost. This invoice information must now be used on all vouchers that are associated with the order. Since duplicate invoice information is not allowed in most accounting software, Accounting Link must combine the vouchers. When read into Accounting Link, the vouchers are displayed separately for review purposes. However, when posting the batch, Accounting Link combines any vouchers that have the same Payee, invoice date and invoice number. In effect, Accounting Link posts the information as if it were from one voucher. When combining vouchers, all value fields will be sum totals. Document information such as document number, date, due date, terms, etc., will be taken from the last voucher read.
It is the responsibility of the user to ensure that all of the vouchers that reference a given invoice are available for posting and that the Read date range encompasses the complete set.

Slips Batch Screen
 

Refer to the following table for information about the Slip Batch screen.

Slip Batch Field	Description
Batch #	Number assigned to identify the batch.
Batch Type	The type of batch: preview or marked.
Transaction count	The number of transactions (documents) in the batch.
Read Date	The date the batch was read into Accounting Link.
Store	The store which received the transferred items.
Doc No	The sequential number assigned to the document.
Doc Date/Time	The date and time the slip was created.
Account #	Account number to which the batch will be posted.
Doc Debit	The amount debited for the selected document.
Doc Credit	The amount credited for the selected document.
Batch Debit	The total amount that will be debited from the account.
Batch Credit	The amount that will be credited to the account.

Memo Batch Screen
Accounting Link only reads Quantity and Cost memos since those memos directly affect the value of inventory. Price memos are not read because price changes do not affect inventory value.

Memo Batch Fields	Description
Batch #	Number assigned to the batch.
Company	Company code as defined in Sage 100.
Batch Type	The type of batch: Preview or Marked.
Transaction Count	Total number of transactions (documents) in the batch.
Store	The store where the adjustment memo was created.
Doc Date/Time	The date and time the memo was created.
Account Name	The name of the account to which the batch will be posted.
Account Number	The account number to which the batch will be posted.
Doc Debit	The amount debited for the selected document.
Doc Credit	The amount credited for the selected document.
Batch Debit	The total amount that will be debited from the account.
Batch Credit	The amount that will be credited to the account.

Posting Data to Sage
When you post a batch, Accounting Link transfers batch information to the appropriate modules in your accounting software, based on the settings in Preferences > System > Options.
Batches can be posted in two ways:

• A single batch
• All active marked batches

The major features of the Post function are:
Consolidate each batch as you prefer. Consolidating by Transactions will post a journal entry to the General Ledger for each transaction within a batch, Consolidating by Store will post a journal entry for each store within a batch, Consolidating by Company with post a single journal entry for the one batch.
Select the date to which you want the batch data posted. (The accounting program must support this feature.)
If any part of a batch cannot be posted, then none of the batch is posted. This eliminates the need to determine what part of a batch was not posted and/or make adjusting entries for a partial posting.
Post multiple vouchers for the same vendor invoice.
To post a batch to accounting software:
1.    Select or display the marked batch that you want to post, and then select Post from the top menu. The Post Batch dialog is displayed.
 
2.    Select the Posting date. You can leave the date as displayed, enter a different date, or click the drop-down arrow to use a calendar to select a date.
3.    Specify which consolidation level you want to use for this batch. The consolidation level that you select becomes the new default.
4.    Select OK to start the posting.  A progress bar indicates the posting activities as they occur. When the posting is finished, click OK.
Vendor Invoice Numbers that exceed 10 Digits
Vendor Invoice numbers in Sage are limited to 10 digits/characters. Any Vendor Invoice that has an Invoice # that exceeds 10 digits will NOT be posted.
Consolidation Levels
General Ledger consolidation can make managing information easier. Accounting Link modifies how data is presented to the accounting software according to the consolidation level you select.
Refer to the following table for information about each consolidation type:

Consolidation Level	Notes
Transaction	Consolidating by Transaction posts a journal entry for each transaction within a batch. For example, five transactions results in five journal entries, one for each transaction. Data that posts to the same account for the same account type, for the same store, will be summed together.  Thus, a single entry is made for each account for each store within a company. For example, for all of the transactions involving Store 001, all Cost of Goods data that posts to the same account would be consolidated to a single Store 001 entry.
Store	Data from the transactions in the batch is posted on a store basis. Thus, a single entry is made for each account type for the each store. For example, Cost of Goods information that posts to the same account ID for the same store would be consolidated to a single store entry.
Company	Company Data from the transactions in the batch is posted on a company basis.  All transaction data that posts to the same account ID for the same account type, for every store in the company, will be summed together. Thus, a single entry is made for each account type for the company. For example, for all of the stores in the company, all Cost of Goods information that posts to the same account ID would be consolidated to a single company entry.

AR and AP Consolidations
AR transactions are not consolidated. AP transactions are consolidated if the Payee code, invoice number and invoice date on a voucher matches those of any other voucher read into the same batch. There is a single entry for the combined information.
Unmarking a Posted Batch
If a Marked batch contains errors, you can unmark it. This changes the batch status to Preview and resets the accounting flags in Prism for the batch transactions. After unmarking a posted batch, you can correct the errors in Prism and re-post the information to Accounting Link.
A posted batch can also be unmarked but do so cautiously because you do not want to mistakenly re-post data. Only if a batch did not import correctly into the accounting software should you unmark it and try to re-post it. Check the accounting software accounts thoroughly before choosing to unmark a posted batch and attempting to re-post it.
If you want to unmark a posted batch, manually adjust the related data in the accounting software before unmarking it and re-posting the data In some cases, the accounting software may not allow data to be re-posted if the receipt or voucher has not been "un-posted," but you should not rely on that safety measure occurring.
To unmark a batch:
1.    Select the Marked (or Posted) batch that you want to unmark in either List View or Form View.
2.    Choose Unmark from the top menu. A confirmation dialog is displayed.
3.    Click Yes to confirm the action.
You can unmark posted batches, but you must then manually cancel the posted data in the accounting package before you reread and post the batch again. Typically, you only want to unmark a posted batch if the batch did not post correctly.
To unmark a posted batch:
1.    Select the batch that you want to unmark.
2.    Click Unmark from the top menu.

Other Posting Consolidations

• Vouchers posted the first time (that do not include an invoice number) will:
• Debit Inventory by the sum of the extended item cost.
• Vouchers posted a second time (with invoice number) will:
• Credit the Payable account with the voucher total.
• Debit the Freight account with the Freight amount.
• Debit the Fee account with the Fee amount.
• Debit the Tax account with the Tax amount.
• Credit the Discount account with the Discount amount.
• Debit the Inventory account with the sum of extended item cost.

Troubleshooting
See the table below for common troubleshooting issues associated with using Accounting Link and the suggested steps to resolve them.

Activity	What to Check
Reading	Is the date range of the Read correct? Are your accounting modules defined in the Accounting Link preferences? For AR transactions, is there an AR tender or fee? Is there an AR customer? For AP transactions, are an AP vendor and the invoice # or invoice date on the voucher?
Posting	Is the path to the accounting software correct? Are the stores for which you are posting defined the same in the accounting software as in Prism? For example, Store 001 is not the same as Store 1. Were customers updated? (receipts only) Were vendors updated? (vouchers only) Are the associates who are represented on the batches defined in the accounting software? Read receipts, update associate information (either manually in the accounting software or use Accounting Link Update feature if supported by your accounting program), and then post the batch. Is there an AR tender or fee? Is there an AR customer? Are all vendor invoice numbers 10 characters/digits or less?
Updating	Are the export flags for A/R customers or A/P vendors set correctly?

Reviewing Batch Information
Preview Batches
Create a Preview batch to review the contents of a batch before sending it to an accounting package. To send a Preview batch to an accounting package, the batch must be reread as a Marked batch. You can use Preview batches for:

• Daily account reconciliation
• End of day procedures
• General review of data prior to a given audit period

Marked Batches
Marked batches are ready for posting to a given accounting package. You cannot edit documents in a marked batch. Data editing must be done in Prism. You can change a marked batch to a preview batch.
Archived Batches
Archived batches are batches that have been posted to an accounting package but not yet purged from the system. You cannot edit documents within an archived batch. To be purged, a batch must be in "Posted" status.
Deleting a Batch
In Accounting Link preferences, you can schedule the deletion of batches as they reach a certain "age."  When working with batches of any transaction type, you have the option to delete individual Preview and Posted batches for that particular transaction type. You can delete the current batch, or delete a batch stored in Active Batches or Archived Batches.  Whenever a batch is deleted, it is flagged as purge-ready.  (When you next enter Link preferences, purge-ready files may be purged from the Accounting Link database.)
To delete a batch:
1.    Select the Preview or Posted batch that you want to delete.
2.    Click Delete on the top menu. Confirm the deletion.
Note: A Marked batch cannot be deleted. It must be unmarked, changing its status to Preview. Then, as a Preview batch, it can be deleted.
 
Searching a Batch
The search mode is based on how the information is currently sorted. For example, you can search for a particular transaction by sorting by transaction number (Doc #).
1.    From the List View, sort the data by the column you want to search by clicking on the column header by which you want to search. Alternatively, while in the body of the List View, simply begin typing the characters of the entry you want to find in the Find field. The first match found is highlighted.
2.    Since the column is sorted, use the down-arrow to move to the next match.
Printing Batch Summaries
You can print a summary of a batch for review:
Important! Before printing a batch summary, document designs need to be configured through document designer.
1.    Select the batch that you want to print.
2.    Click Print from the top menu. The Print dialog displays.
3.    Change the print settings, if necessary, and then click OK.

Note: Alternatively, you can print batch information by holding down the left mouse button and dragging across the columns you want to print, Right-click on the selected columns, and select Print. The Batch will preview on the screen, then click on the print icon at the top of the screen)
Managing Displayed Information
In List View, each row contains information for one transaction in a batch. Each transaction's information is displayed across the row in columns. You can scroll as necessary or rearrange columns using the drag-and-drop procedure. Using Page Manager, you can add/delete columns for a customized List View for each of the transaction types.
In Form View, information is displayed as batch-specific, transaction-specific, or a combination of both. It all depends on the design of the form.  If the information is transaction-specific, select the transaction while in List View and then change to Form View.
Using Page Designer, you can add/delete information fields for a customized Form View for each of the transaction types.

Batch Logs
Accounting Link maintains a log for each batch. This log can be viewed regardless of the state a batch is in. When the batch is purged from the system, so is its log file.
Batch Log Errors
If any errors occur when a batch is read or posted, a log is created which contains the error message(s). The log remains "attached" to the batch until the batch is deleted. When you select to work with a batch, the Batch Logs button is available only if there is a log file related to that batch.
To view a batch log:
1.    Choose the batch that has a log file.
2.    Select Batch Log from the side menu. The log is displayed in the font specified in Link preferences.
3.    Edit and print the Batch log:
Note: Any changes you make to the log are not saved.  You can edit the log so that you can annotate it and print only the information that you want.)
4.    Using normal text editing, add any comments that you want to include in the log.
5.    Right-click for a pop-up menu, then select the available action that you want and follow normal Windows procedures.
Batches Read by Store Share a Batch Log
If you create a single batch for each store during an import, and any errors occur for any of the batches, the errors are recorded in a single multi-store batch log. That batch log is "attached" to all batches created during that import. Situations where a log entry may exist but the batch does not:· If none of the transactions for a store could be read, no batch would be created for that store, but an error message would appear in the multi-store batch log.· If a batch has been deleted, its log will remain in the multi-store batch log. Only when the last batch of that group of batches is deleted is the multi-store batch log deleted.
Uninstall Accounting Link
Launch Uninstall.exe
A confirmation is displayed. Click Yes to proceed with the uninstall.
 If you answered Yes to the prompt, the uninstall wizard launches.
 Click Next.
Click Next again.
Click Uninstall.
Click OK when finished.

Uninstall Notes:

• First, the process takes backup of all the instances in a backup_[timestamp] .zip file and move this file to C:\Program Files (x86)\Retail Pro\PrismAcctLink location.
• All the previously backed-up zip files stored in will be moved to C:\Program Files (x86)\Retail Pro\PrismAcctLink location.
• The process deletes the and all its subdirectories.
• All the registry keys will be removed.
• All the uninstall logs will be stored at C:\Program Files (x86)\Retail Pro\PrismAcctLink location. This, C:\Program Files (x86)\Retail Pro\PrismAcctLink location can optionally be manually removed by the user as it contains all the backup and logs.