- Learning
- Inventory & Supply Chain
- Sales & Unit Prices
-
Getting Started
-
Account Management
-
Reporting & Insights
-
Payroll & Employees
-
Sales & Receivables
-
Purchases & Payables
-
Accounting Practices
-
Contacts & Customers
-
Fixed Assets
-
Inventory & Supply Chain
-
Advanced Warehousing
-
Connected Apps & Services
-
Service Management
-
Support, Data Security & Updates
-
Microsoft Docs
How to import historical sales data
How should you format the CSV file?
Open up the CSV file that you're going to import data from, and set up the columns like this:
- Column 1: Posting Date
- Column 2: Item No.
- Column 3: Variant Code
- Column 4: Source No. (Sales Document No.)
- Column 5: Valued Quantity
- Column 6: Sales Amount (Actual)
- Column 7: Cost Amount (Actual)
How will the results be created?
For each line in the CSV file, Wiise will create two Item Ledger Entries:
- A Sale Entry (Item Ledger Entry Type = Sale)
- An Inventory Entry (Item Ledger Entry Type = Positive Adjmt.)