Lot numbers on Inventory Trx Adjustments through Integration Mgr?

(0) Share

Report

Posted on by Community Member

Hello -

Is there a way to have GP AUTO SELECT lot numbers on inventory trx adjustment trxs that are integrated through Integration Mgr or Web Services?

Thanks!

Travis

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Travis,

I haven't had to tackle this one yet, but if I were to try, I would start by using a VBA script for the Lot field in Integration Mgr. I am not a code monkey, so I can't tell you any cool ways to trigger any GP logic, but from a SQL Standpoint, you're looking at the following tables. You'd like want to select based on expiration date.

select * from IV00300 LM -- Lot Number Master

inner join IV00301 LA on LM.ITEMNMBR = LA.ITEMNMBR -- Lot Attribute Master

Was this reply helpful? Yes No
Galina 1,077 on at

Like (0)

Report

Looking at eConnect documentation it doesn't seem that there is a way to autoselect a lot.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

I also checked the Integration Manager and Inventory Control setup, the "Auto Assign" option in Inventory control does not apply to Inventory transactions. It only applies to SOP, BOM etc. I don't think it is possible to auto assign Lots by out of box features of Integration Manager.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

There is no out of the box method to automatically pick the available lot number for transactions integrated neither through integration manager, eConnect ...etc

I have gone through the exact same requirement recently with one of the clients, as part of the whole order and fulfillment cycle integration between the sales system and Dynamics GP. Since there is no way to let the integration (eConnect in our case) picks the available lot number, which practically could be one lot number, two ..etc (depending on the quantity), the SQL has to play a crucial part in reading the quantity from the sales system, and picking the available lot number/s while keeping the expiry date into consideration.

I personally would give weight to SQL in handling this requirement, it could do the job just precisely by reading the cost layers and lot number details and picking the right lot number. This is a pretty interesting task if you have the know-how in SQL and Dynamics GP, It's quite similar to the technique of picking the right cost layer for FIFO or LIFO valuation method, you will have to do a very similar thing in order to retrieve the proper lot number.

I hope you have the way cleared out by now,

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Travis,

I gave this a little more thought, and I believe you'd be better off handling the assignments of Lot Numbers in a Before the Integration Script, which would process your source file, and create a revised source file, which could generate multiple lines for the lot number insert, based on available quantities, expiration dates, and other metrics you could use to evaluate which lot(s) should be assigned based on the transaction quantity versus available lot quantities. I could put you in touch with a programmer we used to create a similar script for a client, should you so desire.

Was this reply helpful? Yes No