ACCPAC - No records exist in the specified range 1

[weingartctr]

Hi,

I hope someone can help me with this problem.

ACCPAC returns this error

"No records exist in the specified range."

when I try to print AP 1099/CPRS Amounts for year 2008 but when I go back to 2007, everything works out fine.

I looked at some of the vendor AP transactions and confirm that there are 1099 records for 2008.

Pls advise.

thanks

 

[DjangMan]

What version of AP do you have installed and what service pack?

 

[weingartctr]

From ACCPAC help, about -

ACCPAC Advantage Series Enterprise Edition (Version 5.3A Service Pack 3)

thanks

 

[DjangMan]

Scroll down the list of applications and see what is next to Accounts Payable.

 

[weingartctr]

I have Accounts Receivable and Administrative services

 

[DjangMan]

Next to those you'll see a version number and to the right of that you'll see indications of a service pack.

 

[weingartctr]

From help->system information:

System Manager Version - 5.3A (Enterprise Edition) (Build 45) (Service Pack 3)
Accounts Payable - 5.3a (Service Pack 3)
Accounts Receivable - 5.3a (Service Pack 3)
General Ledger - 5.3a (Service Pack 2)

the rest of the modules dont have any service packs.

thanks

 

[Jay Converse]

On what screen do you see these 2008 transactions?
Do the vendors with these transactions have the Invoicing/Tax Reporting option set to 1099?

 

[weingartctr]

Hi,

Under A/P Vendors -> Vendor Activity, the 2008 records show up under Payments tab.

But when I run:
A/P Vendor Reports -> 1099/CPRS Amounts, the 2008 records dont show up.

Actually, when I run:
A/P Vendors -> 1099/CPRS Amounts, the 2008 records dont show up either.

However, 2007 and 2009 A/P Vendor Reports -> 1099/CPRS Amounts run ok.

I wonder what could be different in the way the 2008 1099 payments were made.

Appreciate your help.

 

[Jay Converse]

Just what I thought. Nobody checked the "This is a 1099 invoice" box when the invoices were entered, it's a common user-generated problem. You'll have calculate the amounts manually, and import them into the 1099/CPRS amounts screen.

 

[weingartctr]

But why was it done for the whole calendar year 2008 and was ok for 2007 and 2009 (so far)?

We actually pulled out a 1099 transaction from a batch in 2008 and 2009 from a same vendor and what we noticed was that the 2008 is missing the information that it was for 1099 but the vendor info was not changed. And again, why calendar year 2008 only?

is there a way to get back to the 2008 records and change it to 1099?

thanks again.

 

[Jay Converse]

I don't know why it happened because I can't see your data to do the forensics. Whenever it's happened to my clients, it was caused by either:

A. Stupid user tricks
B. Bad training, or
C. Creative IT people who zeroed out the wrong year's data with a database editor.

You can't go back, like I said before, all you can do is calculate the total amount that should have been 1099-able (you only need one entry per vendor for the whole year), then import it in the 1099/CPRS screen. Run a transaction list of payments for the year, export to Excel, it won't take long.