277
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.
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.
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
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.
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.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (