Make Smartlist Payables trx find unposted batches for reconcile

Smartlist currently does not view unposted payables batches.  Many people 
want to use this object to review unposted batches and to assist in 
reconciling AP to the G/L or to dump AP transaction history for auditors.  he 
Payables Transaction Smartlist object pulls the distribution accounts from 
the Vendor master and not the actual posted distribution.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the 
suggestions with the most votes. To vote for this suggestion, click the "I 
Agree" button in the message pane. If you do not see the button, follow this 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=9e037096-9cc8-458f-bd94-daa877791fc2&dg=microsoft.public.greatplains
0
AdamEckroth (110)
1/16/2006 2:49:01 PM
greatplains 29623 articles. 6 followers. Follow

0 Replies
841 Views

Similar Articles

[PageSpeed] 45

Reply:

Similar Artilces:

Re: Massive "FIND" or " Compare cells " then , Delete....
Hello All, lets say I have in Column A, Dan, John, Bill, Angela, Fred ...many entries of the same names.... In Column B, I have Nancy, Dan, Steve, I want to delete all of the "Dans" in both columns ... Can I do something like: =compare( A1:B20 ) , delete,*.*)) I tried Subsitute, FIND, REPLACE.... Help! I am Confused!!!! :) Select A1:B100 (assuming that is your range), do Edit / Replace, replacing Dan with nothing, then with the range still selected do Edit / Go To / Special / Blanks, then Edit / Delete / Shift Cells UP. This assumes you want ...

How to find default property for particular object.
Hi, is there a way how to identify default property for given object. E.g., I know default property for range object is value. Where can I find the default property for other objects? Thanks Alojz Hi, AFAIK, the only default property for an Excel object is 'value'. If an object doesn't have a value property then it also doesn't have a default property. Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Alojz" wrote: > Hi, ...

Finding data in Excel
Lotus had a data find function where you indicated criteria(Same heading as the database - You could use more than one column) on another part of the worksheet to search for. You selected / data, find and Lotus highlithed the row that matches the criteria. Is there in Excel a simular function? Hi Riaan Cannot remember Lotus, but are you talking about <Ctrl> <F>? "Riaan" wrote: > Lotus had a data find function where you indicated criteria(Same heading as > the database - You could use more than one column) on another part of the > worksheet to search for...

Clip Gallery can't find files
I'd appreciate any help. I just installed Pub. 98 and it started indexing my existing clip gallery. Now, it can't find my old clip gallery files and wants me to update the location of them since they were moved. Any ideas? If they are on your system, open the gallery, click import clips, in the files of type, clip gallery catalogs, browse to the folder. -- Mary Sauer MS MVP http://dgl.microsoft.com/ http://mvps.org/msauer/ "Cyndy b" <bunnfam@bbnp.com> wrote in message news:014c01c347e3$ea772150$a601280a@phx.gbl... > I'd appreciate any help. I just insta...

Can't find my financial institution
My financial institution, Hewitt Associates, says that they are supported by Microsoft Money 2004. They are even listed on the MSN Money website. However, they are not listed in my Money program and thus can't seem to take advantage of the online services provided. Any help would be appreciated. Thanks. >Subject: Can't find my financial institution >From: "=?Utf-8?B?aGVyYg==?=" herb@discussions.microsoft.com >Date: 12/25/2004 10:03 AM Eastern Standard Time >Message-id: <616EC9C2-95B0-479B-BDC0-AAFF3957B0C9@microsoft.com> > >My financial insti...

Finding text using PowerPoint
Hello everybody! What is the easiest way to to find any piece of text in a PowerPoint Presentation? I would like to search for any text in all types of shapes (including smart art etc) as well as comments, notes etc. etc. etc. I have done some research but it seams that there is not a lot of information on PowerPoint. Hope to hear of someone soon!.. please! Jaco Pretorius IT Professional Home Tab > Editing > FIND? -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html ...

Finding the position of a certain picture on the screen
Hi everyone, I need to make a program in c# that will find a certain picture (not a big picture, few pixels in a certain formation, which is not necessarily a rectangle) on the computer screen. I haven't really done something like that before, so I'm not sure how to do it. what I had in mind was taking a screenshot (I found a tutorial that explains how) and then start checking every pixel in the screenshot until I find one that looks like one of the pixels in my picture, and then check if there are pixels next to him that are same to the ones in the picture, and in the same fo...

Batch Recover can post incorrect $ if you mark continue
If you have a posting interruption, and your batch goes to Batch Recovery, you are prompted with the option to continue...which you must do to run an edit list to see if there are infact errors with your batch. We have instances where Continue will allow the system to post to the GJ amts that dont match AP. I opened a support incident, and was told that "This logic seems sound: no posting errors = correct amounts, posting errors = incorrect amounts." and the process was functioning as designed. I might agree ,however, the "Batch Recovery Process" is there to help...

How to find which day of the week, this year, a birthday fall?
Hello: I have a database with employee birthdays. (I enter all the birthdays as mm/dd/1900 so no one knows how old anyone is.) I have a query I use to inform the managers what birthdays are upcoming in their department. It so happens that 2007 had the same calendar as 1900 so I didn't realize I wasn't pulling the day of the week the birthday falls for the current year. Is there an expression I need to build or a particular format I need to set? I was using the number format dddd, mm/dd. Thanks. Using DOB as the employee's birthday: Format(DateSerial(Year(Date),Month(DO...

Using OWA how can I find out the size of my mailbox?
Hi I use OWA at University. How can I easily verify the size of my mailbox ? Thanks Jay ...

How do I find a copy of Publisher 2002?
Hi, I am looking to order a new copy of Publisher 2002. I have a new project that my client wants to do on Publisher. I have not yet upgraded to XP and am still on Windows 98, so Publisher 2003 won't work on my (yes I know) outdated computer. How can I find a new copy of Publisher 2002 which will work on 98? I'm uncomfortable ordering from some of the unknown sites that come up in a google search. Any suggestions? Ebay? Or you could try Sams Club, BJs, or Costco. They may have some older software. We have a buyout company called Ollies in this are. (Their motto is "G...

Finding the difference in days between two dates?
Hi, I was wondering if anyone could let me know how I can find the difference in days between two date fields, would appreciate the help. Thanks Damon Damon; Just try this. Enter two dates ( 01/08/2003 and 21/08/2003 ) In another cell subtract the two dates, but format that cell as "General". If all is well, just must find a 20 in that cell. Or is it too simple and not what you want ? Mark Rosenkrantz. More Excel ? www.rosenkrantz.nl or info@rosenkrantz.nl ----------------------------------------------------------------- "Damon" <damon@nospam.co.uk...

Can't find Australian Banks Online
On the list of financial institutions I can only find American banks. I also have Australian accounts that I would like to add. Could you please advise if this is possible? I am using Microsoft Money 2004. Thanks, Jason You can add foreign banks to money by selecting the not held at a financial instution option when setting up the accounts. The drawback to this is that you cannot link foreign banks to online services and you probably won't be able to download statements from their website because most foreign banks (with the exception of canada) don't support money. This ...

find and replace or ?
Hi, I have a spreadsheet I've been updating which originally utilized a helper column with a date in it. Another column contained a rather long formula which referenced the cell in the helper column with a relative reference. I put the value that was in the helper column in a different location and wanted to update the formula to accommodate an absolute reference to the newly relocated value. Find and replace worked fine for the first instance of the formula, but I had to change the cell reference in the "find" box to update the formula in the next instance. I know I can ...

making your own menus on excel?
Is it possible? I'd like to make one where you can open up various submenus, and eventually select an option that has a macro attached....(like eg the 'all programs' menu that branches off the 'start' option on windows. SURELY that's possible! Cheers, Tom -- TAL27 ------------------------------------------------------------------------ TAL27's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30145 View this thread: http://www.excelforum.com/showthread.php?threadid=498749 Here is an example Option Explicit 'If you put code in th...

Finding the Value in the "last" cell?
I have an excel file that has a vba macro that grabs data from someplace else every few minutes and writes the data to the next empty line on a sheet "n". SInce the macro just appends the info to the sheet when event x is triggered I never know what the last line (row number) of the sheet will be. I need to have cell a1 (for example) give me the data is whatever is *currently* the most recent (or latest appended) data from column E. Thus, if the macro five minutes ago was on row 245 and E245 had the text, "FRED" and now event x triggers the macro so a new line of data is w...

how to make cell content to flash
I need content (text) of the cell to flash under certain conditions. I know how to do it in Word, can't find it in Excel. Sorry, Woytek - Excel does not support Animated Text. Regards |:<( "Woytek" wrote: > I need content (text) of the cell to flash under certain conditions. > I know how to do it in Word, can't find it in Excel. It can be done using VBA code but its a really bad idea.It produces jerky unpredictable flashing and while its running nothing at all else can be done until its stopped. Its nothing like the built in function in Word. My advice is to ...

I wish IM would let you create a batch of any reoccurence status
In Integration Manager I would like to be able to create an AP batch of 'weekly' status so that I can reuse document numbers for garnishment reference numbers...it seems IM will only let you create a batch of type single-use, so I have my users creating a batch of type weekly before integrating so that they don't get an error on every line item that the document number already exists. We decided it was more efficient to integrate garnishments from that spreadsheet that changes frequently than to edit a reoccuring batch which is what brought this up. ---------------- Thi...

Trying to make a duplicate roster with a button.
Previously posted in wrong forum. 'HERE' (http://www.excelforum.com/showthread.php?t=265167) Thanks for the help guy -- virte ----------------------------------------------------------------------- virtex's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1488 View this thread: http://www.excelforum.com/showthread.php?threadid=26517 ...

How to make a workflow wait until the next 600AM, or the next Mond
Has anyone figured out houw to make a work flow wait untill a specific time of day, regardless of the date? ie: I want to send an email out at 6AM, but I don't care what date, just the next time it's 6AM. As a follow up, how about waiting till Monday if its during a weekend. -- Thanks, Steve Noe, MCBMSP(2xCRM), MCT(CRM), MCTS-SQL www.bizitpro.com On Feb 14, 10:48=A0am, Steve Noe <Steve...@discussions.microsoft.com> wrote: > Has anyone figured out houw to make a work flow wait untill a specific ti= me > of day, regardless of the date? ie: I want to send an email out a...

How to make a Sales Process Die?
We had a sales process set up, and then decided it was not what we wanted. I deactivated it, and deleted it in workflow manager. Unfortunately, the opportunities set up under this process cannot be dissassociated form the Sales process, and there doesn't seem to be any way to purge the Sales process from these records. It also causes some strange results on the Opportunity by sales stage reports. Anyone know how to purge a Sales process Completely from the system?? Thanks Only way around this would be to recreate the opportunities. I do not know what affect deleting the sa...

I have question.. I have problem with Cells.find
I have two file (p1.xls , p2,.xls). When I work in file (p2.xls) i need to find something in second file(p1.xls). Then write value from Cecha in the ActiveCell of p2.xls, provided that Cecha is found I have button and code: but this code does not work how I want !! because search in file p2.... (it work on inversely) What I should modify ?? that it search in p1.xls ??? Sub CommandButton3_Click() '------>in file p2.xls Dim szukana As Range Dim Cecha as String Cecha = InputBox("Enter the name", "Enter value") If Cecha = "" Then Exit Sub Workbooks.O...

SMARTLIST REPORTS
i can't modify smartlist reports is there a way to modify reports from smartlist. can i modify smartlist reports in version 9 or in the succeeding versions(ex. 10-11) -- Jeremy Ayaay Technical Specialist STRC Jher, If you are talking about creating you own smartlist reports, you can use Smartlist Builder. This will allow you to create your own smartlist, as well as use SQL Views to pull into Smartlists. If this is not what you are looking for, can you please explain a little more about which reports you want to modify in Smartlist. "Jher" wrote: > i can't mod...

How do I make multi column stacked graphs in Excel
-- Ed Hi, See the links on Jon's page for Cluster Stacked charts. http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html Cheers Andy Ed B wrote: ...

Make outlook default mail client
How do I make sure the Outlook is my default mail client? I'm using Outlook 2000 SR-1 Thanks, Brendan -- Disclaimer: Any comments made are personal and do not reflect the thoughts or policies of this company. Control Panel - Internet Options - Programs - pick Outlook. Brendan MAther wrote: > How do I make sure the Outlook is my default mail client? I'm using > Outlook 2000 SR-1 > > Thanks, > Brendan thankyou "Lanwench [MVP - Exchange]" <lanwench@heybuddy.donotsendme.unsolicitedmail.atyahoo.com> wrote in message news:#D14B8OwDHA.3196@TK2MSFTNGP...