Articles written by Pattranit Lakhan
Articles written by
Pattranit Lakhan

For Invoice Grouping Checkbox Is Greyed out on Sales Order

When a user is viewing a Sales Order, theFor Invoice Groupingcheckbox is greyed out and cannot be unchecked. TheInvoice Groupfeature is enabled in the account.

Read More

Next Bill/Bill Remaining Button Not Showing on Sales Order

Scenario

Customer is trying to create an Invoice from a Sales Order related to a Time and Materials Billing Project. Actual time entered against the project is approved. However, on the Sales Order record, the Next Bill Button is missing. It is also noted that the sales order line item quantity is less than the quantity invoiced.

Solution

1. Open the Sales Order Record
2. ClickEdit
3. Click onRefresh Items from Project
4. ClickSave

After the record loads, the Next Bill button should now appear on the Sales Order

Read More

Update Item Information on Sales Order Using Workflow

Scenario

When an Item record is updated (for example: pricing, description, etc.), the updated item information is not automatically reflected on Sales Orders that were already created with the item. Thus, it is needed to manually re-add the item/s for the new Item information to be shown. To avoid this, a workflow can be created which can be executed using a button whenever needed.

Solution

  1. Navigate toCustomization>Workflow>Workflows>New
  2. Basic Information:
    • Name:EnterName
      Example: Auto Update Items
    • Record Type:SelectTransactions
    • Sub Types:SelectSales Order
    • Execute as Admin:EnterCheckmark
    • Release Status:SelectReleased
  3. Initiation:SelectEvent Based
  4. Event Definition:
    • On Create:EnterCheckmark
    • On View or Update:EnterCheckmark
    • Trigger Type:Select-All-
  5. ClickSave
  6. ClickNew State
  7. ClickState 1
  8. Lower Right Corner:ClickNew Action
  9. ClickAdd Button
  10. Parameters:
    • Label:EnterLabel
      Example: Update Item
    • Save Record First:EnterCheckmark
  11. ClickSave
  12. Double-clickState 1
  13. ClickTransitions
  14. ClickNew Transition
  15. Basic Information:
    • To:SelectState 2
  16. Condition:
    • Execute on Button:SelectUpdate Item
  17. ClickSave
  18. Double-clickState 2
  19. ClickNew Sublist Action
  20. Parameters:
    • Sublist:SelectItems
  21. ClickSave
  22. ClickSublist Action Group
  23. ClickNew Action
  24. ClickSet Field Value
  25. Parameters:
    • Field:SelectItem (Line)
    • Value:SelectFrom Field
      • Record (Join):SelectCurrent Record
      • Field: SelectItem (Line)
  26. ClickSave

Read More

Create Open Sales Order Saved Search to Display Sales Order Internal ID

Although standard Open Sales Orders report can be customized, the option to add column specifically with Sales Order Internal ID is not available at the moment. As a workaround or alternate solution might serve a Saved Search which results would be identical to Open Sales Order Report with additional column with internal ID of the transaction.

Read More

Re-Bill Items from Purchase Order that were Previously Cancelled

Scenario

Purchase Orders are previously cancelled but user wants to generate all remaining items that is up for billing.

Solution

1.Purchase Order: ClickEditon the affected record
2. ClickItemstab
3. Remove the lines that have a cancelled Bill record
4.Re-input the items and other details
5. ClickRelated Recordstab
6.Item Receipt: ClickEditon the related Item Receipt
7. ClickAction
8. ClickDelete
Note:Retain the Item Receipt record for the correctly Billed item
9.Go back to the Purchase Order record and clickSave
10. ClickBill

Read More

Restrict Custom Role to Specific Custom Record Page Only

Userwants to restrict aRolefrom accessing other pages apart from a specificCustom Recordpage.

Read More

Show User Who Logged in Using at Least 2 Different IP Addresses in a Day Via Login Audit Trail

Scenario

User wants to have a saved search where they can see who logged in using at least two different IP addresses in a day.

Solution

  1. Navigate toLists>Search>Saved Searches>New
  2. New Saved Search:SelectLogin Audit Trail
  3. Search Title:EnterTitle
  4. Criteria:ClickSummary
    • Summary Type:SelectCount
    • Field:SelectIP Address
      • IP Address:SelectGreater Than
      • Value:Enter1
      • ClickSet
  5. ClickAdd
  6. ClickStandard
  7. Filter:SelectDate
    • Date:Selectwithin Today
  8. ClickSet
  9. ClickResults
  10. Field:SelectFormula (Date)
    • Formula:EnterTO_DATE({date})
  11. ClickAdd
  12. ClickSave & Run

Read More

Resolve Inability for Custom Role to Edit Purchase Orders via Inline Editing

Scenario

Custom role with Purchase Order permission, set to Edit access level, is unable to edit Purchase Orders via Inline Editing.

Solution

  1. Navigate toSetup>Users/Roles>Manage Roles
  2. Custom Role:ClickEdit
  3. General:
    • Restrict Time and Expenses:RemoveCheckmark
  4. ClickSave

Read More

Display Files Attached to Records on a Transaction Saved Search

Users need to create a Saved Search todisplaythe attached Files on transaction records on a column with a live hyperlink that allows the download of the file.

Read More

Set Default Account on Cash Refunds using Workflow

User would like tocreate a workflow that will automatically set user's preferred account when creatingCash Refunds.

Read More

Save Vendor Bill with Error: Invalid Account reference key xxx for entity xxx

There are two scenarios that could trigger the error:

Read More

Transaction > Price Level on Transaction Line Item Defaults to Custom

User needs to create sales orders wherein entering an item defaults thePrice Levelto 'Custom'.

Read More

Update Status of Closed Purchase Contract

User needs to update a Purchase Contract but it is already Closed.

Read More

Show Missing Events in Show Activity Window

User needs to show missing Events on the Customer's Show Activity Window.

Read More

Removing Credits From Deleted Vendor Payments

It is important to understand that deleting a vendor bill payment or a customer payment does not automatically unapply credits that you have applied. If you need to delete a payment that includes bills or invoices with credits applied, you must open each credit and unapply it separately.

Read More

Missing Items when Receiving Purchase Orders

When trying to receive purchase orders, some or all of the line items may not appear on the item receipt form.

Read More

User in a Custom Role Cannot Access Results on Event Saved Search Even When Event Permission is Added

When the Permission for Events is set to Full on the Custom Role, Events with Event Access of Show as Busy or Private are only visible to Administrator, Organizer of the event or Users that are listed under Attendees sublist.

Read More

CSV Import of Unapplied Customer Payment

CSV Import of Unapplied Customer Payment.

Read More

Write off Remaining Amount of Invoice Using Credit Memo

User wants to write off remaining amount of Invoice. This can be done by using Credit Memos. However, ensure that the Invoice being written off do not contain Inventory Items because this will have an effect on the Cost of Goods Sold account.

Read More

Show Results of Saved Search for Custom Roles When Using The Filter Amount Is Less Than 0

When user creates a Transaction Saved Search with Amount is less than 0 in Criteria tab, it might not be visible for custom roles, even if permissions were set up correctly by Administrator.

Read More
Read More Articles