David_B's Profile



  • Beginner Asked on May 30, 2023 in Accounting.

    Unfortunately it’s impossible after you’ve created it. You have to create a new account of the correct type.
    See recent discussion on Slack (archive)

    • 2 answers
    • 0 votes
  • Beginner Asked on May 30, 2023 in Inventory.

    easiest way is to use a summary search, GROUPed on (using your example) Order, Line Number, SKU. Then two columns (summary type SUM) with formula(numeric) like:

    DECODE({item.inventorylocation}, 'WHS 1',{item.locationavailable},0)
    DECODE({item.inventorylocation}, 'WHS 2',{item.locationavailable},0)

    could also use CASE statement in formula, like:

    CASE {item.inventorylocation} WHEN 'WHS 1' THEN {item.locationavailable} ELSE 0 END

    • 1 answers
    • 0 votes
  • Yes, it is possible. You’ll want to use the options under the “Sourcing & Filtering” tab when creating the transactions line field.
    Refer: Setting Sourcing Criteria (you might also need Creating a Custom Field)

    • 1 answers
    • 0 votes
  • Beginner Asked on April 5, 2023 in SuiteScript.

    Seems like your GET call from the C# program is missing a required argument “recordtype”

    • 1 answers
    • 0 votes
  • I can’t find anything built-in (maybe I missed something in the Supply Allocation feature?). However I have a saved search for this use case.
    There may be more elegant solutions out there, but I can’t find them 😉


    The basic criteria filters you need are:

      • sales orders with back ordered quantities (
        is greater than 0)


      • inventory locations that have available stock (
        CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END
        is greater than 0)


    Additionally I would filter for: Commit (status) is any of Available or Complete Qty; Status is any of (open statuses).
    You also may need to consider additional filters if you have a one-world account (not sure if this is what you’re implying by “two warhouse and multiple store locations”)

    As for search results, I would recommend a summary-level search to group all of your fulfillable locations together. Additionally I have these two results columns that may help:

      • “Total available at other location(s)”, Formula (Numeric), summary type: Sum
        CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END


      • “Available per location”, Formula (Text), summary type: Minimum
        LISTAGG({item.inventorylocation}||': '||CASE WHEN {location} != {item.inventorylocation} THEN {item.locationquantityavailable} ELSE 0 END, '<br>') WITHIN GROUP (ORDER BY {item.inventorylocation})
          • this produces text like:
            Loc1: 50
            Loc2: 65




    • 1 answers
    • 0 votes
  • Beginner Asked on November 3, 2022 in Projects.

    Only thought would be if under Set Up Auto-Generated Numbers, Projects had “Allow override” enabled and someone renumbered a project to 801209. Subsequent projects would increment from there.

    I had the same issue with a user overriding a customer account number to “1234567”….

    • 1 answers
    • 0 votes
  • Beginner Asked on August 4, 2022 in Order Management.

    Have a look into Multiple Shipping Routes
    I haven’t used it specifically with drop shipments, but it works with fulfilling out of inventory.

    • 1 answers
    • 0 votes
  • Beginner Asked on November 10, 2021 in Administration.

    Global searches return records that have name or ID field values that match the entered keywords. I believe that is why those opportunities are showing up, as they have the customer number in their name field.

    For quotes (aka “estimates”), the “title” field is indexed for global search. You can either have users type in the customer number there or (IMO the better solution) you can create a custom field that is sources the account number from the customer record and is indexed for global search.
    Follow these instructions for how to create a custom field (step 12 deals with global search), and this page on how to set the sourcing criteria (to source the customer’s “Name/ID”)

    • 4 answers
    • 0 votes
  • Beginner Asked on October 27, 2021 in SuiteFlow.

    Hi, CONCAT only takes two  values. You could try either nesting the CONCAT functions

    CONCAT({field1}, CONCAT({field2}, {field3}))

    or more simply using the concatenation operator “||”

    • 3 answers
    • 0 votes
  • If you just want a trigger to allocate back ordered SO’s, wouldn’t a search for “SO with backordered quantity where the item has available stock?”

    If you truely want it to be triggered by inbound stock (consider not only receipts, but things like transfers, adjustments, etc), then you would have to:
    Do a summary saved-search, grouped by item. criteria something like: inbound transactions (i.e. receipts); date = today; backordered > 0; available > 0.
    You’d also have to add more criteria if you have locations enabled and what it location specific (to tie the backorder and available qty to the transactions’ location).


    But consider your requirements and whether the first (simpler) option is actually what you need.

    • 1 answers
    • 0 votes