RE: Inventory Transactions - Correct On Hand Balances

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

Hi Ho   

        I have noticed that the MTD and YTD figures are incorrect. The on
hand calculates correctly but if you where to add up individually your
Issues, then your Receipts, then your Adjustments they are not the same as
with is displayed in INV300. I have logged this with SSA many times.
Unfortunately they always reply that they cannot reproduce the problem or
they have not received other complaints on this matter. I thought that it
was our moded 6.02 version causing the problem. We have since gone full ERP
V61.01 as of Jan 01 of this year with no mods what so ever. The YTD and MTD
still do not add up correctly. The problem is with MTD not YTD. The YTD is
updated during month end close. (Previous YTD + Current MTD = Current YTD).
So if your MTD numbers are incorrect they get moved into your YTD. 

        I have written a program that recalcs everything and updates the
YTD. I run the program once a month at month end. (I don't need to worry
about MTD since they are brought to zero after month end). 
        
         

> ----------
> From:         Bailey, Dick[SMTP:Dick_Bailey@MCFA.COM]
> Reply To:     BPCS-L@midrange.com
> Sent:         Sunday, April 15, 2001 11:34 AM
> To:   BPCS-L@midrange.com
> Subject:      Inventory Transactions - Correct On Hand Balances
> 
> 
> 
>          BPCS 6.1.01 -   Has anyone noticed that some Inventory transfer
> transactions post to the receipts total in ILI and IWI and others post to
> adjustments?   Our Inventory Transaction effect files are set up to post
> to adjustments, but sometimes receipts are posted instead. This might not
> matter, except that it has a high correlation with errors in on-hand
> balances.   (My favorite subject)
> 
>          Dick Bailey 
>          MCFA 
> 
> 
> 
> 
__________________________________________________ 

The Royal Canadian Mint is proud to be among the "35 Best Companies to Work
For in Canada" in 2001, according to the Globe and Mail's Report On Business
Magazine.

La Monnaie royale canadienne est fière de se retrouver, pour l'an 2001,
parmi les «35 meilleures entreprises où travailler au Canada», selon la
revue Report On Business du Globe and Mail.

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---