FrontAccounting forum — How to change old items to use bar-code instead of Item Code.

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

null@example.com (boxygen) — Sat, 13 Feb 2021 06:55:37 +0000

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

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

null@example.com (joe) — Tue, 09 Feb 2021 10:19:03 +0000

Will consider this.

Joe

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

null@example.com (kvvaradha) — Tue, 09 Feb 2021 03:01:25 +0000

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.

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

null@example.com (said.omn) — Mon, 08 Feb 2021 15:01:54 +0000

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

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

null@example.com (said.omn) — Mon, 08 Feb 2021 14:54:00 +0000

Thank you very much.
This is really useful information

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

null@example.com (apmuthu) — Mon, 08 Feb 2021 13:55:07 +0000

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

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

null@example.com (said.omn) — Mon, 08 Feb 2021 06:06:28 +0000

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.

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

null@example.com (kvvaradha) — Sun, 07 Feb 2021 17:31:04 +0000

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.

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

null@example.com (said.omn) — Sun, 07 Feb 2021 15:02:31 +0000

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?