How i can edit my historical payment

SOLVED

i am new in sage 50 and I have to make a new company and for outstanding supplier  added the invoice and the amount is wrong in historical payment and case my  balance is wrong  now how i can fixed it

  • 0
    SUGGESTED

    There is a short way to fix this (#1 below) and a longer way (#2 below).  I always use the longer way.

    1a) While still working on the history tab of your vendor, record a payment against the invoice using the Payments button.  In the Vendor Aged Detail report you will see the invoice and a payment against it showing it is no longer outstanding.

    1B) Then you can re-enter the invoice with the correct information.  If the invoice number was correct before you will have to enter a space or zero before or period or something like that after to make it accept the new invoice.  The wrong invoice will exist in the file forever.

    2a) First do the same as #1a above.

    2b) Backup your file

    2c) Select Maintenance, Clear Data, Clear Paid Transactions, Clear Paid Vendor Transactions, select the vendor, select the date range and click OK (with historical transactions there is no invoice look up).  This will get rid of the incorrect one you paid and then you can re-enter the correct invoice.

  • +1
    verified answer

    My question is i did mistake in the customer receivable amount owing and discount and base of you explained  to me, i did  but, i think i did wrong  because the amount owing or amount  must be 197690 and after  i corrected  it is 157690 instead of that197690 . Maybe ,because i added discount 222 and total amount is get less . Now how i can change my owing  balance in customer invoice? please explain very clear to me. i choose  second way that you explained go to maintenance after that clear data  and  the rest you said that .i have only one invoice number and one  Cheque number and amounts .I can't do invoice number because already exist. only i can change from cheque number. now how i can  change back amount to the correct amount  that should be 197690. i really appreciate to answer me right now.

  • 0 in reply to farah Mo

    Sorry, you indicated a supplier in your first message, so I assumed you were making a purchase entry.

    However, the steps are the same but change Vendor to Customer in my instructions.

    I don't think a discount posted as part of the entry makes any difference, you just need to pay it in full, clear it so it is deleted and then put it back in again.  If the program is indicating that the invoice exists, then it was not paid in full and cleared. 

    I have made the assumption when you indicated an historical entry, that you are still in history mode.