History to Open in Dynamics 6.0

[lingtring]

I have some payments applied to an invoice, and this payment (cash receipt) is now on history.

This payment shouldn't be paying the invoice is applied to, so I have to void, cancel, unapply it or move it to the open file so I can do this.

Is there a way to do this?

Invoice shouldn't be voided, cash reciept can be voided, as long as it is unaaplyied from this invoice.

Thanks to all

 

[PTina]

If I understand you correctly the payment was sent to history but the invoice is still open with an unapplied amount.

If this is the case the only way to void the payment is have all documents moved to history. You will need to do a dummy payment and apply it to the unapplied amount on the invoice to move the invoice to history.

Once both the fully applied invoice and the payment are in history, you can void the incorrect payment and the dummy payment: Transactions-->Purchasing-->Void Historical Trx

After the payments are voided the invoice will be open again and another payment can be applied to it.

The same principle can be applied to sales transactions.

 

[lingtring]

Thanks PTina, but I forgot to mention that, unfortunately, this is on purchasing not on sales. And I haven't found anything like Void Historical Trx.

Also, on some cases both the invoice and payment are on historical, other cases one is open and another historical.

What can be done in my case?

 

[PTina]

The Void Historical Trx option is about half way down the list of the Purchasing Transactions Menu.

Transactions-->Purchasing-->Void Historical Trx

1) Invoice and Payment in History:
The payment can be voided which will make the invoice open again. If you also want to void the invoice you will now have to use Void Open Trx:

Transactions-->Purchasing-->Void Open Trx

2) One document is in History and the other Open:
This is the case where you will need to enter the dummy transaction to have the open document moved to history then follow number 1 above to void the payment.

If the document is incorrectly listed as open, i.e. it should have been fully applied to the document in history, then you may have corrupted apply records. Check to see if each document has the correct apply document.

Inquiry-->Purchasing-->Trx By Document or Trx By Vendor
Highlight the document.
Click on Document Number to drill down.
Click on the Apply button to see the apply record.

 

[lingtring]

Once again sorry, but this is on sales, not on purchasing, any idea what can be done in this case?

Thanks for all your help

 

[PTina]

The option to void Posted Transactions in Sales is:
Transactions-->Sales-->Posted Transactions

If you can see the invoice in the lookup list then you should be able to void it.

You may need to unapply the document first:
Transactions-->Sales-->Apply

 

[lingtring]

Thanks again, but my problem is that this invoices and poayments are all ready in history, so I can't see them on the Posted transaction, So I need to "transfer them to the open file.

Hope this is more clear.

 

[PTina]

I don't know of any other void options in Sales.

You may just have to remove transaction history and rekey the documents: Utilities-->Sales-->Remove Trx History

Make sure you have a good backup before doing this.
You will also need to adjust the GL manually.

 

[lingtring]

I will try that, thanks.

Is there a way to move from history to open in sales? I think this would be a better ans easier solution

 

[PTina]

The only time I know of that to happen is with a Void e.g. whe you void a payment and the invoice becomes open again in AP.

If you're going to remove the trx: Read Help-->About window; it will guide you in what to do. Make sure to check remove the distributions as well.

 

[Dukester0122]

Use the RM Transaction Unapply tool to return documents to Open that have been moved to History and return documents to Work that have been moved to Open. It is a good alternative to removing History if you have damaged records. Check with MBS about this tool.

 

[VictoriaYudin]

Yes, the only way to void a transaction in Sales is to have its status be Open. If it is in History, you can either create an adjustment to take care of the issue...or buy the RM Unapply Tool. Works great, however, might not be worth it (I think it's $750) for just one transaction.