Order Time

Home
Glossary
Importing
- Importing Tips
- Importing - Assembly Item
- Importing - Barcodes
- Importing - Bin
- Importing - Bin Quantity Import
- Importing - BOM Component
- Importing - BOM EASY
- Importing - Non Inventory Items
- Importing - BOM Step
- Importing - Cart Item
- Importing - Category
- Importing - Consignment Line Item
- Importing - Contact
- Importing - Count Line
- Importing - Customer
- Importing - Customer Address
- Importing - Customer Alias
- Importing - Customer Category
- Importing - Customer Item Group Prices
- Importing - Customer Item Prices
- Importing - Easy Kit
- Importing - Employee / Other Name
- Importing - Event
- Importing - Item Alias
- Importing - Adjustment Line Item
- Importing - Item Category
- Importing - Item Images
- Importing - Item Vendors
- Importing - Job Item
- Importing - Kit Group
- Importing - Kit Item
- Importing - Kit Selection
- Importing - Lead
- Importing - Location
- Importing - Log
- Importing - Lot or Serial
- Importing - Lot or Serial No Quantity
- Importing - Manufacturer
- Importing - Package Item
- Importing - Part Item
- Importing - Purchase Order Easy
- Importing - Purchase Order Line
- Importing - Quote
- Importing - Receiver Line
- Importing - Related Items
- Importing - Reorder Point by Location
- Importing - Sales Order
- Importing - Sales Order Easy
- Importing - Sales Order Line
- Importing - Service Item
- Importing - Ship Doc
- Importing - Ship Doc Line Item
- Importing - Task
- Importing - Transfer Line Item
- Importing - Vendor
Onboarding
- Setup
- Items
Admin
- Company Preferences
- Using the Payments System
- Profile Lists
- Payment Methods
  - Payment Methods
- Activities
- Label Templates
- Form Templates
- Accounting Integration Settings
- Accounting Integration Restrictions
- List Shading Rules
Integrations
- QuickBooks Online
- QuickBooks Desktop
- Xero Accounting
  - Xero Accounting - Integration & Syncing
- Ecommerce Integrations
- Order Time Mobile
- All Orders Mobile
- Shipping Integrations
  - ShipStation
    - Shipping Integration - ShipStation
    - ShipStation Ship Method Mapping
  - 2Ship
    - 2Ship Integration Guide
- Custom Label Printing
- AvaTax by Avalara
- Mail and Calendar Integration
  - Mail and Calendar Integration Setup
- TrueCommerce EDI
  - TrueCommerce EDI Integration
- SPS Commerce EDI
  - SPS Commerce EDI Integration
  - SPS EDI Preference - Descriptions
- Easy Insight Integration
  - Easy Insight Integration Webinar
  - Easy Insight Integration Setup
- Zapier Integration
  - Zapier Integration
- DocuSign
  - DocuSign Integration
- Syncware EDI
- Accounting Sync Job
- Accounting Sync Queue
- Accounting - Batch Repost Journal Entries
Sales
- Sales Cycle
- Adding Leads
- Adding Customers
- Tracking Number on Ship Docs
- Creating a Quote
- Vendor RFQ - Request for Quote
- Removing Quantity from a Ship Doc
- Create a Sales Order
- Enable Catalog Ordering
- Item Substitution on a Sales Order
- Sales Order Allocation
- Select Items to Ship
- Splitting a Sales Order
- Consignment
- Additional Fees
- Issue a Customer Refund as a Credit
- Credit Limits Explained
- Creating a Transfer from a Sales Order
- Shipping Estimation
- Ship Docs Overview
- Closing a PO or SO with an Open Quantity
- Auto Email Customers on Shipping
- Merging Customers
- Closing Open Orders
- Customer Returns
- Recalculate Pricing on Sales Order
- Creating Refunds and Partial Refunds
- Putting a Customer On Hold
- Assigning Sales Rep to Customer by Address
- Default Forms for Customers
- Fulfillment Batch
- Closing a Sales Order
- Duplicating a Sales Order
- See Can Make for Assemblies and Kits on Sales Orders
- Adding a Discount as a Line Item
Production
- Production Cycle
- Kit vs Assembly Items
- Nested Bill of Materials vs. Steps
- Assemblies and Creating a Bill of Materials
- Create a Bill of Materials: In Depth
- Creating a Configurable Bill of Materials
- Creating a Step
- Generate a Work Order
- Tracking Work Orders
- Work Orders - Reload BOM
- Creating a Reorder Analysis for Production
- Creating a Sales Order with a Linked PO & Linked WO
- Using Quick Build for Work Orders from a Sales Order
- Creating Work Orders for Multiple Sales Orders
- Creating a New Disassembly
- Enable Split, Drill Down, Flatten Features on a Work Order
- Drill Down a Work Order
- Splitting a Work Order
- How to Create Production Orders
- Quick BOM Report
- Handling the Costs of Goods Sold account. How certain conditions may impact behavior and WO components
Warehouse
- Understanding Quantities In Order Time
- How Order Time consumes Inventory
- Complete an Inventory Adjustment
- Generate a Cycle Count
- Complete a New Location Transfer
- Create New Bin Move
- Complete a Value Adjustment
- Order Time and FIFO
- Inventory Aging
- Can Make in Reports
Purchasing
- Purchasing Cycle
- Vendors
- Creating a Purchase Order
- How can I enter my purchasing costs for my items in foreign currencies?
- Linked POs and Drop Ship POs
- Using Reorder Analysis
- Creating a Reorder Analysis for Purchasing
- Create a Receiving Doc
- Import Lot & Serial Numbers Onto Receiver Line Items
- Vendor Returns
- Receiver Charges
- Adding Charges After Receiving
- Add Items From Open Purchase Orders
- Standard Cost Vs. Value Amount
- Receiver Allocation
- Forecasts
B2B Portal
- B2B Portal Guide
- B2B - Adding a Portal
- B2B - Configuring the Portal Settings
- B2B - Setting up Item Categories & Customer Categories
- B2B - Setting up Contacts with Portal Access
- B2B - Setting up Payments for the B2B Portal
- B2B - Cart List
- B2B - Setting up Related Items for the 'Frequently Bought With' Section
- B2B - Image Sizing Guidelines
- B2B Cart import
- B2B - Emails and Logs
Payments
Reports
- Creating Reports
- Customizing Reports
- Viewing Existing Reports
- Sorting Reports
- Creating a Pivot Table Report
- Add Images to Reports
- Creating a Report Schedule
- Inventory Valuation 'At Date' Report
- Inventory Status by Item Table for the Bill of Materials Report
- Reports - Role Access
Rentals
- Rental Module
Repairs
- Enabling Repair Orders and Setting Repair Preferences
- Creating an Internal Repair Order
- Creating an External Repair Order
API
- API Overview
- Entities
- Transactions
- Examples
  - Create Customer Example
  - Work Order API - A-Z
Webinars and Videos
- Past Webinars
- Training Videos
- About Us
Release Notes & Troubleshooting
- Release Notes
- Troubleshooting Solutions
- QuickBooks Online Troubleshooting
- QuickBooks Desktop Troubleshooting
- Xero Troubleshooting
  - Xero Error: Token not valid
- All Orders Migration Questions
  - Why is Inventory Valuation in All Order different than Order Time.
Join our Community Forum
Billing & Subscription
- Order Time Billing
View your Ticket Dashboard
Contact Us / Create a Ticket

Search results...

Exporting a CSV and Opening in Excel is Removing Trailing Zeros

Last Updated: 04/16/2024 in Release Notes & Troubleshooting Troubleshooting Solutions
Tags: import error imports excel comma delimiter CSV troubleshooting trailing zeroes cutting off item name How to

Exporting a CSV from Order Time and Opening in Excel is Removing Trailing Zeros From Numeric Item names and numbers. How to solve this issue by changing how you utilize Excel.
Excel File Splitting Solution - Splitting an Excel Sheet Into Multiple Files

Last Updated: 11/19/2020 in Release Notes & Troubleshooting Troubleshooting Solutions
Tags: file csv online split imports solution excel troubleshooting splitting imports support

How to split a single Excel file into multiple files prior to importing information into Order Time.

Copyright © 2018 - 2026 Order Time is a product of NumberCruncher.com, Inc.. All rights reserved.