Sage 100

Hi Bob,

For the record, I am not officially recommending this. 

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this. 

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

If *UTL doesn't work I'd recommend Inventory Issue transactions to a suspense account (to zero QoH), then Inventory Recept transactions to bring the quantities back... then GL entries to clean up the suspense account and purchases clearing account.
This creates a nice audit trail of what was done.  The only reason you wouldn't want to do this is to preserve cost tier data, which is not an issue with Standard valuation.

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

Original Message:
Sent: 06-08-2020 15:07
From: Alnoor Cassim
Subject: Item Warehouse Average Cost

Hi Bob,

For the record, I am not officially recommending this.

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this.

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Original Message:
Sent: 6/8/2020 3:07:00 PM
From: Alnoor Cassim
Subject: RE: Item Warehouse Average Cost

Hi Bob,

For the record, I am not officially recommending this. 

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this. 

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Hmm I didn't think SetValue would work since it fires off business and dictionary validation (like the ReadOnly flag). In case you run into trouble with that you could try its cousin that does not validate.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Original Message:
Sent: 06-09-2020 11:20
From: Robert Osborn
Subject: Item Warehouse Average Cost

HI Alnoor,

  Thanks much.  I think I can get the work done without this (but I truly appreciate the info).  I am going to create a UDT with both the average cost and the total warehouse value.  Then I am going to write a script to update the IM_ItemWarehouse based on the values in the UDT.    I have a version that updates some other read only fields in IM_ItemWarehouse, so it seems like this should work.   Do you see any issues with this approach? 

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message:
Sent: 6/8/2020 3:07:00 PM
From: Alnoor Cassim
Subject: RE: Item Warehouse Average Cost

Hi Bob,

For the record, I am not officially recommending this.

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this.

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

I checked. It definitely does not work to modify AverageCost with SetValue out of the box.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-224-6642
------------------------------

Original Message:
Sent: 06-09-2020 14:44
From: Alnoor Cassim
Subject: Item Warehouse Average Cost

Hmm I didn't think SetValue would work since it fires off business and dictionary validation (like the ReadOnly flag). In case you run into trouble with that you could try its cousin that does not validate.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------


Original Message:
Sent: 06-09-2020 11:20
From: Robert Osborn
Subject: Item Warehouse Average Cost

HI Alnoor,

  Thanks much.  I think I can get the work done without this (but I truly appreciate the info).  I am going to create a UDT with both the average cost and the total warehouse value.  Then I am going to write a script to update the IM_ItemWarehouse based on the values in the UDT.    I have a version that updates some other read only fields in IM_ItemWarehouse, so it seems like this should work.   Do you see any issues with this approach? 

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message:
Sent: 6/8/2020 3:07:00 PM
From: Alnoor Cassim
Subject: RE: Item Warehouse Average Cost

Hi Bob,

For the record, I am not officially recommending this.

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this.

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA

this is perfect timing.  I need to clean up a few thousand CI_Item.AverageCost values after some testing in a "go live company"; in advance of actually going live next month.  Thank you @Alnoor Cassim for the step by step directions.  :)​

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

Original Message:
Sent: 06-10-2020 01:09
From: Dan Burleson
Subject: Item Warehouse Average Cost

I checked. It definitely does not work to modify AverageCost with SetValue out of the box.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-224-6642
------------------------------


Original Message:
Sent: 06-09-2020 14:44
From: Alnoor Cassim
Subject: Item Warehouse Average Cost

Hmm I didn't think SetValue would work since it fires off business and dictionary validation (like the ReadOnly flag). In case you run into trouble with that you could try its cousin that does not validate.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA


Original Message:
Sent: 06-09-2020 11:20
From: Robert Osborn
Subject: Item Warehouse Average Cost

HI Alnoor,

  Thanks much.  I think I can get the work done without this (but I truly appreciate the info).  I am going to create a UDT with both the average cost and the total warehouse value.  Then I am going to write a script to update the IM_ItemWarehouse based on the values in the UDT.    I have a version that updates some other read only fields in IM_ItemWarehouse, so it seems like this should work.   Do you see any issues with this approach? 

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message:
Sent: 6/8/2020 3:07:00 PM
From: Alnoor Cassim
Subject: RE: Item Warehouse Average Cost

Hi Bob,

For the record, I am not officially recommending this.

Since the purpose is data repair / inventory balancing, and I assume you've already reviewed the utilities from File / Run / *UTL and the Utilities menu to see if there's another or better way, you can do these steps to remove the ReadOnly flag from the AverageCost field in the dictionary. Don't forget to also update the AverageCost in CI_Item after this. AGAIN there is probably a better way to do this.

0. Make a backup of Providex.DDE
1. DFDM Providex.ddf
2. Hit the Lookup button
3. In the ALE lookup window, click the Data column to sort by it.
4. Scroll down until you find IM_ITEMWAREHOUSE
5. Note the Key number on the left-hand side Key column. For me it's 000891
6. DFDM Providex.dde and click the Lookup.
8. Type in the key number and search
9. Find the key 000891AVERAGECOST and press Enter
10. You can now edit Field 20 to change the ReadOnly=1 to ReadOnly=0 or remove it altogether.
11. If Import Job Maint was already open, close it and re-open it. After that AverageCost should be available in Data tab.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA