Welcome, Guest. Please Login.
04/26/24 at 07:17:21
News:
Home Help Search Login


Pages: 1
Send Topic Print
Anyone importing material issues? (Read 1109 times)
TGerak
Full Member
***


DBA Classic Since
2000!

Posts: 186
Anyone importing material issues?
05/25/17 at 07:03:35
 
We recently added a vending unit to control inventory of tooling and inserts.  Working with the vending supplier has been painful, but we seem to be over the hump now.  I get a daily email with an Excel spreadsheet of the prior day's tooling disbursements.  I am able to use DE-K-A to import the transactions and DE-K-B to edit and process them.  My issue is that the transaction does not post all the way through.  The correct quantity of each item is now on the WO BOM and is checked for issuing, but it doesn't issue.
 
Has anyone done this?  I really don't want to have to go into each WO and "issue" the items that I have imported.  I've looked at the defaults and don't see anything that looks like it would change the behavior.
 
We're running the current version and are up to date on patches.
 
Any thoughts?
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Anyone importing material issues?
Reply #1 - 05/25/17 at 11:16:57
 
We have the same system, for many years now. Works well, and we are on patch 2004? hehehe.
 
what is your setting on "Validate WOBOM companents Y,N,A" ?
I believe is A, but if I am mistaken I can ask the guy who runs the tool dispenser.
 
then  you have to use DE-J-H to actually post the transactions.
 
have fun
 
Smiley
 
Kelloggs
 
????
DE-H-B to Import
DE-J-H to Post Material
 
ohhh you are running classic
anyways one to import the other one to post
 
Tongue
Back to top
 
 

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


DBA Classic Since
2000!

Posts: 186
Re: Anyone importing material issues?
Reply #2 - 05/25/17 at 12:04:41
 
I have tried both N and A for validate BOM.  Same result.   Looking at it, my menu item DE-K-A runs program DE-H-B and DE-K-B runs program DE-J-H.  My profile indicates that we're DBA Classic users since 2000, but we are on the current version of the ISTech Support programs.
 
Lynn asked me if the transactions show up JC-E, and they do.  However, I am not seeing them reflected in IN-A.  Our version of DE-J-H is dated 9/14/16.  I don't think we can revert.
 
The tooling vendor is MSC, but the vending unit is a SupplyPoint machine.  The wrestling match has been defining and setup and procedures to ensure we can upload a current job list to validate against prior to dispensing.  The suppliers are perfectly happy to let the unit vend all day, but we need to know where the tooling is going.
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Anyone importing material issues?
Reply #3 - 05/25/17 at 15:19:59
 
Now that I remember we used to have a similar issue. It was the date format.
Hope it helps
 
Cheesy
 
This is our formatted txt file:
 
Date,wo_pre,wo_suf,part_id,quantity
 
20170523,990101.00,1,XP600450,1
20170523,990101.00,1,XP000140,1
20170523,990101.00,1,XP011070,3
20170523,71115.00,1,CI002237,1
20170523,990101.00,1,XP011070,3
20170523,990101.00,1,XP004010,1
20170523,501103.00,1,CI002280,1
20170523,70831.00,1,CI002237,2
 
this is supplypro file
 
TimeStamp
2017-05-23 08:05:04
2017-05-23 08:41:38
2017-05-23 10:41:38
2017-05-23 11:07:51
2017-05-23 11:48:54
2017-05-23 11:50:08
2017-05-23 12:47:34
2017-05-23 17:56:57
 
Tongue
 
Have fun,
 
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