Lot Items MAS: Difference between revisions

From Customer365 for SageCRM
No edit summary
No edit summary
Line 7: Line 7:


To the user menu "PortalSupport" add in the item "Lots" and set the "Custom File" to be "lots.aspx"
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"/>

Revision as of 15:41, 3 September 2012

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"/>