Sage 100

I have a customer who has a couple of items where their item masterfiles do not have the correct total qty on hand. The valuation and stock status reports agree with each other so it's not a matter of cost detail (they use std valuation). Is there an easy way to recalculate this without running the full Recalculate Item History utility? TIA!

#Urgent

------------------------------
Therese Logeais, Technology Integrators
------------------------------
​

I don't think so.  If it's only a few, you could just DFD&M them, though I feel icky saying that.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

I've used Phil's method before.

------------------------------
Robert Wood
Consultant
90 Minds
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

I keep wondering why Sage has a field that probably holds inaccurate information! either fix it or get rid of it.  Kind of like the inventory valuation report by period. For years I had to tell clients "don't run that report it is not going to be accurate" inevitably the client asks - why is it there? I'm still not quite convinced that they have fixed it but...…..

------------------------------
David Overholt
DWD Technology Group
------------------------------

Original Message:
Sent: 05-09-2019 16:32
From: Robert Wood
Subject: CI_Item Total Qty On Hand incorrect

I've used Phil's method before.

------------------------------
Robert Wood
Consultant
90 Minds
Ocala FL
352-615-5898
------------------------------


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

Interesting, using the Recalc item history doesn't resolve it. Guess we'll have to go Phil's route!

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 16:37
From: David Overholt
Subject: CI_Item Total Qty On Hand incorrect

I keep wondering why Sage has a field that probably holds inaccurate information! either fix it or get rid of it.  Kind of like the inventory valuation report by period. For years I had to tell clients "don't run that report it is not going to be accurate" inevitably the client asks - why is it there? I'm still not quite convinced that they have fixed it but...…..

------------------------------
David Overholt
DWD Technology Group
------------------------------


Original Message:
Sent: 05-09-2019 16:32
From: Robert Wood
Subject: CI_Item Total Qty On Hand incorrect

I've used Phil's method before.

------------------------------
Robert Wood
Consultant
90 Minds
Ocala FL
352-615-5898


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

------Original Message------

Interesting, using the Recalc item history doesn't resolve it. Guess we'll have to go Phil's route!

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Which other recalc @Johnny Pabian??​

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 16:51
From: Johnny Pabian
Subject: CI_Item Total Qty On Hand incorrect

It is not the recalc utility but the other inventory recalc – does it not do it?

 

Original Message------

Interesting, using the Recalc item history doesn't resolve it. Guess we'll have to go Phil's route!

------------------------------
Therese Logeais, Technology Integrators
------------------------------

We use the *utl program to compare tiers, warehouse files, CI_Item and transaction history.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-09-2019 16:39
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Interesting, using the Recalc item history doesn't resolve it. Guess we'll have to go Phil's route!

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 05-09-2019 16:37
From: David Overholt
Subject: CI_Item Total Qty On Hand incorrect

I keep wondering why Sage has a field that probably holds inaccurate information! either fix it or get rid of it.  Kind of like the inventory valuation report by period. For years I had to tell clients "don't run that report it is not going to be accurate" inevitably the client asks - why is it there? I'm still not quite convinced that they have fixed it but...…..

------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 05-09-2019 16:32
From: Robert Wood
Subject: CI_Item Total Qty On Hand incorrect

I've used Phil's method before.

------------------------------
Robert Wood
Consultant
90 Minds
Ocala FL
352-615-5898


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

------Original Message------

We use the *utl program to compare tiers, warehouse files, CI_Item and transaction history.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Rebuilding IM sorts only allows you to clear committed quantities. Rebuilding SO and PO sorts only allows you to recalc qties on order. Unless I'm missing something??

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 16:54
From: Raymond Westcott
Subject: CI_Item Total Qty On Hand incorrect

If you haven't yet done it, the first thing I would try is to rebuild application sort files and recalculate inventory for all integrated modules, not just IM.

 

Original Message------

We use the *utl program to compare tiers, warehouse files, CI_Item and transaction history.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

------Original Message------

Rebuilding IM sorts only allows you to clear committed quantities. Rebuilding SO and PO sorts only allows you to recalc qties on order. Unless I'm missing something??

------------------------------
Therese Logeais, Technology Integrators
------------------------------

OMG, @David Overholt - that is the issue of the month for me (Val Report by Period)!  Just had to go through my second discussion of a client about the Valuation by Period not being correct.  Accidental future postings (to Dec 2019) were the culprit this time.  Just yesterday I emailed out a frustrated "Let's take that f-ing worthless report off the menu when we install from now on".​

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, and Cagney
Beth Bowers
269-445-1625
------------------------------

Original Message:
Sent: 05-09-2019 16:37
From: David Overholt
Subject: CI_Item Total Qty On Hand incorrect

I keep wondering why Sage has a field that probably holds inaccurate information! either fix it or get rid of it.  Kind of like the inventory valuation report by period. For years I had to tell clients "don't run that report it is not going to be accurate" inevitably the client asks - why is it there? I'm still not quite convinced that they have fixed it but...…..

------------------------------
David Overholt
DWD Technology Group
------------------------------


Original Message:
Sent: 05-09-2019 16:32
From: Robert Wood
Subject: CI_Item Total Qty On Hand incorrect

I've used Phil's method before.

------------------------------
Robert Wood
Consultant
90 Minds
Ocala FL
352-615-5898


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

Data dictionary hack:  https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=29199480-9ec9-4fb7-9d09-524aeb61e5e3&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm29199480-9ec9-4fb7-9d09-524aeb61e5e3

Because why shouldn't Sage make it more difficult to fix something they've known for years is broken....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

Original Message:
Sent: 05-09-2019 17:04
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

I figured that would be the trick. Thanks for the link @Phil McIntosh.​

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 17:15
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Data dictionary hack:  https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=29199480-9ec9-4fb7-9d09-524aeb61e5e3&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm29199480-9ec9-4fb7-9d09-524aeb61e5e3

Because why shouldn't Sage make it more difficult to fix something they've known for years is broken....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------


Original Message:
Sent: 05-09-2019 17:04
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-09-2019 17:22
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

I figured that would be the trick. Thanks for the link @Phil McIntosh.​

------------------------------
Therese Logeais, Technology Integrators
------------------------------


Original Message:
Sent: 05-09-2019 17:15
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Data dictionary hack:  https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=29199480-9ec9-4fb7-9d09-524aeb61e5e3&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm29199480-9ec9-4fb7-9d09-524aeb61e5e3

Because why shouldn't Sage make it more difficult to fix something they've known for years is broken....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5


Original Message:
Sent: 05-09-2019 17:04
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

@Therese Logeais do you consider it resolved?

If so, I'll close the thread out to the Sage 100 group.​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-09-2019 17:59
From: Kevin Moyes
Subject: CI_Item Total Qty On Hand incorrect



------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-09-2019 17:22
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

I figured that would be the trick. Thanks for the link @Phil McIntosh.​

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 17:15
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Data dictionary hack:  https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=29199480-9ec9-4fb7-9d09-524aeb61e5e3&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm29199480-9ec9-4fb7-9d09-524aeb61e5e3

Because why shouldn't Sage make it more difficult to fix something they've known for years is broken....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5


Original Message:
Sent: 05-09-2019 17:04
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5

Thanks @Robert Wood. For those who didn't attend or listen to the HL session Robert did earlier, there is now an Urgent Support Group for anything urgent, Sage 100, 300, CRM, etc. Once the issue has been resolved (or become 'stale' according to Robert), it will be moved to the appropriate group, e.g. this is now in Sage 100 and not in Urgent Support. Just an FYI!​

------------------------------
Therese Logeais, Technology Integrators
------------------------------

Original Message:
Sent: 05-09-2019 19:12
From: Robert Wood
Subject: CI_Item Total Qty On Hand incorrect

@Therese Logeais do you consider it resolved?

If so, I'll close the thread out to the Sage 100 group.​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------


Original Message:
Sent: 05-09-2019 17:59
From: Kevin Moyes
Subject: CI_Item Total Qty On Hand incorrect



------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-09-2019 17:22
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

I figured that would be the trick. Thanks for the link @Phil McIntosh.​

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 17:15
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Data dictionary hack:  https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=29199480-9ec9-4fb7-9d09-524aeb61e5e3&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm29199480-9ec9-4fb7-9d09-524aeb61e5e3

Because why shouldn't Sage make it more difficult to fix something they've known for years is broken....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5


Original Message:
Sent: 05-09-2019 17:04
From: Therese Logeais
Subject: CI_Item Total Qty On Hand incorrect

Okay, why do I not see TotalQuantityOnHand in VI for CI_Item??

------------------------------
Therese Logeais, Technology Integrators


Original Message:
Sent: 05-09-2019 16:29
From: Phil McIntosh
Subject: CI_Item Total Qty On Hand incorrect

Sage has acknowledged that field is not always maintained properly.  I would use a Crystal report to output a file with item and total from IM_itemwarehouse and VI the totals in.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5