Document Grid Import and Export Standards

fix grid imports and make them standard for import and export from documents 

 All imports to be CSV and semicolon enabled 

 See new layout formats that conforms to both debtors and creditors 

 The grid import and exports for Debtors are as follows: 

 1. Quote 

 2. Sales Order 

 3. Invoice 

 4. Credit Note 

   

 Creditors 

 1. Purchase Order 

 2. GRV 

 3. Stock Return 

   

 For the VAT Type of each line 

 The following rule applies 

 1. If the customer or supplier has a VAT type set, use that for all items 

 2. Otherwise use the default VAT types for each document 

 Warehouse import 

 If the item is a service or custom, ignore the warehouse field 

 If an item does not have a warehouse selected for import and is blank, use company default 

 For Creditor document imports 

 If there are any service items in the import ignore them for creditor document imports 

 For Job CTC import for whether it is CTC or SC.  Use CTC as default is nothing is set 

 For imports, only the first number of fields are required, ignore the rest 

 When importing grids on any of the documents who are multicurrency.  The cost needs to be updated with the value of the multicurrency. 

 Sequence number.  If blank, put in a sequence number from 1 onwards