ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> DE-H-D Import Physical Inventory Counts
http://www.istechforum.com/YaBB.pl?num=1430418619

Message started by Kelloggs on 04/30/15 at 11:30:19

Title: DE-H-D Import Physical Inventory Counts
Post by Kelloggs on 04/30/15 at 11:30:19

We are testing this module.

when importing we get the following

Tag # Location Item Number Actual Qty Count Date Year Qtr Lot Action
------ ---------- --------------- ------------ ---------- ---- --- --------------- ------------------------------
1 LOC 701 06005 0.00 04/30/15 2015 01 0 Skipped - New Item Number
2 LOC 701 06006 6.00 04/30/15 2015 01 0 Skipped - New Item Number

Note: Skipped items (including new items) should be added using BKPIC.

But the items are there on the BKPIC

Line# Bin Item Number Description UM per books Counted Unit Cost
------ ---------- --------------- ------------------------------ --- ------------ --------- --------------
1 11H2 701 06005 TOP PLATE EA ................... 4.00 _________ 771.870000
2 11H2 701 06006 SEAL COVER EA ................... 9.00 _________ 158.173000

Any ideas?

thank you all

:-[

Kelloggs

Title: Re: DE-H-D Import Physical Inventory Counts
Post by Lynn_Pantic on 05/01/15 at 06:57:48

Leading or trailing spaces in the part number field?

Title: Re: DE-H-D Import Physical Inventory Counts
Post by Kelloggs on 05/01/15 at 07:48:32

Thank you Lynn,

That was the problem. In order to work a text file should look like :

1,LOC,701 06005,0,9021,11H2,0
2,LOC,701 06006,6,9021,11H2,0

No spaces before or after the comas

:D

Kelloggs