Lot Items MAS
From Customer365 for SageCRM
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"/>