Search - Revision history

Acs300Admin at 16:09, 8 April 2024

2024-04-08T16:09:17Z

← Older revision		Revision as of 12:09, 8 April 2024
Line 10:		Line 10:
	* Items		* Items

	[[File:Sage ~~100~~ search.png\|thumb]]		[[File:Sage 300 search.png\|thumb]]

	There is also a specific lookup for Email and Phone numbers. This is also used for the Microsoft Outlook and Microsoft Office 365 email integation (in MobileX for Sage 100).		There is also a specific lookup for Email and Phone numbers. This is also used for the Microsoft Outlook and Microsoft Office 365 email integation (in MobileX for Sage 100).

Acs300Admin: Items

2024-04-08T16:07:17Z

Items

← Older revision		Revision as of 12:07, 8 April 2024
Line 164:		Line 164:

	'''Exact'''		'''Exact'''
	* ~~ItemCode~~		* Item No (ITEMNO)
	* ~~PrimaryVendorNo~~		* Formatted Item no (FMTITEMNO)
	* ~~ProductLine~~		* Default Pricelist (DEFPRICLST)
			* Default Pricelist Code (DEFPRICLST_raw)
	* WarehouseDesc		* WarehouseDesc

	'''Like'''		'''Like'''

	* ~~ItemCodeDesc~~		* Description (DESC)
			* Comment1 (COMMENT1)
			* Comment2 (COMMENT2)
			* Comment3 (COMMENT3)
			* Comment4 (COMMENT4)

	'''Default Order''''		'''Default Order''''

	~~ItemCodeDesc~~ ''Ascending''		''Item No (ITEMNO) Ascending''

Acs300Admin: Prospects

2024-04-08T15:59:01Z

Prospects

← Older revision		Revision as of 11:59, 8 April 2024
Line 121:		Line 121:

	'''Exact'''		'''Exact'''
	* City		* City (NAMECITY)
	* ZipCode		* ZipCode (CODEPSTL)

	'''Like'''		'''Like'''

	* CustomerName		* CustomerName (NAMECUST)
	* CustomerContact		* CustomerContact (NAMECTAC)
	* ~~EmailAddress~~		* EmailAddress1 (EMAIL1)
	* ~~EmailAddress~~		* EmailAddress2 (EMAIL2)
	* AddressLine1		* Phone No1 (TEXTPHON1)
			* Phone No2 (TEXTPHON2)
			* AddressLine1 (TEXTSTRE1)

	'''Default Order''''		'''Default Order''''

Acs300Admin: Invoices

2024-04-08T15:55:06Z

Invoices

← Older revision		Revision as of 11:55, 8 April 2024
Line 101:		Line 101:

	'''Exact'''		'''Exact'''
	* InvoiceNo		* InvoiceNo (INVNUMBER)
	* CustomerNo		* Reference (REFERENCE)
			* CustomerNo (CUSTOMER)
			* Billing Zip (BILZIP)
			* Shipping No (SHINUMBER)

	'''Like'''		'''Like'''

	* BillToName		* BillToName (BILNAME)
			* Invoice Date (INVDATE)
			* Description (DESC)
			* Comment (COMMENT)
			* Billing Email (BILEMAIL)

	'''Default Order''''		'''Default Order''''

	~~InvoiceDate~~ ''~~Ascending~~''		Invoice Date (INVDATE) ''Descending''
	----6. Prospects		----6. Prospects

Acs300Admin: AP Vendors

2024-04-08T15:50:18Z

AP Vendors

← Older revision		Revision as of 11:50, 8 April 2024
Line 83:		Line 83:

	'''Exact'''		'''Exact'''
	* VendorNo		* VendorNo (VENDORID)
	* City		* City (NAMECITY)
	* ZipCode		* ZipCode (CODEPSTL)

	'''Like'''		'''Like'''

	* VendorName		* VendorName (VENDNAME)
	* PrimaryContact		* PrimaryContact (NAMECTAC)
	* AddressLine1		* AddressLine1 (TEXTSTRE1)
	* TelephoneNo		* TelephoneNo (TEXTPHON1)
	* FaxNo		* EmailAddress (EMAIL1)
	* EmailAddress

	'''Default Order''''		'''Default Order''''

	VendorName ''Ascending''		VendorName (VENDNAME) ''Ascending''
	----5. Invoices		----5. Invoices

Acs300Admin: AR Customer Orders

2024-04-08T15:48:09Z

AR Customer Orders

← Older revision		Revision as of 11:48, 8 April 2024
Line 60:		Line 60:
	ContactName (FullNAME) ''Ascending''		ContactName (FullNAME) ''Ascending''
	----3. AR Customer Orders		----3. AR Customer Orders

			'''Exact'''

			* Order Number (ORDNUMBER)
			* Order Reference (REFERENCE)
			* Billing Zip Code (BILZIP)
			* Billing City (BILCITY)
			* Customer Code (CUSTOMER)
			* Order Date (ORDDATE)

	'''Like'''		'''Like'''

	* ~~SalesOrderNo~~		* (BILNAME)
	* ~~CustomerPONo~~		* Address 1 (BILADDR1)
			* Billing Phone (BILPHONE)
			* Comment (COMMENT)

	'''Default Order''''		'''Default Order''''

	OrderDate ''~~Ascending~~''		OrderDate (ORDDATE) ''Descending''
	----4. AP Vendors		----4. AP Vendors

Acs300Admin at 15:37, 8 April 2024

2024-04-08T15:37:18Z

← Older revision		Revision as of 11:37, 8 April 2024
Line 42:		Line 42:

	'''Exact'''		'''Exact'''
	* City		* Customer ID (IDCUST)
	* ZipCode		* Contact ID (IDCONTACT)
			* City (NAMECITY)
			* ZipCode (CODESTTE)

	'''Like'''		'''Like'''

	* ContactName		* ContactName (FullNAME)
	* CustomerName		* CustomerName (NAMECUST)
	* ~~ContactCode~~		* TelephoneNo1 (TEXTPHON1)
	* ~~AddressLine1~~		* EmailAddress (EMAIL)
	* ~~TelephoneNo1~~		* Comment1 (COMMENT1)
	* ~~EmailAddress~~		* Comment2 (COMMENT2)

	'''Default Order''''		'''Default Order''''

	ContactName ''Ascending''		ContactName (FullNAME) ''Ascending''
	----3. AR Customer Orders		----3. AR Customer Orders

Acs300Admin at 15:30, 8 April 2024

2024-04-08T15:30:53Z

← Older revision		Revision as of 11:30, 8 April 2024
Line 24:		Line 24:
	'''Exact'''		'''Exact'''

	* City		* Customer ID (IDCUST)
	* ZipCode		* City (NAMECITY)
			* ZipCode (CODEPSTL)

	'''Like'''		'''Like'''

	* CustomerName		* CustomerName (NAMECUST)
	* AddressLine1		* Customer Contact (NAMECTAC)
	* TelephoneNo		* AddressLine1 (TEXTSTRE1)
	* EmailAddress		* TelephoneNo (TEXTPHON1)
			* EmailAddress (EMAIL1 and EMAIL2)

	'''Default Order''''		'''Default Order''''

	~~CustomerName~~ ''Ascending''		NAMECUST ''Ascending''
	----2. AR Customer Contacts		----2. AR Customer Contacts

Acs300Admin: Created page with " You can search across * AR Customers * AR Customer Contacts * AR Customer Orders * AP Vendors * Invoices * Prospects * Items thumb There is also a specific lookup for Email and Phone numbers. This is also used for the Microsoft Outlook and Microsoft Office 365 email integation (in MobileX for Sage 100). '''How searches work''' Here we will outline how the search works per entity. We break this down to EXACT and LIKE matching. ----..."

2024-04-08T15:21:59Z

Created page with " You can search across * AR Customers * AR Customer Contacts * AR Customer Orders * AP Vendors * Invoices * Prospects * Items thumb There is also a specific lookup for Email and Phone numbers. This is also used for the Microsoft Outlook and Microsoft Office 365 email integation (in MobileX for Sage 100). '''How searches work''' Here we will outline how the search works per entity. We break this down to EXACT and LIKE matching. ----..."

New page

You can search across

* AR Customers
* AR Customer Contacts
* AR Customer Orders
* AP Vendors
* Invoices
* Prospects
* Items

[[File:Sage 100 search.png|thumb]]

There is also a specific lookup for Email and Phone numbers. This is also used for the Microsoft Outlook and Microsoft Office 365 email integation (in MobileX for Sage 100).

'''How searches work'''

Here we will outline how the search works per entity.

We break this down to EXACT and LIKE matching.
----
# AR Customers

'''Exact'''

* City
* ZipCode

'''Like'''

* CustomerName
* AddressLine1
* TelephoneNo
* EmailAddress

'''Default Order''''

CustomerName ''Ascending''
----2. AR Customer Contacts

'''Exact'''
* City
* ZipCode

'''Like'''

* ContactName
* CustomerName
* ContactCode
* AddressLine1
* TelephoneNo1
* EmailAddress

'''Default Order''''

ContactName ''Ascending''
----3. AR Customer Orders

'''Like'''

* SalesOrderNo
* CustomerPONo

'''Default Order''''

OrderDate ''Ascending''
----4. AP Vendors

'''Exact'''
* VendorNo
* City
* ZipCode

'''Like'''

* VendorName
* PrimaryContact
* AddressLine1
* TelephoneNo
* FaxNo
* EmailAddress

'''Default Order''''

VendorName ''Ascending''
----5. Invoices

'''Exact'''
* InvoiceNo
* CustomerNo

'''Like'''

* BillToName

'''Default Order''''

InvoiceDate ''Ascending''
----6. Prospects

'''Exact'''
* City
* ZipCode

'''Like'''

* CustomerName
* CustomerContact
* EmailAddress
* EmailAddress
* AddressLine1

'''Default Order''''

CustomerName ''Ascending''
----7. Email/Phone

This is a special look up table only that covers (AR Customer/AR Customer Contacts/AR Customer Orders/AP Vendors/Invoices). Each column name below can in fact contain any type of data we feel is useful to search with.
[[File:Sage 100 email phone search.png|thumb]]

'''Like'''

* NAME
* EMAIL1
* EMAIL2
* NAMECTAC
* TEXTPHON1
* TEXTPHON2

'''Default Order''''

NAME ''Ascending''

The first column in the result shows what the entity is (based on the icon)
----

8. Items

'''Exact'''
* ItemCode
* PrimaryVendorNo
* ProductLine
* WarehouseDesc

'''Like'''

* ItemCodeDesc

'''Default Order''''

ItemCodeDesc ''Ascending''