Colorado Retail Delivery Fee Handling in NetSuite Connector

The Colorado Retail Delivery Fee is a charge applied to all deliveries made by motor vehicle to customers in Colorado. To effectively manage this fee within NetSuite, it's essential to create a non-taxable other charge item, which will then automatically be applied to any Shopify orders that include this fee.

How to Create the Other Charge for Colorado Delivery Fee

Follow these steps to create the other charge item for the Colorado Retail Delivery Fee:

1. Navigate to Lists > Accounting > Items > New.
2. Under Item Type, select Other Charge for Sale.
3. Fill out the necessary information:
   • SKU: Enter ColoradoRetailDeliveryFee in the designated SKU field.
     • Note: To find the correct SKU field for your connector, go to Settings > Orders. The field ID for your SKU can be found under NetSuite SKU field id.
   • Go to the Accounting subtab.
   • In the Income Account field, select the appropriate expense account for this charge.
   • From the Tax Schedule dropdown, choose Not Taxable.
4. Click Save to finalize the setup.

By following these instructions, all future orders that incur this fee in Shopify will have it correctly reflected in your NetSuite account.

Best Practices

• Ensure that your SKU naming conventions are consistent with your business practices to avoid confusion.
• Regularly review your income accounts to verify that fees are being recorded in the correct categories.

Who This Affects

This update impacts the following roles and modules:

• Administrators: Responsible for item setup and accounting configurations.
• Developers: Involved in integrating the NetSuite Connector with Shopify.
• Accountants: Management of income accounts related to delivery fees.

Key Takeaways

• The Colorado Retail Delivery Fee must be handled as a non-taxable charge.
• Correct item setup in NetSuite ensures accurate fee reflections in Shopify orders.
• Proper income account selection is crucial for financial reporting.

Source: This article is based on Oracle's official NetSuite documentation.