× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.





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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.