M5-AR-Inter-Company Cash Receipts

From BlythecoDev Wiki

Jump to: navigation, search

Contents

Synopsis

This solution allows the user to apply cash receipts against any Sage 500 company. The examples provided in the user guide will refer to a source company (SOA) and a target company (COA) for the inter-company transactions.

This enhancement may be used in conjunction with M5-SO - MAS 500 Inter-Company Sales Orders


Installation, Setup & Usage

Installation Requirements:

Prior to running this application, you will need to have the appropriate version of Sage 500 installed. (Various versions of Sage 500 are, or can be, made compatible. For more information please contact BlytheDev). It is recommended to have a complete and tested backup prior to installing any application on your Sage 500 platform.

Reinstalling or Installing an Update:

You must first uninstall any custom (non-Sage) client/server installs via “Add and Remove Programs”. This will not uninstall any database objects, but will permit the update install to run its SQL package to update the necessary database objects. Once the previous install has been removed, you may then run the new client and server installs.

Components to the Installation:

1. Server Installation – This adds the database stored procedures and tables required to run the integration. Run the Install Shield on the MAS 500 database server.
2. Client Installation – This is used to install the client components of Sage 500. Run the Install Shield Application on each appropriate workstation that the enhancement will run.


Task Setup:

The task “Process Cash Receipts_BLY” must be added to the MAS500 task menu.

1. Select your MAS500 desktop, go to the Accounts Receivable > Activities folder
2. Right click on the folder and select “Create New Task.”
3. When the context menu appears, select MAS 500 Task.
4. For Module select Accounts Receivable
5. Select the task named “Process Cash Receipts_BLY” then select OK.
6. A “Process Cash Receipts_BLY” task will appear in the MAS500 task menu.


ICCR Task Setup
Figure 1 - Add MAS500 Task


Payment Terms Setup

In both the source and target companies, the user needs to create a new Payment Term of “None”. This is used for inter-company cash receipts. Be sure all days and discounts are set to “0” as shown in Figure 2.

ICCR Set Up Payment Terms
Figure 2 - Set Up Payment Terms


Inter-Company Customer Setup

Inter-Company Cash Receipts requires that the source and target companies have identical Customer ID’s. For example, if Customer ID “Abbott” is set up in Accounts Receivable > Maintain Customers, for the source company “SOA’, then “Abbott” must also be set up in the target company “COA”.

GL Setup - Maintain Target Companies

In General Ledger > Maintenance > Maintain Target Companies, set up target companies with the new “AR-CR” Source Batch Type and “CR” Target Journal. Select the appropriate GL accounts to be used for the “Source Due To” and “Source Due From” and save. See Figure 3.

ICCR Maintain Target Companies
Figure 3 - Maintain Target Companies



Using This Enhancement

Process Cash Receipts IC –BLY Task

Activate the Process Cash Receipts IC –BLY task (added in Task Setup) by clicking on the task in the menu. (Note the Description for the batch has “Imported IC Cash Receipts” to identify imported batches).

As in standard Sage 500, select the Enter Cash Receipts button to review the cash receipt.

ICCR Process Cash Receipts IC - BLY
Figure 4 - Process Cash Receipts IC - BLY


Figures 5 and 6 show the import for the COA company payment, (i.e. "COA" is designated as the Target Co).

ICCR Enter Cash Receipts IC - BLY - Payment Tab
Figure 5 - ICCR Enter Cash Receipts IC - BLY - Payment Tab


ICCR Enter Cash Receipts IC - BLY - Application Tab
Figure 6 - ICCR Enter Cash Receipts IC - BLY - Application Tab


Note in Figure 6, Application tab, COA is shown as the Target Company with a payment to Invoice 0000000235-IN for $136.

The next cash receipt in this batch is the payment for the SOA company shown in Figures 7 and 8.

ICCR Enter Cash Receipts IC - BLY - Payment Tab
Figure 7 - ICCR Enter Cash Receipts IC - BLY - Payment Tab


ICCR Enter Cash Receipts IC - BLY - Application Tab
Figure 8 - ICCR Enter Cash Receipts IC - BLY - Application Tab


Posting Cash Receipts

The following shows the inter-company posting registers of the Cash Receipt batches. See Figures 9 through 15. The inter-company accounting is performed using the following:

Posting of the cash receipt in the current Sage 500 Company will process the distribution of the cash to the target companies.

  • Due To accounts will be funded.
  • Issue credit memos to the target companies and apply the credit memos to the invoices selected in the Inter-company Application/Distribution screen. These credit memos will complete the distributed payment to the target company.
  • A debit memo in the current Sage 500 Company will be created to adjust AR for the amount distributed to the target companies. The debit memo will apply to the customer unapplied part of the cash receipt that was distributed to the target companies. Any remaining amount not distributed to the target companies will remain as an unapplied payment amount for the customer.
  • Extended data for the reference of cash receipts and the distribution to the target companies will be collected. Memo documents used for the Inter-company distributions may be suppressed on reports by the Customer or Consulting. Or the collected data will facilitate auditing of the distribution.


ICCR - AR - Cash Receipts Register
Figure 9 - ICCR - AR - Cash Receipts Register


ICCR - AR - Cash Receipts Register
Figure 10 - ICCR - AR - Cash Receipts Register


ICCR - AR - Cash Receipts Register
Figure 11 - ICCR - AR - Cash Receipts Register


ICCR - AR - Invoice Register
Figure 12 - ICCR - AR - Invoice Register


ICCR - AR - Invoice Register
Figure 13 - ICCR - AR - Invoice Register


ICCR - AR - Cash Receipts Register - Recap
Figure 14 - ICCR - AR - Cash Receipts Register - Recap


ICCR - AR - Cash Receipts Register - Summary
Figure 15 - ICCR - AR - Cash Receipts Register - Summary


Personal tools
MediaWiki Appliance - Powered by TurnKey Linux