Add check payments

Add your "Check" payment terms in Setup => Payment Terms menu.

Your extra fields:
1. Check Owner Name (anyone other than the customer can be entered in the memo / comments field)
2. Pay to the Order of (anyone other than the Company whose Accounts is being maintained in FA can be similarly entered in the memo / comments field)
3. Check Number can be entered using the comments field and better still using the Non Field DB Data concept discussed in the Wiki.

Then you would definitely need to implement the Non Field DB Data and write your own function for filtering out the checks....

Are you referring to various customer checks your receive or your checks to various suppliers you pay out? If it is the altter, then just make the check number with some start string as the reference for supplier payments and it will auto increment.

I wish joe also involve to this matter too...I think Non Field DB Data can't applicable for this matter.

Thanks to all FA contributors
Asghar

Dear apmuthu, the only thing I want is to have:

1. Adding another "date" input in "Payment Entry(ies)".
2. For checks look up solution, to add 2 "Date input text" in "Journal Inquiry" with start and end date; this will solve everything because we can easily check what checks should be cashed at specific period of time or when is the checks due dates.

Thanks to all FA contributors
Asghar

apmuthu, did I clearly express what I want? at first stage it is very important to me that I indicate FA check section shortage clearly.

How do you put "Bank Account Reconciliation" in check section?

Thanks to all FA contributors
Asghar

Well, there is a big difference here.
Shape of business trades here is vary from US; suppose a business that takes 100's (or more than) of checks from consumers or businesses within a month. Then that business pass away the taken checks to other businesses, like suppliers or etc…, or business issue their own checks to others. Meanwhile here businesses due to backs late encashment or instead of issuing their own company checks pass away taken checks to others, and because of that often put them in banks.

In “Reconcile Bank Account” you can just checkmark and compare with bank statement and this do not alter or change GL. Any change should made at other part like GL or payment entry manually.
Now if that business want to look up for checks they have taken from date to date for encashment or giving to other suppliers what have to do?
For your consideration our type of accounting is accrual and not cash accounting and because of that most of bank transaction based on check.

Thanks to all FA contributors
Asghar

Exactly, you well understood my meant apmuthu, thank you.

I and our team worked on FA very much, we really believed in we are a part of FA and can't give up.

We found a normal solution for check issues. We just need to know the encashment period while looking at "Bank Account Inquiry". For this we need to:

1. Add a date input in customers and suppliers "Payment Entry" for keeping check encashment date.
2. Altering “Bank Account Inquiry” section. Add a Combo box to let users to choose wither they are looking entry date or encashment date and have another encashment field in data grid.

Apmuthu, in your experience how much time does it takes to alter FA to feet in this shape?

Thanks to all FA contributors
Asghar

apmuthu, any recommendation on how to start this module?

With the budget and knowledge we have it took's a lot for us to create this but we will do that. Your further guideline we boost us more, such as which tables to work with and so on.

Thanks to all FA contributors
Asghar

what if we modify the payment entry with a field called cheque number?

so we will have Date, Reference, pay to, to the order of, then cheque number.

What do you guys think?