SYSTRONICS - AR-AP Settlements

Company
Contact Us
Products
- All Products
- Customizations
Sales
Services
Navigation

User ID Password

Forgot Password? Create a Partner Account

Navigation

How to Register

How to Check Prices

How to Request Activation Codes

How to Download Products

Settle A/R Transactions With A/P Transactions!

Please log in to have access to the SYSTRONICS Partners Area.

AR-AP Settlements™ Business Benefits

Reduced number of manual adjustments.
Settlement of a number of documents in a single transaction.
Settlement of the documents belonging to the same Settlement Group with a single click using Automatic Settlements.
Reduced ongoing costs with easy installation, configuration & support.

AR-AP Settlements™
for Sage 300

AR-AP Settlements for Sage 300 (A/O) streamlines the settlement of open Receivable documents with open Payable documents, or vice versa. This is useful when the same company is defined as an A/R Customer as well as an A/P Vendor in Sage 300.

AR-AP Settlements handles the functionality mentioned above, based on user-defined Settlement Groups. A/O allows you to settle open customer and vendor documents within a group easily. As a result, you may pay or receive only the balance amount after the settlement. Multiple companies from both A/R and A/P modules, having different currencies, can be included in the same Settlement Group.

AR-AP Settlements for Sage 300 optionally allows One Sided Settlements when you settle open documents in Receivables against each other or open documents in Payables against each other.

In addition to the above, while making a vendor payment, AR-AP Settlements will let you know the amount that the payee owes you. Similarly, while making a customer receipt, you will know how much you owe that payer.

Highlights

Settles outstanding transactions in A/R and A/P.
Settles A/R Customers and A/P Vendors in multiple currencies.
Allows distribution of settlement amount over multiple documents.

Business Benefits

Reduced number of manual adjustments.
Settlement of a number of documents in a single transaction.
Settlement of the documents belonging to the same Settlement Group with a single click using Automatic Settlements.

Why To Buy SYSTRONICS AR-AP Settlements for Sage 300

Overview

Why SYSTRONICS AR-AP Settlements?

SYSTRONICS AR-AP Settlements facilitates offsetting receivable and payable balances in Sage 300. Related counterparties, i.e. Customers and Vendors, are combined in Settlement Groups, to allow viewing and offsetting outstanding documents from a single screen.

SYSTRONICS AR-AP Settlements also supports one sided settlements. For example, prepayments received from customers may be applied to the open invoices of other customers belonging to the same Settlement Group.

Allows linking related customers and vendors, irrespective of their currencies, and offsetting their open documents.
Shows aggregate balances for Settlement Groups.

Qualification Questions

Business Problems Solved

Do you buy goods and services from and sell to the same company?
Do you maintain multiple Sage 300 customer records for the same entity?
Do you receive payments from the parent company for invoices owed by their subsidiaries?
Do you need to check periodically the net balance for a group of related customers and vendors?

Eliminates manual adjustments while settling open receivable and payable balances of related entities.
Streamlines the application of parent company receipts to open documents of subsidiaries.
Shows net balances for groups of related customers and vendors.

Customer stories

Profile: A Large Petroleum Distributor.
Business Problem: Company sold petrol to hundreds of gas stations throughout the country. At the same time, it paid sales commission to these stations for the gasoline sold.

Hundreds of A/R and A/P invoices were posted during the month. Settling these documents one by one took too much time from the accounting team.
Solution: AR-AP Settlements has been implemented to streamline this process.
Results: AR-AP Settlements makes linking related customer and vendor records, as well as offsetting balances possible in just a few seconds.

Profile: Wholesale Trader Of Electronics Goods.
Business Problem: For the counterparties that were both customers and suppliers, the operations team needed to see current net balances.
This was necessary to perform credit checks while entering new Sales Orders for counterparties. The risk department had to print two different reports to verify receivable and payable balances, and calculate the net amounts manually to decide whether the counterparties were within their credit limits.
Solution: AR-AP Settlements, with its ability to show aggregate net balances for a group of customers and vendors was the right solution.
Results: The risk manager takes quick decisions and the sales team does not delay processing sales orders.

Sales Proposition

Net hundreds of transactions and avoid overpaying with the click of a button!

AR-AP Settlements™ Highlights

Settles outstanding transactions in A/R and A/P.
Settles A/R Customers and A/P Vendors in multiple currencies.
Optionally creates Receipt/Payment for the balance of the settlement group.
Allows distribution of settlement amount over multiple documents.

AR-AP Settlements™ – Currently Supported Versions

Compatible with

Editions

Requires

Integrates with

DBs Supported

OSs Supported

Downloads

Implementation Time

Delivery Mode

Website download.

AR-AP Settlements™ History

AR-AP Settlements 2024H - Released October 31, 2023.

Product Update 1 for AR-AP Settlements 2023H - Released August 17, 2023.

AR-AP Settlements 2023H - Released November 18, 2022.

AR-AP Settlements 2022H - Released January 25, 2022.

Product Update 1 for AR-AP Settlements 2021H - Released June 8, 2021.

AR-AP Settlements 2021H - Released December 17, 2020.

AR-AP Settlements 2020H - Released October 4, 2019.

AR-AP Settlements 2019H - Released December 24, 2018.

Product Update 1 for AR-AP Settlements 2018H - Released December 25, 2017.

AR-AP Settlements 2018H - Released October 23, 2017.

AR-AP Settlements 2017G - Released November 18, 2016.

AR-AP Settlements 2016G - Released March 17, 2016.

AR-AP Settlements 2014G - Released March 26, 2014.

Product Update 1 for AR-AP Settlements 2012G - Released February 3, 2014.

AR-AP Settlements 2012G - Released November 6, 2012.

AR-AP Settlements 6.0G - Released November 1, 2011.

Product Update 1 for AR-AP Settlements 5.6C - Released May 2, 2011.

Product Update 3 for AR-AP Settlements 5.5C - Released May 2, 2011.

Product Update 1 for AR-AP Settlements 6.0C - Released March 18, 2011.

AR-AP Settlements 6.0C - Released December 30, 2010.

Service Pack 2 for AR-AP Settlements 5.4C - Released March 4, 2010.

AR-AP Settlements 5.6C - Released December 24, 2009.

Product Update 2 for AR-AP Settlements 5.5C - Released December 24, 2009.

Product Update 1 for AR-AP Settlements 5.5C - Released March 17, 2009.

Service Pack 1 for AR-AP Settlements 5.4C - Released March 11, 2009.

AR-AP Settlements 5.5C - Released February 4, 2009.

more...

AR-AP Settlements 5.4C - Released January 19, 2009.

AR-AP Settlements 5.5B - Released May 12, 2008.

Service Pack 2 for AR-AP Settlements 5.4B - Released February 1, 2008.

Service Pack 1 for AR-AP Settlements 5.4B - Released August 2, 2007.

AR-AP Settlements 5.4B - Released October 2, 2006.

Service Pack 2 for AR-AP Settlements 5.3B - Released February 4, 2006.

Service Pack 2 for AR-AP Settlements 5.2B - Released February 4, 2006.

Service Pack 1 for AR-AP Settlements 5.3B - Released December 7, 2005.

Service Pack 1 for AR-AP Settlements 5.2B - Released November 21, 2005.

AR-AP Settlements 5.3B - Released October 15, 2005.

AR-AP Settlements 5.2B - Released August 28, 2005.

AR-AP Settlements™ History

AR-AP Settlements 2017G - Released November 18, 2016.

AR-AP Settlements 2016G - Released March 17, 2016.

AR-AP Settlements 2014G - Released March 26, 2014.

Product Update 1 for AR-AP Settlements 2012G - Released February 3, 2014.

AR-AP Settlements 2012G - Released November 6, 2012.

AR-AP Settlements 6.0G - Released November 1, 2011.

Product Update 1 for AR-AP Settlements 5.6C - Released May 2, 2011.

Product Update 3 for AR-AP Settlements 5.5C - Released May 2, 2011.

Product Update 1 for AR-AP Settlements 6.0C - Released March 18, 2011.

AR-AP Settlements 6.0C - Released December 30, 2010.

Service Pack 2 for AR-AP Settlements 5.4C - Released March 4, 2010.

AR-AP Settlements 5.6C - Released December 24, 2009.

Product Update 2 for AR-AP Settlements 5.5C - Released December 24, 2009.

Product Update 1 for AR-AP Settlements 5.5C - Released March 17, 2009.

Service Pack 1 for AR-AP Settlements 5.4C - Released March 11, 2009.

AR-AP Settlements 5.5C - Released February 4, 2009.

more...

AR-AP Settlements 5.4C - Released January 19, 2009.

AR-AP Settlements 5.5B - Released May 12, 2008.

Service Pack 2 for AR-AP Settlements 5.4B - Released February 1, 2008.

Service Pack 1 for AR-AP Settlements 5.4B - Released August 2, 2007.

AR-AP Settlements 5.4B - Released October 2, 2006.

Service Pack 2 for AR-AP Settlements 5.3B - Released February 4, 2006.

Service Pack 2 for AR-AP Settlements 5.2B - Released February 4, 2006.

Service Pack 1 for AR-AP Settlements 5.3B - Released December 7, 2005.

Service Pack 1 for AR-AP Settlements 5.2B - Released November 21, 2005.

AR-AP Settlements 5.3B - Released October 15, 2005.

AR-AP Settlements 5.2B - Released August 28, 2005.

Cheatsheet A4 Format

Cheatsheet Letter Format

Product Brochure A4 Format

Product Brochure Letter Format

Product Presentation

Slide Show

White Paper

Webinar Recording

How to see the outstanding balance of all vendors (customers) belonging to the same Settlement Group while making a Customer Receipt (Vendor Payment) in AR-AP Settlements

Setting up AR-AP Settlements for this functionality

1. Limit each customer/vendor to one Settlement Group on the Settlements tab of the A/O Options screen.

A/O Options - Settlements Tab

2. Select whether you want to see the total outstanding balance of vendors/customers or the outstanding balance due on the Receipt/Payment Date on the Settlements tab of the A/O Options screen.

A/O Options - Settlements Tab

Viewing Customer Outstanding Balance from the A/O A/P Payment Entry Screen

While paying money to the vendor you can view the outstanding balance of all customers belonging to the same Settlement Group as the vendor from the A/O A/P Payment Entry screen. This screen can be opened either from the A/O A/P Payment Batch List screen by clicking the "New" button or from the A/O A/P Payment Entry screen located in the A/O A/P Transactions folder. The A/O A/P Payment Entry screen behaves exactly the same way as the A/P Payment Entry screen, except that it displays additional information related to AR-AP Settlements. After selecting a vendor number on the A/O A/P Payment Entry screen, the Settlement Group code and the outstanding balance for the linked customers will be shown at the top right corner.

A/O A/P Payment Entry

The following table describes fields added to the A/P Payment Entry screen by AR-AP Settlements.

Settlement Group	Displays the Settlement Group to which the vendor belongs.
O/B in Vendor Currency	Displays linked customers' outstanding balance in the vendor's currency. The amount is calculated by converting total Customer Functional Outstanding amount into Vendor Currency using the Vendor Rate information defined for the Payment. This will be either the overall balance or the balance due on the Payment Date, depending on your selection in A/O Options.
O/B in Payment Currency	Displays linked customers' outstanding balance in payment currency. The amount is calculated by converting total Customer Functional Outstanding amount into Payment Currency using the Bank Rate information defined for the Payment. This will be either the overall balance or the balance due on the Payment Date, depending on your selection in A/O Options.

Viewing Vendor Outstanding Balance from the A/O A/R Receipt Entry Screen

While receiving money from the customer you can view the outstanding balance of all vendors belonging to the same Settlement Group as the customer from the A/O A/R Receipt Entry screen. This screen can be opened either from the A/O A/R Receipt Batch List screen by clicking the "New" button or from the A/O A/R Receipt Entry screen located in the A/O A/R Transactions folder. The A/O A/R Receipt Entry screen behaves exactly the same way as the A/R Receipt Entry screen, except that it displays additional information related to AR-AP Settlements. After selecting a customer number on the A/O A/R Receipt Entry screen, the Settlement Group code and the outstanding balance for the linked vendors will be shown at the top right corner.

A/O A/R Receipt Entry

The following table describes the fields added to the A/R Receipt Entry screen by AR-AP Settlements.

Settlement Group	Displays the Settlement Group to which the customer belongs.
O/B in Customer Currency	Displays linked vendors' outstanding balance in the customer's currency. The amount is calculated by converting total Vendor Functional Outstanding amount into Customer Currency using the Customer Rate information defined for the Receipt. This will be either overall balance or balance due on the Receipt Date, depending on your selection in A/O Options.
O/B in Receipt Currency	Displays linked vendors' outstanding balance in receipt currency. The amount is calculated by converting total vendor functional outstanding amount into Receipt Currency using the Bank Rate information defined for the Receipt. This will be either the overall balance or the balance due on the Receipt Date, depending on your selection in A/O Options.

AR-AP Settlements™ Future Versions

Version	What's New	Expected Release Date
AR-AP Settlements™ 6.0G	Settle all Document Types (Invoice, Debit Note, Credit Note, Receipt, Prepayment and Unapplied Cash) Create Customers and Vendors from inside the Settlement Group screen Print a Settlement form Specify Posting Date	Q'4 2011

AR-AP Settlements™ End User Prices In US Dollars

AR-AP Settlements™ Downloads

Certain downloads are available to SYSTRONICS Partners only. Please log in to the SYSTRONICS Partner Area to have access to Downloads. If you are not registered as a SYSTRONICS Partner and wish to do so, please click here.

By downloading this SYSTRONICS product you agree to the Terms and Conditions.

Select Product Version

AR-AP Settlements 2024H (7.1)

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure

AR-AP Settlements 2023H (7.0)

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	AO 2023H PU1 Readme

AR-AP Settlements 2022H

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	Readme

AR-AP Settlements 2021H (6.8)

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	Readme

AR-AP Settlements™ Frequently Asked Questions

Q. Can I use AR-AP Settlements to settle documents posted for one vendor against documents posted for other vendors?

A. Yes, AR-AP Settlements supports one sided settlements, i.e. one vendor's documents can be settled against documents of the same or another vendor. For example, if you have a prepayment posted for one vendor you can settle the prepayment amount against invoices posted for other vendors. The same is true for customer documents.

Q. Can I make changes in the AR-AP Settlements entries after they have been posted?

A. No, once the AR-AP Settlements entries have been posted, they cannot be changed. However, you can reverse the posted settlement entries and create new ones with correct details.

Q. Can I offset an Invoice of a USD Customer against an Invoice of a EUR Customer?

A. Yes, AR-AP Settlements supports settlements between documents which have different currencies.

Q. How can I reconcile A/R Adjustments with A/P Adjustments created by the application?

A. AR-AP Settlements has Audit Report that shows Adjustments created in A/R and A/P modules as a result of posting settlements.

Q. Can I create a settlement if the credit balance of the documents on one side of the settlement does not equal the debit balances of the documents on the other side? For example, can I settle USD 10,000 customer Invoice against USD 8,000 vendor invoice?

A. Yes, depending on AR-AP Settlements settings you can have unallocated amount in the settlement entry. You can also define a threshold for the unallocated settlement amount and receive a warning /an error message when the amount is exceeded.

Q. Can I have partial settlements for a document?

A. Yes, AR-AP Settlements allows partial settlements. The application settles documents by creating A/R and A/P Adjustments for specified amount which can be smaller than the current document balance.

Q. Do I have to create document settlements manually?

A. No, you can use the Automatic Settlement feature of the AR-AP Settlements module to settle all outstanding documents for a Settlement Group. Moreover, starting from version 2017G you can settle documents of multiple Settlement Groups with one click.

Q. Can I use AR-AP Settlements to settle documents against other documents in the group and create payments/receipts for the documents that were not settled?

A. Yes, starting from version 2017G, a new functionality has been added that allows to automatically create receipt/payment for documents in the group that were not settled or were settled partially.

Q. How can I buy AR-AP Settlements?

A. To buy the product you need to have access to the SYSTRONICS Partners Area of our website. To do so you should create a partner account. Once you have the account, log in and request an activation code. The activation code will be dispatched to you after the settlement of the invoice.

Q. How much does AR-AP Settlements cost?

A. Please check the most recent prices on our website. To do so you should create an account and log in to the website.

AR-AP Settlements™ Old Versions

By downloading this SYSTRONICS product you agree to the Terms and Conditions.

Select Product Version

AR-AP Settlements 2020H

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	Readme

AR-AP Settlements 2019H

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	Hotfix AO2019H 20210629 (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	Readme

AR-AP Settlements 2018H

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure	Readme

AR-AP Settlements 2017G

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	AO2017G Hotfix 20171023 (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure

AR-AP Settlements 2016G

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	AO2016G Hotfix 20181009 (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure

AR-AP Settlements 2014G

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	AO2014G Hotfix 20180221 (Details)
	Hotfix AO2014G 20140909 - Visual Process Flow (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure

AR-AP Settlements 2012G

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	AO2012G PU1 Hotfix 20170830 (Details)
	Hotfix AO2012G 20140909 - Visual Process Flow (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Update Notice	Product Brochure
	Readme

AR-AP Settlements 6.0G

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	HotFix AO60G 20140506 (Details)
Documentation
	User & Administrator Guide	How To Use Sample Database
	Product Brochure

AR-AP Settlements 6.0C

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)	Sample Database (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.6C

Installation Resources
	Fully Functional Version (Details)	30-Day Evaluation Version (Details)
	Sample Database (Details)	Hotfix AO56C 20130521 (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.5C

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)	Sample Database (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.5B

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)	Sample Database (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.4C

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)	Sample Database (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.4B

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.3B

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)
Documentation
	User & Administrator Guide	Product Brochure

AR-AP Settlements 5.2B

Installation Resources
	Fully Functional, 30-Day Evaluation Version (Details)	Hot Fix
Documentation
	User & Administrator Guide	Product Brochure

Legal Notice | Site Map