f-9t9it / pos_bahrain Goto Github PK

Let the form fetch wholesale price as per the customer default.

Then fetch standard selling price for the item.

Then custom discount that will calculate the amount based off the % with standard selling price and recalculate the wholesale price.

Item wholesale price fetched from item
Custom field to fetch retail price
Custom discount field to calculate discount amount based on retail price

If custom discount amount is not equal to zero then retail price 7- the discount amount becomes the new wholesale price

So total 3 custom fields

Required to rewrite pos data fetch API method to send only batches that are in stock at the POS Warehouse.

Describe the bug
When clicking the report "Sales Person Item-wise Sales" an error pops "pymysql.err.InternalError: (1054, "Unknown column 'sii.salesman_name' in 'field list'")"
To Reproduce
Steps to reproduce the behavior:

1. Go to : POS BAHRAIN
2. Click on : Sales Person Item-wise Sale
3. See error

Expected behavior
Report to load
Screenshots

Desktop (please complete the following information):

• OS: WIN 10
• Browser Chrome
• Version 88.0.4324.150

Additional context
looks like the script requires an update to custom field pb_sales_employee_name

Cash Amount is the received cash amount

It should be cash Received Less Change amount.

Please update this asap.

• Customer Item-wise Sales - Item Name Missing ??
• Total Also Missing. Add Show total command at the end

An error occurred while installing pos_bahrain: Item Barcode: Field Barcode in row 1 cannot be hidden and mandatory without default
Traceback (most recent call last):
  File "apps/frappe/frappe/commands/site.py", line 416, in install_app
    _install_app(app, verbose=context.verbose, force=force)
  File "apps/frappe/frappe/installer.py", line 296, in install_app
    add_to_installed_apps(name)
  File "apps/frappe/frappe/installer.py", line 324, in add_to_installed_apps
    post_install(rebuild_website)
  File "apps/frappe/frappe/installer.py", line 477, in post_install
    init_singles()
  File "apps/frappe/frappe/installer.py", line 501, in init_singles
    doc.save()
  File "apps/frappe/frappe/model/document.py", line 305, in save
    return self._save(*args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 327, in _save
    return self.insert()
  File "apps/frappe/frappe/model/document.py", line 285, in insert
    self.run_post_save_methods()
  File "apps/frappe/frappe/model/document.py", line 1082, in run_post_save_methods
    self.run_method("on_update")
  File "apps/frappe/frappe/model/document.py", line 914, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1264, in composer
    return composed(self, method, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1246, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "apps/frappe/frappe/model/document.py", line 911, in fn
    return method_object(*args, **kwargs)
  File "apps/pos_bahrain/pos_bahrain/pos_bahrain/doctype/pos_bahrain_settings/pos_bahrain_settings.py", line 22, in on_update
    make_property_setter(
  File "apps/frappe/frappe/custom/doctype/property_setter/property_setter.py", line 64, in make_property_setter
    property_setter.insert()
  File "apps/frappe/frappe/model/document.py", line 285, in insert
    self.run_post_save_methods()
  File "apps/frappe/frappe/model/document.py", line 1082, in run_post_save_methods
    self.run_method("on_update")
  File "apps/frappe/frappe/model/document.py", line 914, in run_method
    out = Document.hook(fn)(self, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1264, in composer
    return composed(self, method, *args, **kwargs)
  File "apps/frappe/frappe/model/document.py", line 1246, in runner
    add_to_return_value(self, fn(self, *args, **kwargs))
  File "apps/frappe/frappe/model/document.py", line 911, in fn
    return method_object(*args, **kwargs)
  File "apps/frappe/frappe/custom/doctype/property_setter/property_setter.py", line 38, in on_update
    validate_fields_for_doctype(self.doc_type)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1037, in validate_fields_for_doctype
    validate_fields(meta)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1458, in validate_fields
    check_hidden_and_mandatory(meta.get("name"), d)
  File "apps/frappe/frappe/core/doctype/doctype/doctype.py", line 1131, in check_hidden_and_mandatory
    frappe.throw(
  File "apps/frappe/frappe/__init__.py", line 526, in throw
    msgprint(
  File "apps/frappe/frappe/__init__.py", line 494, in msgprint
    _raise_exception()
  File "apps/frappe/frappe/__init__.py", line 443, in _raise_exception
    raise raise_exception(msg)
frappe.core.doctype.doctype.doctype.HiddenAndMandatoryWithoutDefaultError: Item Barcode: Field Barcode in row 1 cannot be hidden and mandatory without default

ERPNext: v14.27.9
Frappe Framework: v14.40.0
Pos Bahrain: v0.4.4

POS Return returning cash amount by default.

When we make pos return and want to give the customer Store credit , but when we raise pos return it show full negative stock as paid by cash.

This is due to the any negative value is by default as default mode of payment.

Use Case:
If user removes all the amount from the mode of payment when submitting pos return then it should go to customer credit balance (Store credit)

Add script to fetch Selling Rate for Items in Purchase Receipt and Stock Entry.

Disable Print from POS When Invoice is in draft.

Describe the bug

Sales Register with Employee throws the error "StopIteration"

Screenshots

1. Not able to generate Credit Note Against Sales Return, if customer returns item
2. Advance paid by customer need to adjust in mode of payments.
3. Loyalty Points is Missing

Error Row 1 with ITEM has only 0, EVEN THOUGH STOCK ARE PRESENT

Is it possible to link Payment Request to a POS Sales Invoice or to create a Sales Order from a POS Invoice in Draft?

Some sales are paid by link.

Text in message to be corrected.

• InternalError: (1054, u"Unknown column 'sii.salesman' in 'field list'")

• add Date Range in Print
• Printed on Date
• Add Show Total

• Columns

Grand Total
Discount
Return
Net Total
MOP Amounts

This will be helpful in POS sales Process.

We should have a Toggle Checkbox in setting to enable this. This will make every invoice from POS printed by default directly when submit is pressed.

Add logic in POS to handle batch selection accurately and pass it to sales invoice.

Write access to any user is not feasible.

Either remove the Write Off field from POS payment screen or make it un-editable.

Fetch item number directly in JS using Material Receipt/Purchase receipt Item selection. When Creating new batch from the item row batch field
Check this commit, we need exact same in Purchase Invoice also

Describe the bug
"Item-wise Sales Register with Employee" throws the error "ValueError: too many values to unpack (expected 2)"

Screenshots

Enhancement of Opening cash and Closing Cash Voucher.

Currently Opening Cash is mandatory to raise closing Cash voucher. - that is fine. but if user forgot to do opening cash then closing cash is stuck in error loop.

Closing cash voucher to have time cutoff. Example: Opening cash date time to closing cash date time.

next closing cash voucher should not pull the sales between the previous duration range.