Finance | Project Operations, Human Resources, ...

Auto-Relieve Inventory when transferred to new site

(1) Share

Report

Posted on by RJarrell

319

Hi,

This is more complex than what I am asking here so definitely know there's a reason for asking this.

Is there any way that we can have inventory auto removed/relieved from GP after it is transferred to a certain site.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Craig Fuller 411 on at

Like (0)

Report

Know that I likely don't understand what you are asking here. Are you asking if an Inventory Adjustment (or Variance) entry be made to physically and financially remove the inventory from the system? Or are you asking can the inventory not be available for transactions once moved to the site...to be later adjusted physically/financially out of the system?

Was this reply helpful? Yes No
RJarrell 319 on at

Like (0)

Report

Sorry, I was kind of vague. Exactly the first one. If we transfer to a site, it would be nice if we could automatically create an adjustment that removes it from the inventory items and hits the correct accounts to expense it. Transferring it to the site makes sure that it will hit the right accounts. The reason we are asking this is because they use a scanner. If we don't use the transfer first, then hitting the correct accounts is not possible. Bu for them to relieve inventory is very difficult on the handheld because they have to switch the site to be able to do so. This extends their process significantly.

Was this reply helpful? Yes No
Suggested answer

Craig Fuller 411 on at

Like (0)

Report

The functionality doesn't exist in the box (that I'm aware of) but there may be a 3rd party product that could do this that someone here may suggest.

I don't know what skillsets are available in your organization but I can see this being done with either SQL or Visual Studio. That being said, David Musgrave with Winthrop Development Consultants would likely confirm that their GP Power Tools product could do it as well but I don't have enough experience with it to make that determination.

There are several factors to consider, such as whether is must be real-time, a separate transaction for each transfer, or if batched at the end of the day etc. Off the top of my head I would think about using a SQL trigger on the history table to populate my own processing table. I could either trigger off of that or schedule a SQL job that would then perform the creation of the Adjustment transaction(s) and log it in my processing table. These (or the batch) would need to be posted by someone or else use something like mc2visions.com GP Agent to post automatically. If using Visual Studio (.Net) I would find the desired window/button events from the transfer window and create and post an adjustment from there.

I hope this helps give you some ideas.

Was this reply helpful? Yes No
Joseph Markovich 3,976 on at

Like (1)

Report

You could also use something like SmartConnect from eOne to create an automated process to watch for adds to the Purchase Receipts table that match the site ID and have it create an inventory adjustment transaction in a batch.

This would at least hard allocate the products so they couldn't be used.

Of course, someone would have to post that batch or you could use some kind of auto posting software to have GP post the batch automatically. SmartPost from eOne is what I've used and works great.

Hope this helps.

Joe

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (0)

Report

Econnect API, Gp Webservices and Econnect stored procedures will do but this requires development.

Was this reply helpful? Yes No
DebCummings 75 on at

Like (1)

Report

We use Econnect as others have mentioned. The warehouse transfers the product to WH 29 which we call our DEAD warehouse.

Then an Econnect procedure runs over night and we post the batch file the next morning.

Was this reply helpful? Yes No