Post Dated Checks (Reference SAP Transfer Posting abilities)

The purpose of this discussion is to help you solve the following scenario:

Situation

Customer sends you a post dated check that will not mature for 30 days. You want to register the check in iDempiere so that is shows as an asset on your balance sheet; however, you do not want it to hit Bank in Transfer/Transit yet. How do you do this? NOTE: this is interesting scenario because this is solved with SAP's (1) special GL indicator feature and (2) transfer posting feature. The below is my best solution for how to do this in iDempiere.

Preparation in iDempiere

Create a 'Post Dated Check' Document Type
1. Open the Document Type window
2. Find the AR Credit Memo record
3. Create a copy of this record
4. Name it 'Post Dated Check'
Create a 'Post Dated Check' GL account (Account Element window => Element Value sub-tab)
Create a 'Post Dated Check' Charge and map it to the above GL Account

Steps in iDempiere

Create normal AR Invoice to a customer just like you would to any other customer.
Receive your post dated check
1. Create a new 'Post Dated Check' document using the Invoice (Customer) window
2. Create a line with a 'Post Dated Check' Charge in the amout of the original AR invoice
Allocate the documents form step 1 and step 2 so that both documents are removed from aging.
Create a reminder to help you remember when your post dated check matures
Create an AR Receipt (Payment window) for the amount of the check
1. Set the Payment's Charge field to 'Post Dated Check'
2. By setting the charge, the Payment will not touch aging.

Accounting Entries from the above Steps

AR Invoice - Invoice (Customer) window
1. Dr ==> Accounts Receivable
2. Cr ==> Revenue
Post Dated Checks - Invoice (Customer) window
1. Dr ==> Post Dated Checks
2. Cr ==> Accounts Receivable - eliminates step 1 balance
Allocation between steps 1 and 2 (net zero)
1. Dr ==> Accounts Receivable
2. Cr ==> Accounts Receivable
None
AR Receipt - Payment window
1. Dr ==> Bank in Transit/Transfer
2. Cr ==> Post dated Checks - eliminates step 2 balance

Opportunities for Automation and generic Transfer Posting abilities

In step 2, where you create the Post Dated Check, it would be nice if you had a process that you could run from the original invoice to automate the creation of the Post Dated Check document. here are my thoughts on the design of this process
- Lets assume that when you created the 'Post Dated Check' document type you assigned it a Charge (new field) of 'Post Dated Check'
- The process would would have only one parameter of Document Type. This list would only include Document Types of Document Base Type = 'AR Credit Memo' and contains a non-null Charge.
- When the process is run, it will create a new document from the Document Type parameter. It will have a line containing a Charge from the Document Type for the amount of the original invoice.
- The result is a greatly simplified process that can handle any situation (not just post dated checks)
Create a plugin that automates step 3 upon completion of step 2.
Create process from Post Dated Check document to automatically create and complete the AR Receipt in step 5. Update the AR Receipt to have a new field (called chuboe_invoice_id) that points back to the document that created it.
Create a report that shows the balance (both in document currency and in each schema currency) of each of the above document types. The balance is defined as (1) invoice from step 2 amount minus (2) the sum of AR Receipts that point to it. This report will be used to defend the balance of each of your GL Accounts. NOTE: this concept is not limited to just post dated accounts!