Invoicing Solution - How do i change the "PRODUCT ID's" to my own codes on invoices

[user1234qwerty]

How do i change what the product code is on Invoicing Solution ? At the moment it uses its own Product ID to the products i enter to make an invoice eg,

I need to change PROD000012 to say R43

I have a catlogue that need inputting into File Maker with its own codes, descriptions and prices. When i create a new product file Invoicing Solution gives it a Product ID eg, PROD000012 (I need to change this to R43)

So i can search for products by the correct code.

[ThatOneGuy]

Hi user1234qwerty:

You'll have fewer headaches if you don't change the ID-numbering scheme. Instead, create a field in the Products table where you can put in your own product codes.

I'm not familiar with the Invoicing Solution you're using, but it is probably complex. If you change the ID-numbering, you'll probably start a "domino effect" that would break the links to related records. A file's underlying structure is often delicate.

Having your own Product Code field will let you search for those codes. You'll need to put the new field on any layouts where you want to view or search it.