DMT for Receipting Lots

Kinetic ERP
,
1

Currently working through an upgrade from E10.1.600 to Kinetic 2024.x.

In the old system, we had a work around to manage material lots that had a freezer life, and out life. This was running a custom UI code, and SQL databases.
With the move to Kinetic Cloud (all browser based), we are moving that system into Kinetic.
1st Hurdle, load a packing slip into receipt entry before the material arrives.
This will let us digitally check the actual received Lots vs the packing slip.
I’m trying to get the Lot’s and the corresponding qty’s.

Attempting to Paste new into the Receipt Entry - Lines grid (looks like a grid).
The first Lot adds, but the ‘Our Qty’ fields overwrites with the PO Line ordered qty, then it throws an error on line 2 about the quantity.
image

OK, so try DMT. Pretty much the same outcome.
Worked through this help topic https://www.epiusers.help/t/issues-uploading-po-receipts-via-dmt/36367/13 , but same thing, the Our Qty is overwritten.

image
image884×185 3.99 KB

Tried using different qty fields, but you have to have the Our Quantity field.

What am I missing, this feels like it should be easier than this?

1 Like
2

Did you tried with InputOurQty
What is your company configuration setting either Our Quantity or Supplier Quantity, ?

1 Like
3

Thanks for the response,
I am using InputOurQuantity, have also tried ReceivedQty.

Our Qty is chosen for Receipt Default Qty.
Looking at that configuration though, here’s what the Lot option are:

image
image1658×576 27.6 KB

Maybe that Purchase receipt box needs to be ticked?
Nothing like a Pilot environment for letting my button pushing impulse takeover.

Jonny

4

I did a demo of paste insert with a receipt of over 500 lines last week. It took 10 minutes, but they all got in. I started with the columns I had in classic and they threw a few errors and I had to add some fields while in classic I just did po/line/our qty/lot and the rest filled in from the UI.

I used Paste New from the overflow menu

I needed Release, PartNum and Warehouse, Bin to make a bpm of mine happy.

image
image1211×210 76.6 KB

1 Like
5

End of the day here in NZ, but I’ll bring in the Warehouse which wasn’t present in the script.
Thanks @gpayne

1 Like
6

This is for skipping prompts about specifying lot attributes when processing purchase receipts.
Did adding the warehouse solve the issue? If not, please share your DMT template, and I will try it in my test environment

7

You might want to test using supplier quantity vs our quantity.

8

Alright,
As per last week, it’s loading the first line, with the right Lot number, but the entire line qty, not the Lot quantity.

Adding WareHouseCode didn’t fix that.
Trying Vendor Qty instead of InputOurQty didin’t change that.

I have been entering my Lot quantity under InputOurQty, trying it with OurQty throws a DMT error that I need InputOurQty.
So, I’ve put that back in.
I’ve set the qty in the script as 0, and same thing.

Attached is my script for the DMT.
Lines 1-5 are the lots for the first Partnumber I’m receiving, then lines 6-16 are the lots for line 7 of the PO.
receiptK11.csv (21.7 KB)

9

@JKnopp I did not process mine thru DMT. I used paste new in the receipt entry screen.

I had run into an issue where the warehouse users did not have access to receipt entry in DMT because it was tied to a HH menu and we don’t own the HH module. It turned out fine as now I don’t have to train them on DMT.

10

Thanks Greg,

Giving up on DMT for a minute,

I’m pasting in these columns

PackLine - with actual line numbers.
PartNum
LotNum
Warehouse
Bin
InputOurQty
PONum
POLine
PO Rel
IUM
Received

In the above order I got a Part number not Lot tracked error - which it is.
So I swapped Warehouse and Bin number over now I have a valid bin number error.

I just tried adding the line manually in the grid, and the quantity overwrites when I hit enter to do the next line.

Will run the debug and see if that helps, or at least points me a BPM.

11

What I did was make the header, save and then paste in those columns. it is the same process we do in classic, but had to add a few more fields.

I found a paste new under the overflow menu that worked in the Kinetic screen.

12

Success!

Pasting method:
Column order:
PackLine
PartNum
LotNum
PONum
POLine
release
InputOurQty
IUM
Received
Warehouse
Bin

DMT method Headers:
Company
PackSlip
PackLine
WareHouseCode
BinNum
PartNum
LotNum
PONum
POLine
PORelNum
InputOurQty
IUM
Received
VendorNumVendorID

I’m happy to have it working, but what a process!

Thanks @gpayne for pushing me along.

1 Like