Document Details Import

Document Details Import

Document Details Import allows you to import an Excel file as the details for a document.
the custom function allows you choose an the area where the details are and provides a mapping function for the columns.

1.
prepare the document header. 
select the BP and fill in the date and other areas as needed.

2.
click on the import excel button.

it will prompt you to select the excel file.

3.
Import Detail
Step 1.
mark off the unwanted areas. 
the excel file may have areas that are unnecessary eg a letterhead in the file. 


if the format is the same from a previous setting you can use the "load setting" button to load the previous marked of areas.

Step 2.
identify the column headers
mark the column header row.



Step 3.
Map the columns with the system columns.
under the fields column you can choose the the field to map.


note that you can save the mapping and mark off areas here when you tick 'Save Import Setting'
when you click import it will prompt you to save the setting name
Click import to begin the import.

the details will be imported into the document.

    • Related Articles

    • Changing what header fields get imported

      The accounting system has the function to select what fields get imported. Under  Setup -> Company Details -> Import Settings you can select which stage you want to edit. in the screenshot above you can see that you can choose the stage when you ...

    • 4.0. Sales Delivery Order

      How to Confirm a Quotation into a Delivery Order? Understanding how to confirm a quotation into a delivery order within OCi SAM is a vital step in the order fulfilment process. This function allows users to seamlessly transition a customer's accepted ...

    • Upload my customized document layout.

      Customized document layout will  come in a dot XML extension file. Step 1 Click  Maintenance -> Updates -> Document Settings Import Step 2 Select  the location where the layout is. then click on 'Get Document' a list of the customized layouts will ...

    • 1.0. Company Setup

      This document outlines essential company setup procedures within the software, covering company information entry (address, contact details, financial settings like accounting currency and default accounts, and GST registration), financial period ...

    • XML Import : Import Guide

      Steps. 1. Open Invoice module 2. Click on Import. 3. select the xml file. 4. click 'open' 5.status message will indicate success or failure of the import. Notes the document listing may not refresh automatically, if that happens click on 'clear' or ...