Difference between revisions of "Troubleshooting: Error - Not a valid Tab Delimited Text Format or not an Stock Transfer import text format"

From AutoCount Resource Center
Jump to navigation Jump to search
(Created page with "'''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...")
 
 
Line 1: Line 1:
 
'''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?
 
'''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?
  +
  +
<b>Version :</b> 1.8 / 1.9 / 2.0
   
 
[[File:Stk transfer error1.png]]
 
[[File:Stk transfer error1.png]]

Latest revision as of 01:42, 21 February 2020

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?

Version : 1.8 / 1.9 / 2.0

Stk transfer error1.png


The excel file is as below:

Stk transfer error2.png


Possible Reason :

The header/column name may be not valid (as compared to column name in the system).


Solution :

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.

Stk transfer error3.png


3) Rename it as ItemCode.

Stk transfer error4.png


4) Then try to copy and paste again from Edit > Paste Item Detail Only From Clipboard.

Stk transfer error5.png


5) Now you able to paste it successful.

Stk transfer error6.png


By : Azirah 181019, Lay Swan 181213, P181214



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations