Automatic SKU Creation for Amazon Settlement Charges in NetSuite

TL;DR

NetSuite Connector streamlines the creation of SKUs for Amazon settlement charges, enabling automated management of fees and adjustments. This feature simplifies the process significantly, particularly when dealing with various transactions from Amazon.

How Does Automatic SKU Creation Work?

Automatic SKU creation in NetSuite Connector occurs under specific conditions:

• You must have either a single subsidiary or none.
• The itemId field is used as your SKU identifier.

This automated process avoids the need for manual SKU creation, saving time and errors in data entry.

Automated Process Benefits

By utilizing the automatic SKU creation,

• You reduce the administrative burden associated with manually inputting SKUs.
• It minimizes the potential for errors in SKU data, which can lead to discrepancies in financial reporting.

If you wish to delve deeper into the automated process, refer to the section on Importing Amazon Settlement Reports in NetSuite Connector.

Manual SKU Creation

Should you need to create SKUs manually, the process is outlined in the section Manually Creating Amazon Settlement SKUs in NetSuite Connector. This method is encouraged only if certain SKUs were not successfully created during the automated process to prevent conflicts.

Important Considerations

When implementing SKU creation, consider following best practices:

• Ensure that you do not add existing SKUs during manual creation, as this may result in errors.
• Employ CSV import as an alternative for creating multiple SKUs if necessary.

Conclusion

Automatic SKU creation helps maintain accurate transaction records and saves valuable administrative time when managing Amazon settlement charges. Whether opting for the automated method or falling back on manual processes, understanding these procedures enhances management efficiency within NetSuite.

Who This Affects

• Administrators: Responsible for configuring and maintaining system settings for SKU creation.
• Accountants: Utilize these SKUs for accurate financial reporting and reconciliation.
• Developers: May need to integrate or troubleshoot automation processes within NetSuite Connector.

Key Takeaways

• Automatic SKU creation simplifies fee management for Amazon settlements.
• It operates under specific conditions, such as subsidiary setups.
• Manual creation should only address SKUs not created by the automated process.

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