Troubleshooting: Error - Not a valid Tab Delimited Text Format or not an Stock Transfer import text format
Question : When I copy excel data into stock transfer document by using Paste item detail by clipboard, system prompted an error “Not a valid Tab Delimited Text Format or not an Stock Transfer import text format”. Why?
The excel file is as below:
Possible Reason :
The header/column name may be not valid (as compared to column name in the system).
1) Refer to the excel file and check on the column name, and there are four columns; Item Code, UOM, Description and QTY.
2) For column Item Code, it shouldn’t have space between two words.
3) Rename it as ItemCode.
4) Then try to copy and paste again from Edit > Paste Item Detail Only From Clipboard.
5) Now you able to paste it successful.
By : Azirah 181019, Lay Swan 181213, P181214
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations