Skip ke Konten
Odoo Menu
  • Login
  • Uji coba gratis
  • Aplikasi
    Keuangan
    • Akuntansi
    • Faktur
    • Pengeluaran
    • Spreadsheet (BI)
    • Dokumen
    • Tanda Tangan
    Sales
    • CRM
    • Sales
    • POS Toko
    • POS Restoran
    • Langganan
    • Rental
    Website
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Rantai Pasokan
    • Inventaris
    • Manufaktur
    • PLM
    • Purchase
    • Maintenance
    • Kualitas
    Sumber Daya Manusia
    • Karyawan
    • Rekrutmen
    • Cuti
    • Appraisal
    • Referensi
    • Armada
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Acara
    • Otomatisasi Marketing
    • Survei
    Layanan
    • Project
    • Timesheet
    • Layanan Lapangan
    • Meja Bantuan
    • Planning
    • Appointment
    Produktivitas
    • Discuss
    • Approval
    • IoT
    • VoIP
    • Pengetahuan
    • WhatsApp
    Aplikasi pihak ketiga Odoo Studio Platform Odoo Cloud
  • Industri-Industri
    Retail
    • Toko Buku
    • Toko Baju
    • Toko Furnitur
    • Toko Kelontong
    • Toko Hardware
    • Toko Mainan
    Makanan & Hospitality
    • Bar dan Pub
    • Restoran
    • Fast Food
    • Rumah Tamu
    • Distributor Minuman
    • Hotel
    Real Estate
    • Agensi Real Estate
    • Firma Arsitektur
    • Konstruksi
    • Estate Management
    • Perkebunan
    • Asosiasi Pemilik Properti
    Konsultansi
    • Firma Akuntansi
    • Mitra Odoo
    • Agensi Marketing
    • Firma huku
    • Talent Acquisition
    • Audit & Sertifikasi
    Manufaktur
    • Tekstil
    • Logam
    • Perabotan
    • Makanan
    • Brewery
    • Corporate Gift
    Kesehatan & Fitness
    • Sports Club
    • Toko Kacamata
    • Fitness Center
    • Wellness Practitioners
    • Farmasi
    • Salon Rambut
    Perdagangan
    • Handyman
    • IT Hardware & Support
    • Sistem-Sistem Energi Surya
    • Pembuat Sepatu
    • Cleaning Service
    • Layanan HVAC
    Lainnya
    • Organisasi Nirlaba
    • Agen Lingkungan
    • Rental Billboard
    • Fotografi
    • Penyewaan Sepeda
    • Reseller Software
    Browse semua Industri
  • Komunitas
    Belajar
    • Tutorial-tutorial
    • Dokumentasi
    • Sertifikasi
    • Pelatihan
    • Blog
    • Podcast
    Empower Education
    • Program Edukasi
    • Game Bisnis 'Scale Up!'
    • Kunjungi Odoo
    Dapatkan Softwarenya
    • Download
    • Bandingkan Edisi
    • Daftar Rilis
    Kolaborasi
    • Github
    • Forum
    • Acara
    • Terjemahan
    • Menjadi Partner
    • Layanan untuk Partner
    • Daftarkan perusahaan Akuntansi Anda.
    Dapatkan Layanan
    • Temukan Mitra
    • Temukan Akuntan
    • Temui penasihat
    • Layanan Implementasi
    • Referensi Pelanggan
    • Bantuan
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dapatkan demo
  • Harga
  • Bantuan

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Akuntansi
  • Inventaris
  • PoS
  • Project
  • MRP
All apps
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Anda harus terdaftar untuk dapat berinteraksi di komunitas.
Semua Post Orang Lencana-Lencana
Label (Lihat semua)
odoo accounting v14 pos v15
Mengenai forum ini
Help

[SOLVED] Multiple invoice sequence

Langganan

Dapatkan notifikasi saat terdapat aktivitas pada post ini

Pertanyaan ini telah diberikan tanda
sequenceinvoicingopenerp7sequencenumberodooV8
2 Replies
13332 Tampilan
Avatar
Jorge

A new fiscal law in our country (Honduras) was just published, this law states a new standard in invoice numbering. This new number is formed by:

XXX-YYY-ZZ-NNNNNNNN

  • X is the store/branch number

  • Y is a code given by the fiscal people

  • Z is the document type (In this case 01 means invoice)

  • N is the invoice number (Only moving number,  auto increment)


The result is an invoice with this number: 000-001-01-00000004

When you only have one store, it's easy because you configure your sales journal sequence prefix to '000-001-01-' and fill for 8 digits.

The problem starts when you have more than 1 store, because you have to have 000-YYY-ZZ-NNNNNNNN, 001-YYY-ZZ-NNNNNNNN, 003-YYY-ZZ-NNNNNNNN and so on

The other problem is that each store should have its own incremental number. Example:

Store 1
Store 2
Store 3
000-001-01-00000001
001-001-01-00000001
002-001-01-00000001
000-001-01-00000002
001-001-01-00000002
002-001-01-00000002

001-001-01-00000003
002-001-01-00000003

001-001-01-00000004

This can be taken as multi company, but the accounting for all 3 stores should be reflected under the same company and same Sales Journal.

So basically what i'm trying to figure out is:

  1. Setup multiple sequences for multiple stores.

  2. This sequences should be independent from each other, as shown in the tables above.

  3. There must be a way to choose which store is selling to select the correct sequence. (Dropdown menu in Draft Invoice maybe?)

  4. I need to implement this in Odoo 8 and OpenERP 7

I hope i'm making myself clear, if not please ask! Thanks!

Update:

  1. I created a model called x_punto_emision (store) that has a many2one relation to ir.sequence and a char field to store the name of the store. (http://i.imgur.com/eVromry.png)

  2. I added a selection widget in account.invoice.form so that the user can select the store in the draft invoice: (http://i.imgur.com/FqClLi2.png?1)

<field name="x_punto_emision" widget="selection" attrs="{'readonly': ['|',('state','not in',('draft',)), ('type','&lt;&gt;','out_invoice')]}"/> 

      3.  Then I created two fields in the account.invoice model, a many2one with x_punto_emision (the selected store) and a             x_numero_impresion (the invoice number that the ir.sequence should give based on the selected store)

After this setup, I created 2 Sequences (http://i.imgur.com/GRQtC0Q.png) and 2 Stores  (http://i.imgur.com/vSQrfQz.png). 

I need help connecting everything together, when the user validates the invoice, the system should take the next number in the sequence of x_punto_emision and stores it in x_numero_impresion.

Any ideas on how to do this? Thanks again!


1
Avatar
Buang
Leonardo Donelli

Rui! Thanks a lot! That solved my problem! I can't mark question as answer because of lack of karma points. :S

Avatar
Rui Franco
Jawaban Terbai

Your problem seems to be the fact that you want to use the same sales journal. Should you chose to ignore such requirement, the overall process becomes an easy thing.

Since journals are associated to sequences, when you create an invoice, you can chose the sequence to use by selecting a different journal. Create as many sales journals as stores (as well as sequences: 1 store < 1 sequence), and there you go!

3
Avatar
Buang
Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar
Post Terkait Replies Tampilan Aktivitas
Invoice Sequence ifo POS
sequence invoicing journals sequencenumber odoo16features
Avatar
0
Jun 23
2563
Apply a sequence for a field
sequencenumber odooV8
Avatar
Avatar
2
Sep 23
10274
The invoice number(First number) no longer exists for me when create a invoice. How can I get it back?
invoicing sequencenumber
Avatar
0
Apr 22
2394
How to change the Quotation, Order, Invoice sequence numbers ? Diselesaikan
sequence sequencenumber
Avatar
Avatar
Avatar
2
Des 23
30164
Can we work on the same machine on openerp7 and odoo8 Diselesaikan
openerp7 odooV8
Avatar
Avatar
Avatar
3
Agu 15
4297
Komunitas
  • Tutorial-tutorial
  • Dokumentasi
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Terjemahan
Layanan
  • Odoo.sh Hosting
  • Bantuan
  • Peningkatan
  • Custom Development
  • Pendidikan
  • Temukan Akuntan
  • Temukan Mitra
  • Menjadi Partner
Tentang Kami
  • Perusahaan kami
  • Aset Merek
  • Hubungi kami
  • Tugas
  • Acara
  • Podcast
  • Blog
  • Pelanggan
  • Hukum • Privasi
  • Keamanan
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo adalah rangkaian aplikasi bisnis open source yang mencakup semua kebutuhan perusahaan Anda: CRM, eCommerce, akuntansi, inventaris, point of sale, manajemen project, dan seterusnya.

Mudah digunakan dan terintegrasi penuh pada saat yang sama adalah value proposition unik Odoo.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now