how to do business cash loan or bank loan in IDempiere?
333 views
Skip to first unread message
Hiep Lq
Nov 1, 2013, 5:09:24 AM11/1/13
to idem...@googlegroups.com
I don't find any window or document about cash loan or bank loan transaction.
when company borrow cash from business partner or from bank.
how to I process it in system.
please guide me a step by step. I can make form, window to finish it.
Many thanks for advice.
Naim Berisha
Nov 1, 2013, 9:16:52 AM11/1/13
to idem...@googlegroups.com
Hi,
No loan management functionality actually exist .
But you can use GL Journal for this purpose.
Although it is manual work.
Regards,
Naim
Thomas Bayen
Nov 1, 2013, 10:27:12 AM11/1/13
to idem...@googlegroups.com
Hi!
I am just creating a workflow for loans in my company. We give loans to
customers and I needed a system for that. Up to now it is only a kind of
systematic workflow and no plugin or such. Ask me later...
The easiest way without touching code for you is to create an new
account (accounting element in the accounting schema window) for your
loan. Then you create a charge for that.
Then you can create an "Invoice" (if you want you can create a new
document type derived from Invoice to separate them) document for your
loan. This invoice has no product but only a line with the charge you
created. With this invoice you can assign the payment that you create
from your Bank Statement.
Then you can create a "Credit Memo" (or a new document type...) for your
monthly payment. There is a Scheduler to copy this document every month.
So you see this document in your "open items" list when it is due.
If you have more than one loan you can create different accounts and
different charges. If you have _very much_ loans (like me) you should
use a kind of accounting dimension to differentiate them. Ask me if you
need more information about that.
The pro of using an Invoice/Credit memo and not accounting directly
through a journal is that you have everything going through your open
items. You see the due payments and do not forget them. The second pro
is that you can get reports of your document types if you want more
information about this later.
regards,
Thomas Bayen
> --
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
--
Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
I am just creating a workflow for loans in my company. We give loans to
customers and I needed a system for that. Up to now it is only a kind of
systematic workflow and no plugin or such. Ask me later...
The easiest way without touching code for you is to create an new
account (accounting element in the accounting schema window) for your
loan. Then you create a charge for that.
Then you can create an "Invoice" (if you want you can create a new
document type derived from Invoice to separate them) document for your
loan. This invoice has no product but only a line with the charge you
created. With this invoice you can assign the payment that you create
from your Bank Statement.
Then you can create a "Credit Memo" (or a new document type...) for your
monthly payment. There is a Scheduler to copy this document every month.
So you see this document in your "open items" list when it is due.
If you have more than one loan you can create different accounts and
different charges. If you have _very much_ loans (like me) you should
use a kind of accounting dimension to differentiate them. Ask me if you
need more information about that.
The pro of using an Invoice/Credit memo and not accounting directly
through a journal is that you have everything going through your open
items. You see the due payments and do not forget them. The second pro
is that you can get reports of your document types if you want more
information about this later.
regards,
Thomas Bayen
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
--
Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
Hiep Lq
Nov 1, 2013, 11:59:34 AM11/1/13
to idem...@googlegroups.com
I think about ap credit memo and ar credit memo but i don't know how to use they.
I will study your guideline carefully. I see it is very detail.
about dimension account. anyway i also want it. I have requested it here https://groups.google.com/forum/#!topic/idempiere/0pRG8G4GD5k
because, please kind to share me with your know-how.
I also want make a form for easy loan. anyone can make business requirement, i can implement and test it.
armenrz
Nov 2, 2013, 5:33:28 AM11/2/13
to idem...@googlegroups.com
You can also raise an invoice with payment schedule, let's say, with monthly schedule.
The aging report is clever enough to separate all the due dates.
Best regards,
Armen Rizal
Goodwill.co.id
The aging report is clever enough to separate all the due dates.
Best regards,
Armen Rizal
Goodwill.co.id
Hiep Lq
Nov 2, 2013, 11:11:40 AM11/2/13
to idem...@googlegroups.com
I success test as your guideline.
many thanks. can you share me "how to make account dimension?"
HI Armenrz.
I also like your method. I want confirm a bit about step.
1. make a invoice + payment as Thomas method
2. immediately make and complete a invoice with a payment schedule. and tracking payment for this invoice.
Thomas Bayen
Nov 3, 2013, 10:30:35 AM11/3/13
to idem...@googlegroups.com
Hie Hiep,
Am 02.11.2013 16:11, schrieb Hiep Lq:
>
> Hi Thomas.
> I success test as your guideline.
> many thanks. can you share me "how to make account dimension?"
I am in the process of implementing this. In three months I can tell you
if all of my thoughts do work. Today please decide carefully yourself
which of my words you trust. :-)
I used the "UserElement1" facility for that. There are different types
of accounting dimensions. Every one has its own specialities. I tried to
research that and up to now I collected the results (in german) on
http://wiki.idempiere.org/de/Buchf%C3%BChrungsdimensionen
I would like if someone would translate that to english and extend it. I
am sure I did not get all accounting consequences of every kind of
dimension.
The first and best dimension to do your own extensions is the "Activity"
because it has not much specialties implemented. I got this
recommendation from Carlos so you can see it as a good rule. ;-)
In my case I had already used Activities and needed a second one. I
choosed UserElement1 for that. Partly I choosed it because there are no
specialties at all and (I have to admit) partly because it was just an
interesting challenge to implement it this way...
For the UserElement1 to work you have to do in short four things:
* Activate the Dimension and connect it with a primary key field (e.g.
"HIEP_Loans_ID") of your table.
* Change the type of the UserElement1_ID column in the accounting fact
table (and views) to "table" and create a reference to your HIEP_Loan
table. (this makes reports look better)
* Create a HIEP_Loans_ID column in every document type you want to use
(invoice, payment, etc.)
* Take care that the HIEP_Loans_ID column in the documents are filled.
The last part is the hardest and might need coding. Many documents are
created from processes and you have no influence on every field. If you
create a Payment from a BankStatement where you have already an
Reference to an Invoice there is a process that creates the Payment from
the Invoice. This process does not copy the UserElement1.
I have to change that. I am not sure if this should be called a bug in
the core or if my use case is so special that I just have to write my
own processes for that.
Depending on your accounting report needs it can be important or not to
have the value copied. I need to copy it because for calculation of
interest I need the date of the payment not of the invoice.
I hope this thoughts help you. I would be glad to go on further on a
wiki page with that to collect all thoughts about the problem and create
a helpful document for others.
> HI Armenrz.
> I also like your method. I want confirm a bit about step.
>
> 1. make a invoice + payment as Thomas method
> 2. immediately make and complete a invoice with a payment schedule. and
> tracking payment for this invoice.
>
>
> On Saturday, November 2, 2013 4:33:28 PM UTC+7, armenrz wrote:
>
> You can also raise an invoice with payment schedule, let's say, with
> monthly schedule.
> The aging report is clever enough to separate all the due dates.
I thought about this first. My problem with this approach is that you
can not change the invcoice document later. E.g. you can not raise later
the loaned sum (but have to create a new document). And you can not
assign interests. You have to create also a new document for interest.
But if your loan contract sais that you do not pay the interest in one
turn (but included in your "fixed size" monthly payment) it will be not
so easy to assign and follow your payments.
So this approach may be a second way or good for a combination but this
needs some more thoughts.
(Sorry if I did not get the correct english business terms...) ;)
> Best regards,
>
> Armen Rizal
> Goodwill.co.id <http://Goodwill.co.id>
> <https://groups.google.com/groups/opt_out>.
Thomas Bayen
Am 02.11.2013 16:11, schrieb Hiep Lq:
>
> Hi Thomas.
> I success test as your guideline.
> many thanks. can you share me "how to make account dimension?"
if all of my thoughts do work. Today please decide carefully yourself
which of my words you trust. :-)
I used the "UserElement1" facility for that. There are different types
of accounting dimensions. Every one has its own specialities. I tried to
research that and up to now I collected the results (in german) on
http://wiki.idempiere.org/de/Buchf%C3%BChrungsdimensionen
I would like if someone would translate that to english and extend it. I
am sure I did not get all accounting consequences of every kind of
dimension.
The first and best dimension to do your own extensions is the "Activity"
because it has not much specialties implemented. I got this
recommendation from Carlos so you can see it as a good rule. ;-)
In my case I had already used Activities and needed a second one. I
choosed UserElement1 for that. Partly I choosed it because there are no
specialties at all and (I have to admit) partly because it was just an
interesting challenge to implement it this way...
For the UserElement1 to work you have to do in short four things:
* Activate the Dimension and connect it with a primary key field (e.g.
"HIEP_Loans_ID") of your table.
* Change the type of the UserElement1_ID column in the accounting fact
table (and views) to "table" and create a reference to your HIEP_Loan
table. (this makes reports look better)
* Create a HIEP_Loans_ID column in every document type you want to use
(invoice, payment, etc.)
* Take care that the HIEP_Loans_ID column in the documents are filled.
The last part is the hardest and might need coding. Many documents are
created from processes and you have no influence on every field. If you
create a Payment from a BankStatement where you have already an
Reference to an Invoice there is a process that creates the Payment from
the Invoice. This process does not copy the UserElement1.
I have to change that. I am not sure if this should be called a bug in
the core or if my use case is so special that I just have to write my
own processes for that.
Depending on your accounting report needs it can be important or not to
have the value copied. I need to copy it because for calculation of
interest I need the date of the payment not of the invoice.
I hope this thoughts help you. I would be glad to go on further on a
wiki page with that to collect all thoughts about the problem and create
a helpful document for others.
> HI Armenrz.
> I also like your method. I want confirm a bit about step.
>
> 1. make a invoice + payment as Thomas method
> 2. immediately make and complete a invoice with a payment schedule. and
> tracking payment for this invoice.
>
>
> On Saturday, November 2, 2013 4:33:28 PM UTC+7, armenrz wrote:
>
> You can also raise an invoice with payment schedule, let's say, with
> monthly schedule.
> The aging report is clever enough to separate all the due dates.
can not change the invcoice document later. E.g. you can not raise later
the loaned sum (but have to create a new document). And you can not
assign interests. You have to create also a new document for interest.
But if your loan contract sais that you do not pay the interest in one
turn (but included in your "fixed size" monthly payment) it will be not
so easy to assign and follow your payments.
So this approach may be a second way or good for a combination but this
needs some more thoughts.
(Sorry if I did not get the correct english business terms...) ;)
> Best regards,
>
> Armen Rizal
> Goodwill.co.id <http://Goodwill.co.id>
>
> --
> Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
> AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
>
> --
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
mit freundlichen Gr��en,
> --
> Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
> AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
>
> --
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
Thomas Bayen
Hiep Lq
Nov 6, 2013, 4:04:34 AM11/6/13
to idem...@googlegroups.com
I don't good at english. i also don't absolute understand about how to setup the dimensions.
I still continue study about setup dimension and accounting relate it.
when i can. i will document it.
mit freundlichen Gr��en,
Thomas Bayen
Nov 9, 2013, 10:58:04 AM11/9/13
to idem...@googlegroups.com
Hi Hiep,
i have a woman in my company as a helper which has vietnam sources and
can speak excellent german and english. The problem is she does not know
much about software... But perhaps I can spend this "resource" to join
forces to create a good documentation about this area in all three
languages if you are kind enough to do it in vietnamese in a way that
normal people understand.
Thomas
> > Goodwill.co.id <http://Goodwill.co.id> <http://Goodwill.co.id>
> > an email to idempiere+...@googlegroups.com <javascript:>.
i have a woman in my company as a helper which has vietnam sources and
can speak excellent german and english. The problem is she does not know
much about software... But perhaps I can spend this "resource" to join
forces to create a good documentation about this area in all three
languages if you are kind enough to do it in vietnamese in a way that
normal people understand.
Thomas
> > For more options, visit https://groups.google.com/groups/opt_out
> <https://groups.google.com/groups/opt_out>.
>
> mit freundlichen Gr��en,
> <https://groups.google.com/groups/opt_out>.
>
>
> Thomas Bayen
> --
> Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
> AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
>
> Thomas Bayen
> --
> Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
> AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
>
> --
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
mit freundlichen Gr��en,
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
Hiep Lq
Nov 9, 2013, 9:45:42 PM11/9/13
to idem...@googlegroups.com
It very good. I will try. when I complete I will sent it for you.
> mit freundlichen Gr��en,
>
> Thomas Bayen
> --
> Jakob Bayen KG, Bleichpfad 20-22, 47799 Krefeld
> AG Krefeld HRA 416 Tel +49/2151/65 80 9-0
>
> --
> You received this message because you are subscribed to the Google
> Groups "iDempiere" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to idempiere+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
mit freundlichen Gr��en,
redhuan d. oon
May 30, 2014, 11:58:13 PM5/30/14
to idem...@googlegroups.com
Hi Hiep and Thomas,
I am also looking at a possible project for Banking Trade Financing System. I like to separate my work so that a reusable set of APIs can be commonly used by others such as:
1. Amortisation engine to retrieve payment installment schedules calculated based on principal and interest formula.
2. Reporting engine for different types of customers
3. DocType management
I would need Thomas more high level thinking in designing the models that fulfill the above.
I am also looking at a possible project for Banking Trade Financing System. I like to separate my work so that a reusable set of APIs can be commonly used by others such as:
1. Amortisation engine to retrieve payment installment schedules calculated based on principal and interest formula.
2. Reporting engine for different types of customers
3. DocType management
I would need Thomas more high level thinking in designing the models that fulfill the above.
> an email to idempiere+unsubscribe@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages