Re: Can't have same invoiceID for invoices created in different years

2021-03-17 Thread Eugen Stan
Hi Jacques, Thanks for the link. I've read the documentation and found the entries in ofbiz demo instance. I managed to change the prefix for the invoices. I used to be more creative with invoice series. Now with migration to OFBiz in the works I've channeled my creativity to other fields...

Re: Can't have same invoiceID for invoices created in different years

2021-03-07 Thread Jacques Le Roux
Hi Eugen, Do you mean a sequence by 3rd parties and not only by (OOTB) "company" ? BTW did you read: https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.1+Accounting+Preferences ? Also AFAIK there is no suffix available, but is that really needed when you have a prefix? Jacques Le

Re: Can't have same invoiceID for invoices created in different years

2021-02-22 Thread Eugen Stan
Hi, On 22.02.2021 14:40, Suraj Khurana wrote: Hi Andrie, You can also use prefix in invoice id's to always make them unique, if you want to generate the sequence every year then the current year can be made as InvoiceIdPrefix in PartyAcctgPreference entity. Interesting. Does this mean that

Re: Can't have same invoiceID for invoices created in different years

2021-02-22 Thread Suraj Khurana
Hi Andrie, You can also use prefix in invoice id's to always make them unique, if you want to generate the sequence every year then the current year can be made as InvoiceIdPrefix in PartyAcctgPreference entity. HTH. -- Best Regards, Suraj Khurana Senior Technical Consultant On Mon, Feb 22,

Re: Can't have same invoiceID for invoices created in different years

2021-02-22 Thread Andrei Stan
Hello Aditya, Thank you for the advice, i think is a good idea. Regards, A. On 22.02.2021 07:45, Aditya Sharma wrote: Hi Andrie, Though accounting is not forte, I think you could use the reference number field to store the external invoice id and let the invoiceId be the system's

Re: Can't have same invoiceID for invoices created in different years

2021-02-21 Thread Aditya Sharma
Hi Andrie, Though accounting is not forte, I think you could use the reference number field to store the external invoice id and let the invoiceId be the system's auto-generated value. HTH Thanks and regards, Aditya Sharma On Sun, Feb 21, 2021 at 4:38 PM Andrei Stan wrote: > Hello Michael, >

Re: Can't have same invoiceID for invoices created in different years

2021-02-21 Thread Andrei Stan
Hello Michael, Thank you for reply. Can you suggest any best practices when having multiple invoices and at the end of the (fiscal) year one wishes to reset the invoice counter? Is there an option in ofbiz to do that? Thanks, A. On 21.02.2021 00:28, Michael Brohl wrote: Hi Andrei, if you

Re: Can't have same invoiceID for invoices created in different years

2021-02-20 Thread Michael Brohl
Hi Andrei, if you load data through XML files, there is no application logic in play. It's a plain import to the database. So if you load invoices with the same invoice id (which is the primary key for the invoice table), the second dataset will overwrite the first. The mentioned setting

Can't have same invoiceID for invoices created in different years

2021-02-20 Thread Andrei Stan
Hello everyone, I want to import some of my old invoices into ofbiz, and some of those invoices have the same id, but were created in different time periods, different years. So, for example, i have *EU-1 *created in 2019**and *EU-1 *created in 2020. When importing the xml file with data