Multi company and the invoices series

ERPNext Accounting
1

Hello;

As we know that each company will have separated Chart of Account.

But the problem that the naming serial for the invoices is not separated, and will cause to have discontinuity for the numbers when there is audit, this is not allowed.

The only way to overcome this is to create new instance for each company but in this case, it will mot be possible to see all companies from one login (session), and will not be able even to use duplicate feature.

So how to resolve this problem?
It is not acceptable to have SINV-00001 and then SINV-00020, the audit will ask where is 2 and 3 and 4 … etc, how did u reach for invoice SINV-00020 directly!!!

There should be a solution for this, otherwise it is not possible to use multi company and multi financial book.

Regards
Bilal

2

I did this before, I create custom field in company for all documents that needs separate naming series like Sales Order, Sales Invoice, Journal Entry ,etc…

image
image1169×304 21.4 KB

And save the new naming series for all of them or each company

Then I have to create all of them in Naming for each company like this:

image
image569×689 33.1 KB

then create custom script for all document like this to select naming based on company :

image
image1016×512 20.4 KB

2 Likes
3

You lost me here.

1 Like
4

@flexy2ky I am sorry, I forget to add one more image:

image
image1169×304 21.4 KB

for example : here I have company called Demo Company so I will take the abbr and add it to naming series JV-DC, For anther company in the same instants called Sky Zone I will create JV-SZ and so on

5

erpnext support putting field value in naming series. So on Sales Invoice DocType, you just need to create a custom field (company_abbr) that fetch value from the abbr field in company doctype. For example, Company A will have abbr as CPA, Company B will have abbr as CPB.
https://erpnext.com/docs/user/manual/en/setting-up/settings/naming-series

The naming series will be company_abbr.SINV.#####. And the document ID will be
CPASINV.00001
CPASINV.00002
CPBSINV.00001
CPBSINV.00002

6

Hi Mohammed

Please guide just further, the custom fields created on the “company form”, what is there type, like ‘link’, ‘data’ or something else.

7

@Jalaj It should be “Data”

8

I used this method and it is by far the most reliable option. company initials are automatically appended to naming series and the numbering is unique to each company.

9

Thanks Mohammed.

10

Hi Mohammed,

Are you able to restrict user for specific series???

11

@Parag_Chatwani if you want to do that you have to create custom fields in User DocType and write the script to fetch the naming series from the user record

13

Hi Mohammed

Thanks for your kind support.
I have configured this Company Wise Naming Series for sales order.
but it went blank, sales order become blank.
Please help.

14

@Jalaj share your code please

16

Hi Mohammed

Please find the code.

frappe.ui.form.on(‘Sales Order’, {
setup: function(frm) {
// your code here
frm.add_fecth(“company”, “sales_order_naming_series”, “naming_series”);
}
})

17

@Jalaj Did you follow all steps I mention in my post (2-4) above?

19

Hi Mohammed

I think I had followed the steps.
Can you kindly explain how these steps, can create this kind of effect?
Please suggest do I need to re-do all this, with some specific sequence.
Once again, thanks a lot for your constant support.

20

Hi Mohammed

I have re-done all the steps in the sequence as you have suggested.
but still the form is blank.
Please suggest further.

21

Can you please share your mobile no. or call me on +91 98676 32366 if you can able to do and assist in the said matter would like to outsource the said work and discuss commercials.

Thanks

Parag Chatwani

22

Can we user Abbr for this?