Troubleshooting: Error - Not a valid Tab Delimited Text Format or not an Stock Transfer import text format

From AutoCount Resource Center
Revision as of 01:42, 21 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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