bailabs / tailpos-sync

ERPNext App for TailPOS data to Sync to ERPNext

TailPOS Sync

TailPOS ERPNext Sync

License

MIT

tailpos-sync's Issues

Tail Setting

If you are change TailPOS setting to Attendance then we can use multiple ERPNext POS profile

Benefits
We can manage multiple warehouse (Store)
income account
and other setting which is providing ERPNext POS profile

TailPos_Sync Desktop Icon Issue in ERPNext version 12

Tailpos_Sync Module not showing in erpnext version 12

Receipt Showing Multiple Device ID

Receipt Showing Multiple Device ID.

TailPos_Sync randomly selecting at the same time tablet device ID and TailPOS Device profile ID

Fix : Company not found

After Updation Issue is that Company not Found

[CRITICAL] : Cost Center Not effecting whenever making Sales Invoice from TailPOS

Cost Center Not effecting whenever making Sales Invoice from TailPOS

Stock Issue

If not enable negative inventory in Stock Setting getting this error

please fix if there is no stock sales invoice must be "draft"

Fix : Change cash/card setting to device

Kindly change cash/card setting in device because multiple restaurant handling multiple cash-in-hand

here to

there

Fix : Mode of payment Cash/Card

Mode of payment Cash/Card must be debit in they own ledger

example : if make cash transaction in TailPOS cash must be debit in cash ledger

Please link Mode of payment in POS Profile to TailPOS

Error Snapshot : ImportError(u'Module import failed for Remarks Template (tailpos_sync.tailpos_sync.doctype.remarks_template.remarks_template Error: No module named remarks_template.remarks_template)',)

Traceback
Traceback (most recent call last):
File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 61, in application
response = frappe.handler.handle()
File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 21, in handle
data = execute_cmd(cmd)
File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 56, in execute_cmd
return frappe.call(method, **frappe.form_dict)
File "/home/frappe/frappe-bench/apps/frappe/frappe/init.py", line 1036, in call
return fn(*args, **newargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/load.py", line 71, in getdoctype
docs = get_meta_bundle(doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/load.py", line 81, in get_meta_bundle
bundle = [frappe.desk.form.meta.get_meta(doctype)]
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 26, in get_meta
meta = FormMeta(doctype)
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 39, in init
self.load_assets()
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 53, in load_assets
self.load_templates()
File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/form/meta.py", line 178, in load_templates
module = load_doctype_module(self.name)
File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/utils.py", line 192, in load_doctype_module
raise ImportError('Module import failed for {0} ({1})'.format(doctype, module_name + ' Error: ' + str(e)))
ImportError: Module import failed for Remarks Template (tailpos_sync.tailpos_sync.doctype.remarks_template.remarks_template Error: No module named remarks_template.remarks_template)

Pyver
Python 2.7.15rc1: /home/frappe/frappe-bench/env/bin/python (prefix: /home/frappe/frappe-bench/env)

Exception
{
"args": "(u'Module import failed for Remarks Template (tai... module named remarks_template.remarks_template)',)",
"message": "Module import failed for Remarks Template (tai... module named remarks_template.remarks_template)"
}

Locals
{
"app": "u'tailpos_sync'",
"doctype": "u'Remarks Template'",
"e": "ImportError('No module named remarks_template.remarks_template',)",
"key": "(u'tailpos_sync', u'Remarks Template', u'', u'')",
"module": "u'TailPOS Sync'",
"module_name": "u'tailpos_sync.tailpos_sync.doctype.remarks_template.remarks_template'",
"prefix": "u''",
"suffix": "u''"
}

Fix : tailpos_sync.background_jobs.generate_si_from_receipts

tailpos_sync.background_jobs.generate_si_from_receipts

GitBook Documentation: Frappe settings

It was mentioned in syncing-to-frappe-erpnext page to modify frappe/app.py to include make_form_dict function. But isn't that already part of v10 and v11 ? (referencing specific commits from respective branches)

Fix : tailpos_sync.background_jobs.generate_si_from_receipts

Please Check below issue

{'event': None, 'retry': 0, 'log': <function log at 0x7f22a672bf50>, 'site': u'site1.local', 'job_name': u'tailpos_sync.background_jobs.generate_si_from_receipts', 'method_name': 'tailpos_sync.background_jobs.generate_si_from_receipts', 'method': <function generate_si_from_receipts at 0x7f22a66c0398>, 'user': u'Administrator', 'kwargs': {}, 'is_async': True}
Traceback (most recent call last):
File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 103, in execute_job
method(**kwargs)
File "/home/frappe/frappe-bench/apps/tailpos_sync/tailpos_sync/background_jobs.py", line 62, in generate_si_from_receipts
_insert_invoice(si, mop, submit_invoice)
File "/home/frappe/frappe-bench/apps/tailpos_sync/tailpos_sync/background_jobs.py", line 79, in _insert_invoice
invoice.save()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 260, in save
return self._save(*args, **kwargs)
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 295, in _save
self._validate_links()
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 734, in _validate_links
result = d.get_invalid_links(is_submittable=self.meta.is_submittable)
File "/home/frappe/frappe-bench/apps/frappe/frappe/model/base_document.py", line 471, in get_invalid_links
values_to_fetch, as_dict=True)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 491, in get_value
order_by, cache=cache)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 523, in get_values
out = self._get_value_for_many_names(doctype, filters, fieldname, debug=debug)
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 686, in _get_value_for_many_names
% (field, doctype, ", ".join(["%s"]*len(names))), names, debug=debug))
File "/home/frappe/frappe-bench/apps/frappe/frappe/database.py", line 199, in sql
self._cursor.execute(query, values)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 168, in execute
query = self.mogrify(query, args)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 147, in mogrify
query = query % self._escape_args(args, conn)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 122, in _escape_args
return tuple(conn.literal(arg) for arg in args)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 122, in
return tuple(conn.literal(arg) for arg in args)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 469, in literal
return self.escape(obj, self.encoders)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 462, in escape
return converters.escape_item(obj, self.charset, mapping=mapping)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py", line 27, in escape_item
val = encoder(val, mapping)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py", line 118, in escape_unicode
return u"'%s'" % _escape_unicode(value)
File "/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/pymysql/converters.py", line 73, in _escape_unicode
return value.translate(_escape_table)
AttributeError: 'ModeofPayment' object has no attribute 'translate

Fix: Generate Sales Invoice

Generate sales invoice option not working.

Please fix this issue.

In TailPOS not present in Item doctype after installing app

I just installed the tails-sync but I haven't been able to sync items because none of the products has the "In TailPOS" checkbox. Should I create it manually?

To Reproduce
Steps to reproduce the behavior:

1. Disable production enviroment
2. Install app
3. setup production
4. No In TailPOS on Item Doctype

Bug : Testing with version-12

Old database migration error

Duplicate Items in erpnext after syncing

[Proposal] Remarks Template

Motivation
There are times like receipts need to have remarks. For example, the customers of a restaurant request to have their food spicy or not.

Error occured upon installing tailpos_sync

Im actually not sure if this is a bug or there's just something wrong with my existing setup. The traceback below occured when I did the following steps;

ValueError: Document for field "field_order" attached to child table of "Tail Settings" must be a dict or BaseDocument, not class 'str' (generate_invoice)

1. From my erpnext/ directory where apps/ and sites/ resides I run the ff command:

   bench get-app --branch master tailpos-sync https://github.com/bailabs/tailpos-sync.git

2. It created a tailpos_sync/ folder alongside erpnext/. Then i run:

   bench --site jeeves install-app tailpos_sync

Then the above error occured...

Anyone on this? Thanks in advance!