Avatar

Harrison

  • Total activity 23
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 3
  • Subscriptions 11

Activity overview

Latest activity by Harrison
  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    Autoship Inventory PlanningHow many (qty) of which items (SKU) do I need to be prepared to ship per date? Report includes "today" and future Next Process Dates through the next 365 days, ordered by...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    How can I audit Tree Movements that have been executed by Corporate Users?NOTE: If you process a lot of movements, consider narrowing the date range.  select  ST.Date, ST.[user] as CorporateAgent, ...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    How do I view the order history of a specific Sponsor's Downline? Select Concat (D.Firstname,' ',D.Lastname) as SponsorName,O.Name as CustomerName,O.recordnumber as OrderNumber,O.OrderDate,OD.SKU,O...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    Auditing Associate Types and their Status - what do the numbers look like?If you want to exclude voided accounts from your results, remove the "--" from the WHERE line. As is, this will report all ...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    How can I see all of my Shipping Methods at once? selectSM.Recordnumber as ShipMethodID,SM.Void,SM.MethodName,R.Name,CASEWHEN SM.Shippingtype = 1 then 'FixedCost'WHEN SM.Shippingtype = 2 then 'PerP...

  • Harrison commented,
    1. Emails & Notifications
    2. DirectScale Email Templates
    3. Editing Email Templates

    We've found through trial and error that Email Images must NOT have a "space" in the name. For example, my background.png will not work correctly and the image should instead be saved as mybackgrou...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    How many standard orders did we process today? Results give a count for each day over last 30 days, excluding canceled orders SELECT      CONVERT(varchar(12),orderdate, 101) as Date,      COUNT (r...

  • Harrison commented,
    1. Reporting
    2. Corporate SQL Reports
    3. SQL Query Library

    Which distributors have a remaining balance in their Rewards Points ledger? Select     D.Recordnumber AS DS_ID,     D.BackofficeID,     SUM (RL.Amount) AS UnusedPointsFROM CRM_Distributors DJOIN C...

  • Harrison commented,
    1. General Setup
    2. Markets & Localization
    3. Adding Currencies

    PLEASE NOTE! Exchange rate CANNOT be 0 and will result in errors across the platform. If no exchange rate is desired, the proper entry is 1.