Sage 100

v2019 Advanced.  Is there a utility to set all of the item's Standard Cost to either Average Cost or Last Cost?

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Automatic Cost and Price Change if the valuation method isn't Std.
Standard Cost Adjustment Selection if the valuation method IS Std.

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

They are not changing inventory valuation methods.  All items are average cost.  They want the to set all of the standard costs in item maintenance, for every item code,  to either the last cost or the average cost.  Usually the last cost and the average cost are the same because they turn the inventory quickly.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 02-19-2020 13:48
From: Wayne Schulz
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

I know I could export the average or last cost to Excel with ALE then use VI to change the standard cost.  I was curious if there was a utility that could do it for me.  I looked at the  automatic cost and price change but couldn't determine a way to accomplish this.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 02-19-2020 13:57
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

They are not changing inventory valuation methods.  All items are average cost.  They want the to set all of the standard costs in item maintenance, for every item code,  to either the last cost or the average cost.  Usually the last cost and the average cost are the same because they turn the inventory quickly.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 02-19-2020 13:48
From: Wayne Schulz
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

VI job from ODBC source... no need to export, just point VI at SOTMAS90.

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

Original Message:
Sent: 02-19-2020 14:00
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I know I could export the average or last cost to Excel with ALE then use VI to change the standard cost.  I was curious if there was a utility that could do it for me.  I looked at the  automatic cost and price change but couldn't determine a way to accomplish this.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------


Original Message:
Sent: 02-19-2020 13:57
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

They are not changing inventory valuation methods.  All items are average cost.  They want the to set all of the standard costs in item maintenance, for every item code,  to either the last cost or the average cost.  Usually the last cost and the average cost are the same because they turn the inventory quickly.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 02-19-2020 13:48
From: Wayne Schulz
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

Yes.  Thanks @Kevin Moyes ​

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Original Message:
Sent: 02-19-2020 14:37
From: Kevin Moyes
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

VI job from ODBC source... no need to export, just point VI at SOTMAS90.

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


Original Message:
Sent: 02-19-2020 14:00
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I know I could export the average or last cost to Excel with ALE then use VI to change the standard cost.  I was curious if there was a utility that could do it for me.  I looked at the  automatic cost and price change but couldn't determine a way to accomplish this.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 02-19-2020 13:57
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

They are not changing inventory valuation methods.  All items are average cost.  They want the to set all of the standard costs in item maintenance, for every item code,  to either the last cost or the average cost.  Usually the last cost and the average cost are the same because they turn the inventory quickly.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 02-19-2020 13:48
From: Wayne Schulz
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990

​I've never used that option to point to the SOTAMAS90 ODBC source, and always wondered "what would I use that for".  Thanks for the tip.

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

Original Message:
Sent: 02-19-2020 14:37
From: Kevin Moyes
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

VI job from ODBC source... no need to export, just point VI at SOTMAS90.

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


Original Message:
Sent: 02-19-2020 14:00
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I know I could export the average or last cost to Excel with ALE then use VI to change the standard cost.  I was curious if there was a utility that could do it for me.  I looked at the  automatic cost and price change but couldn't determine a way to accomplish this.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 02-19-2020 13:57
From: Doug Higgs
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

They are not changing inventory valuation methods.  All items are average cost.  They want the to set all of the standard costs in item maintenance, for every item code,  to either the last cost or the average cost.  Usually the last cost and the average cost are the same because they turn the inventory quickly.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary


Original Message:
Sent: 02-19-2020 13:48
From: Wayne Schulz
Subject: Need to Set Standard Cost to Either Average Cost or Last Cost

I recommend a standard disclosure/disclaimer to the customer that you are not in the business of providing tax or accounting advice. A change in inventory valuation method may require certain approvals and should be first discussed with your financial advisor.

Most of my customers laugh in my face when I launch into this. I've been doing this long enough to not care and to know that down the road if this type of a switch becomes a problem then I'm not on the hook.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990