Year End Closing Inventory

tstrop

unread,

Jan 8, 2010, 10:38:01 AM1/8/10

to

You can not complete this process while invoices are being posted? How do I
see what is being posted?

Dencio

unread,

Jan 8, 2010, 4:07:01 PM1/8/10

to

Hi,

Great Plains is validating the batch activity for active transactions in
Inventory, SOP and POP. With everyone logged out (in affected company) from
Great Plains, execute these queries and ensure both is returning zero result.

use DYNAMICS
select * from SY00800
select * from SY00801

Otherwise, you have to perform (1) Batch Recovery for all affected batches
in this company to be relieved and (2) execute a remedial sql query

use DYNAMICS
delete SY00800
delete SY00801

Note: Execute the delete query if you are the only user in the affected
company'

Perform the Inventory reconcile again and it should work perfectly.

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

Dencio

unread,

Jan 8, 2010, 4:12:02 PM1/8/10

to

Hi,

Great Plains is validating the batch activity for active transactions in
Inventory, SOP and POP. With everyone logged out (in affected company) from
Great Plains, execute these queries and ensure both is returning zero result.

use DYNAMICS
select * from SY00800
select * from SY00801

Otherwise, you have to perform (1) Batch Recovery for all affected batches
in this company to be relieved and (2) execute a remedial sql query

use DYNAMICS
delete SY00800
delete SY00801

Note: Execute the delete query if you are the only user in the affected
company'

Perform the Year End process on Inventory again and let us know how you go!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

--
Dennis Araullo

Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

tstrop

unread,

Jan 11, 2010, 8:08:01 AM1/11/10

to

I performed the select statements and got a return on the sy00800 of one
record. Went to the batch recovery utility but no batches currently exist?
Should I continue with the delete statements?

Richard Whaley -- MVP 2006-2008

unread,

Jan 11, 2010, 12:08:01 PM1/11/10

to

Actually, before deleting the activity records, you should try to recover
stuck batches and post them, printing the reports. If they get stuck again,
look at the reports for errors. Correct the errors and post again. Once
everything that can be posted is posted, then delete the activity records if
necessary.
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com

Leslie Vail

unread,

Jan 12, 2010, 3:17:01 PM1/12/10

to

My vote would be yes. Be sure to backup the company and system database
before continuing.