Can PM Edit List be modified to include GL Summary Distributions?

Is it possible to modify the Payables Edit List to inclue GL Summary 
Distributions totals?

When a Payables batch is POSTED a report generates called "PM GL 
Distributions Summary" which lists the SUM of each GL account used in the 
batch regarless of the voucher.

For example, assume a Payables batch contains two invoices. The Accounts 
Payables account on 1st invoice is $35 and on 2nd invoice is $15...this 
report will basically show Accounts Payable account used on this batch is 
equal to $50 total.

We would like to modify the Payabled Edit List so we can see these GL 
distribution sums prior to Posting...essentially we want to use the format of 
the "PM GL Distributions Summary" report which prints AFTER a PM Batch is 
posted and use that on the "PM Edit List".

I tried to modify the PM Edit List report to include same tables/fields as 
the "PM GL Distributions Summary" report but the table relationships cannot 
be formed.

Is there any other way to accomplish this? If the Edit List report cannot be 
modified to look like the "PM GL Distributions Sumary" report, is there any 
other way to get this data before having to post the PM batch? Perhaps 
through SmartList?

Thanks So Very Much

0
10/24/2008 1:55:01 AM
greatplains 29623 articles. 6 followers. Follow

1 Replies
523 Views

Similar Articles

[PageSpeed] 52

I don't know about modifying the PM Edit list, but this report would be a 
snap to write. I think the following will give you what you want:

SELECT 
	PM10000.BACHNUMB, 
	GL00105.ACTNUMST,
	GL00100.ACTDESCR, 
	PM10100.DEBITAMT, 
	PM10100.CRDTAMNT
FROM   
((TWO.dbo.PM10000 PM10000 INNER JOIN TWO.dbo.PM10100 PM10100 ON 
(PM10000.VCHRNMBR=PM10100.VCHRNMBR) AND (PM10000.CNTRLTYP=PM10100.CNTRLTYP)) 
INNER JOIN TWO.dbo.GL00105 GL00105 ON PM10100.DSTINDX=GL00105.ACTINDX) 
INNER JOIN TWO.dbo.GL00100 GL00100 ON GL00105.ACTINDX=GL00100.ACTINDX
WHERE  
	PM10000.POSTED=0
ORDER BY 
	PM10000.BACHNUMB, GL00100.ACTINDX


I bet report writer could even have it as a custom report you could run from 
a macro.

Leslie

-- 
Leslie Vail, CPA, MCT, MVP
MCBSP-Application for Microsoft Dynamics GP
MCBSP-Installation and Configuration for Microsoft Dynamics GP
  cell: 972-814-8550
  fax: 972-692-7472



"GPLoveHateRelationship" wrote:

> Is it possible to modify the Payables Edit List to inclue GL Summary 
> Distributions totals?
> 
> When a Payables batch is POSTED a report generates called "PM GL 
> Distributions Summary" which lists the SUM of each GL account used in the 
> batch regarless of the voucher.
> 
> For example, assume a Payables batch contains two invoices. The Accounts 
> Payables account on 1st invoice is $35 and on 2nd invoice is $15...this 
> report will basically show Accounts Payable account used on this batch is 
> equal to $50 total.
> 
> We would like to modify the Payabled Edit List so we can see these GL 
> distribution sums prior to Posting...essentially we want to use the format of 
> the "PM GL Distributions Summary" report which prints AFTER a PM Batch is 
> posted and use that on the "PM Edit List".
> 
> I tried to modify the PM Edit List report to include same tables/fields as 
> the "PM GL Distributions Summary" report but the table relationships cannot 
> be formed.
> 
> Is there any other way to accomplish this? If the Edit List report cannot be 
> modified to look like the "PM GL Distributions Sumary" report, is there any 
> other way to get this data before having to post the PM batch? Perhaps 
> through SmartList?
> 
> Thanks So Very Much
> 
0
10/24/2008 9:26:09 PM
Reply:

Similar Artilces:

Drop Down List Question!
How do I go about having a drop down list in a invoice so as it will link up with a name and address on another sheet. Sheet (Address) has name and address in A1, A2, A3, A4, A5. Then in Sheet Invoice I want to have a drop down list then select and the next 4 cells fall below to complete a invoice address! -- Thanks in advance for your help....Bob Vance .. .. .. .. Hello Select the cells of your address (A1:A50) in Sheet Address Then | Insert| Name | Define give a name - for eg: "add" Now in your Invoice Sheet, go to the cell where you want the address to be printed Data | V...

Can i get origional back after trial?
I bought my laptop used from Craigslist, so i dont have the discs. I have office pro 2003. i dL the free trial of office pro 2007. After the dL, i discovered i have to delete my outlook in order to run the 2007 version. If i delete 2003, is there any way to retrieve it if i dont upgrade 2007? Nope. In addition, if you didn't get the license and discs for 2003, you don't have the rights to use it. BackwoodsCutie wrote: > I bought my laptop used from Craigslist, so i dont have the discs. I have > office pro 2003. i dL the free trial of office pro 2007. After the d...

Can not get MS Money Premium to connect to internet after KB searc
I can not log into the Windows Live ID because Money will not connect to the internet. I am running Win XP SP2 on Tablet(Pro version) with IE 7 and have upgraded and reset ie7. I have gone through KB http://support.microsoft.com/kb/891338/ and http://support.microsoft.com/kb/899935/ from Cal Learner's previous posts. However, these have not worked and I cannot get to use Windows Live ID since it will not connect. I also reinstalled Money again, but not available. Anyone have any ideas? I know this has been a running problem, but I want to use the Live ID process so my bank info wi...

Can I edit a web query?
I want to download some data from the web which is in a simple table format (7 columns x 50 rows). I use MS Web Query to do this. Is there anyway that I can use VBA to just download the first row of the table? Web Query only allows the whole table to be downloaded and I cannot find a way to edit this using Excel to just get specific bits of data. As always, advice is well received... If you give me the url and your present code, I will take a look at it. OR, import to one sheet and use a macro to extract to another sheet. -- Don Guillett SalesAid Software donaldb@281.com "Alex&...

Help!! Is there any way I can get a deleted folder back??
Hello, I accidentally did a shift delete on one of my folders as it was highlighted instead of the e-mail I wanted to delete. Is there any way I can retrieve this?? :-) Maybe this. Recuva http://www.piriform.com/recuva -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "NZuser" <NZuser@discussions.microsoft.com> wrote in message news:47E64F7B-82EE-4136-8A5B-570DBA727309@microsoft.com... > Hello, > I accidentally did a shift delete on one of my folders as it was > highlighted > instead of the e-mail I wanted to ...

Modifying reports with VB6
I have a program written in VB6 with an mdb file backend on the server in Access 2000 format. I have reports that I create on my computer that has Access installed that I need people on other computers to be able to print. The problem is the old issue of Access resetting the paper size if it happens to run out of legal paper. The code that I've seen and used to fix this problem depends on being able to create an instance of the Access app. This of course does not work on a PC that doesn't have Access installed. Is there a way to programmatically do this from VB6 without the Access app...

Can you open the websit?
Can you open the websit eachenet.go.51.net and eachebay.go.51.net ? I can ,but i can't understand the meaning of the content? Can you tell me what should I do next step? bluesea.go.51.net "Alexander" wrote in <news:g2q2bb$933$1@news.cn99.com>: > Can you open the websit eachenet.go.51.net and eachebay.go.51.net ? > I can ,but i can't understand the meaning of the content? > Can you tell me what should I do next step? > bluesea.go.51.net Based on a vague "can you go open" request which says nothing of some unidentified professed problem, Ale...

want to convert string into byte array hw i can do it
SqlConnection SqlConn = new SqlConnection(Scon); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); SqlDataAdapter ADAP = new SqlDataAdapter("Select * from User1 Where Id = 3", SqlConn); //Initialize Dataset. DataSet DS = new DataSet(); //Fill dataset with ImagesStore table. ADAP.Fill(DS, "User1"); //string filename = GridView1.Rows[GridView1.SelectedIndex] ["FileName"]; string filename = DS.Tables["User1"].Rows[0]...

How can I lock worksheets while macros can still enter into them?
I want to lock worksheets for outside users. But when I do it and a macro needs to go into the worksheet, the system gives an error. So is there a way to lock worksheets while still allowing macros to enter into the sheets and function properly? enginguven, you can protect the sheet with user interface only, like this ActiveSheet.Protect UserInterfaceOnly:=True, password:="123" or Sheets("Sheet1").Protect UserInterfaceOnly:=True, Password:="123" or use something like this Const PW As String = "123" 'Change Password Here ActiveSheet.Unprotect P...

editing pictures
There used to be a way to click on an icon and be able to blend several colors from the background of a picture together and use that new combination to fade or smear out other objects in the picture. I have done it, but don't remember what program it was in, it was in a MS program. Does anyone know what program that is? Did MS change it? Might be thinking Digital Imaging, it was bundled with an earlier version of Publisher. John Inzer has more knowledge about this application. -- Mary Sauer http://msauer.mvps.org/ "mcharron" <mcharron@discussions.micro...

Can't Find Contact Folder?
When I click the contact folder I Outlook "cant find the folder". Where is this setting so I can see which folder it's looking for? .... version Outlook XP Sorry about that. Microsoft Outlook 2003 running on Windows XP. In Outlook, there is not a seperate file for contacts. It is part of the same pst file as the other folders. Never heard of this before, so this may not work, but since OL does not believe thecontact folder is there it might. Right click Personal Folders and select New Folder, name it Contacts and see what happens. Worst that could happen is that it will ...

Supplier Cost Edit?
Does anyone know a way to edit the cost by supplier? I can modify my retail cost by a adding a percentage to my cost in the Inv. Wizard by department, however, I need to mark up according to what supplier I am dealing with. Maybe I am over looking something. Any suggestions would be great! Thanks! David D. L.S.B. have you tried "items from this filter" in Inv. Wizard "David D." wrote: > Does anyone know a way to edit the cost by supplier? I can modify my retail > cost by a adding a percentage to my cost in the Inv. Wizard by department, > however, I need...

Data validation list problem
I am using Excel 2002 sp3. I have a number of sheets that use data validation to limit the values that can be entered in specific cells - this list is several columns wide by up to 1000's rows long (sequential currency amounts for each denomination). It resides on its own hidden sheet which is protected. All works fine but occasionally one or two (or more) of the values in this list seem to be getting altered. e.g, the column may read 98.0, 98.5, 99.0, 99.5 and instead of the next one being 100 (which it was originally) it is now 90 and so on. A number of different users...

Can different editions of Publisher be used together?
If my son uses Publisher 2003 on a school computer, downloads his work to a flash drive, brings it home to edit on Publisher 2007, will he then be able to take the edited work back to the school computer to be used, or will it not be compatible? Stateparent wrote: > If my son uses Publisher 2003 on a school computer, downloads his work to a > flash drive, brings it home to edit on Publisher 2007, will he then be able > to take the edited work back to the school computer to be used, or will it > not be compatible? Publisher 2003 and 2007 share a common file format, so the sc...

Including Country in RW SelectAddrLine Function
Is it possible to include the Country field in the Report Writer rw_SelectAddrLine function? We want the Country to be the last line but still include two address lines. If so, what's the proper format? Replace the last set of double quotes in the function with the country field from the appropriate table. Do this for all of the calculated fields. You will probably have to create a Line 4 (or 5) calculated field for the address. Look closely at the existing fields and replicate the function remembering to increment the line number in the parameter list. -- Tim Foster "El...

Can't see messages in Inbox
When I go to Outlook, and click on the Inbox, the inbox showed up for a second, then it is replaced by PopNav website. This website had replaced my homepage in IE also. I can't see messages in my Inbox anymore. HELP !! What can I do to fix this? Note: as of yesterday my Outlook inbox worked fine. "Fie Fie Niles" <fniles@wincitesystems.com> wrote in message news:efE6nNo6DHA.1592@TK2MSFTNGP10.phx.gbl... > When I go to Outlook, and click on the Inbox, the inbox showed up for a > second, then it is replaced by PopNav website. This website had replaced my > homepage ...

Distribution of MFC42.dll
What's the recommended way of distributing the MFC42.DLL? Is it wise to install this in the folder with my application .exe that uses the .DLL instead of relying on what happens to be on the system its installed on? In the past I've used the InstallShield program to have it attempt to update the system copy. I believe XP and Win2K don't easily allow this system update, however. I'd appreciate any advice on what shipping products are doing. -- Craig >What's the recommended way of distributing the MFC42.DLL? Is it wise to >install this in the folder with my ap...

Macro to edit cell
I would like to write a macro that edits the first 6 digits of a cell but leaving the last 6 digits as is. something like for each c in selection c.value="123456"&right(c,len(c)-6) next "Kevin" <kehan@stormontvail.org> wrote in message news:0ea901c36801$b49474f0$a601280a@phx.gbl... > I would like to write a macro that edits the first 6 > digits of a cell but leaving the last 6 digits as is. ...

windows mail...error message and I can't send mail.
I get the same error message, but not all the time. Randomly I will not be able to read or send mail. I copied but there is no provision to past it here...so annoying. Unknown error...server, etc... Same error message as what? If you can type in a window, you can paste text into it. Are you trying to paste an image? That won't work. Next time you get a Windows Mail error message, right-click on that error message, click Copy, then paste it into a reply here. We can't=20 do much troubleshooting without the complete error message.=20 --=20 Gary VanderMolen, Microsoft MV...

how to match between two list using letters
Hi, I have two sheets as follows: sheet1 A--------------B 34145 D173abcd 333215 TI242EFG 344233 E0124ABCD Sheet2 A-----------B------------C D-173 abcd ? B-241 efgh ? TI-242 XYZ ? E-0124 STQ ? What I want to do is taking the value from Colum A in sheet1 and put it in column C in sheet 2 using Sheet1 Column B as an indicator. Please note that the Column A in sheet2 has the same data of Column B in sheet1 but there are extra letters and characters. In C1 of sheet2 and copy dow...

News reader included in Outlook 07?
I read somewhere that the newsreader feature would be available in Outlook 07. My ISP also indicated that I can set up and aread from an Outlook folder. However, I can find no way to do this. A search of MS web site indicates that I have to buy an additional MAPI product for this to work. I guess I don't understand since I can read any group I want from Outlook Express. Why would this service not be available on the versio of the software that I paid for separately? Or, am I missing something? Since the MAPI servies is running on my machine why can't I simply access it from an ...

Convert mailing list from columns to rows
I have been handed a list that I need to convert and I am stumped. The worksheet contains three columns of addresses. The addresses are generally in one of three formats: Company Contact Street number and name City State Zip or Name Street number and name City State Zip or The repeat of the above with two lines for street information. As far as I can tell so far, these four are the only different formats. Some of the addresses have a comma between the city and state. One final complication, some addresses use the 5 digit zip, some use the zip+4 with a dash. Is the...

Microsoft Visual C++ 2008 Redistributable Package (x86), can i redistribute single files of it?
Hi, until today i always forced users to download/install the complete package of the Microsoft Visual C++ 2008 Redistributable Package (x86), but mostly my applications only need the msvcr90.dll to run. So my question here is if i can pack this file into my installer and redistribute it with my application. For my case it would be just fine if the dll would be in the same directory as the app is. Is it legal to redisitribute the single dll or do i have to pack the complete msi installer into my app installer, which makes the complete installer a huge package,... I didnt find any informatio...

Help! Can't enter duplicate tracking numbers
We just discovered that after 2 years of using GP, our FedEx and UPS tracking numbers are starting to duplicate, because they're reusing the numbers. We can't load them into GP via eConnect anymore because we get a duplicate record type of error. It seems that the Tracking Number field in the SOP10107 table is a key. Has anyone encountered this?? What, if anything, can we do?? -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 Bud, I just tested entering a tracking number already in the SOP10107 table ...

Why won't word alphabetize a list of email addresses?
I typed a list of single spaced email addresses separated by paragraphs and want to alphabetize them. When I try, I get an error message "Word cannot sort fields in the selections." How can I sort this list? Thanks!!! In the Sort dialog, for "Sort by," make sure you have "Paragraphs" selected instead of "Field 1" or anything else. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Sort list of email addresses" <Sort list of email addresses@discussions.microsoft.com&...