import faktur - invoicer/invoicer.github.io GitHub Wiki

Możliwy do wykonania w opcji:

Rejestry VAT - operacje
Integrator - import

*czytaj dysk .zbr - format natywny Madar
*czytaj dysk .csv
czytaj Kamsoft - format DBF
czytaj Comarch F++
czytaj Rachmistrz
czytaj Symfonia Handel
PC Market
Format RAKS_R3
Format Subiekt tag:FormattedAreaPair
Format BASDA tag:urn:schemas-basda-org

Automatyczna dekretacja dokumentów podczas importu. Specyfikacje kodów w opcji: rejestry VAT - operacje - lista kodów

1. Format CSV

2. Format DBF (Kamsoft)

importowane pola

_nrf_ - numer
_NDKR_ - dotyczy
_NIPK_ - kontrahent NIP

ustawienie kont: z dane dla FK pobierane jest konto rozrachunków oraz konta magazynu 1

3. Format FPP (Comarch F++)

PRZYKŁAD

48333,"FA","11/01/03","11/01/03","","FA/1/2011","",2,0,1,1,0,
"PROFEREM","Madar Sp. z o.o.","","ul. Wspólna 8","32-300","Zabrze",
"PL637-010-30-72","",0,0,0,"SK","S ",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"",0.00,0.00,0,3,
"11/02/02",3389.88,0.00,0,0,2194.250000,0.00,0.00,0.00,"JC",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,23.00,2756.00,633.88

5. Format Optima XML

REJESTR - nazwa szablonu

4. Format EPP (Rachmistrz)

[INFO]
"1.03",0,1250,"Pakiet firmy KUCHARSCY S.C.","KC-Eksport","KON","KON","","","","","KON","KON","KON","",1,20130301000000,20130311000000,"",20130311000000
[NAGLOWEK]
"FZ",1,1,"1","12727/2013",,"12727/2013",,,,,"MADAR","DYSTRYBUCJA MIÊSA I WÊDLIN AGAT","DYSTRYBUCJA MIÊSA I WÊDLIN SP.JAWNA AGATA  DARIUSZ ","ZABRZE","41-200","ULICA 12","6443057806",,,,20130226000000,20130226000000,20130301000000,1,0,,585.30,29.27,614.57,585.30,,0.00,"Przelew",20130312000000,0.00,614.57,0,0,0,0,"KCEksport","KCEksport",,0.00,0.00,"PLN",1.0000,,"M25",,,0,0
[ZAWARTOSC]
5,5.00,515.30,29.27,614.57

Automatyczna dekretacja przy imporcie z pliku.

5.Format XML Symfonia 'eFakura.xsd'

SERIA - identyfikator szablonu NUMER - numer dokumentu: dla zakupów wpisywany w pole DOTYCZY dla sprzedaży w pole NUMER

<?xml version="1.0" encoding="windows-1250"?>
<FormatXML
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:noNamespaceSchemaLocation="eFaktura.xsd">
<e-Faktura>
	<Wersja>1.03</Wersja>
</e-Faktura>
<DokumentHandlowy>
	<GUID></GUID>
	<Status>Faktura</Status>
	<NumerDokumentu>0006/2014/FVS</NumerDokumentu>
	<Nazwa>Faktura VAT</Nazwa>
	<Charakter>40</Charakter>
	<Typ>FVS</Typ>
	<Seria>sFVS</Seria>
	<Wystawca>
		<GUID></GUID>
		<Kod>Firma</Kod>
		<Nazwa>Madar</Nazwa>
		<Ulica>1 Maja</Ulica>
		<NumerDomu>27</NumerDomu>
		<NumerLokalu></NumerLokalu>
		<KodPocztowy>41-800</KodPocztowy>
		<Miejscowosc>Zabrze</Miejscowosc>
		<Kraj></Kraj>
		<NIP>625-00-00-73</NIP>
		<REGON></REGON>
		<PESEL></PESEL>
		<VIES>Nie</VIES>
		<VATUE></VATUE>
		<NumerRachunkuBankowego>48 1110 1111 0015 0343 5121 0001</NumerRachunkuBankowego>
		<Telefon1></Telefon1>
		<Telefon2></Telefon2>
		<Fax></Fax>
		<Email></Email>
	</Wystawca>
	<Odbiorca>
		<GUID></GUID>
		<Kod>MUZEUM </Kod>
		<Nazwa>MUZEUM </Nazwa>
		<Ulica>ŚWIERCZEWSKIEGO</Ulica>
		<NumerDomu>15</NumerDomu>
		<NumerLokalu></NumerLokalu>
		<KodPocztowy>41-800</KodPocztowy>
		<Miejscowosc>Zabrze</Miejscowosc>
		<Wojewodztwo>œl¹skie</Wojewodztwo>
		<Kraj>PL</Kraj>
		<NIP>625-00-00-530</NIP>
		<REGON></REGON>
		<PESEL></PESEL>
		<VIES>Nie</VIES>
		<VATUE></VATUE>
		<NumerRachunkuBankowego></NumerRachunkuBankowego>
		<Telefon1></Telefon1>
		<Telefon2></Telefon2>
		<Fax></Fax>
		<Email></Email>
	</Odbiorca>
	<Rejestr>Sprzeda¿ VAT</Rejestr>
	<RodzajCeny>Brutto</RodzajCeny>
	<NaliczanieVAT>Iloczynowe</NaliczanieVAT>
	<MetodaRozliczaniaVAT>Memoriałowa</MetodaRozliczaniaVAT>
	<DataWystawienia>2014-10-31</DataWystawienia>
	<DataSprzedazy>2014-10-31</DataSprzedazy>
	<RejestrPlatnosci>BANK</RejestrPlatnosci>
	<FormaPlatnosci>przelew</FormaPlatnosci>
	<TerminPlatnosci>14 dni</TerminPlatnosci>
	<DataPlatnosci>2014-11-14</DataPlatnosci>
	<KursVAT>1.0000</KursVAT>
	<KursCITPIT>1.0000</KursCITPIT>
	<OdebranyPrzez></OdebranyPrzez>
	<StawkaVAT>
		<Kod>23%</Kod>
		<Nazwa>Stawka 23%</Nazwa>
		<Wartosc>0.2300</Wartosc>
		<ObowiazujeOd>2011-01-01</ObowiazujeOd>
		<ObowiazujeDo></ObowiazujeDo>
		<StawkaRR>Nie</StawkaRR>
		<Typ>8</Typ>
	</StawkaVAT>
	<Stopka>
		<KwotaVAT>
			<StawkaVAT>23%</StawkaVAT>
			<Netto>243.90</Netto>
			<VAT>56.10</VAT>
		</KwotaVAT>
	</Stopka>
	<PozycjaDokumentu>
		<Lp>1</Lp>
		<Towar>
			<Kod>USŁUGA INFORMATYCZNA</Kod>
			<Nazwa>
				<Opis>USŁUGA INFORMATYCZNA</Opis>
			</Nazwa>
			<KodPaskowy></KodPaskowy>
			<PKWiU></PKWiU>
			<CN></CN>
			<JednostkaMiary>
				<Ewidencyjna>szt</Ewidencyjna>
				<Dodatkowa1></Dodatkowa1>
				<Przelicznik1>0.0000</Przelicznik1>
				<Dodatkowa2></Dodatkowa2>
				<Przelicznik2>0.0000</Przelicznik2>
			</JednostkaMiary>
			<StawkaVAT>23%</StawkaVAT>
			<Rodzaj>Usługa</Rodzaj>
		</Towar>
		<JednostkaMiary>szt</JednostkaMiary>
		<Ilosc>1.0000</Ilosc>
		<Cena>300.000000</Cena>
		<StawkaVAT>23%</StawkaVAT>
		<Wartosc>300.00</Wartosc>
		<WartoscVAT>56.10</WartoscVAT>
	</PozycjaDokumentu>
</DokumentHandlowy>
</FormatXML>

6.PC Market - format `FPP`

0,"FZ","14/10/01","14/10/01","","FV 20056/2014","",1,0,1,1,0,"118","MADAR SP.ZO.O.","","ODROWAZÓW 5/4","41-506","ZABRZE","627-25-04-166","",0,0,0,"","",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"0",0.00,0.00,0,3,"14/10/08",282.64,282.64,0,0,0.00,0.00,0.00,0.00,"ANETA",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,387.66,20.34,0,8.00,43.32,3.47,0,5.00,224.62,11.23,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00
0,"FZ","14/10/02","14/10/01","","FV KOR 002405/1","ZWFD/14/438",1,1,1,1,0,"63","P.P.U.H. 'RAMA' SPÓ£KA JAWNA MARIAN","KUBIK, MAGDALENA MAZUR","UL.ZABRZANSKA 117","44-217","RYBNIK","642-002-20-23","",0,0,0,"","",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,"0",0.00,0.00,0,3,"14/10/08",-33.14,-33.14,0,0,0.00,0.00,0.00,0.00,"ANETA",0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,-40.68,-1.92,0,5.00,-31.56,-1.58,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00,0,0.00,0.00,0.00

export-faktur

Webapi

komenda pobierania via HTTP (POST) http://127.0.0.1:8001/import.htm?name=SKLEP;pass=IpyH3Cb+BgKWh22YDSU4Uw==;docum=VAT;file=31012012.fpp

w ciele wywołania wysyłany jest plik do zaimportowania

###parametry:

name - nazwa użytkownika
pass - pole autopassword w użytkowniku
docum - rodzaj importowanych danych (dla rejestrów VAT = VAT )
file - nazwa pliku, na podstawie rozszerzenia detekcja formatu ( fpp - format Comarch; spr - format Madar; txt format csv)

w odpowiedzi otrzymujemy plik wskazanego raportu w zależności od ustawień

###Przykład użycia plik można testowo wysłać przy pomocy komendy CURL

curl --data-binary @vat001.txt http://127.0.0.1:8002/import.htm?name=JAKUB;pass=gZNe40n5cJSCzieB3BPMIg==;docum=VAT;file=vat001.fpp