Importing orders

Importing orders.

Fields that are filled in automatically during order registration

The fields below are not updated on import. We recommend that you use EDI import when you want to import new orders into the database. You can enclose each order with @READ_ORDER (Order no.) and @SAVE_ORDER (Order no.), but then the order number must be recognised in the import file.

When you create a new order values are inserted in several fields. The fields Currency no. and Warehouse no. retrieve values from the Bedriftsopplysninger table.
When you register customer number or product number during order registration, information is retrieved from the underlying tables.
Information about the customer is exported to the fields for recipient when no recipient has been registered, and the invoiced customer number/remitted supplier number is completed.
Values are copied from the order head down to the order lines. If such a field is missing values on an order line, the value in the order head is used. Therefore it is not necessary to complete these fields on import, unless you want to override values in the order head, or are considering searching, selecting, sorting, making break-line totals or indirect links to the fields.
If the standard price is not given, the price is used as the standard price. The standard price is retrieved from Price and discount matrix during order registration, and is used for posting discounts and additions.
When you register or change prices and discounts on the order lines, line amounts is calculated in the current currency, default currency and incurred costs.
Order totals and order status are recalculated when you save. Therefore you do not need to include the fields during import.
Merk: We recommend that you import orders using EDI clock or Special formats EDI. Missing values will then be entered automatically.

When you have imported the orders using the normal import method, you must update the Stock balances and Stock changes tables. This is done as follows:

Open the Orders table
Change the Order type field to 6. Unprocessed order or 5. Quotation order.
Save the changes.

You can also use the commands @READ_ORDER and @SAVE_ORDER, mentioned in the section Syntax for the ASCII file.

Merk: If you import orders using EDI Import, this will be done automatically and you should not perform this post-processing.

Example of an import file that finishes a purchase order using @READ_ORDER and @SAVE_ORDER:

@FIRM_BEGIN (Firm no)
@DEFAULT_PARAMETERS (1)
@READ_ORDER (Order no)
@Ord (OrdNo,InvoNo,LstInvoDt,DueDt)
"Order no" "Invoice no" "Invoice date" "Due date"
@OrdLn (OrdNo,LnNo,RlzN)
"Order no" "Line no" "Qty"
@SAVE_ORDER (Order no)