Cost Variance calculation in A/P

["Rob Stagis" <stagis@xxxxxxxxxxxxxxxxxxxx>]

We receive raw material on a 'U' transaction and when the invoice is keyed
in A/P, the standard cost variance is working nicely.  However, probably
half of our product line goes out for an outside operation - and the cost
variance calculation tries to calculate the outside operation cost versus
the finished good cost.

Our router states that step such-and-such is a 'C' operation and the cost is
keyed into the labor-hours field.  A purchase order is cut, referencing the
shop order and step.  The purchase order's part number is the finished item.

The PO is received as an 'OO' type receipt.  How can I either stop A/P
screen ACP500 from doing the cost variance calculation or have it calculate
against the cost that's on the router?

Thanks - Rob

PS - while this is just an annoyance thing, the A/P person is my wife and
marital bliss is a good thing.

-----Original Message-----
From: bpcs-l-admin@midrange.com [mailto:bpcs-l-admin@midrange.com]On
Behalf Of Al Mac
Sent: Tuesday, December 17, 2002 3:02 AM
To: bpcs-l@midrange.com
Subject: Re: Direct receipts


At 405 CD we can receive raw material against a purchase order PUR550 or
against a resupply order DRP550, but if we wanted raw material to magically
appear without going through an order for it, we could do an adjustment
transaction A which we use for making corrections to our counts, like a
cycle count.  Even if you do a physical inventory that discovers inventory
that somehow got overlooked, there is an O transaction into inventory
history then from there to General Ledger.  We do transfer inventory
between facilities with INV510 T using a temporary location representing
the truck it is in transit in, and coding for what facility it is in
transit TO..

On occasion we mess up, and have to do negative transactions and
adjustments, for which the A adjustment does wonders for corrections.  We
have a set of reason codes reflecting various reasons what is being
corrected here.

There's an option on one of the INV menus to view ITE ... pick one
transaction effect near beginning or end of the list (ours takes up two
summary screens), glue your eyes to one field of interest, then use page up
down or upper shift scroll button to flip through what each of your
transactions does.  Don't forget that additional transactions can be added
to the collection, but of course you have to run them through INV500 or one
of the other inventory transaction programs.

If you wanted to update your inventory to reflect the notion that raw
material had arrived, but not put anything in inventory history, kind of
like embezzlement in reverse, where embezzlement makes the inventory
disappear without a trace, but here it is appearing without an audit trail,
one way would be to use DFU or SQL or some such software outside of BPCS to
jack up quantity received of some item location by the amount you want to
increase it, then run a reorg to get the warehouse and other files in
agreement.  Of course your General Ledger won't reflect this increase in
inventory, because we need a formal transaction in the inventory history to
get the story there.  Also, it would put a bit of a strain on the people
doing input.  I think we have enough trouble figuring out the vanilla
system, let alone a spoofed one.

I have found out by experimentation that it is possible to add transactions
to ITH using a transaction effect code that does not exist in ITE, not that
I reccommend such a course of action.

Al Macintyre
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/
See Al http://www.ryze.com/view.php?who=Al9Mac
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html

>We are running bpcs 6.1
>We are currently receiving Raw material with transactions N (Receipt to
>Inspection) and P (Receipt from inspection to stock).
>We are looking for direct receipts, not based on transaction type  but on
>item number.
>
>Is there any field in item master wich could define this or does somebody
>know another way to do it without a transaction?
>
>Thanks,
>
>Rene Lopez Almazan
>Cost Accountant, Dura CS México
>Tel: 011 52 722 2754776
>E-Mail: renel@dura-inc.com


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.