I'm using Sage 100 Standard 2020 (v6.20.1.0).
In AP, in Vendor Maintenance, Vendor No field, I'm looking for "International Paper". I should be able to type "INTERN" in the Vendor No. field, and then I should see "INTERNATIONAL PAPER - ACH" appear on…
I'm trying to create a formula to pull rates setup on the Pay Rates table in PR. The Fields I used are "Employee" and "Job". When i use the lookup function on a custom public formula to look up a rate from my table i get an error "Too many Parameters…
Hi there!
I want to select which options our users can choose when looking up opportunities.
Primarily, they should only be able to see their own opportunites with the exception of 2 users that should be able to see all opportunities, regardless of…
Search Select Advanced Fields are Sage CRM's powerful lookup field type that allows child records to be linked to parents to ensure referential integrity. A user can search for records within an entry screen just by typing in a few letters into searchbox…
Hi,
I'd like to maintain a lookup value list that should be linked with an external database.
We have decided to use a SQL Job that will insert new items and update translations for the existing ones in the custom_captions table.
Problem is :…
I have a two-part problem, currently being addressed through some kludgy scripting.
We need:
1. A search select advanced field that only shows the names of people who have business email addresses; and
2. A second field that populates with the business…
We often have quotes that become orders and then have to requote on qty changes, before re converting back to orders and eventually invoices.
Also we have to re build a quote with 50-100 line items that had not been stored as a recurring quote, as originally…
I just upgraded a client, reviewed the upgrade guide and it listed enhanced auto complete to look at all words instead of just at the beginning. I found a KB article that said to run the utility to build the search index and I go to do that and got a…
Hey all,
Is there a way to link the email address in the "Salesperson Maintenance" screen which is tied to a particular client to the client's "paperless Office Delivery Options In AR Invoice" (Possibly with a check box?..)
Just as there is a check…
Using version 4.50.70.0. I need to add bin location to the item inquiry and item maintenance look up fields. So when I go to Item Inquiry or Maintenance, then the look up magnifying glass and I use the custom tab. I can add just about everything I want…
Custom Lookup Views appear to follow the user. Is there a way to make a Lookup View globally accessible? Or does anybody know where the custom views are stored?