Vendor Payment Problem

Hi all,

I have strange problem:

For example I have
Vendor Doc #5649
Amount 882.20
Discount Due Aug 01
Discount Amt 8.82

I paid using "Pay Vendors" on August 04 and after I checked I found


Discount Taken 8.82
Paid Amount 873.18

I owe 20 cents

2 problems:
1st: Discount shouldn't be applied due to I missed due date
2nd: Discount and Payment are incorrect, 20 cents differene.

Thank you for your help 


0
vitvov (85)
8/14/2008 8:02:01 PM
greatplains 29623 articles. 5 followers. Follow

7 Replies
808 Views

Similar Articles

[PageSpeed] 10

Vitali:

Not sure about the .20 unless there is a currency exchange problem.... but 
the terms discount can be taken even after the discount date has passed.  
There is an option that is most likely checked on the Select Checks window to 
take Non Qualifying Discounts.

"Vitali V" wrote:

> Hi all,
> 
> I have strange problem:
> 
> For example I have
> Vendor Doc #5649
> Amount 882.20
> Discount Due Aug 01
> Discount Amt 8.82
> 
> I paid using "Pay Vendors" on August 04 and after I checked I found
> 
> 
> Discount Taken 8.82
> Paid Amount 873.18
> 
> I owe 20 cents
> 
> 2 problems:
> 1st: Discount shouldn't be applied due to I missed due date
> 2nd: Discount and Payment are incorrect, 20 cents differene.
> 
> Thank you for your help 
> 
> 
> 
0
8/14/2008 8:43:01 PM
We don't have any currency except USD.

"Dan Shepherd" <DanShepherd@discussions.microsoft.com> wrote in message 
news:8EBB2489-67AE-4F19-9FB8-6E0A129681A0@microsoft.com...
> Vitali:
>
> Not sure about the .20 unless there is a currency exchange problem.... but
> the terms discount can be taken even after the discount date has passed.
> There is an option that is most likely checked on the Select Checks window 
> to
> take Non Qualifying Discounts.
>
> "Vitali V" wrote:
>
>> Hi all,
>>
>> I have strange problem:
>>
>> For example I have
>> Vendor Doc #5649
>> Amount 882.20
>> Discount Due Aug 01
>> Discount Amt 8.82
>>
>> I paid using "Pay Vendors" on August 04 and after I checked I found
>>
>>
>> Discount Taken 8.82
>> Paid Amount 873.18
>>
>> I owe 20 cents
>>
>> 2 problems:
>> 1st: Discount shouldn't be applied due to I missed due date
>> 2nd: Discount and Payment are incorrect, 20 cents differene.
>>
>> Thank you for your help
>>
>>
>> 


0
vitvov (85)
8/15/2008 2:44:45 PM
Vitali,

I don't believe there is a 'Pay Vendors' in GP, are you using SBF?

-- 
Victoria Yudin
Dynamics GP MVP
Flexible Solutions - home of GP Reports
http://www.flex-solutions.com/gpreports.html


"Vitali V" <vitvov@dynamo-ny.com> wrote in message 
news:OjUx8Uu$IHA.5068@TK2MSFTNGP02.phx.gbl...
>
> We don't have any currency except USD.
>
> "Dan Shepherd" <DanShepherd@discussions.microsoft.com> wrote in message 
> news:8EBB2489-67AE-4F19-9FB8-6E0A129681A0@microsoft.com...
>> Vitali:
>>
>> Not sure about the .20 unless there is a currency exchange problem.... 
>> but
>> the terms discount can be taken even after the discount date has passed.
>> There is an option that is most likely checked on the Select Checks 
>> window to
>> take Non Qualifying Discounts.
>>
>> "Vitali V" wrote:
>>
>>> Hi all,
>>>
>>> I have strange problem:
>>>
>>> For example I have
>>> Vendor Doc #5649
>>> Amount 882.20
>>> Discount Due Aug 01
>>> Discount Amt 8.82
>>>
>>> I paid using "Pay Vendors" on August 04 and after I checked I found
>>>
>>>
>>> Discount Taken 8.82
>>> Paid Amount 873.18
>>>
>>> I owe 20 cents
>>>
>>> 2 problems:
>>> 1st: Discount shouldn't be applied due to I missed due date
>>> 2nd: Discount and Payment are incorrect, 20 cents differene.
>>>
>>> Thank you for your help
>>>
>>>
>>>
>
> 

0
victoria (3340)
8/15/2008 3:23:20 PM
Yes,  this is SBF.


"Victoria [MVP]" <victoria@flex-solutions.com> wrote in message 
news:eNg20vu$IHA.1224@TK2MSFTNGP02.phx.gbl...
> Vitali,
>
> I don't believe there is a 'Pay Vendors' in GP, are you using SBF?
>
> -- 
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions - home of GP Reports
> http://www.flex-solutions.com/gpreports.html
>
>
> "Vitali V" <vitvov@dynamo-ny.com> wrote in message 
> news:OjUx8Uu$IHA.5068@TK2MSFTNGP02.phx.gbl...
>>
>> We don't have any currency except USD.
>>
>> "Dan Shepherd" <DanShepherd@discussions.microsoft.com> wrote in message 
>> news:8EBB2489-67AE-4F19-9FB8-6E0A129681A0@microsoft.com...
>>> Vitali:
>>>
>>> Not sure about the .20 unless there is a currency exchange problem.... 
>>> but
>>> the terms discount can be taken even after the discount date has passed.
>>> There is an option that is most likely checked on the Select Checks 
>>> window to
>>> take Non Qualifying Discounts.
>>>
>>> "Vitali V" wrote:
>>>
>>>> Hi all,
>>>>
>>>> I have strange problem:
>>>>
>>>> For example I have
>>>> Vendor Doc #5649
>>>> Amount 882.20
>>>> Discount Due Aug 01
>>>> Discount Amt 8.82
>>>>
>>>> I paid using "Pay Vendors" on August 04 and after I checked I found
>>>>
>>>>
>>>> Discount Taken 8.82
>>>> Paid Amount 873.18
>>>>
>>>> I owe 20 cents
>>>>
>>>> 2 problems:
>>>> 1st: Discount shouldn't be applied due to I missed due date
>>>> 2nd: Discount and Payment are incorrect, 20 cents differene.
>>>>
>>>> Thank you for your help
>>>>
>>>>
>>>>
>>
>>
> 


0
vitvov (85)
8/15/2008 8:21:33 PM
Update:
I took backup and did the same procedure on another server and it was 
working fine.

Any ideas? Thanks.

"Vitali V" <vitvov@dynamo-ny.com> wrote in message 
news:OCSrkhk$IHA.3884@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I have strange problem:
>
> For example I have
> Vendor Doc #5649
> Amount 882.20
> Discount Due Aug 01
> Discount Amt 8.82
>
> I paid using "Pay Vendors" on August 04 and after I checked I found
>
>
> Discount Taken 8.82
> Paid Amount 873.18
>
> I owe 20 cents
>
> 2 problems:
> 1st: Discount shouldn't be applied due to I missed due date
> 2nd: Discount and Payment are incorrect, 20 cents differene.
>
> Thank you for your help
> 


0
vitvov (85)
8/15/2008 8:22:11 PM
Try running Checklinks. (File >> Data Maintenance >> Checklinks)
-- 
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
8/15/2008 4:53:31 PM


Vitali V wrote:

> Update:
> I took backup and did the same procedure on another server and it was
> working fine.
> 
> Any ideas? Thanks.
> 
> "Vitali V" <vitvov@dynamo-ny.com> wrote in message
> news:OCSrkhk$IHA.3884@TK2MSFTNGP03.phx.gbl...
> > Hi all,
> > 
> > I have strange problem:
> > 
> > For example I have
> > Vendor Doc #5649
> > Amount 882.20
> > Discount Due Aug 01
> > Discount Amt 8.82
> > 
> > I paid using "Pay Vendors" on August 04 and after I checked I found
> > 
> > 
> > Discount Taken 8.82
> > Paid Amount 873.18
> > 
> > I owe 20 cents
> > 
> > 2 problems:
> > 1st: Discount shouldn't be applied due to I missed due date
> > 2nd: Discount and Payment are incorrect, 20 cents differene.
> > 
> > Thank you for your help
> > 
0
japheth (84)
8/15/2008 8:53:59 PM
I did it a lot of times and it's not helping...

"Japheth Nolt" <japheth@landiscomputerLC.dot.com> wrote in message 
news:xn0ftyny4dl6qz000@msnews.microsoft.com...
> Try running Checklinks. (File >> Data Maintenance >> Checklinks)
> -- 
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 8/15/2008 4:53:31 PM
>
>
> Vitali V wrote:
>
>> Update:
>> I took backup and did the same procedure on another server and it was
>> working fine.
>>
>> Any ideas? Thanks.
>>
>> "Vitali V" <vitvov@dynamo-ny.com> wrote in message
>> news:OCSrkhk$IHA.3884@TK2MSFTNGP03.phx.gbl...
>> > Hi all,
>> >
>> > I have strange problem:
>> >
>> > For example I have
>> > Vendor Doc #5649
>> > Amount 882.20
>> > Discount Due Aug 01
>> > Discount Amt 8.82
>> >
>> > I paid using "Pay Vendors" on August 04 and after I checked I found
>> >
>> >
>> > Discount Taken 8.82
>> > Paid Amount 873.18
>> >
>> > I owe 20 cents
>> >
>> > 2 problems:
>> > 1st: Discount shouldn't be applied due to I missed due date
>> > 2nd: Discount and Payment are incorrect, 20 cents differene.
>> >
>> > Thank you for your help
>> > 


0
vitvov (85)
8/19/2008 2:50:07 PM
Reply:

Similar Artilces:

Have multiple price breaks for a vendor
When we order products from a vendor we can save money by ordering maybe 100 at a time versus 1 at a time. There is no way in the system to enter multiple price breaks for a vendor. If we order 200 we may even get a cheaper price. ---------------- 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 mess...

moving to the next cell problem
I have a problem moving to the next cell using the arrow to the right button, and i can use the left arrow key to move back. Can anyone help it was just working a while ago, is there some option i need to reclick? no the problem is that i cant move right and left with the arrow buttons but i can with tab >-----Original Message----- >always use the down arrow first, then, move to the >desired cell. > >>-----Original Message----- >>I have a problem moving to the next cell using the arrow >>to the right button, and i can use the left arrow key to >>mo...

Mortgage Int. Payment not in Budget
I have a "Bill" setup for mortgage payments. The interest payments show correctly in my budget when I view "Transactions" for that budget item but the screen report and the printed report both show no "Actual" expense. I do have my mortgage setup as an account. I have other "Bill" expenses that work correctly with my budget. How can I get the "Transaction" figures to show in the "Budget? More about my problem. The "Actual expenses" do show up in a category named "DEBT". I actually have two mortgages to track. One m...

Problem with formula IF(C5="", "",NOW())
I use IF(C5="", "",NOW()) to reflect the date of entry but it changes every time with new day..how to prevent it? in other words, if i entered smth yesterday in C5 so that for example in c4 it shows 15/02/05 so I want C4 be the same tomorrow as well, not change C4 to tomorrow's date! You can do it with event code Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A5:Z5")) Is Nothing Then With Target .Offset(-1, 0).Value = Now ...

Recipient Policy Problem #2
Hello, I have a problem with the Recipient Policy. I've added new SMTP address to Default Policy last 2 week. Now, I need to remove it because I will only give access to certain OU on using that new SMTP address. I remove the SMTP address from Recipient Policy but that changes does not remove the SMTP address from user email properties in AD. I decide to remove all SMTP address using ADModify tool from MS and yes I successfully remove that SMTP address. Now, I want to apply that SMTP address for the OU that I've created and set it as primary address, but seems like there is no changes...

Junk/Relay Mail Problems...Help!!
I keep receiving junk mails, like the one below, everyday. The majority though, are from Microsoft Security Update. Can someone help me figure out whats going on. I am running Exchange 2000/Windows 2000 Server and I have Trend Officescan/Trend Server Protect in place. I also have a Watchguard Firebox 2 in place. I know that I had a couple instances of MY_DOOM in a few mailboxes, but I've cleaned those, using a trial version of Trend Scanmail. The mail below I think is being relayed through my exchange server, correct me if I'm wrong. From: Inet Message System [mailerengine@yahoo....

GetFtpConnection::SetCurrentDirectory problem
I use GetFtpConnection and being connected to my own PC. Then I use GetFtpConnection::SetCurrentDirectory("..\\") to navigate to the parent directory. The return value is 1 - means OK, but when I get files its always the same files , as if the directory was not changed. I have tried a few variation of parameters but nothing helps. Can someone help please? Regards Geler I gorgot to note that that after using GetFtpConnection::SetCurrentDirectory("..\\") I used GetFtpConnection::GetCurrentDirectory(currenetDir) and get always the answer "/". "Geler"...

Vendor Statement
Dear Sir, We are looking to have Vednor Statment to be print showing Begining Balance All transaction withini selected period and closing balance. ---------------- 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...

Rules Problem (blank emails)
I use Outlook 2003 and every day I receive several totally blank emails. I want to create a rule to filter them to my Deleted Items folder, but I can't see how to do it. The Rules Wizard always wants some actual value to work with and you can't insert "nothing" as a criterion (i.e. ""). I would be grateful for any suggestions. Tony Shrapnel "Tony Shrapnel" <shrapnel@ozemail.com.au> wrote in message news:16MBd.99518$K7.50922@news-server.bigpond.net.au... >I use Outlook 2003 and every day I receive several totally blank >emails. I want...

Add vendor balance to "Payables Transaction Inquiry
When doing Inquiry > Purchasing > TRX by vendor, show the outstanding balance due the vendor when a vendor is selected. ---------------- 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?mi...

Rounding Problem 03-24-10
Access 2003 I'm off by a penny. Debit and Credit rows in the table are currency, 2 decimals. Here's the query: SELECT tblARINH.Custkey, tblARINH.Date AS TransDate, tblARINH.Key AS TransKey, tblARINH.InvNo AS [Number], tblARINH.ChkNo, tblARINH.Desc, tblARINH.Debit, tblARINH.Credit, ====> Round(DSum("Debit","tblARINH","CustKey=" & [CustKey] & "And [Date]<=#" & [Transdate] & "# "),2) AS RunDeposit, ====> IIf(IsNull(DSum("Credit","tblArinh","CustKey=" & [Cus...

Payment History
Hello, Has any imported payment history into GP? I would appreciate if some one could me some info on how to import and what tables are involved. I thought I could use manual payment entry screen but the amount is sitting as unapplied for that vendor. Please advice. Thanks There is no elegant way of doing this. You can use Integration Manager to import the invoices, post the invoices (without impacting GL) then import the payments with the invoice apply information. Since the invoices are closed and the payments are closed in real life, then all these documents should make it to histor...

hyperlink problems
Sometimes I create one email... copy it and paste it into new emails.. and when it's pasted I always get this same problem.. Here is an example of the error wlmailhtml:{1CCDD8F0-9573-4BA1-A7CD-5578123C3193}mid://00000068/!x-usc:http://www.jlfood.com/ When what it should just be a link to www.jlfood.com The original email is fine... it's just when copied and pasted it changes.. ...

Hyperlink problems
I am running Excel 2007. I have a spreadsheet that I have hyperlinks to .BMP files. I have my computer setting to use MS Picture Viewer as default program, but when I click the link from within Excel it uses MS Paint to open the file. How can I set it to be MS Picture Viewer? 1. Open Folder Options in Control Panel. 2. Select "File Types" tab. 3. Select BMP from "Extensions" and press "Advanced" button. 4. Select "Open" from "Actions" and press "Edit" button. 5. Type Picture Viewer pass or select Picture Viewer exe file (o...

Removing a Payment from the Reconcile to GL Spreadsheet
Hello: There is a payment that, oddly enough, is in receivables history according to inquiry windows but is not applied to any invoices. Evidently, either the client at one time had previously removed transaction history or a glitch occurred on the network that caused this. The payment is not showing on the Receivables Historical Aged Trial Balance or on the General Ledger Detailed Trial Balance. It is showing, however, on the Reconcile to GL spreadsheet that is available in GP 10.0 in the Financial Routines section. We would like to get this "hung up" payment ...

Temporary Vendors/Vendor History
We are using Great Plains v7.5. In one of our Company ID's we have 1777 vendors, of which 690 of them are Temporary Vendors - which are only used once, possibly twice. I know I can delete these vendors and still inquire in: 'Inquiry, Purchasing, Trx by Document' BUT the Vendor Name shows as "Vendor not found" and I'd still like to have that information. Is it possible to save Temporary vendors and their accompanying transaction history (possibly in Excel, although I'm open to other suggestions)to CD. Thanks Chris Chris Chris, I believe that the temp ...

Sending Problems
Hello Sirs, I have a problem sending mail with outlook 2k from two stations in my network. all other station work fine. From those two station, the outlook configures that it alone sends and recieves mails and pushes them to the exchange server. when i try to send mail to some recipents, the mail doesn't come out from the pop settings in the "E-mail Account Settings" in the station, and goes directly to the SMTP Queue int the exchnage, there he stays. If I try to rightclick on the SMTP node, i have an error massage that says "SMTP protocol error". whta should i ...

Problems copying XLA file
In MAIN.XLS I check to see if the MACRO.XLA file on a network drive is more up to date than the file in Application.UserLibraryPath. If it is more up to date, I want to update / copy over the old file in user lib. If I attempt to copy the XLA and it is currently open, I get an Error = 70 (Permission denied) on the source of the copy. So I added a macro to the XLA (Force_Close_XLA) which simply closes the XLA. BUT when I do this the sub routine in MAIN.XLS ends following the execution of Force_Close_XLA. Is it possible to copy an open file or retain contol in MAIN.XLS? MACRO.XLA: Sub ...

Trasfers and Credit Card Payments
I currently download all transactions from my bank and do not manually enter trasactions. However, I have to manually classify transactions. I have a chequing, VISA and line of credit account. I transfer money from the chequing into various accounts (and sometimes money from the line of credit into other accounts). How should I classify these transactions? When I used the transfer classification it started to incorrectly adjust account balances. Is there a tutorial or FAQ on using Money or recommended books? When you say "classify" these transactions, I assume you mean &qu...

Payables Transaction Entry, change vendor
When I am in Payables Transaction Entry, it would be nice if I could change the vendor without having to delete the voucher. As it is now, the last vendor used is what pops up in the Vendor field. so you have already put in the date and the description and the Invoice # and if you accidentally tab the last used vendor name pops in and you have to delete the entire transaction and start over. If we had the option to change the vendor name without deleting it, it would save a lot of time. -- Sheri Salomone for Margaret Lopez THANKS! ---------------- This post is a suggestion for Micros...

Problems Installing Divx
My computer crashed and I'm trying to install Divx codec. I thought I only needed the codec but the file would not play so I downloaded all four components. Now it will play in the Divx player but as soon as I set WMP as my default I get a message the WMP does not support the file. They are all ..avi files. Just to test, I tried the same files on another PC and they play fine. Can anyone suggest what I need to do? Not sure if my last post went through, but just in case, try asking for help on the forum at DivX Labs: http://labs.divx.com since this is where DivX people hang o...

voiding a partially applied payment
The only work around for this currently is to process a dummy invoice for the reminder of the payment to fully apply it, then void both the payment and the dummy invoice. Really don't want to be creating dummy invoices to have to void a payment - there must be a better way. ---------------- 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 Newsrea...

Show Payment Check Number on Statements?
I've been asked to modify the standard statement report to include a check number for payment transactions that were processed during the reported period. The Statement report currently uses a Description Field thats empty for PMT records. It looks like the detail lines are from a temporary table named RM_Statements_TRX_TEMP and none of the fields in that table appear to posses the check number. Is there an easy way to accomplish this or am I going to have to modify the report (add tables, conditional field for description, etc.) to display those pesky check numbers. VinceV ...

Credit Card Payments #4
I have a question that I hope someone can answer... I put almost all expenses every month to a credit card then every payday I pay off the balance due. I put each of these charges into MS Money under the Credit Card account and put them in groups (clothing, food, etc) as appropriate. Then I pay the credit card and it is put into MS Money as a "credit card payment/transfer" This is all fine, except when you go look at the "reports/spending by catagory" it is showing that my largest expense is "Credit Card Payments/Transfers" This is not really an expense so I ...

Page format problems
Page prints differently when spreadsheet is printed from desktop using WIN98SE (Excel 2000). Document was created in Excel 2000 on a desktop using WIN2000. Could someone help and explain why. Printer is LJ5Si. Do we need to upgrade to WIN2000 on all desktops. Running NT4.0 on server???????? Thanks Is it stuff like margins being slightly off? If yes, then I'm gonna guess that it's a printer driver difference (and that's just a guess). I bet that Win98 and win2k have different drivers (even for the same printer). You may want to visit the HP site and see if there's...