Topic Options
#8651 - 03/15/07 11:30 AM AR Transaction Report Missing Entries
Anonymous
Unregistered


The AR Transation report is missing some entries from Jan 06 through June 06. We are running the report for Current and Historical entries but the data is not in AR. We were keeping history for 90 days and that was changed to 365 in February. The transcations are in Adagio Invoices.

Is there any way to retrieve the transactions into AR?

Top
#8653 - 03/15/07 11:38 AM Re: AR Transaction Report Missing Entries [Re: ]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hello timapowersystems,

Are the transactions paid or outstanding? You can always enter the transactions through Adagio Receivables Invoice batch entry and post them, but you'll have to be careful about the general ledger entries that are going to be created. You'll also need to be careful about keeping the AR control account in synch.

Is there a pressing reason you need these transactions?
_________________________
Andrew Bates

Top
#8656 - 03/15/07 02:03 PM Re: AR Transaction Report Missing Entries [Re: Retired_Guy]
Anonymous
Unregistered


We need to runa report on the top 10 customers for 2006. We want the report to include sales, credit memos, and cash receipts. We do not have Crystal reports or gridview, so we are analyzing the Adagio reports.

Top
#8657 - 03/15/07 02:05 PM Re: AR Transaction Report Missing Entries [Re: ]
Anonymous
Unregistered


Also, the transactions that are missing are paid transactions. We do not want to go through the process of entering into AR, why would they be missing?

Top
#8658 - 03/15/07 02:34 PM Re: AR Transaction Report Missing Entries [Re: ]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Why would they be missing?

Incorrect backup and restore procedures could result in transactions being in AR but not Invoices. Or, you have purged the fully paid transactions from Receivables duing a period end - this doesn't remove them from Invoices.

Here's a method to create this list.
  • In Smartfinder (F6), add the LAST YEAR Invoices, Adjustments, Credit note figures to the grid.
  • Select all customers (cust # <> blanks)
  • ExcelDirect the list
  • Calculate the net sales in Excel
  • Sort the list in descending order in Excel
  • Save the top 10 customers
  • Delete all but the top 10 customers
  • Delete all columns but the customer number
  • Save the resulting sheet as Top10.xls
  • Go back to Adagio Receivables
  • Create an import template (File | Import | Customers) that imports from Top10.xls, just the customer numbers, without adding new records, but allowing Overwrite, with a title row.
  • Specify that the customer number is being imported
  • Set the field "Report Group" to default to "Top10" on import
  • Import the sheet
  • Run the report for just the report group "Top10"


It's probably taken me longer to write the list of steps that it will take you to complete the process.
_________________________
Andrew Bates

Top
#8659 - 03/15/07 03:12 PM Re: AR Transaction Report Missing Entries [Re: Retired_Guy]
Anonymous
Unregistered


Thanks.
I'll try it and let you know.

Top


Moderator:  Christa_Meissner 
Who's Online
2 registered (Samuel Kopstick, 1 invisible), 90 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31