ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
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 Sales Management
DrillDown Icon RMA Management
DrillDown Icon RMA Management
DrillDown Icon RMA Accounting
DrillDown Icon Sales Price List Information
DrillDown Icon Customer Information (CI)
DrillDown Icon Sales Representitive Information (SR)
DrillDown Icon Inventory 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
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Return Material Authorization Accounting

Overview regarding Return Material Authorization Accounting

 

No Journal Entry is created in the RMA module, however the system is collecting the JE components from this 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 return is created in the Return Material Authorization Receiving module.  (The value is calculated against the total value of the RMA minus any credit memos created against the invoice, whether manually or via RMA).  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:

 

1.       The Journal Entry is created as follows and forwards to the Release & Post to GL 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, 1015.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 the Kitting module and add line shortages which will be included in the Material Variance once the Kit is closed.  
 
 
From this point forward, the accounting is the same as for a regular order.
 
 
   
Article ID: 4625