Default Barcode Setting


A

Alex

Need to have the option to be able to set a default Barcode (type) so we
don't have to set this everytime we create a new item.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/Businessso...d30-a468-ca9514f99d3b&dg=microsoft.public.pos
 
Ad

Advertisements

A

Akber Alwani

Hi Alex, it akber again,
I have already posted this and again posting for you.
you can create the database level trigger to accomplish this

CREATE TRIGGER UpdBarcode ON Item
FOR INSERT
AS

UPDATE Item SET Barcodeformat= 3
FROM Item INNER JOIN Inserted ON Item.ID= Inserted.ID

in the above line you can give any element of format I given 3 which is the
3rd list item of drop down of barcode i.e. 3 of 9 (don't count NONE becuase
it is by default zero value as barcodeformat field)

I hope you know how to do this. please rate this.
 
A

Alex

Thanks Akber I appreciate the help. This was a suggestion to enhance RMS. I
think most people (for good reasons) would like to stay away from adding
database triggers and doing behind the scenes modifications to avoid any
potential (future) conflicts.

From what I have seen most everybody consistently uses the same barcode type
as well as for example the same item taxes. So if we can default any
respective settings/fields this would be great and save time and avoid
mistakes. I know you can set a default tax for items so why not apply this
to Barcode Type and other fields as well?

P.S. Why do you request your post to be rated, and how do we rate you?
 
P

Point of Sale [MSFT]

Thank you for your suggestion on default barcode types. We are considering this for future versions.

This posting is provided "AS IS" with no warranties, and confers no rights.

<Alex> wrote:


Need to have the option to be able to set a default Barcode (type) so we
don't have to set this everytime we create a new item.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/Businessso...d30-a468-ca9514f99d3b&dg=microsoft.public.pos
 
A

Andrew

Hi. I have SQL express on the machine to manage the DB we have here and I
have the default barcodeformat = "8" (Code128).

However I cannot get the SQL query to run. Please let me know if you can
get me some more help.

-Andrew
 
Ad

Advertisements

R

Ryan Faught

Akber et al,

Just what I needed, however, how do I 'update' / 'change' the trigger as
you've set out below.

You will have to forgive me, I know what triggers are but I do not know
my way around SQL (yet).

In short, I would like to amend an already created trigger. I would
like to change:

UPDATE Item SET Barcodeformat=3
UPDATE Item SET Barcodeformat=6 (for 128A)

Cheers.

Ryan
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top