Community mailing list archives

community@mail.odoo.com

Re: Payment Document: sequence based on Document Type, not based on Journal. WDYT? (v8)

by
Ecosoft Co. LTD, Kitti Upariphutthiphong
- 02/25/2016 01:09:04
Hi I have done something here as "doctype_sequence".


Make sense?
Kitti

On Wed, Feb 24, 2016 at 5:31 PM, Houssine BAKKALI <houssine.bakkali@gmail.com> wrote:
One journal per bank account but I didn't read well on my smartphone that this was already the case on the example you described.

Neither I've understood that you were registring the payment from the supplier/customer invoice itself... 

2016-02-24 10:38 GMT+01:00 Kitti U. <kittiu@ecosoft.co.th>:
@Houssine,

You mean one Journal per Payment Method (journal)? (or per Bank Acocunt?)

I am not sure what you means. And how would that solve problem of us wanting to use same sequence of Customer Payment regardless of selected Payment Method?

On Wed, Feb 24, 2016 at 3:45 PM, Kitti U. <kittiu@ecosoft.co.th> wrote:
Yes, I will write the new document into the journal entry, think of write it to field "ref", but still not sure

On Wed, Feb 24, 2016 at 3:27 PM, Dominique KON SUN TACK <dominique.k@elico-corp.com.sg> wrote:

Will you still be able to find a voucher from the journal entry ?

On 24 Feb, 2016 12:18 pm, "Kitti U." <kittiu@ecosoft.co.th> wrote:
Dear community,

For customer payment and supplier payment. I wonder if there is any module that change behavior from having Number based on sequence in "Journal" to based on "Document type", i.e., Customer Payment or Supplier Payment.

We think sequence based on Document Type is the better practice for ERP, but as Journal is the core of Odoo, this is not happening now.

Current Behavior
=============

In Customer Payment and Supplier Payment, the document sequence will run by selected Journal (payment method). This result in some problem if there are many payment methods to select, and we will not have same series of Payment numbering.

For example,

  • In Customer Payment
    • If user choose Bank-A, and validate payment, number will be the sequence of Journal Bank-A, i..e, BNKA-0001
    • If user choose Bank-B, and validate payment, number will be the sequence of Journal Bank-B, i..e, BNKB-0001
    • While, what we actually need is RCT-001 and RCT-002
  • In Supplier Payment
    • If user choose Bank-A, number will be the sequence of Journal Bank-A, i..e, BNKA-0002 (continue from journal Bank-A)
    • If user choose Bank-B, number will be the sequence of Journal Bank-B, i..e, BNKB-0002 (continue from of journal Bank-B)
    • While, what we actually need is SRCT-001 and SRCT-002
Proposed Solution:
==============

Adding new field "Document Type", i.e., "Customer Payment" or "Supplier Payment" (can be hidden), and tie it with sequence number. This way, no matter what Journal user choose it doesn't matter, document number will be using sequence based on Document Type

Meanwhile, the sequence of Journal should still be used for Journal Enteries (journal entries should have both number, journal number and document number)


What is your opinion about this?
--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th



--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Mobile: +66-(0)8-1841-7480
Your ERP Partner => www.ecosoft.co.th