Item Location Stored Procedure Name

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

Can anyone tell me for GP 2010 the name of the stored procedure that is called to assign sites to items. In my case I need create a scheduled job that will run once a day and assign every site to every item inventory. If there is a script that assigns all sites to all locations please let me know what it is. Otherwise I will schedule my to do as much as it needs to do.

*This post is locked for comments

All responses (4)

Answers (2)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Item Location Stored Procedure Name

Thanks for the tips folks. Looks fairly simple. They use GP to cut PO's for medical parts. Inventory stock quantities are of no concern to them. They just want to order parts for their offices. They need the sites to be there for all items at all times. I figure just queuing up this job at night should do it.
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Item Location Stored Procedure Name

Thanks Naga. I made a typo error. "taItemSite" is the sproc used to assign item site.
Verified answer

Naga Kiran on at

Like (0)

Report

RE: Item Location Stored Procedure Name

Basically 'taCreateInventorySite' will create a Site and will NOT assign sites to Items. The sproc "taItemSite" will do the job for you. As I see , it requires the below parameters (Where item number and location code are required and remaining are optional) :

@I_vITEMNMBR

@I_vLOCNCODE

@I_vBINNMBR

@I_vPRIMVNDR

@I_vLanded_Cost_Group_ID

@I_vQTYRQSTN

@I_vUpdateIfExists

@I_vUSRDEFND1

@I_vUSRDEFND2

@I_vUSRDEFND3

@I_vUSRDEFND4

@I_vUSRDEFND5

@O_iErrorState

@oErrString

Richard, you can use this in a loop to assign all locations to items. Hope this helps.
Verified answer

soma 24,410 on at

Like (0)

Report

RE: Item Location Stored Procedure Name

This "taCreateInventorySite" is the eConnect schema for assigning sites to items in GP. I guess, the SP name should be same as the eConnect schema name "taCreateInventorySite". Please check and let me know.