Welcome, Guest. Please Login.
05/10/25 at 22:32:54
News:
Home Help Search Login


Pages: 1
Send Topic Print
DE-H-D Import Physical Inventory Counts (Read 942 times)
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
DE-H-D Import Physical Inventory Counts
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
 
embarrassed
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: DE-H-D Import Physical Inventory Counts
Reply #1 - 05/01/15 at 06:57:48
 
Leading or trailing spaces in the part number field?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: DE-H-D Import Physical Inventory Counts
Reply #2 - 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
 
 Cheesy
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print