Re: SYSTEM21 Digest, Vol 8, Issue 50 -- SYSTEM21

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@xxxxxxxxxxxx> wrote:

Send SYSTEM21 mailing list submissions to
system21@xxxxxxxxxxxx

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@xxxxxxxxxxxx

You can reach the person managing the list at
system21-owner@xxxxxxxxxxxx

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 <anujgupta17@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxx>
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]anujgupta17@xxxxxxxxx>
Date: Tue, July 13, 2010 3:19 am
To: System 21 Users <[3]system21@xxxxxxxxxxxx>

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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [5]http://lists.midrange.com/mailman/listinfo/system21
or email: [6]SYSTEM21-request@xxxxxxxxxxxx
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://anujgupta17@xxxxxxxxx
3. mailto://system21@xxxxxxxxxxxx
4. mailto://SYSTEM21@xxxxxxxxxxxx
5. http://lists.midrange.com/mailman/listinfo/system21
6. mailto://SYSTEM21-request@xxxxxxxxxxxx
7. http://archive.midrange.com/system21

------------------------------

message: 3
date: Tue, 13 Jul 2010 20:17:47 +0530
from: Anuj Gupta <anujgupta17@xxxxxxxxx>
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@xxxxxxxxxxxxxxxxx

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]anujgupta17@xxxxxxxxx>
Date: Tue, July 13, 2010 3:19 am
To: System 21 Users <[3]system21@xxxxxxxxxxxx>

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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [5]http://lists.midrange.com/mailman/listinfo/system21
or email: [6]SYSTEM21-request@xxxxxxxxxxxx
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://anujgupta17@xxxxxxxxx
3. mailto://system21@xxxxxxxxxxxx
4. mailto://SYSTEM21@xxxxxxxxxxxx
5. http://lists.midrange.com/mailman/listinfo/system21
6. mailto://SYSTEM21-request@xxxxxxxxxxxx
7. http://archive.midrange.com/system21
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
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 <anujgupta17@xxxxxxxxx>
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 <anujgupta17@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxx
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]anujgupta17@xxxxxxxxx>
Date: Tue, July 13, 2010 3:19 am
To: System 21 Users <[3]system21@xxxxxxxxxxxx>

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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [5]http://lists.midrange.com/mailman/listinfo/system21
or email: [6]SYSTEM21-request@xxxxxxxxxxxx
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://anujgupta17@xxxxxxxxx
3. mailto://system21@xxxxxxxxxxxx
4. mailto://SYSTEM21@xxxxxxxxxxxx
5. http://lists.midrange.com/mailman/listinfo/system21
6. mailto://SYSTEM21-request@xxxxxxxxxxxx
7. http://archive.midrange.com/system21
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
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 <richard_caldicott@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx>
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]richard_caldicott@xxxxxxxxxxxxxxx>
Date: Tue, July 13, 2010 9:56 am
To: System 21 Users <[3]system21@xxxxxxxxxxxx>

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@xxxxxxxxxxxx
[[5]mailto:system21-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [7]http://lists.midrange.com/mailman/listinfo/system21
or email: [8]SYSTEM21-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [11]http://lists.midrange.com/mailman/listinfo/system21
or email: [12]SYSTEM21-request@xxxxxxxxxxxx
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://richard_caldicott@xxxxxxxxxxxxxxx
3. mailto://system21@xxxxxxxxxxxx
4. mailto://system21-bounces@xxxxxxxxxxxx
5. mailto:system21-bounces@xxxxxxxxxxxx
6. mailto://SYSTEM21@xxxxxxxxxxxx
7. http://lists.midrange.com/mailman/listinfo/system21
8. mailto://SYSTEM21-request@xxxxxxxxxxxx
9. http://archive.midrange.com/system21
10. mailto://SYSTEM21@xxxxxxxxxxxx
11. http://lists.midrange.com/mailman/listinfo/system21
12. mailto://SYSTEM21-request@xxxxxxxxxxxx
13. http://archive.midrange.com/system21

------------------------------

_______________________________________________
This is the System 21 Users (SYSTEM21) digest list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

End of SYSTEM21 Digest, Vol 8, Issue 50
***************************************