• From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Topic: How to change old items to use bar-code instead of Item Code.

I wanted to use barcode for all of the items in the accounting system. Therefore I have made the following change: In Company Setup I have enabled "Use Barcodes on Stocks"

Now the Item Code field accepts barcode for the new Items only. So how to add a barcode instead of the old Item Code for all of the old items.

Would you please advice?

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: How to change old items to use bar-code instead of Item Code.

for old items, you can't add it easily, because those item codes are being used in different tables like stock moves. grn_items, sales order details, debtor trans details, supp trans details and so on. like that. its hard to make change it for existing items. Maybe you can do one separate program to search all the tables in the database and  replace with new code.  But this requires php , mysql programming skills to do this.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: How to change old items to use bar-code instead of Item Code.

Thank you for your reply

In fact, I don't have a problem with working on the database, I have good experience but I need the database relationship diagram to find out the related tables, in order to change the Item Code using SQL statement.

I think the database designer should have added an independent indexed field for the barcode where it's not a primary key, this way it will be easy even to change the item barcode without effecting the whole table or other tables in the database.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: How to change old items to use bar-code instead of Item Code.

The following Wiki pages have the DB's ERDs:
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram24

BarCode dev info:
https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage

apmuthu's Website

  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: How to change old items to use bar-code instead of Item Code.

Thank you very much.
This is really useful information

  • From: Oman, Muscat
  • Registered: 10/10/2020
  • Posts: 39

Re: How to change old items to use bar-code instead of Item Code.

This modification is not required for the version 2.4.9 as its already there

BarCode dev info:
https://frontaccounting.com/fawiki/index.php?n=Devel.BarCodeUsage

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: How to change old items to use bar-code instead of Item Code.

said.omn wrote:

Thank you for your reply

In fact, I don't have a problem with working on the database, I have good experience but I need the database relationship diagram to find out the related tables, in order to change the Item Code using SQL statement.

I think the database designer should have added an independent indexed field for the barcode where it's not a primary key, this way it will be easy even to change the item barcode without effecting the whole table or other tables in the database.

@said.omn  you are right,  it's good to keep the barcode separate instead of item code.

@Joe shall we consider this change for the next update. So the barcode will be helpful to have second code for items.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: How to change old items to use bar-code instead of Item Code.

Will consider this.

Joe

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: How to change old items to use bar-code instead of Item Code.

said.omn wrote:

Thank you for your reply

In fact, I don't have a problem with working on the database, I have good experience but I need the database relationship diagram to find out the related tables, in order to change the Item Code using SQL statement.

I think the database designer should have added an independent indexed field for the barcode where it's not a primary key, this way it will be easy even to change the item barcode without effecting the whole table or other tables in the database.

Good Suggestion

www.boxygen.pk

boxygen's Website