8.03.408B Progress- change from avg cost to std cost for all par

Write a BAQ to format the data required by DMT for all parts(including the current stock position), export to excel then use that as your DMT file to adjust the stock to zero (dmt Inventory - Adjustments - Qty Adjustment), use the same file to adjust the costing method (dmt Inventory - Part - Part) then upload the original qty again and then set your standard cost via dmt - Inventory - Adjustments - Cost Adjustment making sure your value goes in the Standard Cost field

--- In vantage@yahoogroups.com, jdaniel1127@... wrote:
>
> no one with Progress??? I have DMT and service connect, looks like I will be playing in test database to figure this out.....
>
> ----- Original Message -----
> From: "Elizabeth" <gracefulthreads@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, February 9, 2012 7:49:51 AM
> Subject: [Vantage] Re: 8.03.408B Progress- change from avg cost to std cost for all parts
>
> ÂÂ
>
>
>
>
> Vic,
>
> We're going to be making this same journey after fiscal year end (3/31/12). If you could send the scripts up this way I'd really appreciate it!
>
> Ernie Lowell
> Diba Industries
>
> --- In vantage@yahoogroups.com , "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > I have some SQL scripts if you’re on SQL for this very thing.
> >
> > From: jamesd
> > Sent: Wednesday, February 08, 2012 3:27 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] 8.03.408B Progress- change from avg cost to std cost for all parts
> >
> >
> >
> > we have a new controller and he wants to change all of the parts in the test database from avg cost to std cost before we change live. does anyone have a dmt or service connect procedure for this? Epicor doesn't, they said zero qty, change to std and then put qty back in...
> > I have too many parts to do that with or will be here doing that for a loooooooong time...
> >
> >
> >
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.1913 / Virus Database: 2112/4796 - Release Date: 02/08/12
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>