Changing Material Costs on Jobs

Kerry,

What costing method do you use? If it's standard, what about a journal entry against your variance account? Otherwise, Keith's suggestion makes sense to me, but I've never had good luck tricking it with negative quantities.

Jared

--- In vantage@yahoogroups.com, "kwokchai1129" <keith.kwok@...> wrote:
>
> Kerry,
>
> you can try to do the negative qty of job receipt to inventory (cancel off past records), then make sure the material issue qty is correct, then do the job receipt to inventory again. Moreover, sometimes ADJ-CST will occur as the average cost maybe different at any time.
>
> After that run the WIP reconciliation report again to see the result.
>
> Keith
>
I got error trying to run one of my Crystal Reports:

"Column CommentText in table PUB.PODetail has value exceeding its max length or
precision. (#-210012)"

It is obvious that the comment text is over 2000 characters in one of our PO's,
but the question is how to find out which one?


Thanks.

Bart.





[Non-text portions of this message have been removed]
Good morning.

You can try running the BAQ alone (Test) and either visually or in Excel scan the results? If this is not a BAQReport, create a quick BAQ based on PODetail...

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bartosz Niemczewski
Sent: Tuesday, October 05, 2010 5:27 PM
To: Vantage Group
Subject: [Vantage] Exceeding Max Length or Precision



I got error trying to run one of my Crystal Reports:

"Column CommentText in table PUB.PODetail has value exceeding its max length or
precision. (#-210012)"

It is obvious that the comment text is over 2000 characters in one of our PO's,
but the question is how to find out which one?

Thanks.

Bart.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Good morning all,

Although we actually purchased Vantage (we are currently on 8.03.408B) 4 years
ago, we have just implemented the manufacturing portion within the last 6
months.

We are having a difficult time changing the material cost on a job and not
having it post to Manufacturing Variance.

For example, our employees thought they were issuing square inches of material
to a job. However, the material was stocked in sheets, so when they issued 8100
"square inches" of aluminum to a job, in reality what was issued was 8100 sheets
of aluminum, resulting in a material cost of almost $4,000,000. Well, that
obviously wasn't correct, so we returned the material to inventory, then issued
the correct amount to the job. Everything looked okay when we ran the
Production Detail report, but when I ran the WIP reconciliation report, I had a
positive variance of approximately $4,000,000. Does anyone know what I have to
do to get rid of the variance?

Thanks a lot for any help - this group has been amazing so far.

Kerry Travis
Controller
International Name Plate Supplies Limited


[Non-text portions of this message have been removed]
Did you do the material issue before job receipt to inventory.

If material issue do after job receipt to inventory, the cost will go to manufacturing variance instead of material cost.

hope above information would help you.

Keith Kwok
Ka Shui Holdings Co. Ltd

--- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@...> wrote:
>
> Good morning all,
>
> Although we actually purchased Vantage (we are currently on 8.03.408B) 4 years
> ago, we have just implemented the manufacturing portion within the last 6
> months.
>
> We are having a difficult time changing the material cost on a job and not
> having it post to Manufacturing Variance.
>
> For example, our employees thought they were issuing square inches of material
> to a job.? However, the material was stocked in sheets, so when they issued 8100
> "square inches" of aluminum to a job, in reality what was issued was 8100 sheets
> of aluminum, resulting in a material cost of almost $4,000,000.? Well, that
> obviously wasn't correct, so we returned the material to inventory, then issued
> the correct amount to the job.? Everything looked okay when we ran the
> Production Detail report, but when I ran the WIP reconciliation report, I had a
> positive variance of approximately $4,000,000.? Does anyone know what I have to
> do to get rid of the variance?
>
> Thanks a lot for any help - this group has been amazing so far.
>
> Kerry Travis
> Controller
> International Name Plate Supplies Limited
>
>
> [Non-text portions of this message have been removed]
>
Keith, thanks for your reply. I think that is what happened.

Is there any way to fix it?

Thanks,

Kerry




________________________________
From: kwokchai1129 <keith.kwok@...>
To: vantage@yahoogroups.com
Sent: Wed, October 6, 2010 10:42:57 AM
Subject: [Vantage] Re: Changing Material Costs on Jobs

Â
Did you do the material issue before job receipt to inventory.

If material issue do after job receipt to inventory, the cost will go to
manufacturing variance instead of material cost.

hope above information would help you.

Keith Kwok
Ka Shui Holdings Co. Ltd

--- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@...> wrote:
>
> Good morning all,
>
> Although we actually purchased Vantage (we are currently on 8.03.408B) 4 years

> ago, we have just implemented the manufacturing portion within the last 6
> months.
>
> We are having a difficult time changing the material cost on a job and not
> having it post to Manufacturing Variance.
>
> For example, our employees thought they were issuing square inches of material

> to a job.? However, the material was stocked in sheets, so when they issued
>8100
>
> "square inches" of aluminum to a job, in reality what was issued was 8100
>sheets
>
> of aluminum, resulting in a material cost of almost $4,000,000.? Well, that
> obviously wasn't correct, so we returned the material to inventory, then issued
>
> the correct amount to the job.? Everything looked okay when we ran the
> Production Detail report, but when I ran the WIP reconciliation report, I had a
>
> positive variance of approximately $4,000,000.? Does anyone know what I have to
>
> do to get rid of the variance?
>
> Thanks a lot for any help - this group has been amazing so far.
>
> Kerry Travis
> Controller
> International Name Plate Supplies Limited
>
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
Thanks.





________________________________
From: Roel Martinez <rmartinez@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, October 6, 2010 8:35:42 AM
Subject: RE: [Vantage] Exceeding Max Length or Precision


Good morning.

You can try running the BAQ alone (Test) and either visually or in Excel scan
the results? If this is not a BAQReport, create a quick BAQ based on
PODetail...

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bartosz Niemczewski
Sent: Tuesday, October 05, 2010 5:27 PM
To: Vantage Group
Subject: [Vantage] Exceeding Max Length or Precision

I got error trying to run one of my Crystal Reports:

"Column CommentText in table PUB.PODetail has value exceeding its max length or
precision. (#-210012)"

It is obvious that the comment text is over 2000 characters in one of our PO's,
but the question is how to find out which one?

Thanks.

Bart.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
Kerry,

you can try to do the negative qty of job receipt to inventory (cancel off past records), then make sure the material issue qty is correct, then do the job receipt to inventory again. Moreover, sometimes ADJ-CST will occur as the average cost maybe different at any time.

After that run the WIP reconciliation report again to see the result.

Keith

--- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@...> wrote:
>
> Keith, thanks for your reply. I think that is what happened.
>
> Is there any way to fix it?
>
> Thanks,
>
> Kerry
>
>
>
>
> ________________________________
> From: kwokchai1129 <keith.kwok@...>
> To: vantage@yahoogroups.com
> Sent: Wed, October 6, 2010 10:42:57 AM
> Subject: [Vantage] Re: Changing Material Costs on Jobs
>
> ÂÂ
> Did you do the material issue before job receipt to inventory.
>
> If material issue do after job receipt to inventory, the cost will go to
> manufacturing variance instead of material cost.
>
> hope above information would help you.
>
> Keith Kwok
> Ka Shui Holdings Co. Ltd
>
> --- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@> wrote:
> >
> > Good morning all,
> >
> > Although we actually purchased Vantage (we are currently on 8.03.408B) 4 years
>
> > ago, we have just implemented the manufacturing portion within the last 6
> > months.
> >
> > We are having a difficult time changing the material cost on a job and not
> > having it post to Manufacturing Variance.
> >
> > For example, our employees thought they were issuing square inches of material
>
> > to a job.? However, the material was stocked in sheets, so when they issued
> >8100
> >
> > "square inches" of aluminum to a job, in reality what was issued was 8100
> >sheets
> >
> > of aluminum, resulting in a material cost of almost $4,000,000.? Well, that
> > obviously wasn't correct, so we returned the material to inventory, then issued
> >
> > the correct amount to the job.? Everything looked okay when we ran the
> > Production Detail report, but when I ran the WIP reconciliation report, I had a
> >
> > positive variance of approximately $4,000,000.? Does anyone know what I have to
> >
> > do to get rid of the variance?
> >
> > Thanks a lot for any help - this group has been amazing so far.
> >
> > Kerry Travis
> > Controller
> > International Name Plate Supplies Limited
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>