Ave costing (as I feared). Even with zero o/h it likely won't allow you to make the change as it is the aver age cost is not based upon a FIFOish calc of O/H - but rather average cost fo receipts from the time you told it to start collecting costs and generating a moving average.
You MIGHT be able to reset your ave cost period start from date in costing WB (so it ignores your offending PartTrans record).
If you don't know what odbc/SQL write is - forget I mentioned it (too dangerous if you don't know what to do).
When you call support, have they offered to remote connect and use their utilities to turn of dim inventory for the part (deleting your errant Part Trans record while they're at it so you can start clean again)?
If your costs are generally a mess anyway (perhaps you recently implemented and are still sorting things out), did you try changing the part to std cost to see if this removes the prohibition to turn off dim inventory? (If your costs ARE a bit of a mess, what do you have to lose by trying?) If it works, you could then return the part to ave cost.
I'm not sure what business objects are involved, but if you are comfortable with .net customization, you could create a temp subroutine in part entry to SetExtendedProperties of the appropriate Part table.field to read-only = false. (Force the dim inventory switch to be editable, change it, save the part record, and then remove your temp customization.)
If comfort level with that is also low, get Epicor to earn their support fees and fix the record for you. They will of course spend more time arguing that you did the db damage (so you should pay additonal for them to fix) than the time required for them to fix it.
Stick to your guns and escalate up the management chain if you get the run around.
Rob
Rob
You MIGHT be able to reset your ave cost period start from date in costing WB (so it ignores your offending PartTrans record).
If you don't know what odbc/SQL write is - forget I mentioned it (too dangerous if you don't know what to do).
When you call support, have they offered to remote connect and use their utilities to turn of dim inventory for the part (deleting your errant Part Trans record while they're at it so you can start clean again)?
If your costs are generally a mess anyway (perhaps you recently implemented and are still sorting things out), did you try changing the part to std cost to see if this removes the prohibition to turn off dim inventory? (If your costs ARE a bit of a mess, what do you have to lose by trying?) If it works, you could then return the part to ave cost.
I'm not sure what business objects are involved, but if you are comfortable with .net customization, you could create a temp subroutine in part entry to SetExtendedProperties of the appropriate Part table.field to read-only = false. (Force the dim inventory switch to be editable, change it, save the part record, and then remove your temp customization.)
If comfort level with that is also low, get Epicor to earn their support fees and fix the record for you. They will of course spend more time arguing that you did the db damage (so you should pay additonal for them to fix) than the time required for them to fix it.
Stick to your guns and escalate up the management chain if you get the run around.
Rob
Rob
--- On Wed, 11/5/08, vistapdmmatt <mh@...> wrote:
From: vistapdmmatt <mh@...>
Subject: [Vantage] Re: Help! Track Dimensions accidentially selected in Part Maintenance
To: vantage@yahoogroups.com
Date: Wednesday, November 5, 2008, 1:20 PM
Yes...cost averaging this part. I have adjusted the part quantity to
zero. This didn't help. I still can't take "track dimensions" off.
It seems like what I really need to do is remove the record in the
PartTrans table. Anyway to do that?
I didn't follow what you were saying regarding the ODBC write
process. I've not done anything like this before.
Thanks for you help,
Matt
--- In vantage@yahoogroups .com, Robert Brown <robertb_versa@ ...>
wrote:
>
> The message suggests it is a cost process imposed prohibition. (Are
you average costing this part?)
>
> I've found a lot of things can't be done to a part while any on-
hand inventory exists. Try adjusting on-hand to zero and see if you
can then turn dimensions off. (Either way, readjust the an-hand back
into inventory when done.)
>
> Worst case: Copy your db over to a train or pilot environment and
use odbc write to change the dimensional inventory switch. The verify
it didn't foul things up by issuing some portion of the material to a
job and see if the job WIP is correct. Also use cost workbench to
establish a new cost and verify it didn't screw things up.
>
> If it didn't - do it in your live system.
>
> Rob
>
> --- On Tue, 11/4/08, vistapdmmatt <mh@...> wrote:
> From: vistapdmmatt <mh@...>
> Subject: [Vantage] Help! Track Dimensions accidentially selected in
Part Maintenance
> To: vantage@yahoogroups .com
> Date: Tuesday, November 4, 2008, 3:36 PM
>
>
>
>
>
>
>
>
>
>
>
> Help! Anyone know how to fix this...
>
>
>
> We have a part that had a quantity in inventory. At some point in
time
>
> after parts were put into inventory, the "track dimensions" check
box
>
> was accidently selected. Later there was a quantity adjustment.
>
>
>
> We do not want to track dimensions on this part. When I try to
>
> deselect the "track dimensions" checkbox, I get an error "Track
>
> Dimension cannot be turned OFF because there is at least one
PartTran
>
> record with a dimension defined."
>
>
>
> How do I fix this?
>
>
>
> Thanks!
>
>
>
> Matt
>