# Document Grid Import and Export Standards

<span class="ts0">fix grid imports and make them standard for import and export from documents</span>

<span class="ts0">All imports to be CSV and semicolon enabled</span>

<span class="ts0">See new layout formats that conforms to both debtors and creditors</span>

<span class="ts0">The grid import and exports for Debtors are as follows:</span>

1.<span class="ts0">Quote</span>

2.<span class="ts0">Sales Order</span>

3.<span class="ts0">Invoice</span>

4.<span class="ts0">Credit Note</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2930).png)

<span class="ts0">Creditors</span>

1.<span class="ts0">Purchase Order</span>

2.<span class="ts0">GRV</span>

3.<span class="ts0">Stock Return</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(2931).png)

<span class="ts0">For the VAT Type of each line</span>

<span class="ts0">The following rule applies</span>

1.<span class="ts0">If the customer or supplier has a VAT type set, use that for all items</span>

2.<span class="ts0">Otherwise use the default VAT types for each document</span>

<span class="ts0">Warehouse import</span>

<span class="ts0">If the item is a service or custom, ignore the warehouse field</span>

<span class="ts0">If an item does not have a warehouse selected for import and is blank, use company default</span>

<span class="ts0">For Creditor document imports</span>

<span class="ts0">If there are any service items in the import ignore them for creditor document imports</span>

<span class="ts0">For Job CTC import for whether it is CTC or SC. Use CTC as default is nothing is set</span>

<span class="ts0">For imports, only the first number of fields are required, ignore the rest</span>

<span class="ts0">When importing grids on any of the documents who are multicurrency. The cost needs to be updated with the value of the multicurrency.</span>

<span class="ts0">Sequence number. If blank, put in a sequence number from 1 onwards</span>