Microsoft Dynamics GP (Archived)

HOW TO REMOVE FROM AGING OF A SUPPLIER PAID INVOICE

(0) Share

Report

Posted on by zulfi721

Here iam trying to remove the remove the payment of 950 against an invoice of 950....

but it is not appearing in the Transaction>Purchasing>Apply payable documents....

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Suggested answer

Tom Cruse 1,477 on at

Like (1)

Report

You can't just unapply a payment, You'll have to goto Void Historical Transactions to do this. Voiding the payment will reopen the invoice and place it back in the open status, I'm hoping that's the result you're looking for.

Transactions >> Purchasing >> Void Historical Transactions

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Zulfi,

I think you wanted to apply the 950 to the invoice to remove it from the aged trial balance. After going to Transaction->Purchasing->Apply payable documents press the lookup button above the document type payment and select the 950 from the list, once you select apply against the invoice which will be listed on the same window.

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (1)

Report

Hi,

Confusion here is that you don't want to show 'fully paid' transactions into your aging or you really want to void your transactions.

If you want don't want to show Fully Paid transaction from your report just check 'Exclude Full Paid Documents' and it won't show it in your Aging. Otherwise follow other bloggers suggesstion i.e. voiding transactions.

Thanks

Sandip

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Hi babu,

thx for the help...

iam using the same way but in look up this invoice of 950 is not appearing but when i go to view the aging both invoice and payment are appearing in it.

i have used the filter exclude fully paid invoices...but this is still there....

Was this reply helpful? Yes No
Verified answer

Ian Grieve 22,784 on at

Like (1)

Report

You're running the Historical TB, but I can't see the date you're running it for. That might be why the report is including the invoice and payment.

Try running the normal Aged TB which will show the transactions as of now.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Zulfi,

Did you type the creditor ID before press the lookup button please share the screen shot of the apply payment window.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

screen shot

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Ian is correct you are running historical trial balance change the same Aged Trial balance with options and run and check it.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

NORMAL AGED TB

Was this reply helpful? Yes No
Verified answer

Ian Grieve 22,784 on at

Like (1)

Report

Your invoice and payment aren't showing as they are fully applied and on history.

The Historical Aged TB you ran first is showing you the status as of the date you selected, which was presumably before they were applied and moved to history.

Was this reply helpful? Yes No