Lot Items MAS - Revision history

CrmtogetherPortal at 16:48, 24 September 2013

2013-09-24T16:48:34Z

← Older revision		Revision as of 17:48, 24 September 2013
Line 8:		Line 8:

	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).		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 or cause an error.

	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"

CrmtogetherPortal at 17:25, 26 November 2012

2012-11-26T17:25:58Z

← Older revision		Revision as of 18:25, 26 November 2012
Line 2:		Line 2:

	[[File:lotlist.png]]		[[File:lotlist.png]]

			When the Entry no is clicked the PDF invoice opens

	Add a table connection to "IM_LotSerialTransactionHistory" in CRM.		Add a table connection to "IM_LotSerialTransactionHistory" in CRM.
Line 9:		Line 11:

	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"




	----		----

CrmtogetherPortal at 17:22, 26 November 2012

2012-11-26T17:22:41Z

← Older revision		Revision as of 18:22, 26 November 2012
Line 1:		Line 1:
	Lot items can be viewed from the portal.		Lot items can be viewed from the portal.

			[[File:lotlist.png]]

	Add a table connection to "IM_LotSerialTransactionHistory" in CRM.		Add a table connection to "IM_LotSerialTransactionHistory" in CRM.

CrmtogetherPortal at 17:08, 26 November 2012

2012-11-26T17:08:37Z

← Older revision		Revision as of 18:08, 26 November 2012
Line 11:		Line 11:


			----
			View required for this screen

			create view [dbo].[v_IM_LotSerialTransactionHisto]
			as
			select a.*,b.ItemCodeDesc
			from IM_LotSerialTransactionHistory a, CI_Item b
			where a.ItemCode=b.ItemCode

	----		----

CrmtogetherPortal at 14:11, 3 September 2012

2012-09-03T14:11:09Z

← Older revision		Revision as of 15:11, 3 September 2012
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.

CrmtogetherPortal at 13:41, 3 September 2012

2012-09-03T13:41:38Z

← Older revision		Revision as of 14:41, 3 September 2012
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"/>

CrmtogetherPortal at 13:35, 3 September 2012

2012-09-03T13:35:08Z

← Older revision		Revision as of 14:35, 3 September 2012
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.
			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"		To the user menu "PortalSupport" add in the item "Lots" and set the "Custom File" to be "lots.aspx"

CrmtogetherPortal at 13:26, 3 September 2012

2012-09-03T13:26:13Z

← Older revision		Revision as of 14:26, 3 September 2012
Line 4:		Line 4:

	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.

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

CrmtogetherPortal: Created page with "Lot items can be viewed from the portal. Add a table connection to "IM_LotSerialTransactionHistory" in CRM. Create a list called "IM_LotSerialTransactionHistoryList". Add fi..."

2012-09-03T13:20:25Z

Created page with "Lot items can be viewed from the portal. Add a table connection to "IM_LotSerialTransactionHistory" in CRM. Create a list called "IM_LotSerialTransactionHistoryList". Add fi..."

New page

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.