Re: CST920 in 405 CD

Al,

In answer to your questions about cost transfers, If there is a record in the "from" facility and cost set then the system will create a new record in the "to" facility and cost set, regardless of the value in the cost fields.

The system will only create records in the "to" facility if there is a corresponding record in the "from" facility.

Dan Sweeney - Sr Technical Consultant
PHOENIX Business Consulting, Inc.
Cell: 860.490.6712
www.phoenixbcinc.com
 


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of Al
Sent: Wednesday, October 13, 2010 9:30 PM
To: 'BPCS ERP System'
Subject: [BPCS-L] CST920 in 405 CD



I am reviewing what needs to be ready for end-of-year EOY, which is often a little different year to year. Also a lot has fallen out of my brain since last EOY.

We have various types of what we call "glitches", where something is haywire with our data, and the focus is on getting it identified and fixed, avoid any finger pointing which can be destructive.

We keep actual costs of raw material current with vendor prices, then towards end of year key in vendor price changes for the coming year. I make a copy of standard cost to frozen cost reference, then copy actual into standard, and rollup. In theory at this point our new year standard costs are based on latest expected costs per our PUR vendors.

I know from prior years that if the "from-cost" is zero, that will make the "to-cost" zero, so I am now running queries listing items which have recently been active per IWI file, and are raw materials per IIM item type, but have actual cost zero so they can be fixed before EOY. During end-of-month EOM, right after INV900 we often run INV973 which goes on JOBQ to purge IWI records whose on-hand etc. have gone to zero. We rarely do INV970 because it cannot go on JOBQ, and I often doing EOM via VPN which has a bad habit of losing connection. Thus if an item is in IWI I know it was recently active. We do not do this IWI purge in same month of a physical inventory.

My question is about NULLS, items for which there is no cost record. Does anyone know what happens with CST920 if there is a null? I have looked at the source code, and cannot figure that out. We do not have AS/SET but CST920B is from AS/Set.

If "from-cost" record exists, but not "to-cost" record, does CST920 add the to-record copy, or ignore it?

If "from cost" record is missing, does CST920 ignore that item?

-Al Mac-

- Allowing one's computer to be unprotected, while connected to the internet, can be compared to owning a handgun and putting it out on your doorstep every night, in case a passing robber might be in need of one.
Unfortunately millions of people are doing exactly that, while thousands of them do so through networks of companies and government agencies that they manage.