Articles tagged #OR
Articles tagged
#OR

Import Expense Report > Sublist Fields

You use the Expenses sublist to add or update individual expenses on an expense report record. This sublist can be selectively updated by either the Line ID or Ref No. field.

Read More

Import Expense Reports as Reimbursable

The user needs to import Expense Reports to be recognized as Reimbursable, and won't be deducted on the Advances to Apply.

Read More

Custom Accountant Role With Expense Report Permission Full Cannot Approve Expense Report via Approve Expense Report Page

The user has a Custom Accountant role with permission for theExpense Reportset toFull.Using the role, the user navigates to theApprove Expense Report page to view lists of expense reports for approval. Aftera checkmark is placed on theExpense Reportto approve and clickSubmit,the page reloads but theExpense Reportchecked is stillUnapproved.

Read More

Importing Vendor Records with Special Characters

To import Vendor or Customer Name with special characters, do the following;

Read More

Restrict Users from Updating Field Mapping of a Shared CSV Import

A user needs to restrict users from editing the mapping and settings of a saved CSV import that they have shared.

Read More

Return User Error on Transaction Deletion not Working

A user wants to return a user error via workflow whenever a user tries to delete purchase orders that are not created by them.

Read More

Unable to set Account for Corporate Card Expenses When Editing Expense Reports

A user is trying to select an account in the Account for Corporate Card Expenses dropdown field in an Expense Report, but when saving the record, the value under this field is missing.

Read More

Use one Email Address to Display in the From Field of the Emails Sent from OneWorld NetSuite Account

User needs to set their emails to show only one email address on the FROM email address sent from the system

Read More

Specific Roles to Access Only Specific Custom Form

A user would like to know how they can assign a specific custom form to a specific role

Read More

Things to Check if Item is not Showing on the Web Store

Items are not showing on the web store.

Read More

Restricting Ship To Countries in Your Commerce Web Store

If you only provide domestic shipping or cannot ship to certain countries, you can designate which countries you want customers to be able to select in your Commerce web store.

Read More

Set Document Status on Estimates

User wants to set the Document Status of Estimates based on their Probability.

Read More

Resolve Error: Enter Values For Serial/Lot Number when Billing a Sales Order

The user gets the error saying:Please enter value(s):for Serial/Lot Numberwhen billing theSales Order.

Read More

Enable/Disable Oracle Guided Learning Preference

The user wants to remove the newly added button at the middle-right part of the dashboard.

Read More

Remove an Employee from the Sales Rep Field > Unable to Locate the Employee Record

The user wants to remove one of the employees listed on the standard Sales Rep field in entity/transaction records. However, when the user navigates to the Lists > Employees > Employees, the employee is not listed. The employee may have a generic name such as "Pre-Sales, Sales - Professional Services, Accounts, Marketing Team", etc.

Read More

Align the Webstore Pages to Center

By default, the page width is set to percentage and the page alignment field is disabled.

Read More

Resolve Users Who are Allowed to Fulfill More than the Quantity on hand When Fulfill based on Commitment setting is set to Limit to Committed

System allows fulfilling of Sales Orders more than current Quantity On Hand even if Fulfill based on Commitment setting is set to "Limit to Committed" and the user is fulfilling items using the Standard Sales Order Form.

Read More

Add AR Aging Summary Report to Home Dashboard

The only way to add the AR aging summary report to Home Dashboard portlet is by way of creating a standard KPI - Receivables. The KPI provides a link to the report. When you click on Today in the KPI, the AR aging summary report opens. The report is not available as a snapshot.

Read More

Saved Search on Inventory Count of Lot Numbered Items to Show the Inventory Numbers and Quantities on Snapshot Detail and Count Detail

Scenario

Users want to show in a single saved search theInventory Numbersand their quantities on theSnapshot DetailandCount Detail.

Solution

  1. Navigate toLists>Search>Saved Searches>New
  2. SelectTransaction
  3. Search Title:EnterTitle
  4. ClickResults
  5. ClickStandard
  6. Filter:
    • SelectType
      • SelectInventory Count
    • SelectItem
      • Selectnot none
    • SelectStatus
      • SelectInventory Count:Approved,Inventory Count:Completed/Pending Approval
    • SelectItem fields...
      • SelectIs Lot Number
        • SelectYes
    • SelectFormula(Numeric)
      • Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
        • Formula (Numeric):Selectequal to
        • Value:Enter1
  7. ClickResults
  8. ClickColumns
  9. Field:
    • SelectDate
    • SelectDocument Number
    • SelectItem
    • SelectFormula(Text)
      • Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
      • Custom Label:EnterSnapshot Lot Number
    • SelectFormula(Text)
      • Formula:EnterCASE WHEN{transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.quantity} ELSE null END
      • Custom Label:EnterSnapshot Quantity
    • SelectFormula(Text)
      • Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
      • Custom Label:EnterCount Lot Number
    • SelectFormula(Text)
      • Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.quantity} ELSE null END
      • Custom Label:EnterCount Quantity
  10. ClickAdd
  11. ClickSave & Run

Read More

No Items Showed on Create Inventory Count Page

Scenario

A user found no items shown on the Create Inventory Count page. This is due to the last inventory count date can no longer be used or set even when the inventory count created on that day has already been deleted. For example, when an item has the last inventory count date set to 12/31/2020, the next inventory count date is 1/30/2021, and the inventory count interval is 30. On the inventory count page, the count start date should be 1/30/2021 but not 12/31/2020.

This holds true even if the previous inventory count made on 12/31/2020 has already been deleted. This last inventory count date is not editable because this is based on the inventory count generated from the create inventory count page. Itis also not advisable to delete an inventory count as there may be inventory adjustments related to it.

Solution

Recreate deleted Inventory Count record.
  1. Navigate toTransactions>Inventory> EnterInventory Count
  2. Populate required fields with preferred values
  3. Itemstab
  4. SelectItemfrom the drop-down list
  5. ClickSave
Note:Inventory Adjustments might be created by the deleted Inventory Count due to differences between Count Quantity and Snapshot Quantity.Moving forward, the Create Inventory Count page may be used on succeeding Inventory Counts.

Read More
Read More Articles