Applying Payables Transaction to Receivables Invoice

I have an invoice in receivables, and I would like to apply a payables 
document against it. This customer sent us an invoice, and he had one 
outstanding invoice from us, so he paid us for the difference between these 
invoices. When I go to apply the payment, I would like to first apply the 
payables document against the customer invoice so the payment can clear 
properly. Is this possible?
-- 
I am running on Dynamics GP 10.0, unless otherwise stated.
1
10/2/2009 1:19:01 PM
greatplains 29623 articles. 2 followers. Follow

1 Replies
478 Views

Similar Articles

[PageSpeed] 42

On Oct 2, 8:19=A0am, Orion Cochrane
<OrionCochr...@discussions.microsoft.com> wrote:
> I have an invoice in receivables, and I would like to apply a payables
> document against it. This customer sent us an invoice, and he had one
> outstanding invoice from us, so he paid us for the difference between the=
se
> invoices. When I go to apply the payment, I would like to first apply the
> payables document against the customer invoice so the payment can clear
> properly. Is this possible?
> --
> I am running on Dynamics GP 10.0, unless otherwise stated.

Frank Hamelly has a nice post describing 2 options for you:

http://gp2themax.blogspot.com/2009/10/gptip42day-customervendor.html

Janakiram has another post in which he takes a deeper dive into the
Customer/Vendor Consolidations:

http://janakirammp.blogspot.com/2009/07/customervendor-transactions.html
-1
michaelj2 (179)
10/2/2009 1:42:01 PM
Reply:

Similar Artilces:

How do I apply a combo box to multiple cells in Excel so that it .
I would like to apply a combo drop down box in Excel. However I only want the box to appear when the cursor is over the cell can anyone offer me some help on this matter? Thank you, Dwain Hi Dwain, Perhaps you are looking for Data Validation, available on the Data menu. See Debra Dalgleish's tutorial at: http://www.contextures.com/xlDataVal01.html --- Regards, Norman "DB" <DB@discussions.microsoft.com> wrote in message news:6939ADC2-CF1C-46AA-B163-BEE27E23356A@microsoft.com... >I would like to apply a combo drop down box in Excel. However I only w...

Apply view to all folders
Greetings, A user has numerous folders created under her Inbox in Outlook 2000. She woule like to create a custom view and then apply it to all folders automatically. I can create a custom view easily, but can't find a way to apply it to all folders other than on a one-by-one basis. Is there a way to apply the view to all folders at one time? Thanks much, Justin You can't apply it to all at once - unless you customize the Messages view. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Gu...

Downloaded Transactions not matching correctly, non-downloaded transactions showing up with 'E' status when they shouldn't
I recently did the cure-all of 'Remove all bills data' and I've regularly repaired my file. But I'm still seeing an issue of data not matching, and manually entered transactions mysteriously showing up with 'E' or 'Downloaded' status. Here's what I think is going on: 1) I enter a bill into my register. It shows up un-reconciled. 2) I download a statement from the bank, and this includes a transaction that matches the bill entered in step 1 perfectly (date, amount anyway) 3) I go into the register, and Money has *not* matched the downloaded to the ex...

Is there Smartlist Builder Template for GL Account Transactions???
I know from Partner Source Smartlist Builder templates can be downloaded, but I do not see one for the "Account Transactions" smartlist in the Financial series. Does anyone know if a Smartlist Builder template is available for download? We need to modify the canned Account Transactions smartlist using Smartlist Builder. Having a template would be very helpful instead of starting everything from scratch. Thanks!!! GP, On Disc 2 of the install CDs, in the Tools>Dex>Doc>PDF folder, there=92s a file called IG.pdf, which is the Dexterity Integration Guide. There=92s a se...

view applied?
What does the following WLM beta message mean? View applied not connected to imap4.xxxxxx.co.uk I had already clicked on this account and a couple of emails were downloaded. ...

payroll integration with payables
Hello, I keep reading about payroll integration with payables and I saw some screenshots of the "payroll vendor setup" window to set this up. However I am having difficulty finding documentation or "how to's" on this new feature or how to find it on GP10. Thanks, -- Greg. An update... I did find a cnk file that installs "payroll extensions" which gives you this feature. However, I am still trying to figure out how this prices out. Is this part of advanced payroll? (which costs extra). We are contacting microsoft and I'll give you an update. --...

I've applied a Fill and now can't see the gridlines....
Does anyone know how to show the Gridlines through a fill? I've searched and searched but can't find the answer, yet the silly thing is I know it can be done as I have done it before (by accident) Any help mostgratefully received! bestregards, Tim Apply borders... In article <62E1EA83-287A-4FE3-BEC6-7C0155EA1850@microsoft.com>, "FizzyBunghole" <FizzyBunghole@discussions.microsoft.com> wrote: > Does anyone know how to show the Gridlines through a fill? I've searched and > searched but can't find the answer, yet the silly thing is I know it c...

Not receiving email in outlook #2
About 1 month ago, Email was no longer being received in my Outlook inbox. I can still read my emails via Hotmail . After lots of frustration, I have not been able to resolve. Any suggestions? Chris Any error messages ?? Post it here . Also describe what happens --=20 Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. "Chris" <Chris@discussions.microsoft.com> wrote in message = news:D3FF1F7F-8A8A-465A-8023-67F0B0D054EC@microsoft.com... > About 1 month ago, Email was no longer being receiv...

M2005 Cannot Apply Epayment To Invoice
This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C4AD73.81F30C10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I create invoices for payments from customers. I have those = automatically charged to their bank accounts and credited to my bank = account. When the payments hit my bank account and are downloaded into = Money, I go into the transaction and enter "Payment For Invoice" and = then try to go to the apply payment to an invoice screen but a nice = little pop up comes up in Money 2005 that says &qu...

Cross Apply problem
How do I get the desired result for the following: SOURCE TABLE: USSoilLyr FIELDS: TAXOR PARTSIZE PCT_R Alfisols ashy 60 Alfisols ashy 57 Alfisols ashy 38 Alfisols clayey 85 Alfisols clayey 79 Andisols medial 50 Andisols medial 36 DESIRED RESULT (TARGET TABLE): T_Order FIELDS: TAXOR PARTSIZE PCT_R Alfisols ashy AVG(60+57+38) Alfisols clayey Avg(85+79) Andisols medial Avg(50+36) My T-SQL Code, as follows, returns wrong calculations when I manually check the results. UPDATE T_Order SET ...

Install V10 HR after applying service pack 3
I am currently on V10, SP3 and now have purchased the HR module. I am not sure of the steps I need to take to load the HR module (we have the V10 DVD that is not sp3) Are these my steps? 1. Load the HR module from V10 DVD on SQL Server install (I was told previously to use the Add/Remove programs option and change but it still asks for the DVD) 2. Do I need to reload SP3 on server install? 3. Then load the HR module (from V10 dvd) on additional workstations? If I have to re run the SP3 I am concerned it is going to take hours to complete like original instal of SP3 If anyone has a...

Apply Multicurrency Invoices in Bank Management
I oppened a ticket to know why I cant apply Multicurrency Invoices to payment transactions in Bank Managment as it is available in Payable Management. I've been suggested to post a suggestion for that. Simply, while doing a payment in Bank Management. If the Chequebook Currency is diffrenet than the invoices currencies that you are paying againist, then you can't apply these invoices. Thus, you cant see them in the remittance advice. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestio...

Transaction Report
Is any way to have a report by transaction Numbers ? Detailed Sales report includes Transaction Number. I believe it is hidden by default though - use Show/Hide columns to display it. -- -- Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information "JAL" <toto@telcel.net.ve> wrote in message news:Op18oiF9FHA.3592@TK2MSFTNGP12.phx.gbl... > Is any way to have a report by transac...

Payment for invoice in 2005 from downloaded transaction
I am trialing Money for small business and downloading transactions from bank, I am having probem with two things. 1. I try to reconcile the downloaded transaction and it doesnt work Account register-select transaction(show transacton forms) Deposit-From, category is Special - payment for invoice get the error message 'payment for Invoice is not a valid selection for this transaction' HELP PLEASE, I'm about to throw out the product. 2. when you do the above WHY dosent it split the transaction in the amount field to the amount/VAT....help again please > 1. I try to reconci...

unposted applied credits
how can list all unposted applied credits in AR. Thanks, Scott If you have SmartList Builder, you could use it to create a SmartList based on the Cash receipts work file. "Scott Rusoff" wrote: > how can list all unposted applied credits in AR. > > Thanks, > Scott > Create a report off RM10201 (RM Cash Receipts Work File). Add a restriction where Current Transaction Amount <> Original Transaction Amount. "Scott Rusoff" wrote: > how can list all unposted applied credits in AR. > > Thanks, > Scott > Which smartlist contains t...

I can receive but not send emails, using Outlook 2003 with AOL9
Am trying to configure Outlook 2003. AOL instructions seemed ok, and can now receive emails but when I try to send them, it says the connection to the server was interrupted. The AOL Q&A mentions this problem and says to reduce the regularity of send/receiving to over 11 mins. Have done this but its made no difference at all. If you've experienced this and come out the other side, I would gratly appreciate your suggestions. Thanks in advance I don't know if this will help, but read it through: http://www.slipstick.com/addins/SERVICES/online.htm#aol -- Kathleen Orland Outloo...

Payables issue with Applied Payments and Void Check
Hi, We had a user a number of months ago apply a number of Credit Memos from a vendor to a large invoice while creating a check. Apparently the check was then void, without a normal check number leaving us with "REMIT0000000000xx" as the reference to it. We now have a situation where the large invoice and all of the credits are still showing in the system as open. The individual credit memos do not show as having amounts applied, but when we try to apply them we're told that the amount is already applied. Everything seems to be stuck in limbo, with no way to post to resol...

local exchange users not receiving email
I've just loaded Exchange 2003 Server. We already had existing domain users in the domain so to create mailboxes for them I went into AD users and computers, selected the users object and right clicked on each user, selected Exchange tasks, then created each mailbox. That went very smoothly. However, no one is receiving email. They all send fine but do not receive. We do have a firewall and I have allowed SMTP and POP3 through the firewall. Presently we are not using Internet Email on the Exchange Server just internal email only. Can someone tell me why we can send locally...

Where do Originating Transaction Source values come from on Receip
I was looking at the records in the GL20000 (YTD Transaction Open) table for two Purchasing Receipt transactions. Receipt #1 has a TRXSORCE value of 'GLTRX00019321' and a ORTRXSRC value of 'GLTRX019320'. Receipt #2 has a TRXSORCE value of 'GLTRX00016391' and a ORTRXSRC value of 'RECVG00000679'. Why would they have different ORTRXSRC origins (i.e., GLTRX for Receipt #1 and RECVG for Receipt #2)? -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 Receipt 1 may have 2 explanatio...

Error 0x80040118 when sending/receiving
Any clue what error 0x80040118 (unknown error) is. I get this on a pop3 account in Outlook 2002. I have googled it and didn't find anything. Thanks What is happening when this error occurs? -- Kathleen Orland Outlook Tips: http://www.outlook-tips.net/ http://www.howto-outlook.com/ "tk" wrote: > Any clue what error 0x80040118 (unknown error) is. I get this on a pop3 > account in Outlook 2002. I have googled it and didn't find anything. > > Thanks > > > ...

How to apply a weighting
I'm trying to apply a weighting to my teams to allow for experience and size I have 3 teams which are different sizes and are different skill levels. Level 5 is the lowest skill level and level 1 being the highest skill level. Team size/level5/level4/level3/level2/level1 6/3/2/0/1/0 10/2/3/4/0/1 7/0/2/3/1/1 How do I apply a weighting to these numbers to allow for team size and experience. Can I do this using sumproduct? I tried looking at this but cant get my fragile little mind around it Thanks in advance. -- Homer J ---------------------------------------------------------------...

Able to receive mail from domains but not send to them
We have a front-end / back-end Exchange 2003 Standard setup - with Exchange SP1. The front-end server basically has no problems with sending and receiving mail except for one external domain. The servers can receive email from the external domain with no problems but cannot sent email to it. The outbound email stays in the outbound queue in retry state. What should I be looking for or what should I ask the administrator on the external domain to look for to fix this problem? Thanks, Francis Palacio Thank you, Francis Palacio - Check SMTP logs - Can your server resolve fqdn of remot...

Mass apply or batch apply sales documents?
Is there any way to avoid manually applying payments one by one? Our current process is that we have a cash receipt batch of payments that have declined, and on a daily basis, it is reauthorized. When the payments are approved, the payments are posted without applying the payment to the invoice first. We are using GP 10. Thanks, Erin Erin, There are several third party programs that address this issue very well. Do a search on the internet and you shall find them. Best regards, Leslie Vail "Erin Black-Mitchell" wrote: > Is there any way to ...

adding business name of customer to invoice
Can I customize my invoice design to show the business name in addition to the customer name in the address area on the invoices? This is not one of the check box options. (Why not?) Tazz3L wrote: > Can I customize my invoice design to show the business name in > addition to the customer name in the address area on the invoices? > This is not one of the check box options. (Why not?) Are you talking about an invoice created in Microsoft Money (what version and type?) or Microsoft Access the database problem? -- Joseph Meehan Dia duit Joseph Meehan wrote: > Tazz3L wr...

Apply CF to Row after CF was applied to Column
Can someone please help me? I've read through the postings and the help files but still can't seem to figure out how to do this. I've applied conditional formatting to the J column of my spreadsheet so that if there's any text listed the cell turns yellow. What I'd like is if not only the cell but the row, from A:O turned yellow also. How do you do that? I'm using 07. Any help in English walking me through the steps or a hint toward the appropriate post would be greatly appreciated. Cuz I aint figrin it out on myown! Thanks in advance! --Dax...