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 Reply
  • 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'.

Children
  • 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.