Re: Inventory Year End Closing Issue

"Doug Griffin" <doug-ksEAidkFPgnmSTqxT0N/UAC/[email protected]> Tue, 13 Jul 2010 08:15:33 -0700
Newsgroups gmane.comp.systems.as400.jbausers
Message-ID <20100713081533.b2d78bf4853c635a83125b0bb3d9a663.7c8a11416a.wbe@email05.secureserver.net>
   It looks like Richard has this well in hand.
   Regards,

   Doug
   708-261-5300
   [1]www.amzassociates.com

     -------- Original Message --------
     Subject: Re: [SYSTEM21] Inventory Year End Closing Issue
     From: Richard Caldicott <[2][email protected]>
     Date: Tue, July 13, 2010 9:56 am
     To: System 21 Users <[3]system21-Zwy7GipZuJhWk0Htik3J/[email protected]>

     Our procedure at year end (and we just went through it too) is to do the
     month end and then use 8/STINM (we use Style) to change the year. We
     don't use the stats so it is the easiest solution for us - I know some
     people will disagree and say run the year end option. We had this
     problems a few years ago but spotted it within a couple of hours so we
     just had inventory transactions and were able to fix before they posted
     to the G/L. There is no real short cut.

     Inventory: Use SQL to change the period on INP95/96
     Order entry : Use SQL to change the period on OEP65/70 (APP65/70 if
     Style)
     A/R: SQL period on SLP15/20 and run a rebuild
     G/L: Run query over G/L to summarize postings by G/L Account. Post
     reversing entry to period 1012 using 35/GLU and then repost with
     original signs to 1101 using same option.

     Best advice is don't rush it and don't try to cut corners.

     Richard

     -----Original Message-----
     From: [4]system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
     [[5]mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Anuj Gupta
     Sent: Tuesday, July 13, 2010 3:20 AM
     To: System 21 Users
     Subject: [SYSTEM21] Inventory Year End Closing Issue

     Hello,

     I need your assistance on below issue.

     I forgot to do inventory year end on 3rd July 2010 and now she is facing
     the
     problem with inventory fiscal year and period.

     For normally month end close in AS400 system S21 per screen at
     bottomest, I
     usually use \\"2/ INC for closing inventory module. Unfortunately, for
     year
     end I have not done 3/INC for year end close.

     Since year end of Fiscal year (FY) 2010 is 3rd July, FY2011 is starting
     of
     4th July on ward. The consequence of year end close has not been done,
     there
     were some transactions of FY11 during 5- 13 July (per G/L record in red
     text
     ) recorded in FY10 P12 (1012). Our sales volume, sales amount, costing
     and
     G/L are wrongly booked.

     Could you please advise me for solve for year end close for FY2010 ? I
     need
     to remove recorded of FY11 out from FY10, is there any possible way to
     do
     kindly advise.
     Thanks in advance.

     Regards,
     Anuj
     _______________________________________________
     This is the System 21 Users (SYSTEM21) mailing list
     To post a message email: [6]SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
     To subscribe, unsubscribe, or change list options,
     visit: [7]http://lists.midrange.com/mailman/listinfo/system21
     or email: [8]SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
     Before posting, please take a moment to review the archives
     at [9]http://archive.midrange.com/system21.

     _______________________________________________
     This is the System 21 Users (SYSTEM21) mailing list
     To post a message email: [10]SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
     To subscribe, unsubscribe, or change list options,
     visit: [11]http://lists.midrange.com/mailman/listinfo/system21
     or email: [12]SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
     Before posting, please take a moment to review the archives
     at [13]http://archive.midrange.com/system21.

References

   Visible links
   1. http://www.amzassociates.com/
   2. mailto://[email protected]
   3. mailto://system21-Zwy7GipZuJhWk0Htik3J/[email protected]
   4. mailto://system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
   5. mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
   6. mailto://SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
   7. http://lists.midrange.com/mailman/listinfo/system21
   8. mailto://SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
   9. http://archive.midrange.com/system21
  10. mailto://SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
  11. http://lists.midrange.com/mailman/listinfo/system21
  12. mailto://SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
  13. http://archive.midrange.com/system21
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.