ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Anyone importing material issues?
http://www.istechforum.com/YaBB.pl?num=1495721015

Message started by TGerak on 05/25/17 at 07:03:35

Title: Anyone importing material issues?
Post by TGerak on 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?

Title: Re: Anyone importing material issues?
Post by Kelloggs on 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

:)

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

:P

Title: Re: Anyone importing material issues?
Post by TGerak on 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.

Title: Re: Anyone importing material issues?
Post by Kelloggs on 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

:D

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

:P

Have fun,

Kelloggs