Search: Difference between revisions
Acs300Admin (talk | contribs) No edit summary |
Acs300Admin (talk | contribs) (AR Customer Orders) |
||
| 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''' | ||
* | * (BILNAME) | ||
* | * Address 1 (BILADDR1) | ||
* Billing Phone (BILPHONE) | |||
* Comment (COMMENT) | |||
'''Default Order'''' | '''Default Order'''' | ||
OrderDate '' | OrderDate (ORDDATE) ''Descending'' | ||
----4. AP Vendors | ----4. AP Vendors | ||
Revision as of 10:48, 8 April 2024
You can search across
- AR Customers
- AR Customer Contacts
- AR Customer Orders
- AP Vendors
- Invoices
- Prospects
- Items
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
- Customer ID (IDCUST)
- City (NAMECITY)
- ZipCode (CODEPSTL)
Like
- CustomerName (NAMECUST)
- Customer Contact (NAMECTAC)
- AddressLine1 (TEXTSTRE1)
- TelephoneNo (TEXTPHON1)
- EmailAddress (EMAIL1 and EMAIL2)
Default Order'
NAMECUST Ascending
2. AR Customer Contacts
Exact
- Customer ID (IDCUST)
- Contact ID (IDCONTACT)
- City (NAMECITY)
- ZipCode (CODESTTE)
Like
- ContactName (FullNAME)
- CustomerName (NAMECUST)
- TelephoneNo1 (TEXTPHON1)
- EmailAddress (EMAIL)
- Comment1 (COMMENT1)
- Comment2 (COMMENT2)
Default Order'
ContactName (FullNAME) Ascending
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
- (BILNAME)
- Address 1 (BILADDR1)
- Billing Phone (BILPHONE)
- Comment (COMMENT)
Default Order'
OrderDate (ORDDATE) Descending
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.
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
