Documents
HomeGlossary
Learn NetSuite
Learn NetSuite
  • Introduction
  • Integration Tools and Methodologies
    • SuiteScript
      • N/Task Module
      • N/Record Module
      • N/Search Module
      • N/File Module
    • Saved Search
    • Integration Methodologies
    • NetSuite
    • HotWax
  • Integration Flows
    • Inventory
    • Sales Orders
      • Order Approval
      • Order Allocation
      • Fulfillment
      • Invoicing
      • Shipping Methods
      • Gift Card Orders
      • POS Orders
      • Send Sale Orders
      • Reports
    • Returns
    • Exchanges
    • Kit Products
    • Transfer Orders
      • Warehouse to Store
      • Store to Warehouse
      • Store to Store
      • Reports
    • Cycle Count
    • Purchase Orders
  • NetSuite Deployment
    • Deployment
    • SDF Bundle Setup
      • Install SDF
      • Setup SFTP
      • Date Time Format
    • Prerequisites
      • Install NetSuite Jobs
      • Product Store Settings
      • SFTP Locations
      • Historical Customers
      • Shipping Methods
      • Price Level
      • Payment Methods
      • Promo Codes
      • NetSuite Facility Group
  • Synchronization Flows
    • Auditing
    • Products and Inventory
      • Product IDs
      • Inventory Reset
    • Orders
      • POS Cash Sales
      • Sync Customer
      • Sync Order IDs
      • Approve Orders
      • Reports
    • Allocation & Fulfillment
    • Transfer Orders
    • Purchase Orders
    • Integration Mappings
      • Payment Methods
      • Discount Codes
      • Price Levels
      • Shipping Methods
      • Facility Group
  • Troubleshooting
    • Failed SuiteScripts
    • Error Logs
    • Failure Notifications
    • Order Sync Failure
Powered by GitBook
On this page
  • Default Formats
  • Verification Process
  • Verification Steps

Was this helpful?

Edit on GitHub
Export as PDF
  1. NetSuite Deployment
  2. SDF Bundle Setup

Date Time Format

Ensure accurate date and time formatting for seamless data communication with NetSuite.

Default Formats

  • Date Format: 'M/D/YYYY'

  • Time Format: hh:mm AM/PM

Verification Process

  • For Date Format: a. Log in to NetSuite. b. Navigate to Setup > General preferences > Company c. Verify the date format under the Date/Time Format section.

  • For Time Format: a. Log in to NetSuite. b. Navigate to Setup > General preferences > Company c. Verify the time format under the Date/Time Format section.

Verification Steps

  1. Date Format:

    • Check the default NetSuite date format, 'M/D/YYYY.'

    • If changed, share the updated format with the HotWax integrations team.

    • Ensure the HotWax integrations team adjusts the date format in CSV imports for entities like sales orders, cash sales, and inventory adjustments.

  2. Time Format:

    • Confirm the default NetSuite time format is 'hh:mm AM/PM.'

    • If modified, update all export map/reduce SuiteScripts.

    • Ensure these adjustments align with the client's last run date-time data.

By following these steps, you can easily check and verify the NetSuite date and time formats, ensuring accurate communication with the HotWax integrations layer and seamless data handling in export processes.

PreviousSetup SFTPNextPrerequisites

Last updated 1 year ago

Was this helpful?