frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
18.05k stars 6.87k forks source link

POS Not Validating Serial Number at time of Sale #12147

Closed Olawale1 closed 5 years ago

Olawale1 commented 6 years ago

Hi,

The offline POS is not validating serial numbers at the point of sale! Now we have several errors blocking the sync. All those errors refer to duplicate serial numbers as shown below:

"Serial number 10908xxxxx already referenced in Sales Invoice SINV-xxxxx"

Please fix urgently

Thanks

rohitwaghchaure commented 6 years ago

Hi @Olawale1

To fix this issue, kindly remove the sales invoice from the serial no 10908xxxxx. I am trying to replicate this issue on local account but not able to replicate it. I did following steps

  1. Created sales invoice from the offline POS for the serial no ABC00010

  2. Tried to add serial no ABC00010 again in the new sales invoice but not able to add it because it's already delivered

Can you please share steps to replicate the issue

Olawale1 commented 6 years ago

Hi @rohitwaghchaure

Thanks for your response. Steps to replicate

  1. Create sales invoice from the offline POS for the serial no ABC00010
  2. Immediately click on 'reload' option under menu (while the sales invoice is still in customer queue)
  3. Select a new Customer and add serial no ABC00010 again in the new sales invoice

Both invoices will now appear in the queue. One will get synced while the other gives errors as described above

Thanks

Olawale1 commented 6 years ago

Hi @rohitwaghchaure

Trust you're doing great. Any update on this issue please?

Thanks

jaichavan commented 5 years ago

Hello, in the latest version [ v11.0.3-beta.34 () (staging) ], there is no such issue, that I could replicate.. The system doesn't let you fetch the serial number that has already been used in the sales invoice (through Offline POS) Attaching screenshots from my test account for your reference:

  1. POS Invoice for an item with serial number IRL_BH1750_LIM000032 :

image

Item Serial Number whose invoice is made via POS - IRL_BH1750_LIM000032

image

  1. When I clicked on Reload and tried to create another Sales Invoice, and creating new invoice, then it's not allowing to fetch same serial number, as below:

image

Hope this helps. Thanks for reporting!!