DATEV_Belegsatz ( Gesamtbetrag ; Rechnungsdatum ; Rechnungsnummer ; IBAN ; Firma ; Stadt ; Bestellnummer ; Lieferdatum ; AR_ER ; Sachkonto ; Personenkonto ; BuchungsCode ; MWST_

DATEV XML Belegsatz Datei

Be the first to rate this function Log in to vote

Markus - Show more from this author
COBIX Consult

Sample input:

DATEV_Belegsatz ( Gesamtbetrag ; Rechnungsdatum ; Rechnungsnummer ; IBAN ; Firma ; Stadt ; Bestellnummer ; Lieferdatum ; AR_ER ; Sachkonto ; Personenkonto ; BuchungsCode ; MWST_Satz ; Rechnungstext ;

Sample output:

DATEV XML "Belegsatz" file

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let (
[aaa =  ".xml"  ;
bbb = ".pdf"];

"<?xml version=\"1.0\" encoding=\"utf-8\"?>
<LedgerImport xmlns=\"http://xml.datev.de/bedi/tps/ledger/v050\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" 
xsi:schemaLocation=\"http://xml.datev.de/bedi/tps/ledger/v050 Belegverwaltung_online_ledger_import_v050.xsd\" version=\"5.0\" 
generator_info=\"DATEV-FileMaker\" generating_system=\"DATEV-Musterdaten\" xml_data=\"Kopie nur zur Verbuchung berechtigt nicht zum Vorsteuerabzug\">
  
<consolidate consolidatedAmount=\"" 
& DATEV_Format_Betrag ( Gesamtbetrag ) &

 "\" consolidatedDate=\"" 
& DATEV_Format_Datum ( Rechnungsdatum ; "[YYYY]-[MM]-[DD]" ) &

"\" consolidatedInvoiceId=\""
& Rechnungsnummer &

"\" consolidatedCurrencyCode=\"EUR\" 

consolidatedDeliveryDate=\""
& DATEV_Format_Datum ( Lieferdatum ; "[YYYY]-[MM]-[DD]" ) & 

"\" consolidatedOrderId=\""
& Bestellnummer &
"\">"

& If( AR_ER = "AR";"<accountsReceivableLedger>";"<accountsPayableLedger>") &

		"<date>"
		& DATEV_Format_Datum ( Rechnungsdatum ; "[YYYY]-[MM]-[DD]" )  &
		"</date>
		
		<amount>"
		& DATEV_Format_Betrag ( Gesamtbetrag )& 
		"</amount>

		<accountNo>"
		& Sachkonto &
		"</accountNo>

		<buCode>"
		&  BuchungsCode & 
		"</buCode>
		
		<costCategoryId>10</costCategoryId>
		<costCategoryId2>20</costCategoryId2>

		<tax>"
		& DATEV_Format_Betrag ( MWST_Satz ) &
		"</tax>

		<information>Information</information>
		<currencyCode>EUR</currencyCode>
		
		<invoiceId>"
		& Rechnungsnummer &
		"</invoiceId>

		<bookingText>"
		& Rechnungstext &
		"</bookingText>

		<partyId>"
		& Kundennummer &
		"</partyId>

		<iban>"
		& IBAN &
		"</iban>

		<dueDate>"
		&  DATEV_Format_Datum ( Fälligkeitsdatum ; "[YYYY]-[MM]-[DD]" ) & 
		"</dueDate>

		<bpAccountNo>"
		& Personenkonto & 
		"</bpAccountNo>

		<deliveryDate>"
		& DATEV_Format_Datum ( Lieferdatum ; "[YYYY]-[MM]-[DD]" )  &
		"</deliveryDate>

		<orderId>"
		& Bestellnummer &
		"</orderId>"

		& If( AR_ER = "AR";"<customerName>";"<supplierName>") 
		& Firma 
		& If( AR_ER = "AR";"</customerName>";"</supplierName>") 

		& If( AR_ER = "AR";"<customerCity>";"<supplierCity>") 
		& Stadt 
		& If( AR_ER = "AR";"</customerCity>";"</supplierCity>") 

& If( AR_ER = "AR";"</accountsReceivableLedger>";"</accountsPayableLedger>") &


  "</consolidate>
</LedgerImport>"
)

This is Part2 to create DATEV XML Online output in line with https://developer.datev.de/portal/de/dxso

Reach out for FileMaker sample files including script and compression

Comments

		Gerrit Aug 11, 2022
CF name is incomplete due to too many parameters. Please note all parameter names in the function definition.

		Markus, COBIX Consult Aug 14, 2022
Works with in my app - maybe you may share some more details?

		Gerrit Aug 15, 2022
Just open your CF on briandunning.com and you will see that the name of your CF is cut-off because it's too long. It's just not possible to copy the name and parameters into FM.

		Gerrit Aug 15, 2022
And: It requires CFs DATEV_Format_Datum and DATEV_Format_Betrag which are not included here

		Markus, COBIX Consult Aug 15, 2022
DATEV integration/configuration stands for covering a wide spectrum ;) Maybe we take this discussion BrianDunning-offline? I am available at markus.walter@mac.com - happy to support in English or Deutsch

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

DATEV_Belegsatz ( Gesamtbetrag ; Rechnungsdatum ; Rechnungsnummer ; IBAN ; Firma ; Stadt ; Bestellnummer ; Lieferdatum ; AR_ER ; Sachkonto ; Personenkonto ; BuchungsCode ; MWST_

Comments

Support this website.

Support this website.