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

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


"tstrop" wrote:

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

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


"Dencio" wrote:

> 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
> 
> 
> "tstrop" wrote:
> 
> > You can not complete this process while invoices are being posted? How do I 
> > see what is being posted?

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?

"tstrop" wrote:

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

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



"Dencio" wrote:

> 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
> 
> 
> "Dencio" wrote:
> 
> > 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
> > 
> > 
> > "tstrop" wrote:
> > 
> > > You can not complete this process while invoices are being posted? How do I 
> > > see what is being posted?

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

"tstrop" wrote:

> 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?
> 
> "tstrop" wrote:
> 
> > You can not complete this process while invoices are being posted? How do I 
> > see what is being posted?