DataBase - Unapplied receivables

What is the quickest way to retrieve ALL unapplied Customer / Cash Receipts.

thank you
H

  Dencio replied to Harry

Hi Harry,

With posted cash receipts, you can use the existing Receivables Transactions
smartlist and add to filters (search) on :

Document Type = Payments
Current Trx Amount <> 0

Hope this helps!

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

  Leslie Vail replied to Dencio

You could also print the Unapplied Documents report. Reports>>Sales>>Analysis
then choose the Unapplied Documents report from the list. You can restrict
the report to only include 'Payment' document types.

Library Database DataBase Firstly, I am not sure if Library database is the correct term. I am talking about Dbs to which you set a reference drew blanks last time. Now assuming I have several referenced (library?) databases in my main database, how do I get the names of all the forms in all the Dbs? CodeProject AllForms.Count gives me the correct number of forms if I am in that referenced database. What I think I need is a method of looping through all the different CodeProject names in the main database, but there is not a sort of CodeProjects parent object. Or somehow moving the focus And, No, there is not any parent object for all the code projects. Because each database only knows about its own objects (or documents), you have to use a procedure in each database to refer to the objects in that database. E.g. to open a form in

Exporting Report from Access into PDF DataBase Hi everybody. I am hoping someone may be able to help me out. I have a database report that I want to export into PDF for each individual customer. Basically, I want to pick a location to save the files and then create a PDF based on a report that I have saved in Access for each customer individually. I have been looking around with each customer, I do not know if I can have the properties of the report change every time this source data changes. I am trying to work with Stephen Leban's A2000ReportToPDF database right now, but it is far more advanced than my puny range of code knowledge I am working with right now: Dim qdf As DAO.QueryDef Dim dbs As DAO.Database Dim rstMgr As DAO.Recordset, rstMgr1 As DAO.Recordset Dim strSQL As String, strTemp As

Limit Records Shown Per Report DataBase Question I use a report to show all systems located at a specific customer. When a customer has more than 20 systems, I would like a new report to start with all the same information in the header, etc. Any suggestions?? I am with header repeated on each page. UNTESTED UNTESTED UNTESTED In your query that feeds the report add field - - ZZZ: 1 Use Ranking in a Group in follow-on query with \ 20 post helpful to you? Reply Top Tia 2 / 3 / 2010 8:39 AM PST My report is set up with all the header information on the report and then all the systems are listed on subreport. They are connected through Customer ID I place the code in the query for the subreport or the query for the report??? Click to show or hide original message or reply text. Was this post helpful to

Need to print Cover Sheet for report. DataBase Hi, I am using Access via Office XP Pro. I am working on a government report. The first page of the report is a cover sheet / instructions and has nothing to do with the actual data other than it has to be the first page / coversheet to the report. Then I have the actual report which needs to have one footer at the end of the report which has the actual totals. I do not need a footer on each page, just the last page. Currently, I put the cover sheet in the Report Header. The cover sheet has our name, address, phone number, name of person submitting the

reporting even though a calculation made is dividing by zero DataBase I have a report which initially opens a form to input a start and end date in for the report information. One of the calculated reports items is a % of bad rolls produced. My report opens; I input the dates and it then runs a query based on those dates rolls" and divides the "off quality" by the "total" to give a % bad value. The report works great IF the (due to maintenance problems, etc. . .) then the report will not open. I just get the query results with ERR in that field. I 0, Null, [of quality rolls] / [total roll produced]), but this still would not run the report if zeros are in the "total rolls produced field". Do you know how I can have the report still run, but just have a blank or even ERR on the report to come