Unapplied Cash import Error

[erprider]

Hi guys

I was importing the unapplied cash through excel sheet in AR Receipt after importing an excel sheet i was trying to post it from AR receipt Batch it was generate an error batch when i checked the error shows like "Document must be applied to at least one detail."


Any idea!

 

[ettienne]

You must apply the receipt to at least one document.

 

[erprider]

Thanks for the reply ettienne

But i am just the unapplied cash batch. i dont want apply the receipt to the document now.
but i want to post the unapplied cash batch. Will it possible?

 

[ettienne]

Well you didn't do what you thought you did. You want to import unapplied cash, what you did is imported receipts not applied - totally different things. Try again.

 

[erprider]

Okay fine. Well if i do the Unapplied Cash manually in AR Receipt(because of Opening Balance import) it wasnt throw any error if i import through excel sheet and when i posts the batch gives an error.

 

[Jay Converse]

You need to reduce the number of columns in your spreadsheet so that more default values are used. Don't ask me which columns because none of my clients have ever asked me how to do it, you'll have to figure it out for yourself.