Match Credits to Open Invoices
An alternative to applying a Credit Memo to a Debit Memo via zero Deposit Cash Receipt would be to use the Match Credits to Open Invoice option on the Accounts Receivable, Period End menu. You can use this option to match credits automatically, such as prepayments, credit memos and negative invoices, against open invoices in the Open Invoice file. You can perform global or selective matching of credits to outstanding invoices by invoice date or sequentially by invoice number. There is no requirement that the invoice numbers and credit numbers must match.
The Match Credits to Open Invoices Report shows all invoices for which the option automatically applies the credits. After printing and reviewing the report, you can update credit matches to the AR Open Invoice file and the AR Transaction/Payment History file.
Credit Memos are created with a transaction type payment of CREDIT-X, with the transaction date and an offset amount to the open invoices selected for matching.
You can select Sequentially to apply credits to open invoices sequentially by invoice number. Or, you can select Invoice Date to apply credits to open invoices by invoice date.
Enter a range of customer numbers, or select the All check box to include all customer numbers.
Select Print, review the Match credits to open invoice register. If everything is okay, you can then answer "Yes" to "Do you want to update Open Invoices?"
*
Offset Customer and Vendor Balances
You may have Accounts Payable vendors who are also your Accounts Receivable customers. For these vendor/customers, Accounts Receivable invoices can be applied automatically or selectively to the vendor's balance, eliminating the manual matching process of issuing checks and posting payments.
Note: This option can only be used if customers are set up in the Accounts Receivable module.
The vendor/customer links must be established in Vendor/Customer Link Maintenance, found in AP, Setup.
Customer Field
Enter a customer number representing the Accounts Receivable customer who you want to link to an Accounts Payable vendor. Click the Lookup button to list all customer numbers. Click the alternate Search (Flashlight) button to display a list of defined customer/vendor links.
Vendor Field
Enter a vendor number to which you want to link the customer number. Click the Lookup button to list all vendor numbers.
Click the Printer button to print a Vendor/Customer Link Listing.
In AP, Period End, Use A/P from A/R Clearing Selection to choose the vendors/customers to be included in the clearing process.
If you have linked multiple customers to a single vendor, you must verify that the amount being cleared from the customer to Accounts Payable does not exceed the vendor's balance, or the vendor's account may have a negative balance.
A/R Transfer Not to Exceed A/P Due
Select the A/R Transfer Not to Exceed A/P Due check box if the dollar amount cleared from a vendor account to a customer account does not exceed the total balance for that vendor. Clear the check box if all open invoices for the customer can be cleared to the vendor account.
Include Invoices on Hold
Select the Include Invoices on Hold check box to include invoices on hold.
Customer Number
Enter a range of customer numbers that includes the customers you want to clear to Accounts Payable, or select the ALL check box to include all customer numbers. Click the Lookup button to list all customer numbers.
Click on Proceed, and then Print the AP from the AR Clearing Register. After printing, you will be prompted to Update the Register.
*
Changing AR/AP Addresses to all Upper Case
Within MAS 90, on the menu bar, select File, Run and at the Program Name, type in SWUPCS and click proceed. An Uppercase Address Utility window will open, stating
"This utility will convert address information to uppercase for the selected files." This is a permanent change and cannot be reversed, therefore we recommend making a backup before initiating this process. There are several fields to choose from
Uppercase City Only
Uppercase All Address Fields
Customers
Ship-to-Addresses
Vendors
Purchase Addresses
Select the fields you want to change and then click proceed. Again this process CANNOT be reversed.
To change only the CITY names to ALL Caps, within MAS 90, from the menu select File, Preferences and on the 4th Tab System Prefs, top right side check the box next to
Return CITY names in ALL CAPS.