Lot Items MAS

From Customer365 for SageCRM
Revision as of 13:41, 3 September 2012 by CrmtogetherPortal (talk | contribs)

Lot items can be viewed from the portal.

Add a table connection to "IM_LotSerialTransactionHistory" in CRM.

Create a list called "IM_LotSerialTransactionHistoryList". Add fields as required to this list. Note that the fields added must also be edited so that they have a record in "custom_edits" otherwise the list may appear blank.

To the user menu "PortalSupport" add in the item "Lots" and set the "Custom File" to be "lots.aspx"





Settings fields for this screen.

   <add key="MASLotFilter" value=""/>
   <add key="MASIM_LotSerialTransactionHistorySQL" value="select ItemCode, TransactionCode, EntryNo from MAS_TST.dbo.IM_LotSerialTransactionHistory" />
   <add key="MASLotOrderBy" value="" />
   <add key="lblLotItemsHint" value="Click on the Entry No field to open the invoice"/>
   <add key="lblYourLotItems" value="Your Lot Items"/>
   <add key="IM_LotSerialTransactionHistoryList" value="IM_LotSerialTransactionHistoryList"/>