Sage 100

Sage 100 Version 2022 PU 2 Advanced - I'm importing into purchase order detail to create new lines and update existing lines on a purchase order. I'm trying to Import into the linekey field but the linekey field was not being read - it was completely passed over, not listed in the VI log record detail.

I'm not finding any KB articles related to this in purchase order module. Has anyone seen this and/or have advice?

------------------------------
David Overholt
DWD Technology Group
------------------------------

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group
------------------------------

Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

I've tried putting a full 6 character linekey in my source file as a test and that did not change anything. 
the LineKey field still just does not populate. Has anyone done this in Purchase Order even in a different version? if so I can try testing in another version to see if maybe it is specific to my import job.

------------------------------
David Overholt
DWD Technology Group
------------------------------

Original Message:
Sent: 09-29-2022 11:16
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group
------------------------------


Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions

Before
Import
File
Results
After


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 09-29-2022 16:05
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

I've tried putting a full 6 character linekey in my source file as a test and that did not change anything.
the LineKey field still just does not populate. Has anyone done this in Purchase Order even in a different version? if so I can try testing in another version to see if maybe it is specific to my import job.

------------------------------
David Overholt
DWD Technology Group
------------------------------


Original Message:
Sent: 09-29-2022 11:16
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions

That was done in 2022.1 Standard.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 09-29-2022 16:42
From: Kevin Moyes
Subject: Importing Linekey in Purchase Order Detail

Before
Import
File
Results
After


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 09-29-2022 16:05
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

I've tried putting a full 6 character linekey in my source file as a test and that did not change anything.
the LineKey field still just does not populate. Has anyone done this in Purchase Order even in a different version? if so I can try testing in another version to see if maybe it is specific to my import job.

------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:16
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions

Interesting, 
I don't see the linekey listed in your VI record detail either, but it is using it.  Maybe I'm crying wolf then. just because I'm not seeing it, the value may still be importing. I'll check that 
Thanks!!!

------------------------------
David Overholt
DWD Technology Group
------------------------------

Original Message:
Sent: 09-29-2022 16:43
From: Kevin Moyes
Subject: Importing Linekey in Purchase Order Detail

That was done in 2022.1 Standard.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------


Original Message:
Sent: 09-29-2022 16:42
From: Kevin Moyes
Subject: Importing Linekey in Purchase Order Detail

Before
Import
File
Results
After


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 09-29-2022 16:05
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

I've tried putting a full 6 character linekey in my source file as a test and that did not change anything.
the LineKey field still just does not populate. Has anyone done this in Purchase Order even in a different version? if so I can try testing in another version to see if maybe it is specific to my import job.

------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:16
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions

I'd add conditions to your LineKey / ItemCode columns to only do one or the other (based on whether column 2 is blank... IMP$[02] <> ""...) but I was suspecting the issue was just in how the VI log is presented. 
By not including the ItemCode for updates, the only way a line could be accepted ("Passed")  is if the LineKey was found.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Original Message:
Sent: 09-29-2022 16:51
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

Interesting,
I don't see the linekey listed in your VI record detail either, but it is using it.  Maybe I'm crying wolf then. just because I'm not seeing it, the value may still be importing. I'll check that
Thanks!!!

------------------------------
David Overholt
DWD Technology Group
------------------------------


Original Message:
Sent: 09-29-2022 16:43
From: Kevin Moyes
Subject: Importing Linekey in Purchase Order Detail

That was done in 2022.1 Standard.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 09-29-2022 16:42
From: Kevin Moyes
Subject: Importing Linekey in Purchase Order Detail

Before
Import
File
Results
After


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.


Original Message:
Sent: 09-29-2022 16:05
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

I've tried putting a full 6 character linekey in my source file as a test and that did not change anything.
the LineKey field still just does not populate. Has anyone done this in Purchase Order even in a different version? if so I can try testing in another version to see if maybe it is specific to my import job.

------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:16
From: David Overholt
Subject: Importing Linekey in Purchase Order Detail

out of pure chance - yes to both, I am doing a replace and it is the first line field.the source file may not be a full 6 characters. I'm not sure if that would cause it to skip.





------------------------------
David Overholt
DWD Technology Group


Original Message:
Sent: 09-29-2022 11:01
From: David Speck II
Subject: Importing Linekey in Purchase Order Detail

When importing into the LineKey field, you MUST use the Replace operation and it should be the first line level field you set.  Are you doing so?

EDIT: Since you mentioned it, if i recall correctly, even when the LineKey is set, it still won't show up in the job log.

------------------------------
David Speck II
Tennessee Software Solutions