Page Comparison

...

• Set up Designers as Salesforce Accounts

• Owned or Consignment???? By Order????

• Set up Royalty Rate by Item, Designer/Vendor, and Channel Type

• Royalty Rate Setup

  • Game - Designer’s game (Item)

  • Designer/Account/Vendor - Designer/Vendor account

  • Sales Channel - Pickst list with values “Retail” and “Wholesale”

    • Total Sales defaults Channel Type to Retail when sales orders are from Shopify

    • If not from Shopify, Wholesale

    • Ad Magic has a routine to create GF Sales Orders from Total Sales. The routine also populates the Sales Channel.

    • If a Sales Order is created manually, the Channel Type defaults to wholesale but can be changed.

  • Rate - Numeric field represents % if Rate Type is ‘Percentage’, $ Amount if Rate Type is ‘Fix Amount per Unit.

  • Rate Type - Picklist with values: “Percentage” and ”Fix Amount per Unit”

  • Unit COGS - Cost of goods sold per unit.

  • Deduct COGS - If Checked, the system will deduct the total cost of goods sold (COGS * Invoiced Qty) from the royalty amount.

    

...

1. Navigate to Royalty Calculation

2. Click the “Calculate Royalty” button

3. Month End defaults to the previous month’s last date.

4. System will

   1. Gather all games(items) with a royalty rate setup

   2. Retrieve all Sales Invoice Lines with the following criteria

      1. Sales Invoices' Document Status = Posted

      2. Item gathered in step a

      3. It does not have a Royalty Calculation Line linked

      4. Posting Date <= the Month End date

• Each unique combination of Year/Month and Designer account will have a Royalty Calculation header????

• Royalty Amount calculation logic

  • If Royalty Rate’s Rate Type setup is “Percentage”

    • Then Royalty Amount = Sales Amount * Rate / 100

  • If Royalty Rate’s Rate Type setup is “Fix Amount per Unit”

    • Then Royalty Amount = Invoice Qty. * Rate

  • If Deduct COGS is checked and the Unit COGS field is not blank in the Royalty Rate setup

    • Then Royalty Amount = Royalty Amount - Line COGS

      • Line COGS field in the Royalty Calculation Line object is calculated using COGS in the Royalty Rate * Invoice Qty.

• Multiple Royalty Calculation Lines will be created if more than one designer/vendor is set up to receive a royalty in the Royalty Rate table.

• Users need to review and pay.

...