Form-controlled XML printing in Visma Business

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from Bedriftsopplysninger

from e-documents

M

<0?381:380

M

• Order = 220

• Query = 210

• Quotation = 310

• Order confirmation = 320

C

Gr.1-12 etc.

C

C

C

M

O

C

O

C

C

C

The due date must be used on invoice/cr. note.

M

M

M

O

O

(Seller/buyer)

O

O

Organisational unit 2

O

Empl. no.

O

Order total net - Freight amount + Invoice fee

M

Sp. tax amount

O

C

Order total net - Freight amount + Invoice fee + Sp. tax amount

M

O

C

@InvoiceFee()

O

Document macro @Fakturagebyr ()

@FreightFee ()

O

Document macro @Frakt beløp Freight product 1-4 and customs must be registered in the Bedriftsopplysninger table and the product must be exempted from invoice printout.

Order total net - Rounding

M

Sum total excl. VAT.

@VATAmount (1) + @VATAmount (2) + @VATAmount (3)

M

Total VAT for the order/invoice If there are more VAT numbers than 1-3, the form must be updated so that you can include other VAT numbers. Only add new macros with @VATAmount (VAT no).

@VATBasisAmount(1)+

@VATBasisAmount(2)+

@VATBasisAmount(3)

M

Total VAT basis amount If there are more VAT numbers than 1-3, the form must be updated so that you can include other VAT numbers. Only add new macros with @MvaGrLag (VAT no).

@VATFree (1) + @VATFree (2) + @VATFree (3)

M

Total VAT free amount If there are more VAT numbers than 1-3, the form must be updated so that you can include other VAT numbers. Only add new macros with @AvgFritt (VAT no).

Order total gross - Rounding

M

Sum total incl. VAT.

Rounding

M

Rounding

Order total gross

M

Sum total to pay

@AmountCheckDigit

I1

M

Document macro for @GirobeløpSjekksiffer

X20

C

VAT specification The segment can occur 0 or more times. Once for each VAT rate. Not necessary when using just one VAT rate. Ref. total fields above. If several rates are used or VAT numbers other than the Norwegian ones that are standard, the form, and if there are additions, also the imp file must be changed.

@VATAmount (VAT no.)

F14

M

Total calculated VAT Document macro for @VATAmount () Included with set See comments on main tag for more or other rates.

@VATPercentage (VAT no.)

F14

M

VAT rate in % Document macro for @MvaSats () Included with set See comments on main tag for more or other rates.

@VATBasisAmount (VAT no.)

F14

M

VAT basis amount Document macro for @MvaGrLag () Included with set See comments on main tag for more or other rates.

X20

X20

C

Currency for settlement

Ord.Cur-> Cur.ISO (Cur)

ISO code

from currencies

(Currency no.)

F14

M

Currency code - 3Alpha (NOK, GBP, USD etc.)

Ord.ExtRate

Exchange rate

F14

M

Exchange rate: 1 CUR = x NOK

@DocDate ()

@DocDate

F14

M

Document macro @DocDate

X20

X20

M

Supplier

FrmData.Nm

Company name

from Bedriftsopplysninger

S40

M

Supplier's name

FrmData.Ad1

Company's Addr. 1

from Bedriftsopplysninger

S40

C

Supplier's street address

FrmData.Ad2

Company's Addr. 2

from Bedriftsopplysninger

S40

C

Supplier's street address

FrmData.Ad3

Company's Addr.3

from Bedriftsopplysninger

S40

C

Supplier's street address

FrmData.Pno

Company's post code from Bedriftsopplysninger

S10

C

Supplier's post code

FrmDat.Parea

Company's Post office from Bedriftsopplysninger

S40

C

Supplier's post office

FrmData.Ctry -> Ctry.ISO (CtryNo)

ISO country code from Country table

(Country no.)

S3

C

Supplier's country code. 2Alpha E.g. NO, US, DK, SE

@Order (Associates [Seller/buyer->Empl. no.] (Name))

Seller's name

From Associates (EmpNo)

C

Supplier's reference person

FrmData.Ad4

EAN location no.

from Bedriftsopplysninger

S40

M

Supplier's EAN location number. Before ver. 4.60 Bedriftsopplysninger Address 4 is used. Other fields can be used freely.

FrmData.BsNo

Organisation no.

from Bedriftsopplysninger

S18

C

Supplier's organisation number

FrmData.BsNo

Comp. no.

from Bedriftsopplysninger

S18

C

Supplier's VAT registration number. This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID

FrmData.Phone

Phone

from Bedriftsopplysninger

S20

C

Supplier's Phone

FrmData.Fax

Fax no.

from Bedriftsopplysninger

S20

C

Supplier's Fax

FrmData.MailAd

E-mail address

from Bedriftsopplysninger

S260

C

Supplier's e-mail address

FrmData.IntAd

Web page

from Bedriftsopplysninger

S260

C

Supplier's web page

FrmData.BGiro

Bank giro

from Bedriftsopplysninger

S35

C

Supplier's bank giro number

FrmData.PGiro

Postal giro

from Bedriftsopplysninger

S35

C

Supplier's postal giro number

This field should not be included in the Norwegian default because postal giro accounts no longer exist. They do abroad and therefore the tag is kept.

X20

X20

M

Customer / Buyer

Ord.CustNo

Cust. no.

I10

C

Buyer's ID

Ord.Nm

Name

S40

M

Buyer's name

Ord.Ad1

Address 1

S40

C

Buyer's street address

Ord.Ad2

Address 2

S40

C

Buyer's street address

Ord.Ad3

Address 3

S40

C

Buyer's street address

Ord.PNo

Post code

S10

C

Buyer's post code

Ord.PArea

Postal area

S40

C

Buyer's postal area

Ord.Ctry -> Ctry.ISO (CtryNo)

ISO code

from country table

(Country no.)

S3

C

Buyer's country code. 2Alpha E.g. NO, US, DK, SE

Ord.LiaAct -> Actor.Nm (LiaAct)

Contact's

name from associates

(contact for)

S40

C

Buyer's reference person

Can also be replaced with the field Your ref. in the form if no contact is used

Ord.CustNo -> Actor.EANLocCd (CustNo)

EAN location no.

from Associates (Customer no.)

S13

M

Buyer's location number

Ord.CustNo -> Actor.BsNo (CustNo)

Organisation no.

from Associates (Customer no.)

S18

C

Buyer's organisation number

Ord.CustNo -> Actor.BsNo (CustNo)

Organisation no.

from Associates (Customer no.)

S18

C

Buyer's VAT registration number.

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

Ord.CustNo -> Actor.FactNo (CustNo)

Factoring no.

from Associates (Customer no.)

S18

C

Customer no. at factoring company. Only used if factoring employed.

InvoiceWWWAddress

Ord. CustNo -> Actor.WebPage1

(CustNo)

Web page 1

from Associates

(Cust. no.)

S260

O

Buyer's web page

BuyerEmailAddress

Ord.CustNo -> Actor.MailAd

(CustNo)

E-mail address

from Associates (Customer no.)

S260

C

Buyer's e-mail address

BuyerPhone

Ord.CustNo -> Actor.Phone (CustNo)

Telephone number

from Associates (Customer no.)

S20

C

Buyer's telephone number

BuyerrFax

Ord.CustNo -> Actor.Fax (CustNo)

Fax no.

from Associates (Customer no.)

S20

C

Buyer's fax number

/Buyer

X20

DeliveryParty

X20

M

Recipient

DeliveryPartyID

Ord.DelActNo

Delivery associate no.

I10

C

Recipient ID

DeliveryPartyName

Ord.DelNm

Delivery name

S40

M

Recipient's name

DeliveryPartyAddress1

Ord.DelAd1

Delivery address 1

S40

C

Recipient's street address

DeliveryPartyAddress2

Ord.DelAd2

Delivery address 2

S40

C

Recipient's street address

DeliveryPartyAddress3

Ord.DelAd3

Delivery address 3

S40

C

Recipient's street address

DeliveryPartyPostCode

Ord.DelPNo

Delivery post code

S10

C

Recipient's post code

DeliveryPartyPostOffice

Ord.DelPArea

Delivery postal area

S40

C

Recipient's postal area

DeliveryPartyCountryCode

Ord.DelCtry -> Ctry.ISO (DelCtryNo)

ISO code

from country table

(Country no.)

S3

C

Recipient's country code. 2Alpha E.g. NO, US, DK, SE

DeliveryPartyReference

--

C

Customer's reference on the order for delivery address

No field is defined in the form as contacts are not included in Associates, here you can select a suitable field if you want a value at this point.

DeliveryPartyEANLocationNo

Ord.DelActNo -> Actor.EANLocCd (DelActNoNo)

EAN location no.

from Associates

(Delivery associate no.)

S13

M

EAN location number for delivery address.

DeliveryPartyCompanyNo

Ord.DelActNo -> Actor.BsNo (DelActNo)

Organisation no.

from Associates

(Delivery associate no.)

S18

C

Recipient's organisation number

DeliveryPartyVATRegNo

Ord.DelActNo -> Actor.BsNo (DelActNo)

Organisation no.

from Associates

(Delivery associate no.)

S18

C

Recipient's VAT reg. number

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

DeliveryWWWAddress

Ord.DelActNo-> Actor.WebPage1

(DelActNo)

Web page 1

from Associates

(Delivery associate no.)

S260

O

Recipient's web page

DelyveryPartyEmailAddress

Actor.MailAd

(DelActNo)

E-mail address

from Associates

(Delivery associate no.)

S260

C

Recipient's e-mail address

BuyerPhone

Ord.CustNo -> Actor.Phone (DelActNo)

Telephone number

from Associates

(Delivery associate no.)

S20

C

Buyer's telephone number

BuyerrFax

Ord.CustNo -> Actor.Phone (DelActNo)

Fax no.

from Associates

(Delivery associate no.)

S20

C

Buyer's fax number

/DeliveryParty

X20

Invoicee

X20

C

Invoicee Only used for chain invoicing!

InvoiceID

Ord.InvoCust -> Actor.ActNo (InvoCust)

Invoice customer no.

I10

C

Invoicee's ID

InvoiceName

Ord.InvoCust - > Actor.Nm (InvoCust)

Name

from Associates

(Inv. Cust. No.)

S40

M

Invoicee's name

InvoiceAddress1

Ord.InvoCust - > Actor.Ad1 (InvoCust)

Address 1

from Associates

(Inv. Cust. No.)

S40

C

Invoicee's street address

InvoiceAddress2

Ord.InvoCust - > Actor.Ad2 (InvoCust)

Address 2

from Associates

(Inv. Cust. No.)

S40

C

Invoicee's street address

InvoiceAddress3

Ord.InvoCust - > Actor.Ad3 (InvoCust)

Address 3

from Associates

(Inv. Cust. No.)

S40

C

Invoicee's street address

InvoicePostCode

Ord.InvoCust - > Actor.PNo (InvoCust)

Post code

from Associates

(Inv. Cust. No.)

S10

C

Invoicee's post code

InvoicePostOffice

Ord.InvoCust - > Actor.PArea (InvoCust)

Postal area

from Associates

(Inv. Cust. No.)

S40

C

Invoicee's postal area

InvoiceCountryCode

Ord.InvoCust - > Actor.Ctry (InvoCust) -> Ctry.ISO (CtryNo)

ISO code

from Associates country no.

(Inv. Cust. No.)

S3

C

Invoicee's country code. 2Alpha E.g. NO, US, DK, SE

InvoiceReference

Ord.LiaAct2 -> Actor.Nm (LiaAct2)

Name

from Associates

(Contact 2)

S40

C

Invoicee's reference person

Contact 2 is displayed and must be updated manually if required during order registration, as the field is not updated automatically in the order.

InvoiceEANLocationNo

Ord.InvoCust -> Actor.EANLocCd (InvoCust)

EAN location no.

from Associates

(Inv. Cust. No.)

S13

M

Invoicee's EAN location number.

InvoiceCompanyNo

Ord.InvoCust -> Actor.BsNo (InvoCust)

Organisation no.

from Associates

(Inv. Cust. No.)

S18

C

Invoicee's organisation number

InvoiceVATRegNo

Ord.InvoCust -> Actor.BsNo (InvoCust)

Organisation no.

from Associates

(Inv. Cust. No.)

S18

C

Invoicee's VAT reg. number

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

InvoiceCustomerNoFactor

Ord.InvoCust -> Actor.FactNo (InvoCust)

Factoring no.

from Associates

(Inv. Cust. No.)

S18

C

Customer no. at factoring company. Only used if factoring employed.

InvoiceWWWAddress

Ord.InvoCust -> Actor.WebPage1

(InvoCust)

Web page 1

from Associates

(Inv. Cust. No.)

S260

O

Invoicee's web page

InvoiceEmailAddress

Actor.MailAd

(InvoCust)

E-mail address

from Associates

(Inv. Cust. No.)

S260

C

Invoicee's e-mail address

BuyerPhone

Ord.CustNo -> Actor.Phone (InvoCust)

Telephone

from Associates

(Inv. Cust. No.)

S20

C

Invoicee's telephone number

BuyerrFax

Ord.CustNo -> Actor.Fax (InvoCust)

Fax no.

from Associates

(Inv. Cust. No.)

S20

C

Invoicee's fax number

/Invoicee

X20

Factor

X20

C

Factoring company Only used in event of factoring of invoices where the payment method is set to fact.

FactorID

@Factor (ActNo)

@Factoring actor no.

I10

C

Factoring ID

FactorName

@Factor (Nm)

@Factoring (Name)

S40

M

Factoring name

FactorAddress1

@Factor (Ad1)

@Factoring (Address 1)

S40

C

Factoring street address

FactorAddress2

@Factor (Ad1)

@Factoring (Address 2)

S40

C

Factoring street address

FactorAddress3

@Factor (Ad1)

@Factoring (Address 3)

S40

C

Factoring street address

FactorPostCode

@Factor (PNo)

@Factoring (Post code)

S10

C

Factoring post code

FactorPostOffice

@Factor (PArea)

@Factoring (Postal area)

S40

C

Factoring postal area

FactorCountryCode

@Factor (Ctry) -> Ctry.ISO (CtryNo)

ISO code

@Factoring (Country no.)

S3

C

Factoring country code. 2Alpha E.g. NO, US, DK, SE

FactorReference

=@Order (Fact. company no./CID-def.)=0?@Firm (Factoring ID): @Order (Factoring company and CID-def. [Fact. comp. no./CID-def.->Fact. company no./CID-def.] (Factoring ID))

Factoring ID

from Bedriftsopplysninger

or from Factoring company and CID def.

C

Factoring reference - Fill in agreement no. From Bedriftsopplysninger here,

If several factoring companies are used, this must be retrieved from Factoring company no.

FactorEANLocationNo

@Factor (EANLocCd)

@Factoring

(EAN location no.)

S13

M

Factoring EAN location number.

FactorCompanyNo

@Factor (BsNo)

@Factoring (comp. no.)

S18

C

Factoring company number

FactorVATRegNo

@Factor (BsNo)

@Factoring (comp. no.)

S18

C

Factoring VAT reg. number

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

FactorBankAccount

@Factor (BGiro)

@Factoring (Bank giro)

S18

M

Factoring bank giro number

FactorWWWAddress

@Factor (Web page 1)

@Factoring

Web page 1

S260

O

Factoring web page

FactorEmailAddress

@Factor (MailAd)

@Factoring

(E-mail address)

S260

C

Factoring e-mail address

BuyerPhone

@Factor.Phone (CustNo)

@Factoring (Telephone no.)

S20

C

Factoring telephone number

BuyerrFax

@Factor.Fax (CustNo)

@Factoring (Fax no.)

S20

C

Factoring fax number

/Factor

X20

ShipFrom

Coming in 4.60

C

Ship from

Not used with free delivery.

This will normally be the warehouse, but it can also be a carrier's goods terminal, subcontractor's warehouse etc. Therefore I think the information should be accessible in the order register so that it can vary from order to order.

ShipFromID

M

Ship from ID (Associate no.)

ShipFromName

Ord.FrStc -> Stc.Name

Name

from Warehouse

(Warehouse no.)

M

Ship from name

ShipFromAddress1

Ord.FrStc -> Stc.Ad1

Address 1

from Warehouse

(Warehouse no.)

C

Ship from street address

ShipFromAddress2

Ord.FrStc -> Stc.Ad1

(FrStc)

Address 1

from Warehouse

(Warehouse no.)

C

Ship from street address

ShipFromAddress3

Ord.FrStc -> Stc.Ad1

(FrStc)

Address 1

from Warehouse

(Warehouse no.)

C

Ship from street address

ShipFromPostCode

Ord.FrStc -> Stc.Ad2

(FrStc)

Address 2

from Warehouse

(Warehouse no.)

C

Ship from post code

ShipFromPostOffice

Ord.FrStc -> Stc.Ad3

(FrStc)

Address 3

from Warehouse

(Warehouse no.)

C

Ship from post office

ShipFromCountryCode

Ord.FrStc -> Stc.Ctry ->

(FrStc)

Ctry.ISO

(Ctry)

ISO code

from Warehouse country no.

(Warehouse no.)

C

Ship from country code. 2Alpha E.g. NO, US, DK, SE

ShipFromReference

Ord.FrStc -> Stc.Rsp ->

(FrStc)

Actor.Nm

(Rsp)

Name

from Associates

(Warehouse no. -> Official)

C

Ship from reference person

ShipFromEANLocationNo

Ord.FrStc -> Stc.EANLocCd

(FrStc)

Address 1

from Warehouse

(Warehouse no.)

M

Ship from EAN location number

ShipFromCompanyNo

FrmData.BsNo

Organisation no.

from Bedriftsopplysninger

C

Ship from organisation number

Can be added to the official if different from Company

ShipFromVATRegNo

FrmData.BsNo

Comp. no.

from Bedriftsopplysninger

C

Ship from VAT reg. number.

Can be added to the official if different from Company.

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

ShipFromEmailAddress

Ord.FrStc -> Stc.MailAd

(FrStc)

E-mail address

from Warehouse

(Warehouse no.)

C

Ship from e-mail address

ShipFromWEB

Ord.FrStc ->

Stc.Ad4

(FrStc)

Address 4

from Warehouse

(Warehouse no.)

C

Ship from web page

Address 4 can be used

ShipFromPhone

Ord.FrStc ->

Stc.Phone

(FrStc)

Phone

from Warehouse

(Warehouse no.)

C

Ship from telephone number

ShipFromFax

Ord.FrStc ->

Stc.Fax

(FrStc)

Fax

from Warehouse

(Warehouse no.)

C

Ship from fax number

/ShipFrom

Carrier

Not included

C

Carrier

CarrierID

Carrier ID (Associate no.)

CarrierName

Ord.ShpActNo -> Actor.Name

Name

from Associates

(Carrier/Tranship.)

M

Carrier name

CarrierAddress1

Ord.ShpActNo -> Actor.Ad1

Address 1

from Associates

(Carrier/Tranship.)

C

Carrier street address

CarrierAddress2

Ord.ShpActNo -> Actor.Ad1

(ShpActNo)

Address 1

from Associates

(Carrier/Tranship.)

C

Carrier street address

CarrierAddress3

Ord.ShpActNo -> Actor.Ad1

(ShpActNo)

Address 1

from Associates

(Carrier/Tranship.)

C

Carrier street address

CarrierPostCode

Ord.ShpActNo -> Actor.Ad2

(ShpActNo)

Address 2

from Associates

(Carrier/Tranship.)

C

Carrier post code

CarrierPostOffice

Ord.ShpActNo -> Actor.Ad3

(ShpActNo)

Address 3

from Associates

(Carrier/Tranship.)

C

Carrier post office

CarrierCountryCode

Ord.ShpActNo -> Actor.Ctry ->

(ShpActNo)

Ctry.ISO

(Ctry)

ISO code

from Associates country no.

(Carrier/Tranship. -> Country no.)

C

Carrier country code. 2Alpha E.g. NO, US, DK, SE

CarrierReference

Ord.ShpActNo -> Actor.Rsp ->

(ShpActNo)

Actor.Nm

(Rsp)

Name

from Associates

(Carrier/Tranship. -> Official)

C

Carrier's contact

CarrierEANLocationNo

Ord.ShpActNo -> Actor.EANLocCd

(ShpActNo)

Address 1

from Associates

(Carrier/Tranship.)

M

Carrier's EAN location number

CarrierCompanyNo

Ord.ShpActNo ->

Actor.BsNo

(ShpActNo)

Organisation no.

from Associates

(Carrier/Tranship.)

C

Carrier's organisation number.

CarrierVATRegNo

Ord.ShpActNo ->

Actor.BsNo

(ShpActNo)

Comp. no.

from Associates

(Carrier/Tranship.)

C

Carrier's VAT reg. number.

This field should be removed from the default or change name to EU reg. no. since in Norway there is only one ID (Organisation no.). For EU countries there is the EU organisation no. in addition to the national one.

CarrierEmailAddress

Ord.ShpActNo -> Actor.MailAd

(ShpActNo)

E-mail address

from Associates

(Carrier/Tranship.)

C

Carrier's e-mail address

CarrierWWWAddress

Ord.ShpActNo ->

Actor.WebPg1

(ShpActNo)

Web page 1

from Associates

(Carrier/Tranship.)

C

Carrier's web page

BuyerPhone

Ord.ShpActNo ->

Actor.Phone

(ShpActNo)

Phone

from Associates

(Carrier/Tranship.)

C

Carrier's telephone number

BuyerrFax

Ord.ShpActNo ->

Actor.Fax

(ShpActNo)

Fax

from Associates

(Carrier/Tranship.)

C

Carrier's fax number

/Carrier

TotalMeasurements

X20

O

Dimensions of the goods Each dimension can have the attribute unit=..a3 E.g. <TotalVolume unit=MTQ>.......

TotalVolume

Ord.Vol

Volume

F14

M

Total volume for the order

TotalWeight

Ord.5961

Gross weight

F14

M

Total weight of the order (Gross weight)

NumberOfPackages

Ord.Package

Pack units

I10

C

Number of packages

/TotalMeasurements

X20

InvoiceFreeText

X20

O

Free text from orders

By default Information 1-5 is used, but this can be edited in the form to other fields, texts to be displayed.

To determine if it is a header or footer.

When the fields Text 1-5 start with #H[number] or #F[Number] they will be seen as text lines to be printed on the invoice heading or invoice footer.

#H1[Text to be printed]

#H2[Text to be printed]

#F1[Text to be printed]

Valid values are #H1-#H5 and #F1-#F5

Text1

Ord.Inf

Information 1

S70

M

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text2

Ord.Inf2

Information 2

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text3

Ord.Inf3

Information 3

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text4

Ord.Inf4

Information 4

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text5

Ord.Inf5

Information 5

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

/InvoiceFreeText

OrderFreeText

X20

O

Free text from orders

By default Information 6 in Text6 is used and others are not defined, but this can be edited in the form to other fields, texts to be displayed. To determine if the text is to appear before the order lines or after the last order line When the fields Text 6-10 start with #H[number] or #F[number] they will be seen as text lines to be printed before the order lines [H] or after the last order line [F]. #H1[Text to be printed] #H2[Text to be printed] #F1[Text to be printed] Valid values are #H1-#H5 and #F1-#F5

Text6

Ord.Inf6

Information 6

S70

M

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text7

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text8

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text9

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

Text10

S70

C

Free text line, max. 70 characters

Here you can freely use other fields, this must be defined in the form

DirectOredr

=@Order (Order type)=2?1:0

Calculated from Order type and when it is a direct order has the value 1

I1

O

Because the outstanding quantity field is processed differently for normal and direct orders, the field Balance to pick is also included which will then show the correct outstanding quantity for direct orders. Both fields are displayed to avoid two rule files.

UserDefined1

A20

O

Free field 1

Definition to eInvoice for Posten Invoice head.

To eInvoice for Posten it is permitted from Visma Business that the customer can define 5 free fields that can be printed on the invoice form. This must be arranged with Posten before it can be used.

UserDefined2

A20

O

Free field 2

UserDefined3

A20

O

Free field 3

UserDefined4

A20

O

Free field 4

UserDefined5

A20

O

Free field 5

/OrderFreeText

C

The segment contains all the order lines

XML_NoOfOrderLines

XML_NoOfOrderLines

Special macro for counting order lines

S20

M

Total number of order lines

O

Optional order break on the line to display total/batch eInvoice. This segment is just additional information for the user. The segment is currently only used by eInvoice. This segment cannot be included in the OrderLineCount element. In Visma Business there is a limit on which fields can be used. All fields that can be used are listed below.

BatchOrderNo

Ord.OrdNo

Order no.

I10

O

Order number. N10 from Rub, up to A30 from customer/supp. (saved in your ref. in Rub)

BatchDespatchAdviceNo

Ord.PacNo

Packing slip no.

I10

O

Packing slip no.

BatchOrderCustSupOrderNo

Ord.CSOrdNo

Cust/suppl. order no.

I10

C

Customer’s order no. Or order ref. EDI interpreter

BatchCaseNumber

BatchOrderR3-6

BatchOrderR7

BatchOrderR8-12

BatchOrderRequisition

--

Ord.R3-R6

Ord.R7

Ord.R3-R6

Ord.ReqNo

Organisational unit 8-12 3-6

Organisational unit 7

Organisational unit 8-12 8-12

Requisition no.

I10

I10

S40

S10

S20

O

Case number/Agreement number/Contract number

Here you can enter one of the organisational units or requisition no. from the order. By default nothing is displayed here.

Organisational unit 1-6 are numerical if required

otherwise R7 is 40 characters and R8-112 are 10 characters

Requisition no. 20 characters

BatchOrderR3-6

Organisational unit 3 -6

I10

O

Organisational unit 3-6 can be included if required.

BatchOrderR7

Organisational unit 7

S40

O

Organisational unit 7 can be included if required.

BatchOrderR8-12

Organisational unit 8 -12

S10

O

Organisational unit 8-12 can be included if required.

BatchOrderDate

Ord.OrdDt

Order date

D8

O

Order date

BatchOrderDeliveryDate

Ord.DelDt

Required del. date

D8

O

Delivery date

BatchOrderDeliveryTerms

Ord.DelTrm

Delivery terms

I10

O

Delivery terms ( EXW,FOB,DDU…..) INCOMTERMS abbreviations are therefore used here. Separate field for Delivery terms: INCOTERM? Or use Name or Description for this?

BatchOrderDeliveryMethod

Ord.Delmt

Delivery method

I10

O

Delivery method

BatchOrderOrderReceivedBy

Ord.SelBuy -> Actor.Nm (EmpNo)

Name

From Associates

(Empl. no.)

S40

O

Order recipient

BatchOrderR1

Ord.R1

Organisational unit 1

I10

O

Department no.

If you want to use one of the 11 other organisational units, this only has to be done in the form.

BatchOrderR2

Ord.R2

Organisational unit 2

I10

O

Project no.

If you want to use one of the 11 other organisational units, this only has to be done in the form.

BatchOrderVATBasisAmount

Special macro

Total net amount for order lines that are taxable

F14

O

Total amount liable to VAT

BatchOrderFreeAmount

Special macro

Total net amount for order lines that are taxable

F14

O

Total amount free of VAT

BatchOrderAmountIncVAT

Special macro

Total gross amount including all taxes

F14

O

Sum total incl. VAT

Buyer

X20

O

Customer / Buyer

BatchOrderBuyerID

Ord.CustNo

Cust. no.

I10

C

Buyer's ID

BatchOrderBuyerName

Ord.Nm

Name

S40

O

Buyer's name

BatchOrderBuyerAddress1

Ord.Ad1

Address 1

S40

C

Buyer's street address

BatchOrderBuyerAddress2

Ord.Ad2

Address 2

S40

C

Buyer's street address

BatchOrderBuyerAddress3

Ord.Ad3

Address 3

S40

C

Buyer's street address

BatchOrderBuyerPostCode

Ord.PNo

Post code

S10

C

Buyer's post code

BatchOrderBuyerPostOffice

Ord.PArea

Postal area

S40

C

Buyer's postal area

BatchOrderYourRef

Ord.YrRef

Your ref.

S40

C

Your ref. from the order head

/Buyer

X20

DeliveryParty

X20

O

Recipient

BatchOrderDeliveryPartyID

Ord.DelActNo

I10

C

Recipient ID

BatchOrderDeliveryPartyName

Ord.DelNm

S40

O

Recipient's name

BatchOrderDeliveryPartyAddress1

Ord.DelAd1

S40

C

Recipient's street address

BatchOrderDeliveryPartyAddress2

Ord.DelAd2

S40

C

Recipient's street address

BatchOrderDeliveryPartyAddress3

Ord.DelAd3

S40

C

Recipient's street address

BatchOrderDeliveryPartyPostCode

Ord.DelPNo

S10

C

Recipient's post code

BatchOrderDeliveryPartyPostOffice

Ord.DelPArea

S40

C

Recipient's postal area

/DeliveryParty

X20

OrderLine

X20

M

Order line One or more lines can follow each other

2952

OrdLn.OrdNo (2952)

Order no.

I10

M

Order number

3028

OrdLn.Srt (3028)

Sort seq. no.

I10

M

Order line number

Sort seq no. is used here instead of the original line no. so that the line can appear in the sequence shown on screen unless there is other sorted. Can be replaced with Line no. (Ord.LnNo) to display the original line no.

2953

OrdLn.LnNo (2952)

Line no.

I10

M

Original line number from the order is created (customer's original line no.)

5977

Ord.CSOrdNo (5977)

Cust/suppl. order no.

from Orders

I10

C

Customer's reference no./purchase no.

5067

Ord.PacNo (5067)

Packing slip no.

from Orders

I10

C

Packing slip number from the order head

Only the last run number will be shown here.

Item

X20

C

Item information Only used without Text. Text is ignored as <Item> is also used.

7562

Ord.EANItmNo (7562)

Bar code

S13

M

Item's EAN13 number

This requires that the barcode field is used in order registration

2613

OrdLn.ProdNo (2959)

Product no.

S40

C

Supplier's item number

--

C

Supplier's alternative item number This field is used for NOB and other industry-related product ID. Here you must use a free field on the order line transferred from Product, such as Trans. information 1-4 or you can import a field from the product such as Information 1-8

--

C

Item's PLU number

Here you must use a free field on the order line transferred from Product, such as Trans. information 1-4 or you can import a field from the product such as Information 1-8

2961

OrdLn.Descr (2961)

Description

S60

C

Item description

3000

OrdLn.ProdTp (3000)

Product type 1

I10

C

Main group

Can be replaced with other product related fields like Gr.1-12 or Product category 1-6 etc.

IntermediateGroupNo

OrdLn.ProdTp2 (5027)

Product type 2

I10

C

Intermediate group

Can be replaced with other product related fields like Gr.1-12 or Product category 1-6 etc.

6105

OrdLn.ProdTp3 (6105)

Product type 3

I10

C

Subgroup

Can be replaced with other product related fields like Gr.1-12 or Product category 1-6 etc.

2991

OrdLn.R3

(2991)

Organisational unit 3

I10

C

Product group

R3 is selected here by default and can be changed to other organisational units or other group fields like Gr.1-12 etc.

2989

OrdLn.R1 (2989)

Organisational unit 1

I10

C

Department number

If you want to use one of the 11 other organisational units, this only has to be done in the form.

2990

OrdLn.R2 (2990)

Organisational unit 2

I10

C

Project number

If you want to use one of the 11 other organisational units, this only has to be done in the form.

2955

OrdLn.EmpNo (2955)

Empl. no.

I10

C

Employee number

4721

OrdLn.4721

Total quantity

F14

M

Number of units ordered

2968

OrdLn.NoInvoAb (2968)

Quantity

F14

M

Number of units delivered

4759

OrdLn.4759

Outstanding

F14

M

Number of units marked as outstanding for normal orders

4950

OrdLn.4950

Balance to pick

F14

O

Number of units marked as outstanding for direct orders

5590

Alt.

3068

OrdLn.Un -> Unit.Descr (Un) (5590)

OrdLn.Un -> Unit.EDIUn

(5590)

Description

From Unit

(Unit)

EDI unit

From Unit

(Unit)

S40

M

Unit (PCE, KGM, LTR, MTQ?)

Field 3068, which is the EDI from the unit table, can also be used so that it agrees with international standards and not the description in the unit table.

This must be changed in Print setup and the imp file if it is to be changed.

5938

OrdLn.NoUn (5938)

F14

M

CLP_Invoiced * CLP_QuantityPerUnit

3714

OrdLn.Ser (3714)

Serial no.

S22

C

Serial no. - MUST use one line serial number

3716

OrdLn.DurDt (3716)

Use by date

D8

C

Use by date

2975

OrdLn.Price (2975)

Price

F14

M

4476

Ordln.4476

Price after discount

F14

M

5621

OrdLn.5621

Amount before discount

F14

M

Amount before taxes and discounts.

2980

OrdLn.2980

Amount

F14

M

Amount including taxes and discounts, e.g. VAT

OrdLn.CfDelDt

(3736)

Confirmed delivery date

M

Confirmed delivery date

Discount

X20

C

Discount

In Visma Business you can operate with 6 discount % fields and 6 discount amount fields. In a simple solution, all these are combined into a special calculation and show the total.

This is found in a special macro in the imp file.

If on the other hand you want to present each individual discount, the imp file and invoice setup must be changed.

The same values will be presented in the TotalDiscount segment.

XML_AmountPrUnit

Price after discount (4476)- Price (2975)

Special macro

F14

M

Amount per unit

XML_Amount

Amount before discount (5621) - Amount (2980)

Special macro

F14

M

Line amount

XML_Percentage

(1 - (Price after discount (4476) / Price (2975))) * 100

Special macro

F14

M

Percentage

5621

OrdLn.5621

Amount before discount

F14

M

Basis for calculating discount

/Discount

X20

Detaljert alternativ

Discount

X20

C

Detailed discount alternative

For each discount you want to present for this, a <Discount> tag is defined and within it the external number must be defined for the respective discount no. and the fields must be called up into the invoice setup.

Here is an example of discount 1 and in the imp file c,Discount,30,20,,,,,,,,,,X, c,0,31,14,2,,AmountPrUnit,,,,,,,F, c,2977,32,14,2,,Amount,,,,,,,F, c,2976,33,14,2,,Percentage,,,,,,,F, c,5621,34,14,2,,BasisAmount,,,,,,,F, c,/Discount,35,20,,,,,,,,,,X, c,Discount,36,20,,,,,,,,,,X, c,0,37,14,2,,AmountPrUnit,,,,,,,F, c,2979,38,14,2,,Amount,,,,,,,F, c,2978,39,14,2,,Percentage,,,,,,,F, c,5621,40,14,2,,BasisAmount,,,,,,,F, c,/Discount,41,20,,,,,,,,,,X,

2977

2979

6765

6768

6771

6774

OrdLn.2977

OrdLn.2979

OrdLn.6765

OrdLn.6768

OrdLn.6771

OrdLn.6774

Disc. amount

Disc. amount 2

Disc. amount 3

Disc. amount 4

Disc. amount 5

Disc. amount 6

F14

M

O

Discount amount 1-6

A set of discount tags is created for each discount set to be included, which contains AmountPrUnit, Amount, Percentage and BasisAmount. See above example.

One <Discount> tag must always be created, more are optional.

2976

2978

6764

6767

6770

6773

OrdLn.2976

OrdLn.2978

OrdLn.6764

OrdLn.6767

OrdLn.6770

OrdLn.6773

Disc. %

Discount 2 %

Discount 3 %

Discount 4 %

Discount 5 %

Discount 6 %

F14

M

Percentage 1-6

5621

OrdLn.5621

Amount before discount

F14

M

Basis for calculating discount

This field must be repeated in each <Discount> tag and is the same.

/Discount

X20

TotalDiscount

X20

Discount

In Visma Business you can operate with 6 discount % fields and 6 discount amount fields. In a simple solution, all these are combined into a special calculation and show the total.

This is found in a special macro in the imp file.

If on the other hand you want to present each individual discount, the imp file and invoice setup must be changed. This field can be used together with detailed discount and used on the printout.

XML_AmountPrUnit

Price after discount (4476)- Price (2975)

Special macro

F14

M

Amount per unit

XML_Amount

Amount before discount (5621) - Amount (2980)

Special macro

F14

M

Line amount

XML_Percentage

(1 - (Price after discount (4476) / Price (2975))) * 100

Special macro

F14

M

Percentage

5621

OrdLn.5621

Amount before discount

F14

M

Basis for calculating discount

/TotalDiscount

X20

SpecialDuty

X20

C

Special duty

--

M

Basis type: 1 = Amount, 2 = Weight/Volume, 3 = Number

/SpecialDuty

VAT

X20

C

VAT

4197

OrdLn.VatAm (4197)

VAT Amount

F14

M

VAT amount for the line

XML_VATPercent

XML_VATPercent

Special macro

F14

M

VAT percentage

XML_VATBasisAmount

XML_VATBasisAmount

Special macro

F14

M

VAT basis

/VAT

X20

Measurement

X20

O

Dimensions of the goods Each dimension can have the attribute unit=..a3. E.g. <TotalVolume unit=MTQ>.......

5941

OrdLn.5941

Gross weight

F14

M

Gross weight

5939

OrdLn.NWgtL (5939)

Net weight

F14

C

Net weight (NB: Required since the information is to be used for customs clearance)

5944

OrdLn.VolL (5944)

Volume

F14

M

Volume

/Measurement

X20

FreeText1

A20

O

Free field 1

Definition to eInvoice for Posten for invoice line.

To eInvoice for Posten it is permitted from Visma Business that the customer can define 5 free fields that can be printed on the invoice form. This must be arranged with Posten before it can be used.

FreeText2

A20

O

Free field 2

FreeText3

A20

O

Free field 3

FreeText4

A20

O

Free field 4

FreeText5

A20

O

Free field 5

/Item

X20

/Orderline

X20