I gave you the answer 11 years ago.  You have too many columns in your sheet.

Hi Jay,

I'm new to Sage Accpac, it was not me 11 years ago hehe. I just found that link when i tried to solving this problem.

Currently i have these columns to import from excel :

I think these are the same as when importing the Receipt, the only difference was RMITTYPE is set to 3 (for Unapplied Cash) instead of 1 (Receipt).

I don't think there are any additional columns , Could you please help me ?

Thank You

Hi Yiren

If you need to import to a new batch as "Apply Document" , the RMITTYPE should be 4. 
And in the import file there should have another worksheet as "Applied_Receipts_Adjustments" for the documents that need to apply.

There are difference type of table or fields required in difference type of batches. To avoid any error during import, what I usually did is to export from any existing "Applied Document" batch or create a new batch with an entry then export. The purpose is to get it export file with it original table and fields required and ensure the data I added in are follow the sample entry.  

Hi Shirlena,

Thankyou so much for your reply,

I was import the Receipt with "Unapplied Cash" and only filling into "Receipts_Adjustments" , another sheets were left blank (since i heard that they always only fill the first sheet when importing "Receipt")

You said about there should have another worksheet as "Applied_Receipts_Adjustments" inspired me that i should try filling that sheet, and i'm exporting the existing batch with Unapplied Cash inside to see the example.

I tried posting it again, and it was all going smoothly (before there was error)
You saved my day

One more question,

For example, since i already posted the xls doc with UC in this batch.
For the next batch, all i need to do is just following the existing "Apply Document" as an example and fill into  "Receipts_Adjustments" and  "Applied_Receipts_Adjustments" sheets too, right ?
Please correct me if i'm wrong

I'm going to test the "Apply Document" into the new batch right now.
Will update what i found here later.

Hi Yiren

Glad it help.

Yes. You may try the same way but provided the details in "Applied_Receipts_Adjustments" are correctly match to those UNAPPLIED POSTED DOCUMENTS in your database.  Even a single small mistake in the document number or date will not allow to import. 

As "Apply Document" type, is more to matching and there are more fields information need to provide, example : INCUST, IDINVC, DOCTYPE, AMTPAYM, UNAPLPAYM, DATEINVC,AMTPAYMHC, etc..

I suggest you manually type in an entry using Apply Document type and export to see the sample.

Good Luck.

Hi Shirlena,

Yes, i tried it exactly as you said. I manually input 1 and exported it to guide me.
And it's working good, it's successfully posted

My testing steps are :

1. Import Receipt with some UC inside, then post it.
2. Import and post Invoices for those UC receipts.
3. Import Receipt "Apply Document" with detail of UC and Invoice number that belongs to it. and posted it successfully.
(this also solved that we used to manually click the "Apply"  fron "No" to "Yes", but this import file solved it, the receipt linked to the invoice and all set to "Yes")

Thank you again,
also thanks  Jay Converse Acumen for replying me too.

Best Regards,
Yiren