Import e-Slog Receiving Documents
Import e-Slog Receiving Documents
Import e-Slog Receiving
Documents
Import/export data - receiving
 |
Documentation on which the import/export of simple XML calculation in
e-Slog relies, can be found on the WebPages of GZS/CCIS (Chamber of
Commerce and Industry of Slovenia) at the address
http://www.gzs.si/Nivo3.asp?ID=14871&IDpm=2306. |
Basic data
|
Path to
XML Files |
enter the
path to the register, where the received XML files are stored.
The directory can also be selected with the click on the icon. |
|
Add
Missing External IDs to Items Register at Import |
Before the
import of data you have to take care, that every received code of the ID
entered in the received file (field "Subject ID" in the line of
document for import) gets the code of the item as entered in your
database in the IDs register (field "ID" in line of document for
import). If this connection has not already been established before the
import in the IDs register, but it has been selected before the import,
you set if such connection is permanently recorded in the ID register or
not by using this checkbox:
-
if you
check the box, every link "ID" - "Subject ID"; that you will enter
during the import, will be recorded in the ID register in the
Subject IDs
tab;
-
if you
do not check the checkbox, every link "ID" - "Subject ID", that you
will enter before the import of data, will count as link that is
only valid for this document and will not be entered in the IDs
register for use with next import documents.
For examples see also chapters
Search ONLY by subject IDs and
Search by IDs of subjects AND the item code |
|
Read Item IDs |
with this
checkbox you select, in what path the data about the ID code, which is
also transferred into the line of receiving is being filled.
You can select:
|
|
Fill
Subject's Doc. To |
select, in
which one of the chapters of the
received invoice
you wish to import the number of supplier's invoice and the date of
supplier's invoice. You can select Linked document 1 or Linked document
2. The data about the supplier's invoice is usually filled in the field
for entry of the first linked document. |
|
Import XML |
with the
click on this button you import the XML file / data from the file into
the following list (see Data on documents for import and lines of
document for import).
If the previously entered path to this kind of files was correct, the
list of documents for import is filled automatically when you open this
window. |
|
Create Doc. |
with the click on this button the supplier's invoices are created, the number of
which is equal to the number of files marked for import. The invoices are
created in the currently active type of document (so, in the type of document
from which you have called the function).
When the document has been successfully created, the successfully imported file
is deleted from the registry from which you have imported the file.
After the click on this button the creating of documents has to be
confirmed (see
Do you really wish to create documents). |
Data on documents for import
|
Sel (selected) |
if the
line is checked, it is marked for import.
By default, all lines for import are marked, read from XML files from
the collective registry, if they do not contain errors.
If errors are present on the document (see description of last column
Errors), the document is not marked for the import by default and can
not be marked for import before the errors are corrected (see
Document can not be marked for import, because it contains errors!). |
|
File Name |
name of
the file you are importing, including the data on path to it. |
|
Number (of supplier's invoice) |
number of
invoice of the supplier from the XML files for import |
|
Type (of supplier's invoice) |
type of
document from the XML file for import (codification of type of document
is prescribed by e-Slog). Allowed types of documents are here:
-
325 -
Pro-forma invoice
-
380 -
Invoice
-
381 -
Credit
-
383 -
Debit
-
386 -
Invoice for pre-payment
With the use of this functions, the documents of types 380, 381, 383,
386 are imported as received invoices and in the type of document from
which you have selected the function for import of data.
Import of received pro-forma invoices (type 325) is anticipated in the
menu
Import and export of data and orders to suppliers (see
Import of e-Slog pro-forma invoices). |
|
Date
|
date of
packing slip from the invoice, that is imported.
Data can also be edited manually before the import. |
|
VAT Date |
date of
VAT from the invoice you are importing.
The data can also be manually edited before the import. |
|
Invoice
Date |
date of
invoice you are importing.
The data can also be edited manually before the import. |
|
Due Date |
due date
from the invoice you are importing.
The data can also be edited manually before the import. |
|
Supplier |
name of
supplier. The program finds it in your database and according to the VAT
number from the file for import (see field Tax number).
If the subject with the tax number, entered in the file, is not in
the database, this field will be empty and the program will report an
error (see below). |
|
Amount due |
the amount
for payment from the invoice you are importing |
|
Currency |
currency
in which the value from the previous field is shown |
|
Error |
if errors
or missing data occurred on base where you are importing the document at
the time of import, the import WILL NOT BE POSSIBLE. The type of error
regarding the basic data of the invoice is in such case shown at this
place in form of IRIS error message:
|
|
VAT ID |
tax number
of the supplier from the invoice you are importing |
| Ref. Format |
model for reference from the file for
import |
| Reference |
reference number from the file for import |
| Full Name |
first and last name of the contact person |
| E-mail Address |
e-mail address of the contact person |
Line of document for import
|
Line | |
| ID |
ID of the item,
under which the goods will be received into your database.
Data about the ID of the item is searched for by the program
through the
suppliers' ID of the item with an adequate selection of type of search for
the items; and also directly by the item code. For both examples see:
Items register is opened with a
double-click into this field. |
|
External ID | ID of the item, used by the
supplier and is included into the file you are importing. |
|
Name | name of the item from the file you are
importing. The name can also be changed before the import of data. | |
Quantity | quantity of the item from the file you are importing | |
UM | unit of measure from the imported file,
in foreign language. The data can also be changed before the import of
data. | |
Discount | percentage of discount | |
Tax Type |
Tax type from the
assets register for the asset from the "ID"
field. If the field is empty, the field for entry of the tax type will thus
be empty as well. This data is NOT filled from
the file for import. | |
Tax | percentage
of tax calculated on the invoice is filled from the file for import.
If here displayed percentage is not consistent with the
tax percentage from the ID of the tax type (previous field), the program
returns an IRIS error message
4851 Not in accordance with the tax rate!. | |
Amount Due | overall value of the line for payment | |
Error |
If errors or missing data occurred at the import of data
on the base, where the document is being imported to, the import WILL NOT BE
POSSIBLE (see Document can not be marked for
import because it contains errors!). Type of error regarding the
lines of invoice is in such case shown in this place in form of IRIS
error message:
|
|