Epicor ERP Epicor ERP Accounts Receivable Transaction Hierarchy

Download as pdf or txt
Download as pdf or txt
You are on page 1of 15
At a glance
Powered by AI
The document describes Epicor ERP accounts receivable transactions and the accounts that are credited or debited for each transaction type.

The document is about the transaction hierarchy for accounts receivable in Epicor ERP, including invoice entry, credit memos, cash receipts, reversals and adjustments.

Transactions described include applying invoices and credit memos, cash receipts, reversals of cash receipts and invoices, write-offs and adjustments, and payment instruments.

Epicor ERP

Epicor ERP Accounts Receivable


Transaction Hierarchy
10
Disclaimer
This document is for informational purposes only and is subject to change without notice. This document and its
contents, including the viewpoints, dates and functional content expressed herein are believed to be accurate as of its
date of publication. However, Epicor Software Corporation makes no guarantee, representations or warranties with
regard to the enclosed information and specifically disclaims any applicable implied warranties, such as fitness for a
particular purpose, merchantability, satisfactory quality or reasonable skill and care. As each user of Epicor software is
likely to be unique in their requirements in the use of such software and their business processes, users of this document
are always advised to discuss the content of this document with their Epicor account manager. All information contained
herein is subject to change without notice and changes to this document since printing and other important information
about the software product are made or published in release notes, and you are urged to obtain the current release
notes for the software product. We welcome user comments and reserve the right to revise this publication and/or
make improvements or changes to the products or programs described in this publication at any time, without notice.
The usage of any Epicor software shall be pursuant to an Epicor end user license agreement and the performance of
any consulting services by Epicor personnel shall be pursuant to Epicor's standard services terms and conditions. Usage
of the solution(s) described in this document with other Epicor software or third party products may require the purchase
of licenses for such other products. Where any software is expressed to be compliant with local laws or requirements
in this document, such compliance is not a warranty and is based solely on Epicor's current understanding of such laws
and requirements. All laws and requirements are subject to varying interpretations as well as to change and accordingly
Epicor cannot guarantee that the software will be compliant and up to date with such changes. All statements of
platform and product compatibility in this document shall be considered individually in relation to the products referred
to in the relevant statement, i.e., where any Epicor software is stated to be compatible with one product and also
stated to be compatible with another product, it should not be interpreted that such Epicor software is compatible
with both of the products running at the same time on the same platform or environment. Additionally platform or
product compatibility may require the application of Epicor or third-party updates, patches and/or service packs and
Epicor has no responsibility for compatibility issues which may be caused by updates, patches and/or service packs
released by third parties after the date of publication of this document. Epicor® is a registered trademark and/or
trademark of Epicor Software Corporation in the United States, certain other countries and/or the EU. All other
trademarks mentioned are the property of their respective owners. Copyright © Epicor Software Corporation 2014.
All rights reserved. No part of this publication may be reproduced in any form without the prior written consent of
Epicor Software Corporation.

10
Revision: June 25, 2014 3:00 a.m.
Total pages: 15
sys.ditaval
Epicor ERP Accounts Receivable Transaction Hierarchy Contents

Contents
Epicor ERP Accounts Receivable Transaction Hierarchy.......................................................4
AR Invoice Entry - Add Invoice..........................................................................................................................4
AR Invoice Entry - Action Menu........................................................................................................................7
AR Invoice Entry - Discounts and Taxes.............................................................................................................8
Cash Receipt Entry.........................................................................................................................................10
Apply Document............................................................................................................................................12
Reverse Cash Receipt.....................................................................................................................................13
AR Write Off and Adjustment........................................................................................................................14
Payment Instrument (PI) Receivable Entry........................................................................................................14

Epicor ERP | 10 3
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Epicor ERP Accounts Receivable Transaction Hierarchy

This hierarchy is a summary of common general ledger (GL) transactions posted from within the Accounts
Receivable (AR) module.
Note This hierarchy assumes your company uses an unmodified version of the Standard posting rules
delivered with the Epicor application. If you use the Extended posting rules, or if you need information
regarding an AR transaction that is not listed on this hierarchy, refer to GL Transaction Type Maintenance
and review the details of the AR Invoice posting rules.
In addition, this hierarchy does not include intercompany or consolidation transactions.

AR Invoice Entry - Add Invoice

Transaction/Program Action Debit Credit

AR Invoice Entry

Post Advanced Receivables Account Deferred Revenue Account


Billing Invoice
1. AR Account GL Control - 1. AR Account GL Control -
With the Deferred Customer Customer
Revenue option
2. AR Account GL Control - 2. AR Account GL Control -
Company Config Company Config
Note: If you select the Deferred
Revenue check box on an invoice
line, the application credits the
Deferred Revenue Account.

Post Advanced Receivables Account Sales Account


Billing Invoice
1. AR Account GL Control - 1. Product Group GL Control -
Without the Customer Product Group
Deferred
2. AR Account GL Control - 2. AR Account GL Control -
Revenue option
Company Config Customer
3. AR Account GL Control -
Company Config
Note: If you clear the Deferred
Revenue check box on an invoice
line, the application credits the
Sales Account.

Post Deposit Receivables Account Prepayment Account


Billing Invoice
1. AR Account GL Control - 1. AR Account GL Control -
Customer Customer

4 Epicor ERP | 10
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Transaction/Program Action Debit Credit


2. AR Account GL Control - 2. AR Account GL Control -
Company Config Company Config

Post Receivables Account Miscellaneous Charge Income


Miscellaneous Account
1. AR Account GL Control -
Charge Amount
Customer 1. Account from GL Control on
Miscellaneous Charge
2. AR Account GL Control -
Company Config

Post Credit Memo Returns Account Receivables Account


1. AR Account GL Control - 1. AR Account GL Control -
Product Group Customer
2. AR Account GL Control - 2. AR Account GL Control -
Customer Company Config
3. AR Account GL Control -
Company Config

Post Advance Deferred Revenue Account Receivables Account


Billing Credit
1. AR Account GL Control - 1. AR Account GL Control -
Memo
Customer Customer
With the Deferred
2. AR Account GL Control - 2. AR Account GL Control -
Revenue Account
Company Config Company Config
option
Note: If you select the Deferred
Revenue check box on a credit
memo invoice line, the
application debits the Deferred
Revenue Account.

Post Advance Sales Account Receivables Account


Billing Credit
1. AR Account GL Control - 1. AR Account GL Control -
Memo
Product Group Customer
Without the
2. AR Account GL Control - 2. AR Account GL Control -
Deferred
Customer Company Config
Revenue Account
option 3. AR Account GL Control -
Company Config
Note: If you clear the Deferred
Revenue check box on a credit
memo invoice line, the
application debits the Sales
Account.

Post Deposit Prepayment Account Receivables Account


Billing Credit
1. AR Account GL Control - 1. AR Account GL Control -
Memo
Customer Customer

Epicor ERP | 10 5
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Transaction/Program Action Debit Credit


2. AR Account GL Control - 2. AR Account GL Control -
Company Config Company Config

Post Receivables Account Sales Account


Miscellaneous
1. AR Account GL Control - 1. Product Group GL Control -
Invoice
Customer Product Group
2. AR Account GL Control - 2. AR Account GL Control -
Company Config Customer
3. AR Account GL Control -
Company Config
Note: A Sales Account can be
updated on an AR invoice line at
the time of invoice entry.

6 Epicor ERP | 10
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

AR Invoice Entry - Action Menu

Transaction/Program Function Debit Credit

AR Invoice Entry -
Actions

Get Shipments Receivables Account Sales Account


- Post
1. AR Account GL Control 1. AR Account GL Control - Product
Shipment
- Customer Group
Invoice
2. AR Account GL Control 2. AR Account GL Control - Sold To
- Company Config Customer
3. AR Account GL Control - Bill To
Customer
4. AR Account GL Control - Company
Config
Notes:
• If a Sales Category is used (invoice
line or customer), the Department
segment comes from the Department
GL Control selected on the Sales
Category.
• If a Site is selected on the invoice, the
Division segment comes from the
Division GL Control selected on the
Warehouse or Site.

Post Reverses original AR invoice Reverses original AR invoice GL credit


Cancellation GL debit transactions transactions
Invoice

Post Finance Receivables Account AR Finance Charge Accrual Account


Charges
1. AR Account GL Control 1. AR Account GL Control - Customer
- Customer
2. AR Account GL Control
- Company Config

Epicor ERP | 10 7
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

AR Invoice Entry - Discounts and Taxes

Transaction/Program Function Debit Credit

AR Invoice Entry -
Discounts and Taxes

Post Discount Sales Discount Account Receivables Account


Amount (All
1. AR Account GL Control - Product 1. AR Account GL Control -
Invoice Types,
Group Customer
Part)
2. AR Account GL Control - Customer 2. AR Account GL Control -
Company Config
3. AR Account GL Control - Company
Config
*If a Sales Category is used (invoice
line or customer), the Department
segment comes from the Department
GL Control selected on the Sales
Category.
*If a Site is selected on the invoice,
the Division segment comes from
the Division GL Control selected on
the Warehouse or Site.

Post Discount Receivables Account Discount Account


Amount (Credit
1. AR Account GL Control - Customer 1. AR Account GL Control -
Memo, Part)
Product Group
2. AR Account GL Control - Company
Config 2. AR Account GL Control -
Customer
3. AR Account GL Control -
Company Config

Set Terms Payment Discount Receivables Account


Discount (On
1. AR Account GL Control assigned 1. AR Account GL Control
Invoice)
to invoice you are paying assigned to invoice you are
paying.

Sales Tax (All Receivables Account AR Tax Accrual Account


Invoice Types,
1. AR Account GL Control - Customer 1. Tax GL Control - Tax Type
Part)
2. AR Account GL Control - Company
Config

Sales Tax (Credit AR Tax Accrual Account Receivables Account


Memo, Part)
1. Tax GL Control - Tax Type 1. AR Account GL Control -
Customer

8 Epicor ERP | 10
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Transaction/Program Function Debit Credit


2. AR Account GL Control -
Company Config

Epicor ERP | 10 9
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Cash Receipt Entry

Transaction/Program Function Debit Credit

Cash Receipt Entry

Post Invoice Cash Account Receivables Account


Payment
1. Bank GL Control - Bank Account 1. AR Account GL Control
assigned to invoice you are
Note If the Reconciled AR
paying.
Balance check box is selected
on the bank record in Bank
Account Maintenance, this
transaction debits the Pending
Cash Account defined in the
Bank GL Control instead of the
Cash Account.

Book Cash Account Unapplied Cash Account


Unapplied
1. Bank GL Control - Bank Account 1. AR Account GL Control -
Cash
Customer
Note If the Reconciled AR
Note
Balance check box is selected 2. AR Account GL Control -
Unapplied
on the bank record in Bank Company Config
cash on
Account Maintenance, this
receipts
transaction debits the Pending
creates
Cash Account defined in the
Unapplied
Bank GL Control instead of the
Receipt
Cash Account.
(UR)
Credit
Memos.

Post Cash Account Enter Account Number on


Miscellaneous Record
1. Bank GL Control - Bank Account
Payment
Note If the Reconciled AR
Balance check box is selected
on the bank record in Bank
Account Maintenance, this
transaction debits the Pending
Cash Account defined in the
Bank GL Control instead of the
Cash Account.

Post Deposit Cash Account Prepayment Account


Payment
1. Bank GL Control - Bank Account 1. AR Account GL Control -
(Allocated or
Company Config
Unallocated) Note If the Reconciled AR
Balance check box is selected

10 Epicor ERP | 10
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Transaction/Program Function Debit Credit


on the bank record in Bank 2. Option to enter Account
Account Maintenance, this Number on record.
transaction debits the Pending
Cash Account defined in the
Bank GL Control instead of the
Cash Account.

Post Debit Receivables Account Cash Account


Note
1. AR Account GL Control - Customer 1. Bank GL Control - Bank
Account
2. AR Account GL Control - Company
Config Note If the Reconciled
AR Balance check box
is selected on the bank
record in Bank Account
Maintenance, this
transaction credits the
Pending Cash Account
defined in the Bank GL
Control instead of the
Cash Account.

Book Bank Fee Bank Fee Account Cash Account


1. Bank Fee GL Control - Bank Fee 1. Bank GL Control - Bank
Account
2. Option to change account on the
Cash Receipt (A/R Account > Bank Fee Note If the Reconciled
sheet) AR Balance check box
is selected on the bank
record in Bank Account
Maintenance, this
transaction credits the
Pending Cash Account
defined in the Bank GL
Control instead of the
Cash Account.

Epicor ERP | 10 11
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Apply Document

Transaction/Program Function Debit Credit

Apply Document

Apply Credit Memo Receivables Account Receivables Account


CM created in AR Invoice 1. AR Account GL Control 1. AR Account GL Control -
Entry - Posted Credit Memo Posted Invoice to which you are
applying credit memo

Apply Credit Memo Unapplied Cash Account Receivables Account


CM created when 1. AR Account GL Control 1. AR Account GL Control -
unapplied cash posted in - Posted UR Credit Memo Posted Invoice to which you are
Cash Receipt Entry applying the credit memo

12 Epicor ERP | 10
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

Reverse Cash Receipt

Transaction/Program Function Debit Credit

Reverse Cash
Receipt

Reverse Deposit Prepayment Account Cash Account


Payment Credit
1. AR Account GL 1. Bank GL Control - Bank Account -
Control - Source Cash Source Cash Receipt
Receipt

Reverse Invoice Receivables Account Cash Account


Payment Credit
1. AR Account GL 1. Bank GL Control - Bank Account -
Control - Source Cash Source Cash Receipt
Receipt
Note If a Pending Cash Account
is defined in the Bank GL Control,
this transaction credits that account
instead of the Cash Account.

Reverse Account Selected on Cash Account


Miscellaneous Source Cash Receipt
1. Bank GL Control - Bank Account -
Payment Credit
Source Cash Receipt
Note If a Pending Cash Account
is defined in the Bank GL Control,
this transaction credits that account
instead of the Cash Account.

Reverse Unapplied Cash Cash Account


Unapplied Cash Account
1. Bank GL Control - Bank Account -
1. AR Account GL Source Cash Receipt
Control - Source Cash
Note If a Pending Cash Account
Receipt
is defined in the Bank GL Control,
this transaction credits that account
instead of the Cash Account.

Epicor ERP | 10 13
Epicor ERP Accounts Receivable Transaction Hierarchy Epicor ERP Accounts Receivable Transaction Hierarchy

AR Write Off and Adjustment

Transaction/Program Function Debit Credit

AR Write Off and


Adjustment

Increase or decrease an Enter Account Number on Receivables Account


open invoice amount Record
1. AR Account GL Control
assigned to invoice you are
adjusting

Increase or decrease an Receivables Account Enter Account Number on


open credit memo Record
1. AR Account GL Control
amount
assigned to credit memo you
are adjusting

Payment Instrument (PI) Receivable Entry

Transaction/Program Function Debit Credit

Payment Instrument
(PI) Receivable Entry

Receivables Account
AR PI PI Receivable Account
Payment 1. AR Account GL Control assigned
1. Payment Instrument GL
to the invoice to which you are
Control assigned to the
applying the Payment Instrument
Payment Instrument Receivable
Receivable

14 Epicor ERP | 10
Additional information is available at the Education and
Documentation areas of the EPICweb Customer Portal. To access
this site, you need a Site ID and an EPICweb account. To create an
account, go to http://support.epicor.com.

You might also like