Create a Saved Search That Shows All Items Applied on a Sales Order and Estimate Record

Source out all items that is applied on an Estimate and Sales Order Record. Navigate to Lists > Search > Saved Search Click Transaction Search Title: Enter Title Click Criteria Use Expressions: Enter Checkmark Click StandardNote: Use Parens and And/Or as indicated. Filter:Note: For every required filter use the drop-down menu to select it and once adjusted click Add if needed. Select Main Line Parens: Select ( Select: is false And/Or: Select And Select Tax… Continue reading Create a Saved Search That Shows All Items Applied on a Sales Order and Estimate Record

Saved Search for System Notes Notification When Purchase Price Field Is Modified

The user has an existing Item Saved Search that would notify him every time the Purchase Price field of any item is modified. But when the report runs, users get an email of any System field that has been modified. The existing Item Saved Search has the following Criteria and Results: A. Criteria: Type: is any of Non-inventory item, Inventory item Purchase Price: is Not Empty System Notes: Type is Change System Notes: Field is Purchase Price… Continue reading Saved Search for System Notes Notification When Purchase Price Field Is Modified

Error: “An Unexpected Error Had Occurred | Parse of Date/Time “Xx” Failed with Date Format “M/D/Yy H: Mm a” in Time Zone America/Chicago” CSV Import of FAM Alternate Depreciation

The user encountered the above error during the CSV Import of FAM Alternate Depreciation. The error is due to a value in the column(s) of the imported file where a date value is expected but an integer was entered instead. The error description can be translated as follows: Parse of date/time xx where xx refers to the integer… Continue reading Error: “An Unexpected Error Had Occurred | Parse of Date/Time “Xx” Failed with Date Format “M/D/Yy H: Mm a” in Time Zone America/Chicago” CSV Import of FAM Alternate Depreciation

Mass Delete Customer Item Pricing via CSV Import when Multiple Currencies feature is Enabled

The user wants to mass delete the pricing in the customer records. Solution A. CSV File Creation Create a CSV file with the following fields as headers: Internal ID = indicate Internal ID of the Customer record/s to be updated Item = blank Price Level = blank Currency = blankNote: If the Multiple Currencies feature is disabled, this column is no longer… Continue reading Mass Delete Customer Item Pricing via CSV Import when Multiple Currencies feature is Enabled

Resolve Error: “Permission Violation: You need the ‘Vicarious emails’ permission to access this page. Please contact your account administrator.”

When a user edits or submits a transaction that undergoes a workflow that has a Send Email Action, the user gets the error ‘Permission Violation: You need the ‘Vicarious emails’ permission to access this page. This error is encountered if the user’s role does not have permission on ‘Vicarious Emails’. Solution Navigate to Setup > Users/Roles > Manage Roles Preferred… Continue reading Resolve Error: “Permission Violation: You need the ‘Vicarious emails’ permission to access this page. Please contact your account administrator.”

Manually Trigger the To Be Emailed Checkbox > Error Message: “Approval routing is enabled for this Transaction, please contact your Workflow Administrator about enabling email processing within an Approval Routing Workflow”

When manually triggering the To Be Emailed checkbox on a Transaction Record where the Approval Workflow applied, the system would give an error message: “Approval routing is enabled for this transaction, please contact your workflow administrator about enabling email processing within an approval routing workflow.” This error message appears when the Approval Workflow is enabled… Continue reading Manually Trigger the To Be Emailed Checkbox > Error Message: “Approval routing is enabled for this Transaction, please contact your Workflow Administrator about enabling email processing within an Approval Routing Workflow”

Populate Rate Field on Item Fulfilment if It Was Created from a Sales Order

The standard Rate field only shows on the Item Fulfillment record if it was created from Vendor Return. If Item Fulfillment was created from Sales Order, the standard Rate field is not displayed on Item Fulfillment by default. As an alternative solution, create a custom transaction line field with a formula {itemunitprice}.If the currency of the… Continue reading Populate Rate Field on Item Fulfilment if It Was Created from a Sales Order

PO Vendor and PO Rate Fields in the Sales Order

The PO Vendor and PO Rate fields are missing in the Custom Transaction Form > Sublist Fields tab when customizing the Sales Order form. In order to see these fields, the Drop Ship&Special Orders feature must be enabled.   Solution Navigate to Setup > Company > Enable Features  Click Items & Inventory Tab  Item Section: Drop Ship & Special Orders: Enter Checkmark  Click Save

Saved Search Not Sending Email Alerts

Scheduled email alerts from a Saved Search no longer send out an email to a specific email address. Find the Recipients of Saved Search Navigate to Lists > Search > Saved Searches Find the Saved Search in Concern Click Email Tab Click Specific Recipients sublist Take note the Email Address of Recipients To Check the Bounced Email Addresses, user may do the following: Navigate to  Lists > Relationships > Bounced Email Addresses Remove the Email… Continue reading Saved Search Not Sending Email Alerts

Saved Search> Scheduled Email> Excel File Has Duplicate Lines

> Saved Purchase Order Search that sends scheduled emails with an Excel attachment for the results.> XXXX is the next Approver of Purchase Order.> XXXX receives an Email that shows 2 lines per Purchase Order. Solution Check Saved Search > Email tab> Specific Recipients subtab> A is listed Check Saved Search > Email tab > Recipients from Results subtab> Next Approver is selected To avoid duplicate lines,… Continue reading Saved Search> Scheduled Email> Excel File Has Duplicate Lines