I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
It means can i combine both parent and child template in one file or there exist template with name 'All Template'. If yes where is the 'All Template' is locate in the system.
Thanks and Regards
Rohit
On Thu, Sep 12, 2013 at 1:52 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Rohit,
You must import parent and child together (using the All template). - the message is quite clear.
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
After selecting a doctype which has child, you will find a section called "All Tables (Main + Child Tables)". This template is to import both parent and children together.
On 12-Sep-2013, at 3:38 PM, Rohit Waghchaure wrote:
Hi Rushabh,
It means can i combine both parent and child template in one file or there exist template with name 'All Template'. If yes where is the 'All Template' is locate in the system.
Thanks and Regards
Rohit
On Thu, Sep 12, 2013 at 1:52 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Rohit,
You must import parent and child together (using the All template). - the message is quite clear.
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Thank you, the problem is due to non update version. After updates I got the template.
Thanks and Regards
Rohit
On Thu, Sep 12, 2013 at 3:45 PM, Nabin Hait <na...@gmail.com> wrote:
After selecting a doctype which has child, you will find a section called "All Tables (Main + Child Tables)". This template is to import both parent and children together.
On 12-Sep-2013, at 3:38 PM, Rohit Waghchaure wrote:
Hi Rushabh,
It means can i combine both parent and child template in one file or there exist template with name 'All Template'. If yes where is the 'All Template' is locate in the system.
Thanks and Regards
Rohit
On Thu, Sep 12, 2013 at 1:52 PM, Rushabh Mehta <rm...@gmail.com> wrote:
Rohit,
You must import parent and child together (using the All template). - the message is quite clear.
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
I found there is no "Sales Invoice" in data import. But I want to migrate my invoice to ERPnext, is it a bug or building feature for importing sales invoices?
Thank you so much in advance.
Adam
Rohit Waghchaure於 2013年9月12日星期四UTC+8下午3時07分47秒寫道:
Hi all,
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
Sales Invoices are importable in the latest release.
On Thursday, November 21, 2013 8:47:22 AM UTC+5:30, Adam Tong wrote:
I found there is no "Sales Invoice" in data import. But I want to migrate my invoice to ERPnext, is it a bug or building feature for importing sales invoices?
Thank you so much in advance.
Adam
Rohit Waghchaure於 2013年9月12日星期四UTC+8下午3時07分47秒寫道:
Hi all,
I have to import bulk Sales Invoice data through application.
For that i have given 'Allow Import' permission to Sales Invoice doctype
In data Import tool, i have download sales invoice and sales invoice item template.
I have added records in sales invoice template to create a sales invoice(parent) and saved in csv format
At the time of uploading i got an error message "Error: Data missing in table: Sales Invoice Items"
On console i got following error
Traceback (innermost last):
File "../lib/core/page/data_import_tool/data_import_tool.py", line 232, in upload
ret.append(import_doc(d, doctype, overwrite, row_idx, params.get("_submit")))
File "../lib/webnotes/utils/datautils.py", line 164, in import_doc
bean.insert()
File "../lib/webnotes/model/bean.py", line 299, in insert
return self.save()
File "../lib/webnotes/model/bean.py", line 311, in save
self.check_mandatory()
File "../lib/webnotes/model/bean.py", line 399, in check_mandatory
raise webnotes.MandatoryError, ", ".join([fieldname for msg, fieldname in missing])
MandatoryError: entries
For your reference i have attached csv file here with. Please give me solution on it.
Thanks and regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.