Forum Discussion

mitchf2's avatar
mitchf2
Contributing User
5 days ago

Phantom Purchases

I need help with a phantom purchase.  I was converting purchase order deposits to bills and somehow a transaction involving 4 bills paid in one became a transaction involving 5 bills that were transferred from "deposits with vendors" to "trade creditors".  So after converting every deposit paid, there is still a balance in "deposits with vendors" and I've got no idea how to get rid of the balance.  I can't delete the phantom bill because it's got a payment against it, even though it wasn't paid through the bank account.

 

I'm trying to work out whether creating a negative purchase order will work... I'm not sure how I could record a payment against it, given that the phantom bill wasn't paid through the bank, even though it looks as if it was. The bank account is reconciled so somehow the bill is recorded as paid without actually having been paid.

 

Any help will be greatly appreciated.

5 Replies

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    4 days ago

    Hey mitchf2,

     

    While you can't reduce or remove the amount on the converted bill (since that's all tied up with the original deposit), what you can do is pop in a negative bill for that supplier. That’ll boost your trade creditors and square off the leftover balance in “deposits with vendors” without having to unravel the whole payment history. You can check this link for more info.

     

    Cheers,

    Doreen

  • mitchf2's avatar
    mitchf2
    Contributing User
    4 days ago

    Hi Doreen,

    Thanks for the reply.  I tried that but it didn't have the effect that I need.  While it fixed the expense accounts, it decreased the creditors but left the  "deposits with vendors" untouched.

     

    At this point I've created a negative purchase order, but that doesn't appear in either the deposits with vendors or creditors account, as far as I can see, until it is "paid" and/or converted, it is just listed under the "Purchase orders" list.

     

    I think my main problem is that the amount was never paid as such.  I don't know how (or why) the system just decided for itself that the purchase order that it created out of nothing, was actually paid, so it increased the amount received without increasing the payment in the bank account.  If I could work out what it did, I'd have a chance of reversing it, but at the moment I'm lost.

     

    I've attached a screenshot of the trade creditors without any adjustments, as you can see, the transactions balance each other, but the Deposits with vendors is out by that phantom amount.  I've also attached screen shots of the deposits with vendors transactions and the payment to the supplier.  You can see that the payment to the bank remains unchanged, but the "payment" in the "Payment to supplier" window has increased by the phantom amount.  Do you have any idea where the other side of the "payment" would have gone, if not to the bank account?

     

    Thank you for your help.

     

    Michelle (mitchf2)

     

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    4 days ago

    Hi mitchf2

     

    Thanks for explaining. Sounds like that deposit popped up out of the blue. Just so you know, the software can’t actually add a deposit to transactions, so the quickest way to check where the payment came from is to jump into the purchase order and bill’s transaction windows. Have a look at the Activity section, that’ll show whether the deposit came from the purchase order you converted, or maybe it’s linked to a different invoice altogether.

     

    If you’re still scratching your head or want to chat about ways to sort it out, you can pop in a support ticket from your MyAccount window, or have a yarn with our live chat team through MOCA, our virtual assistant.

     

    Regards,

    Genreve

  • mitchf2's avatar
    mitchf2
    Contributing User
    4 days ago

    I've sent a support request, thanks Genreve.  I hope they can help.

     

    The payment to supplier just says "Transfer from deposits" which I understand, but the problem is that there's no payment in the "Deposits with vendors" account to offset that amount, which is why there's a credit balance at the end.

     

    Hmmm... It gets curiouser and curiouser!  If I generate a remittance advice from the "Payment to supplier" window, the phantom bill disappears and the correct figures are there.  It seems that MYOB knows, deep inside its soul, that it has done the wrong thing! :-D

     

    Regards,

     

    Michelle

     

  • mitchf2's avatar
    mitchf2
    Contributing User
    4 days ago

    I've sent a support request, thanks Genreve.  I hope they can help.

     

    The payment to supplier just says "Transfer from deposits" which I understand, but the problem is that there's no payment in the "Deposits with vendors" account to offset that amount, which is why there's a credit balance at the end.

     

    It gets curiouser and curiouser!  If I generate a remittance advice from the "Payment to supplier" window, the phantom bill disappears and the correct figures are there.  It seems that MYOB knows, deep inside its soul, that it has done the wrong thing! :-D