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
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.
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,
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.
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
