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.

2021-02-13T06:55:37Z

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.

2021-02-09T10:19:03Z

Will consider this.

Joe

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

2021-02-09T03:01:25Z

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.

2021-02-08T15:01:54Z

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.

2021-02-08T14:54:00Z

Thank you very much.
This is really useful information

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

2021-02-08T13:55:07Z

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.

2021-02-08T06:06:28Z

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.

2021-02-07T17:31:04Z

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.

2021-02-07T15:02:31Z

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?