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