Lot Items MAS: Difference between revisions

From Customer365 for SageCRM
No edit summary
No edit summary
Line 3: Line 3:
Add a table connection to "IM_LotSerialTransactionHistory" in CRM.
Add a table connection to "IM_LotSerialTransactionHistory" in CRM.


Create a list called "IM_LotSerialTransactionHistoryList". Add fields as required to this list.  
Create a list called "IM_LotSerialTransactionHistoryList". Add fields as required to this list (entryno must be on this list for the links to open the invoice to appear).  
Note that the fields added must also be edited so that they have a record in "custom_edits" otherwise the list may appear blank.
Note that the fields added must also be edited so that they have a record in "custom_edits" otherwise the list may appear blank.



Revision as of 16:11, 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 (entryno must be on this list for the links to open the invoice to appear). 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"/>