There seems to be an issue with the sales order import where the wrong error is flagged.
When I import this file:
Data Import Template,
Table:,Sales Order,
DocType:,Sales Order,~,Sales Order Item,items,
Column Labels:,ID,Series,Customer,Order Type,Company,Date,Currency,Exchange Rate,Price List,Price List Currency,Price List Exchange Rate,Territory,Customer Group,Fiscal Year,Status,Customer Name,Delivery Date,Memo,PO No,PO Date,ID,Item Code,Item name,Quantity
Column Name:,name,naming_series,customer,order_type,company,transaction_date,currency,conversion_rate,selling_price_list,price_list_currency,plc_conversion_rate,territory,customer_group,fiscal_year,status,customer_name,delivery_date,memo,po_no,po_date,~,name,item_code,item_name,qty
Start entering data below this line,
,SO -.###,Lucuma Designs,Sales,Apumano SAC,07/06/2015,USD,3.18,Standard Selling,USD,3.18,Peru,Commercial,2015,Draft,Lucuma Designs,08/22/2015,ARP_070615 Lucy Arpilleras,07/06/2015,ARP114M,ARP114M,1
,ARP612S,ARP612S,1
,ARP652S,ARP652S,2
,ARP630L,ARP630L,1
I get this error:
Import Failed
Error for row (#7) : Date 07/06/2015 not in any active Fiscal Year. For more details check https://erpnext.com/kb/accounts/fiscal-year-error.
This seems like it should be a trivial error, BUT (a) that date is used by other sales orders already in the system,
(b) the current fiscal year is 2015 running from 01/01/2015 to 12/31/2015,
and (c) 2014 and 2015 show up in the list of fiscal years.
I would love to get this working, so any ideas, fixes or work arounds are welcome.
–Don