Re: SYSTEM21 Digest, Vol 8, Issue 50
Kugendran <kugendran-50QpOnh702NWk0Htik3J/[email protected]> Wed, 14 Jul 2010 06:32:37 +0530
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <[email protected]> |
Dear Anuj You will have to correct the revevntt data early as possible. Your Inventory Year is still 10. (Assumption). The current period = 10/01 Change to 11 immediately, using INM/7 - Inventory calendar. Make Sure ALL System21 users are exit from Entire Application Modules. Then the new transactions, from this point will be posted to the Financial Year 11. The next phase of the operation is very critical. This is data correction of relevant transactions erroneously posted to period 110/01 instead of 111/01 ( Assumption). 1. Write a program to correct all the records in all the tables including IN/SO/AR/AP/GL. 2. INP60 is the inventory balance table, may not be affected as it goes by current period. 3. Then you will have to execute the balances rebuild options of AR/AP/GL, in respective utilities 4. This will bring the data to the accurate level. I hope that this will help you. Regards Kugendran On 13 July 2010 22:30, <system21-request-Zwy7GipZuJhWk0Htik3J/[email protected]> wrote: > Send SYSTEM21 mailing list submissions to > system21-Zwy7GipZuJhWk0Htik3J/[email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.midrange.com/mailman/listinfo/system21 > or, via email, send a message with subject or body 'help' to > system21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > > You can reach the person managing the list at > system21-owner-Zwy7GipZuJhWk0Htik3J/[email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of SYSTEM21 digest..." > > > Today's Topics: > > 1. [SYSTEM21] Inventory Year End Closing Issue (Anuj Gupta) > 2. Re: [SYSTEM21] Inventory Year End Closing Issue (Doug Griffin) > 3. Re: [SYSTEM21] Inventory Year End Closing Issue (Anuj Gupta) > 4. Re: [SYSTEM21] Inventory Year End Closing Issue (Anuj Gupta) > 5. Re: [SYSTEM21] Inventory Year End Closing Issue > (Richard Caldicott) > 6. Re: [SYSTEM21] Inventory Year End Closing Issue (Doug Griffin) > > > ---------------------------------------------------------------------- > > message: 1 > date: Tue, 13 Jul 2010 13:49:38 +0530 > from: Anuj Gupta <[email protected]> > 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 > > > ------------------------------ > > message: 2 > date: Tue, 13 Jul 2010 07:23:36 -0700 > from: "Doug Griffin" <doug-ksEAidkFPgnmSTqxT0N/UAC/[email protected]> > subject: Re: [SYSTEM21] Inventory Year End Closing Issue > > A few thoughts > 1. Write one time programs/dfu to change fy11 transactions to fy10. > Difficult, time consuming, and risky > 2. Enter reversing transactions for all those wrongly booked, close the > year, then enter the transactions again in fy11 > 3. Have finance make compensationg entries in fy10 and fy11. Close the > year, and live with the wrongly booked transactions. > I hope this helps > Regards, > > Doug > 708-261-5300 > [1]www.amzassociates.com > > -------- Original Message -------- > Subject: [SYSTEM21] Inventory Year End Closing Issue > From: Anuj Gupta <[2][email protected]> > Date: Tue, July 13, 2010 3:19 am > To: System 21 Users <[3]system21-Zwy7GipZuJhWk0Htik3J/[email protected]> > > 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: [4]SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: [5]http://lists.midrange.com/mailman/listinfo/system21 > or email: [6]SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at [7]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-Zwy7GipZuJhWk0Htik3J/[email protected] > 5. http://lists.midrange.com/mailman/listinfo/system21 > 6. mailto://SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > 7. http://archive.midrange.com/system21 > > > ------------------------------ > > message: 3 > date: Tue, 13 Jul 2010 20:17:47 +0530 > from: Anuj Gupta <[email protected]> > subject: Re: [SYSTEM21] Inventory Year End Closing Issue > > Hello Doug, > > I appreciate your feedback. > > Could you please let me know which are all the files need to be updated to > change FY11 transactions to FY10 as per 1st point? > > Thanks in advance. > > Regards, > Anuj > > On Tue, Jul 13, 2010 at 7:53 PM, Doug Griffin <doug-ksEAidkFPgnmSTqxT0N/UAC/[email protected] > >wrote: > > > A few thoughts > > 1. Write one time programs/dfu to change fy11 transactions to fy10. > > Difficult, time consuming, and risky > > 2. Enter reversing transactions for all those wrongly booked, close the > > year, then enter the transactions again in fy11 > > 3. Have finance make compensationg entries in fy10 and fy11. Close the > > year, and live with the wrongly booked transactions. > > I hope this helps > > Regards, > > > > Doug > > 708-261-5300 > > [1]www.amzassociates.com > > > > -------- Original Message -------- > > Subject: [SYSTEM21] Inventory Year End Closing Issue > > From: Anuj Gupta <[2][email protected]> > > Date: Tue, July 13, 2010 3:19 am > > To: System 21 Users <[3]system21-Zwy7GipZuJhWk0Htik3J/[email protected]> > > > > 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: [4]SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > > To subscribe, unsubscribe, or change list options, > > visit: [5]http://lists.midrange.com/mailman/listinfo/system21 > > or email: [6]SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > > Before posting, please take a moment to review the archives > > at [7]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-Zwy7GipZuJhWk0Htik3J/[email protected] > > 5. http://lists.midrange.com/mailman/listinfo/system21 > > 6. mailto://SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > > 7. 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. > > > > > > > ------------------------------ > > message: 4 > date: Tue, 13 Jul 2010 20:20:42 +0530 > from: Anuj Gupta <[email protected]> > subject: Re: [SYSTEM21] Inventory Year End Closing Issue > > Hello Doug, > > For your 2nd point; is there menu options available in System 21 to reverse > these transactions? > > Regards, > Anuj > > On Tue, Jul 13, 2010 at 8:17 PM, Anuj Gupta <[email protected]> wrote: > > > Hello Doug, > > > > I appreciate your feedback. > > > > Could you please let me know which are all the files need to be updated > to > > change FY11 transactions to FY10 as per 1st point? > > > > > > Thanks in advance. > > > > Regards, > > Anuj > > > > On Tue, Jul 13, 2010 at 7:53 PM, Doug Griffin <doug-ksEAidkFPgnmSTqxT0N/UAC/[email protected] > >wrote: > > > >> A few thoughts > >> 1. Write one time programs/dfu to change fy11 transactions to fy10. > >> Difficult, time consuming, and risky > >> 2. Enter reversing transactions for all those wrongly booked, close > the > >> year, then enter the transactions again in fy11 > >> 3. Have finance make compensationg entries in fy10 and fy11. Close the > >> year, and live with the wrongly booked transactions. > >> I hope this helps > >> Regards, > >> > >> Doug > >> 708-261-5300 > >> [1]www.amzassociates.com > >> > >> -------- Original Message -------- > >> Subject: [SYSTEM21] Inventory Year End Closing Issue > >> From: Anuj Gupta <[2][email protected]> > >> Date: Tue, July 13, 2010 3:19 am > >> To: System 21 Users <[3]system21-Zwy7GipZuJhWk0Htik3J/[email protected]> > >> > >> 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: [4]SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > >> To subscribe, unsubscribe, or change list options, > >> visit: [5]http://lists.midrange.com/mailman/listinfo/system21 > >> or email: [6]SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > >> Before posting, please take a moment to review the archives > >> at [7]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-Zwy7GipZuJhWk0Htik3J/[email protected] > >> 5. http://lists.midrange.com/mailman/listinfo/system21 > >> 6. mailto://SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > >> 7. 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. > >> > >> > > > > > ------------------------------ > > message: 5 > date: Tue, 13 Jul 2010 09:56:09 -0500 > from: Richard Caldicott <[email protected]> > subject: Re: [SYSTEM21] Inventory Year End Closing Issue > > 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: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [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: 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. > > > > ------------------------------ > > message: 6 > date: Tue, 13 Jul 2010 08:15:33 -0700 > from: "Doug Griffin" <doug-ksEAidkFPgnmSTqxT0N/UAC/[email protected]> > subject: Re: [SYSTEM21] Inventory Year End Closing Issue > > 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) digest 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. > > > > End of SYSTEM21 Digest, Vol 8, Issue 50 > *************************************** > _______________________________________________ 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.