AR-AP Settlements for Sage 300
Settle A/R Transactions With A/P Transactions!
Why SYSTRONICS 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.
AR-AP Settlements Business Benefits
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.
Why to buy
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!
Currently Supported Versions
| Currently supported | 2023H · 2024H · 2025H · 2026H |
|---|---|
| Compatible with | Sage 300 2026, Sage 300 2025, Sage 300 2024, Sage 300 2023 |
| Delivery Mode | Website download. |
AR-AP Settlements Downloads
AR-AP Settlements prices
Annual subscription
Entitles the End User to use any shipping version during the validity period, including updates, upgrades and unlimited offsite technical support direct from the SYSTRONICS Support Team.
Fixed license fee
Updates, upgrades and support are available under a valid Software Assurance Plan, mandatory for the first year and charged at 20% of the current product SRP.
Version history
Tips & tricks
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 GroupViewing 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 GroupFAQ
Can I use AR-AP Settlements to settle documents posted for one vendor against documents posted for other vendors?
Can I make changes in the AR-AP Settlements entries after they have been posted?
Can I offset an Invoice of a USD Customer against an Invoice of a EUR Customer?
How can I reconcile A/R Adjustments with A/P Adjustments created by the application?
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?
Can I have partial settlements for a document?
Do I have to create document settlements manually?
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?
How can I buy AR-AP Settlements?
How much does AR-AP Settlements cost?
See AR-AP Settlements on your Sage 300
Tell us your Sage 300 version and how you plan to use AR-AP Settlements. The SYSTRONICS team will arrange an online demonstration.
Ready to put AR-AP Settlements on Sage 300?
Download the current version, request an activation code, or ask the SYSTRONICS team for a walkthrough.