Invoice Already Entered, But Won't Allow Me to Find It

I am trying to confirm and invoice entered into Sage 50 2015 and it keeps saying it cannot find it by the Invoice number, or Company name and the date is within the search criteria. At first I thought I had forgot to enter it or missed it some how and tried to re-enter it only to be given an error message stating that the invoice number had already been used. 

When I go into the companies statistics, I can see the total amount does include the amount from the statements I am trying to bring up. 

Any help would be greatly appreciated.

Parents
  • 0

    have you tried searching for the invoice, in the quick search box ?

  • 0 in reply to Roger L

    Hi Roger,

    I have tried that and it shows a new window saying "no data to report"

  • 0 in reply to KRAT

    reports, journal entries, all, pick current fiscal year
    once report is displayed, control-F to find, type invoice# followed by a comma, find next

    if not found, pick and find in next fiscal year, and last fiscal, etc

  • 0 in reply to Roger L

    Okay so I was able to find it from doing a report on the company name though I still cannot find it when I look for it in "Adjust invoice" or "Find Invoice" under payables.

  • 0 in reply to KRAT

    Run the aging report. Find the invoice in the list and double click on the invoice #.

  • 0 in reply to AmyGurl

    I have tried that and it gives me an error stating "there is no data to show"

  • 0 in reply to KRAT

    if you create a 0.00 invoice and pay it, a journal entry is created but the invoice is not created

    so you can find the JE but you can't open the invoice to view/change it - you get the 'no data' message

    I created a feedback suggestion a while ago to fix this (bug or by-design) problem by creating an invoice

  • 0 in reply to Roger L

    It does have a balance and is not 0.00 but it shows it as 2,825.00.  

    I did see that but did not think it would apply to an invoice with an amount as you mentioned it for 0.00 balance.

  • 0 in reply to KRAT

    We often have a similar problem.  If you create an invoice to a customer, it seems to be in the system but does not show up if you try to receipt payment of it.  For example, if we receive a check from a customer that includes interest on statement (and interest has not been posted) we create an invoice for the interest, when we go into receipt the payment the interest is not there.  It does show up eventually but we have found that if you leave it for awhile (time varies on each) it will eventually show up.  We have tried closing out of Sage and logging back in, but that doesn't work.  I haven't tried having everyone log out because that is way to time consuming. In this situation, I can find the invoice, just can't receipt it.

  • 0 in reply to Moonball

    what report, using company name, allowed you to find the purchase invoice ?
    now that you have an invoice date, can you find it by date or journal entry or amount ?

  • 0 in reply to Roger L

    It was a vendor aged report under payables, I did use the company name and it shows its there but when I go into "find invoices" no matter how much information I fill out it still gives me an error that it cannot find the invoice i'm looking for with the data given.

  • 0 in reply to KRAT

    that's the same as right-clicking on the supplier, and selecting the report from the list, the source column is the invoice#

    now, that you have an invoice date, if you search journal entries per my Nov 18th post, reported/filtered by date

    including corrections, is the entry found ?

  • 0 in reply to Roger L

    Okay so when I attempt to find it in journal entries, I cannot it. Though it was paid in this fiscal year. I did try the suggestion you gave but I still cannot bring up the invoice by search and I can't find it by journal entry either so I am unable to bring it up by the journal # to adjust anything.

  • 0 in reply to KRAT

    If all the journal entry lines sum up to zero, no invoice journal entry is created.

    If the invoice had an amount, and was *PAID* in the current fiscal year, open the payment screen, and double-click on the invoice number.  

    If that doesn't work, probably the invoice was later deleted, adjusted, or 'cleared'.

    An invoice that does not result in a journal entry can be created, but can't be deleted or adjusted.  Happens here every couple weeks - someone converts a Sales Order to an Invoice, then the phone rings before they fill any quantities, and they hit 'post'.

  • 0 in reply to RandyW

    but Randy, Krat indicated about that the invoice amount is 2825$, so there should've been an invoice

    that's why I suggested including corrections in the journal entry search - in case the invoice was reversed after it had been created, which would show two entries (the creation and deletion) - instead of three entries when an invoice if updated (creation, reversal, adjustment)

  • 0 in reply to Roger L

    There was most definitely an invoice, at the time that it was paid.  

    Invoices entered under 'Make Other Payment' behave a bit strangely, so it could have been one of those.

    If it was reversed, there would be a 'credit note' entry.  

    If the invoice was 'cleared', there would not be any entry, no way to adjust, no way to 'drill down'.

    The program's refusal to 'drill down' can have at least those three possibilities, and that's if nothing went wrong.

    If the original poster would be very specific about exactly what screen is open, what actions are performed, and the result, it would be easier to understand the situation.  

  • 0 in reply to RandyW

    Krat - you said the invoice balance is 2825.00 - enter that amount in the Search box. I know you have tried that with the invoice nbr but do it again with just the dollar amount (no comma needed)

    Also do the Control-F with 'all Journal entry' report (be sure to check show 'corrections') but again type in just the dollar amount - I'm hoping you will find that amount followed by a correction or reversal or?? that will explain why you cannot pull it up.

  • 0 in reply to Smith and Co

    Hi smithco,

    I did try searching just the amount and no luck.

    Control F was the first thing I did try but I will try again and see if anything has changed.

    I am not sure why I cannot pull it up but can see it in the reports but hopefully there is a way to find it.  Thank you everyone for your suggestions, I will continue to try and find it.

Reply
  • 0 in reply to Smith and Co

    Hi smithco,

    I did try searching just the amount and no luck.

    Control F was the first thing I did try but I will try again and see if anything has changed.

    I am not sure why I cannot pull it up but can see it in the reports but hopefully there is a way to find it.  Thank you everyone for your suggestions, I will continue to try and find it.

Children
No Data