Pos3/5/FNB: Error with duplicated Barcode or Alternate Code

From AutoCount Resource Center
Revision as of 04:06, 30 September 2021 by PeterT (talk | contribs) (Created page with "<u><b>Question :</b></u> In Find Stock Item screen, when Search with keyword (11111) don’t get any duplicated itemcode/alternate code. File:000247-a.png But when I tr...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Question :

In Find Stock Item screen, when Search with keyword (11111) don’t get any duplicated itemcode/alternate code.

000247-a.png

But when I try to save a new item code, system prompts error.

There are more than one UOM use the same Barcode or Alternate Code XXX(11111) at ItemCode XXX(000001).

000247-b.png


Possible Reason :

User may have imported AutoCount older version (1.5/1.6/1.8/1.9) Item Code to AutoCount 2.0 or POS 5.0 Backend, which the database may have problem prior to it (such as with empty UOM).


Solution :

1. Do backup for your account book.

https://wiki.autocountsoft.com/wiki/Backup


2. Go to open AutoCount Management Studio under Windows Start Menu > AutoCount POS 5.0

000247-c.png


3. Go to Tools > SQL Query.

000247-d.png


4. Click Yes. (Note As a software vender, we WILL NOT take any RESPONSIBILITY if you use the SQL Query tools without our supervision)

000247-e.png


5. Enter the statement (Select * from ItemSubCode) > highlight it > Execute. Check at UOM column to see is there any empty value, if Yes all those Sub Code & Item Code need to be removed from list.

000247-f.png


6. Enter the statement (delete from ItemSubCode where UOM = 'b' ) > highlight it > Execute.

000247-g.png


7.You can go to save your item already.


By: CK 20210906, Jacky 20210921, P210927 [000247]


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations