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? |
Answers to common "how to" type questions regarding the post process for EnterpriseOne Accounts Receivable Manual Cash Receipts batches.
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:
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.
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.
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:
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.
Answer 6: The RG document type is created for a domestic transaction if all of the following criteria are met:
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.
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.