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