ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon Sales
DrillDown Icon Inventory Management
DrillDown Icon Packing List Management
DrillDown Icon RMA Receiver
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields and Definitions
DrillDown Icon RMA Receiver Tab
DrillDown Icon Detail Tab
DrillDown Icon Notes Tab
DrillDown Icon WO List Tab
DrillDown Icon Accounting
DrillDown Icon How To ....
DrillDown Icon PO Receiving & DMR
DrillDown Icon Kitting, Allocating & Shortage Management
DrillDown Icon Inventory Control Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Quality/Engineering
DrillDown Icon Administration
DrillDown Icon Accounting
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Overview Regarding Return Material Authorization Accounting

No Journal Entry is created in the RMA module, however the system was collecting the JE components from that module as follows:

Assume that the original sale was for 10 units @ $100.00 each, with a standard cost of $80.00 each and freight charged the customer of $15.00.

At the time the user selects the original Invoice number in the Return Material Authorization module, the system “remembers” the original accounting entry that was created at the time the original Invoice was printed, which was:

Debit Accounts Receivable – Trade  $1,015.00

Debit Cost of Goods Sold  $800.00

Credit Sales  $1,000.00

Credit Finished Goods Inventory  $800.00

Credit Freight Income  $15.00

When the user enters the “return quantity” (the one entered as a negative quantity), the system will remember that the original cost of sales was $80.00 per unit.

The user then enters the pricing on the item to be returned on the Pricing page of the RMA module.

The pricing entered can be any amount up to the amount of the original pricing of $100.00 per unit. And so the journal entry component for the debit to the sales account is 2X $100.00 = $200.00, in this example.

The user selects the sales and cost of goods general ledger accounts to be used per the Sales Type column:

And so, the sales account number selected will be debited for $200.00 once the journal entry is created, upon the actual receipt of the returned item.And the related Cost of Goods sold account will be credited for the $160.00.

If the return is to be reworked and then returned back to the customer, the user creates a second line item on the RMA using a positive quantity which is in actuality creating the RMA Sales Order and an eventual invoice upon shipment.

The journal entry and the applicable Credit Memo for the returnis created in this Return Material Authorization Receiving module.On this screen, the user indicates the amount of freight to be credited, such as a pro rata 2/10 of $15.00, or $3.00, for example:


After the user types in the quantity received on the Detail page and depresses the Save button, several things happen all at once:

The Journal Entry is created as follows and forwards to the Release to General Ledger module:

Debit Sales  $200.00

Debit WIP  $160.00

Debit Freight  $3.00

Credit Accounts Receivable $203.00

Credit COGS  $160.00

  1. The Credit Memo is created for an amount of $203.00 total.  If the original invoice is still open, the amount of the credit memo will net against the original invoice leaving an open balance of $812.00, $1,015.00 minus $203.00.   If the invoice is paid than a credit balance will appear on the A/P Aging for the unapplied amount up to $203.00.
  2. The e-mail trigger is activated announcing that a Credit Memo has been created.
  3. The ReWork Work Order is created.
  4. The returned material is placed into WIP.

Once the Rework Work order is released, the user may opt to go into kitting and add line shortages which will be included in the Material Variance once the Kit is closed.Please refer to the Kitting and Shortage Management manual.

From this point forward, the accounting is the same as for a regular order.

Article ID: 4694