FAQ - Frequently Asked Questions Regarding Standard (Manual) Receipts and Receipt Post Process in Accounts Receivable Within EnterpriseOne (R09801, P00241)

Purpose
Questions and Answers
 Accounts Receivable Cash Receipts Posting (R09801) Questions
 Question 1: What account is used when creating the Automatic Entry for a receipt when posting?
 Question 2: Why does posting a receipt batch create an RK document type in the General Ledger (F0911) rather than an RC document type?
 Question 3: What determines the  bank account the RC record posts to in the General Ledger (F0911)?
 Question 4: Why does the R09801 sometimes print "No F0911 Records Exist in this Batch" but other times it shows entries to the same trade account when posting receipts batches for spreads?
 Question 5: Can you assign a subledger on cash receipts?
 Question 6: What is the required set up for creating the RG document in the XA ledger for the gain/loss on a domestic cash receipt?
 Question 7: What determines the account the RC record posts to in the General Ledger (F0911)?
 Question 8: Is the Remark field entered during receipt entry updated to the General Ledger (F0911) table?

Purpose

 Answers to common "how to" type questions regarding the post process for EnterpriseOne Accounts Receivable Manual Cash Receipts batches.

Questions and Answers

Accounts Receivable Cash Receipts Posting (R09801) Questions

Question 1: What account is used when creating the Automatic Entry for a receipt when posting?

Answer 1: The account used for the Automatic Entries (AEs) for receipts is retrieved from the Account ID (AID) field in the Receipt Details (F03B14) table. This field is populated during Receipt Entry/Creation as followed:

  1. If the receipt is an unapplied cash receipt (or has a line of unapplied cash in the F03B14), the system using the RCUC AAI to populate the Account ID in the Receipts Detail (F03B14).
  2. If a receipt is applied to invoices, the Account ID (AID) is pulled from the invoice record in the Customer Ledger (F03B11). The Account ID (AID) in the Customer Ledger (F03B11) is populated using an RC AAI using the selection hierarchy described in the AAI Search Sequence section of Troubleshooting Account Receivable Automatic Accounting Instruction AAI Errors (P0012, R09801) at the time of invoice entry.

Question 2: Why does posting a receipt batch create an RK document type in the General Ledger (F0911) rather than an RC document type?

Answer 2: The RK Document Type (DCT) is hard-coded for use in the General Ledger (F0911) when the the Offset Method for Accounts Receivable is set to B (one document per batch) in the AR Constants (P0000). This document type indicates that the general ledger document is a summarized amount for all receipts within a batch.


Question 3: What determines the  bank account the RC record posts to in the General Ledger (F0911)?

Answer 3: The RC record on a receipt posts to the General Ledger (F0911) using the account that is specified on the header of the receipt in Receipt Entry (P03B102). This bank account is also saved in the Receipt Header (F03B13) table.


Question 4: Why does the R09801 sometimes print "No F0911 Records Exist in this Batch" but other times it shows entries to the same trade account when posting receipts batches for spreads?

Answer 4: When matching (aka spreading) AR invoices to credit memos, and posting the resulting receipt batch, the Post (R09801) pdf prints the "No F0911 Records Exist in this Batch" message when the Offset Method in the AR constants is either B (By Batch) or Y (By Document) and the Exchange Rate field in the F0911 (CRR) is blank. This message is displayed because it is a debit and credit to the same account and would therefore not create a by batch or by document posting for a zero amount.

If the Offset Method is S for 'By Pay Item' or the Exchange Rate (CRR) field in the F0911 is set to 1, the R09801 creates entries in the F0911, even if these are debits and credits to the same account.

Note: the Exchange Rate (CRR) field may be set to 1 because of the following:


Question 5: Can you assign a subledger on cash receipts?

Answer 5: No.  This is because the accounting entries for receipts are controlled by Automatic Accounting Instructions (AAIs) and there is not a way to assign a subledger to them.  Therefore, do not set the Post Edit Code (PEC) to require a subledger for any associated receipt accounts associated to AAIs. 


Question 6: What is the required set up for creating the RG document in the XA ledger for the gain/loss on a domestic cash receipt?


Answer 6: The RG document type is created for a domestic transaction if all of the following criteria are met:

  1. RG and RL AAIs exist
  2. The Detailed Currency Restatement Flag for company 00000 is not blank
  3. The Detailed Currency Restatement Flag for transaction company is not blank
  4. The currency code for Ledger Type XA is not Blank
  5. The Receipt Type Code is not D (Draft receipt) neither G (General ledger receipt)
  6. If the receipt currency is not equal to XA ledger currency
  7. For receipts in question, there is a difference in exchange rate between invoice and payment.

Question 7: What determines the account the RC record posts to in the General Ledger (F0911)?

Answer 7: The RC record on a receipt posts to the General Ledger (F0911) using the account that is specified on the header of the receipt in Receipt Entry (P03B102). This bank account is also saved in the Receipt Header (F03B13) table.


Question 8: Is the Remark field entered during receipt entry updated to the General Ledger (F0911) table?

Answer 8: At the time of posting the receipt batch, the Remark (RMK) in the grid is populated for the AR Trade account in the Name Alpha Explanation (EXA) field in the General Ledger (F0911), whereas the Remark (RMK) in the header is populated for the Bank Account in the Name - Remark Explanation (EXR).  In the case of Unapplied Cash Receipts, since no remark values are entered in the grid, the Remark (RMK) in the header is also populated for the the Unapplied Cash (RCUC) account and Bank Accounts in EXA and EXR fields of the General Ledger (F0911) table.