Sage 100

Hi Rebekah,

Yes, Sage allows the same item/sn combination to exist in multiple warehouses with a quantity. This has always been a thorn in my side. 

Sorry for the bad news!

Karen

Thanks Karen.  Wow, I am surprised as this seems to defeat the purpose of a serial number.  Are you aware if Sage believes this to be a "feature" or a flaw that they are unwilling to fix.  I will need to explain to my client why this valuation method does not perform as expected. 

Hi Rebekah,

Yes, Sage allows the same item/sn combination to exist in multiple warehouses with a quantity. This has always been a thorn in my side. 

Sorry for the bad news!

Karen

Sure! I don't know. All I ever got was 'works as designed'. I suspect that some intense additional programming would be needed and they don't want the challenge. I don't think that there is a business case for a single product having a different serial number just because it's stored in a different warehouse. It makes no sense.

I don't see an entry for this on Ideation90, or on the Sage ideas site. I'm sure that it's out there somewhere and I'm not using the right search words. Or else users gave up. It might be good to add it when you get a minute.

Thanks Karen.  Wow, I am surprised as this seems to defeat the purpose of a serial number.  Are you aware if Sage believes this to be a "feature" or a flaw that they are unwilling to fix.  I will need to explain to my client why this valuation method does not perform as expected. 

Hi Rebekah,

Yes, Sage allows the same item/sn combination to exist in multiple warehouses with a quantity. This has always been a thorn in my side. 

Sorry for the bad news!

Karen

Oh boy!  Everyday, I learn something new.  I never knew this worked this way... sigh... 

@Madeline Stefanou - "I never knew this worked this way" That Sage was lazy or the same serial number in multiple warehouses??

If you think about it, one would expect a vendor to have decent control over their SN process.  And what are the odds that TWO vendors have the same SN for like part you buy under your part number.  It is probably a lot of work for minimal need.  From a manufacturing standpoint, I would hope a company had decent SN controls but who knows.....

@Rebekah Veuger - What was the circumstance how you came across this?

Oh boy!  Everyday, I learn something new.  I never knew this worked this way... sigh... 

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed"). 

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
kolane@asifocus.com
559-448-0900
559-577-4142
http://www.asifocus.com
------------------------------


Original Message:
Sent: 10-25-2024 08:43
From: Madeline Stefanou
Subject: Serialized Item - Qty greater than one allowed if different warehouse. Is this right??

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed"). 

------------------------------
Madeline Stefanou
RKL eSolutions, LLC

I ran into this issue a long time ago and had DSD write custom code for my client.

https://www.dsdinc.com/enhancements/marketplace/products/im-1241-unique-serial-numbers-per-item

------------------------------
Greg Stiles
DSD Business Systems
------------------------------


Original Message:
Sent: 10-25-2024 11:28
From: Karen O'Lane
Subject: Serialized Item - Qty greater than one allowed if different warehouse. Is this right??

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
kolane@asifocus.com
559-448-0900
559-577-4142
http://www.asifocus.com


Original Message:
Sent: 10-25-2024 08:43
From: Madeline Stefanou
Subject: Serialized Item - Qty greater than one allowed if different warehouse. Is this right??

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed"). 

------------------------------
Madeline Stefanou
RKL eSolutions, LLC

@Greg Stiles - Good to know! I need to remember to check DSD for software that fixes dumbass problems in Sage.

@Rebekah Veuger - There you go. Just buy this for your customer. :-)

I ran into this issue a long time ago and had DSD write custom code for my client.

https://www.dsdinc.com/enhancements/marketplace/products/im-1241-unique-serial-numbers-per-item

------------------------------
Greg Stiles
DSD Business Systems
------------------------------


Original Message:
Sent: 10-25-2024 11:28
From: Karen O'Lane
Subject: Serialized Item - Qty greater than one allowed if different warehouse. Is this right??

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

------------------------------
Karen O'Lane
Accounting Systems, Inc. (ASI)
kolane@asifocus.com
559-448-0900
559-577-4142
http://www.asifocus.com

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed"). 

This very much fits my reply to the WAD response:  "So the design is deflective, not the code, and you think that means you don't have to fix it?"

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed"). 

I sold Sage to a firearms manufacturer at the turn of the century. Imagine my (and my customer's) surprise to learn that this is how the system works. The ATF keeps pretty tight control on serial numbers. 

It's a bad design. Or an oversight. Either way, not good.

I've never noticed this before.  What I am seeing is that I can add the same serial number for the same item to three different warehouses.  It only stops me when I try and transfer one of those units to a warehouse that already has that same serial number on hand.  If that serial is sold from a warehouse, it does then let you transfer the item with the same serial from a different warehouse into the one that no longer has the serial.  I honestly think this is a "misstep" in Sage Engineering (otherwise known as "working as designed").