Manufacturing, Distribution, and Internet Applications

[Midknight_Tranz]

Hi Guys,

Would anyone by chance know the stored procedure being used by Sage in updating  Quantities in the timinvtlotbin table?  I'd like to study how sage does the updates.

As always, any feedback would be greatly appreciated.

Best Regards,

Patrick

[JohnHanrahan]

Run this in SQL 

SELECT Distinct O.Name

 FROM sysobjects O

   INNER JOIN syscomments C on O.Id = C.ID

 WHERE O.Type = 'P' AND C.Text LIKE  '%timInvtLotBin%'

There are a lot. 

J

[Midknight_Tranz]

Thanks for the feedback John, I already ran that query before I posted the question here 

I was hoping that someone from SAGE can direct me to the specific SPs especially for creating pick lists, committing SOs and Processing Inventory transactions under the IV module.

Anyway, I guess I'll just have to do a trace and see what SPs are involved while there is no specific SP mentioned in this thread.

Again, thanks for the feedback 

[LouDavis]

If you are looking to do this processing on your own, in regards to the pick list and committing SO's you may want to check out RKL's Autoship API which has this functionality.  As far as Inventory transactions go, you could always use the standard MAS 500 DIM routine spimAPIInventoryIns and its related staging tables to do this..  No sense in re-inventing the wheeel if processes already exist to do this..

[Midknight_Tranz]

Thanks Lou, I'll look into your suggestion