Articles tagged #SALES
Articles tagged
#SALES

Custom Role > Create KPI Scorecard > Unexpected Error

Scenario
When a custom role tries to add a Custom KPI Scorecard in the dashboard, it shows "Unexpected error has occurred" notice
Solution
  1. Log in as an Administrator
  2. Navigate toCustomization>Centers and Tabs>KPI Scorecard
  3. Affected Scorecard: ClickEdit
  4. ClickContent
  5. ClickCustom
    Note: Make sure that there are no skipped fields for Custom KPI # 1-9. For instance, if you add three Custom KPIs, it should be under Custom KPI #1, Custom KPI #2, and Custom KPI #3.
  6. ClickSave

Read More

Unable to Link Quote to Opportunity

Scenario
A user wants to link their existing quote record to the opportunity record.

It is standard behavior that users cannot link opportunities to existing quotes. To link opportunities to quotes, users need to use the Create New menu from opportunities.
Solution
  1. Navigate toTransactions>Sales>Create Opportunities>List
  2. OpenOpportunityrecord
  3. ClickSalestab
  4. ClickQuotessubtab
  5. ClickNew Quote
Note:You will see under the quote form that the "Created From" field is inline.

Read More

Print Picking Ticket Status on Sales Order Changed from True to False

User wants to change thePrint Picking Ticket Statusunder theSystem InformationofSales Orderfrom T to F

Read More

CSV Import > Sales Order > Error: Invalid item reference key XXX for subsidiary XXX

During an update of a transaction via CSV import, the error"Invalid item reference key XXX for subsidiary XXX"is encountered.

Read More

FulfillOrderNotice:numberbins(xx)nottoitem(xx)

When user tries to fulfill a Sales Order, a notice pops up with a message,"The number of bins entered (xx) is not equal to the item quantity (xx)."

Read More

Customer Saved Search Shows Total Sales for Both Parent and Child Customers

User wants to create a Customer saved search that returns the Total Sales for both Parent and Child customers.

Read More

Gift Certificate not available in sales order

Gift Certificate not available in Sales Order.

Read More

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

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

Class per line item is not populating in a sales order transaction

Classper line item is not populating in aSales Ordertransaction.

Read More

GST Sales Tax Code is Appearing on Purchase by Tax Code Report

The user has a Tax Code which is specifically made for Sales Transactions. However, whenthe user runs the Purchase by Tax Code report, the said Tax Code is appearing on the report.

Read More

Shipping Tax Code Blanks After Changing Shipping Address

Shipping Tax Code becomes blank after user changes Shipping Address in new Sales Order.

Read More

Show Purchase Orders and Vendor Bills Under Related Records of Project/Job Record When Projects on Sales Transactions Are Not Consolidated

Purchase transactions (Purchase Orders and Vendor Bills) are not directly associated with Project entities because they are part of the Accounts Payable module and not the Advanced Project Management module of NetSuite. This is reproducible when the Accounting Preference "Consolidate Projects on Sales Transactions" is disabled.

Read More

Saved Search to Show Fulfillment /Invoice Dates of Sales Orders in a Date Range

Create Saved Search to display the Fulfillment and Invoice applied to a Sales Order within a specific Date Range

Read More

Sales Order Saved Search to Display Related Invoice, Item Fulfillments, Purchase Orders, and Bills

User requires a Sales Order Saved Search to show related Invoices, Item Fulfillments, Purchase Orders and Bills on each column.

Read More

Saved Search > Transaction > Sales Orders > Actual Ship Date or Fulfillment Date per Line Item

To create a transaction saved search that shows the actual ship date on the item fulfillment.

Read More

Cost of Sales Adjustment on Bill Credit

Cost of Sales Adjustmentis not always equal to the amount ofItemsbeing returned in theBill Credit.

Read More
Read More Articles