Kişi bilgileri gizlidir. Logo çalışanları görebilir.

TIGER3 2.56 Rest servis Perakende satış faturası aktarımı

04/02/19 10:20   Tiger/REST

Perakende satış faturasında json ile post ettiğimiz de "SALES_INVOICES" ve "INVOICE" kırılımlarını kaldırmadığımız taktirde aşağıdaki hatayı geri almaktayız.


/* 

{
"Message": "The request is invalid.",
"ModelState": {
"ValError0": [
"Fişin tip bilgisi girilmelidir."
],
"ValError1": [
"Fiş tarihi girilmelidir."
],
"ValError2": [
"Tarih mali yıl içerisinde değil."
]
}
}/*


Ancak "SALES_INVOICES" ve "INVOICE" Kırılımlarını kaldırdığımız taktirde kayıt atılıyor fakat bu sefer de faturaya satırlar ve irsaliyeyi oluşturmuyor.



Mert.POLAT

İsmail Bey merhaba ,

Json ile post ettiğinizde şu an için almış olduğunuz hatalar aslında gönderdiğinz json dosyasına göre beklenen hatalardır.Fatura aktarımı sırasında göndermiş olduğunuz Json dosyasında gerekli alanlar gönderilmediği için bu hataları almaktasınız.Bu tarz hataların önüne geçebilmek için bizim tavsiyemiz ilk olarak oluşturmak istediğiniz fatura tipinde bir kaydı Tiger içerisinde oluşturup bunun sonrasında oluşturduğunuz kaydı expandLevelFull methoduyla get edip aldığınız Json dosyasını istediğiniz değerleri girerek içeriye post etmektir.Bu sayede başarılı bir aktarım yapmış olursunuz.

Kolay gelsin iyi çalışmala dilerim.

 

04/02/19 10:54

Kişi bilgileri gizlidir. Logo çalışanları görebilir.

Kullanmamız gereken asıl json çıktısı aşağıdaki gibidir. Biz bunu post ettiğimizde yine aynı hatayı alıyoruz.  yukarıde belirtmiş olduğunuz tavsiyeyi daha önce de bir kaç kere denedik ama sonuç olumsuz oldu. 



{

"SALES_INVOICES": {

"INVOICE": {

"TYPE": "7",

"NUMBER": "~",

"DATE": "31.01.2019",

"TIME": "303437372",

"DOC_NUMBER": "FATURA NO",

"ARP_CODE": "120.01.001",

"POST_FLAGS": "247",

"VAT_RATE": "18",

"ADD_DISCOUNTS": "20",

"TOTAL_DISCOUNTS": "20",

"TOTAL_DISCOUNTED": "92.59",

"TOTAL_VAT": "7.41",

"TOTAL_GROSS": "92.59",

"TOTAL_NET": "80",

"NOTES1": "SEVK ADRESI BULA BULA CADDE NO 24 KAT 1 DAIRE 5",

"NOTES2": "NILUFER",

"NOTES3": "BURSA",

"NOTES4": "XXX KİŞİYE TESLIM",

"TC_XRATE": "1",

"TC_NET": "80",

"VAT_INCLUDED_GRS": "1",

"CREATED_BY": "1",

"DATE_CREATED": "31.01.2019",

"HOUR_CREATED": "18",

"MIN_CREATED": "28",

"SEC_CREATED": "19",

"MODIFIED_BY": "1",

"DATE_MODIFIED": "03.02.2019",

"HOUR_MODIFIED": "22",

"MIN_MODIFIED": "42",

"SEC_MODIFIED": "26",

"CURRSEL_TOTALS": "1",

"DATA_REFERENCE": "3",

"DISPATCHES": {

"DISPATCH": {

"TYPE": "7",

"NUMBER": "0000000000000001",

"DATE": "31.01.2019",

"TIME": "303437372",

"DOC_NUMBER": "FATURA NO",

"INVOICE_NUMBER": "ARV2019000000011",

"ARP_CODE": "120.01.001",

"INVOICED": "1",

"ADD_DISCOUNTS": "20",

"TOTAL_DISCOUNTS": "20",

"TOTAL_DISCOUNTED": "92.59",

"TOTAL_VAT": "7.41",

"TOTAL_GROSS": "92.59",

"TOTAL_NET": "80",

"CREATED_BY": "1",

"DATE_CREATED": "03.02.2019",

"HOUR_CREATED": "21",

"MIN_CREATED": "43",

"SEC_CREATED": "12",

"MODIFIED_BY": "1",

"DATE_MODIFIED": "03.02.2019",

"HOUR_MODIFIED": "22",

"MIN_MODIFIED": "42",

"SEC_MODIFIED": "26",

"CURRSEL_TOTALS": "1",

"DATA_REFERENCE": "3",

"ORIG_NUMBER": "0000000000000001",

"TC_RATE": "1",

"DEDUCTIONPART1": "2",

"DEDUCTIONPART2": "3",

"AFFECT_RISK": "0",

"DISP_STATUS": "1",

"GUID": "B1752D20-231D-4C3B-9CE5-5D3A7E6A575C",

"DOC_DATE": "31.01.2019",

"DOC_TIME": "303437372",

"EINVOICE": "2"

}

},

"TRANSACTIONS": {

"TRANSACTION": [

{

"TYPE": "0",

"MASTER_CODE": "MALZEMEKODU",

"QUANTITY": "1",

"PRICE": "100",

"TOTAL": "100",

"TC_XRATE": "1",

"COST_DISTR": "20",

"DISCOUNT_DISTR": "20",

"DESCRIPTION": "SATIR ACIKLAMASI",

"UNIT_CODE": "ADET",

"UNIT_CONV1": "1",

"UNIT_CONV2": "1",

"VAT_INCLUDED": "1",

"VAT_RATE": "8",

"VAT_AMOUNT": "5.81",

"VAT_BASE": "72.59",

"BILLED": "1",

"TOTAL_NET": "72.59",

"DATA_REFERENCE": "3",

"DISPATCH_NUMBER": "0000000000000001",

"SL_DETAILS": {

"SERIAL_LOT_TRN": {

"SOURCE_MT_REFERENCE": "2",

"SOURCE_SLT_REFERENCE": "2",

"SOURCE_QUANTITY": "1",

"IOCODE": "4",

"LOCATION_CODE": "001",

"MU_QUANTITY": "1",

"UNIT_CODE": "ADET",

"QUANTITY": "1",

"UNIT_CONV1": "1",

"UNIT_CONV2": "1",

"DATE_EXPIRED": "31.01.2019",

"DATA_REFERENCE": "3",

"ORGLINKREF": "0",

"GUID": "FA05A0CA-BD68-4DBC-BC8C-28EDA46D368B"

}

},

"DETAILS": "

",

"DIST_ORD_REFERENCE": "0",

"CAMPAIGN_INFOS": {

"CAMPAIGN_INFO": "

"

},

"MULTI_ADD_TAX": "0",

"EDT_CURR": "1",

"GENIUSFLDSLIST": "

",

"DEFNFLDSLIST": "

",

"MONTH": "1",

"YEAR": "2019",

"PREACCLINES": "

",

"UNIT_GLOBAL_CODE": "NIU",

"EDTCURR_GLOBAL_CODE": "USD",

"GUID": "5374E4AA-6F82-4DEB-ABBC-12F558F24235",

"MASTER_DEF": "ACIKLAMA",

"BARCODE": "MLZBARKOT",

"FOREIGN_TRADE_TYPE": "0",

"DISTRIBUTION_TYPE_WHS": "0",

"DISTRIBUTION_TYPE_FNO": "0"

},

{

"TYPE": "2",

"DETAIL_LEVEL": "1",

"DISCEXP_CALC": "1",

"QUANTITY": "0",

"TOTAL": "20",

"TC_XRATE": "1",

"DISCOUNT_RATE": "21.6",

"BASE_AMOUNT": "92.59259259",

"UNIT_CONV1": "0",

"UNIT_CONV2": "0",

"VAT_RATE": "8",

"VAT_AMOUNT": "1.6",

"VAT_BASE": "20",

"DATA_REFERENCE": "5",

"NET_DSC_FLAG": "1",

"NET_DSC_AMOUNT": "20",

"DIST_ORD_REFERENCE": "0",

"CAMPAIGN_INFOS": {

"CAMPAIGN_INFO": "

"

},

"MULTI_ADD_TAX": "0",

"GENIUSFLDSLIST": "

",

"DEFNFLDSLIST": "

",

"MONTH": "1",

"YEAR": "2019",

"PREACCLINES": "

",

"EDTCURR_GLOBAL_CODE": "USD",

"GUID": "C3235E5F-E83F-421C-B191-63F90D7D5D54",

"FOREIGN_TRADE_TYPE": "0",

"DISTRIBUTION_TYPE_WHS": "0",

"DISTRIBUTION_TYPE_FNO": "0"

}

]

},

"PAYMENT_LIST": {

"PAYMENT": {

"DATE": "31.01.2019",

"MODULENR": "4",

"TRCODE": "7",

"TOTAL": "80",

"PROCDATE": "31.01.2019",

"TRRATE": "1",

"DATA_REFERENCE": "0",

"DISCOUNT_DUEDATE": "31.01.2019",

"PAY_NO": "1",

"DISCTRLIST": "

",

"DISCTRDELLIST": "0"

}

},

"DEFNFLDSLIST": "

",

"DEDUCTIONPART1": "2",

"DEDUCTIONPART2": "3",

"DATA_LINK_REFERENCE": "66",

"INTEL_LIST": {

"INTEL": "

"

},

"AFFECT_RISK": "0",

"PREACCLINES": "

",

"DOC_DATE": "31.01.2019",

"EINVOICE": "2",

"PROFILE_ID": "2",

"GUID": "FB930DBC-8B33-49E1-A705-0CE03BD3C43F",

"EDURATION_TYPE": "0",

"EINVOICE_TURETPRICESTR": "Sıfır TL",

"EDTCURR_GLOBAL_CODE": "USD",

"TOTAL_NET_STR": "Seksen TL",

"EXIMVAT": "0",

"EARCHIVEDETR_LOGICALREF": "39",

"EARCHIVEDETR_INVOICEREF": "66",

"EARCHIVEDETR_SENDMOD": "2",

"EARCHIVEDETR_INTSALESADDR": "asd",

"EARCHIVEDETR_INTPAYMENTTYPE": "0",

"EARCHIVEDETR_INTPAYMENTDATE": "31.01.2019",

"EARCHIVEDETR_TCKNO": "11111111111",

"EARCHIVEDETR_NAME": "ADI",

"EARCHIVEDETR_SURNAME": "SOYADI",

"EARCHIVEDETR_ADDR1": "adres1",

"EARCHIVEDETR_ADDR2": "adres2",

"EARCHIVEDETR_CITY": "İL",

"EARCHIVEDETR_COUNTRYCODE": "TR",

"EARCHIVEDETR_COUNTRY": "TÜRKİYE",

"EARCHIVEDETR_TOWN": "İLCE",

"EARCHIVEDETR_EMAILADDR": "[email protected]",

"EARCHIVEDETR_ISPERCURR": "1",

"EARCHIVEDETR_INSTEADOFDESP": "1",

"EBOOK_DOCTYPE": "99",

"OKCINFO_LIST": {

"OKCINFO": "

"

}

}

}

}

04/02/19 11:09

Mert.POLAT

Post işlemini kendi localimde denediğimde herhangi bir problem ile karşılaşmadım.Size anlattığım gibi önce Tiger içerisinde bulunan bir kaydı get edip ardından alanları düzenleyip post ettim örnek olması açısından post ettiğim json dosyasını size iletiyorum.

{
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 },
 "INTERNAL_REFERENCE": 1,
 "GRPCODE": 2,
 "TYPE": 8,
 "NUMBER": "0000000000000099",
 "DATE": "2019-01-10T00:00:00",
 "TIME": 138032162,
 "CLIENTREF": 0,
 "RECVREF": 0,
 "CENTERREF": 0,
 "ACCOUNTREF": 0,
 "SOURCE_WH": 0,
 "SOURCE_COST_GRP": 0,
 "CANCELLED": 0,
 "CANCEL_DATE": "1899-12-30T00:00:00",
 "GL_POSTED": 0,
 "PAIDINCASH": 0,
 "FROMSAFE": 0,
 "POST_FLAGS": 247,
 "VAT_RATE": 0,
 "ADD_DISCOUNTS": 0,
 "TOTAL_DISCOUNTS": 0,
 "TOTAL_DISCOUNTED": 0,
 "ADD_EXPENSES": 0,
 "TOTAL_EXPENSES": 0,
 "EXPENSE_DISTRB": 0,
 "TOTAL_DEPOSITED": 0,
 "TOTAL_PROMOTIONS": 0,
 "TOTAL_GROSSVINC": 0,
 "TOTAL_VAT": 0,
 "TOTAL_GROSS": 0,
 "TOTAL_NET": 0,
 "TC_XRATE": 0,
 "TC_NET": 0,
 "RC_XRATE": 0,
 "RC_NET": 0,
 "PAYDEFREF": 0,
 "VAT_INCLUDED_GRS": 0,
 "DEPARTMENT": 0,
 "ACCFICHEREF": 0,
 "ADDEXPACCREF": 0,
 "ADDEXPCENTREF": 0,
 "CREATED_BY": 0,
 "HOUR_CREATED": 1,
 "SEC_CREATED": 8,
 "MODIFIED_BY": 59,
 "HOUR_MODIFIED": 0,
 "SEC_MODIFIED": 0,
 "SALESMANREF": 0,
 "TEXTINC": 0,
 "DATA_REFERENCE": 0,
 "FACTORY": 0,
 "DISPATCH_DATE": 1,
 "DISPATCHES": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/DISPATCHES",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "TRANSACTIONS": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/TRANSACTIONS",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "PAYMENT_LIST": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/PAYMENT_LIST",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "BORSA_RATE": 0,
 "KOMISYON_RATE": 0,
 "KOMKDV_RATE": 0,
 "BAGKUR_RATE": 0,
 "STOPAJ": 0,
 "SSDF": 0,
 "BORSA": 0,
 "KOMISYON": 0,
 "KOMKDV": 0,
 "BAGKUR": 0,
 "EK1_PER": 0,
 "EK1": 0,
 "EK2_PER": 0,
 "EK2": 0,
 "SSDFACCREF": 0,
 "BORSAACCREF": 0,
 "KOMISYONACCREF": 0,
 "KOMKDVACCREF": 0,
 "BAGKURACCREF": 0,
 "STOPAJCREF": 0,
 "SSDFCREF": 0,
 "BORSACREF": 0,
 "KOMISYONCREF": 0,
 "KOMKDVCREF": 0,
 "BAGKURCREF": 0,
 "EK1ACCREF": 0,
 "EK2ACCREF": 0,
 "EK1CREF": 0,
 "EK2CREF": 0,
 "EK3ACCREF": 0,
 "EK4ACCREF": 0,
 "EK5ACCREF": 0,
 "EK3CREF": 0,
 "EK4CREF": 0,
 "EK5CREF": 0,
 "COSTOFSALEFCREF": 1,
 "OP_STATUS": 0,
 "TOTAL_ADD_TAX": 0,
 "PAYMENT_TYPE": 0,
 "INFLATION_IDX": 0,
 "GENIUSFLDSLIST": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/GENIUSFLDSLIST",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "DEFNFLDSLIST": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/DEFNFLDSLIST",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "WFLOWCARDREF": 0,
 "STATUS": 0,
 "DEDUCTIONPART1": 0,
 "DEDUCTIONPART2": 0,
 "DATA_LINK_REFERENCE": 2,
 "TOTALEXADDTAX": 3,
 "BNTRANSREF": 0,
 "GUARANTOR1_FICHETYPE": 0,
 "GUARANTOR1_NR": 0,
 "GUARANTOR1_CLIENTREF": 0,
 "GUARANTOR2_CLIENTREF": 0,
 "INTEL_LIST": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/INTEL_LIST",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 },
 "items": [
 {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/INTEL_LIST/0",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 },
 "LOGICALREF": 0,
 "INVOICEREF": 0,
 "CLIENTREF": 0,
 "LINENUM": 0
 }
 ]
 },
 "GRPFIRMTRANS": 0,
 "EXCHINFO_INTERNAL_REFERENCE": 0,
 "EXCHINFO_FICHE_REF": 0,
 "EXCHINFO_ADD_DISCOUNTS": 0,
 "EXCHINFO_TOTAL_DISCOUNTS": 0,
 "EXCHINFO_TOTAL_DISCOUNTED": 0,
 "EXCHINFO_ADD_EXPENSES": 0,
 "EXCHINFO_TOTAL_EXPENSES": 0,
 "EXCHINFO_DIST_EXPENSE": 0,
 "EXCHINFO_TOTAL_DEPOZITO": 0,
 "EXCHINFO_TOTAL_PROMOTIONS": 0,
 "EXCHINFO_VAT_INC_GROSS": 0,
 "EXCHINFO_TOTAL_VAT": 0,
 "EXCHINFO_GROSS_TOTAL": 0,
 "EXCHINFO_TOTAL_ADD_TAX": 0,
 "EXCHINFO_TOTAL_EX_ADD_TAX": 0,
 "EXCHINFO_BAGKUR": 0,
 "EXCHINFO_STOPAJ": 0,
 "EXCHINFO_SSDF": 0,
 "EXCHINFO_BORSA": 0,
 "EXCHINFO_KOMISYON": 0,
 "EXCHINFO_KOM_KDV": 0,
 "EXCHINFO_EK1": 0,
 "EXCHINFO_EK2": 0,
 "EXCHINFO_EK3": 0,
 "EXCHINFO_EK4": 0,
 "EXCHINFO_EK5": 0,
 "TAX_FREE_CHECK": 0,
 "ACC_FICHE_SITEID": 0,
 "PREACCLINES": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/PREACCLINES",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 }
 },
 "ENTRUST": 0,
 "EK3": 0,
 "EK4_PER": 0,
 "EK4": 0,
 "EK5_PER": 0,
 "EK5": 0,
 "PROFILE_ID": 0,
 "ESTATUS": 0,
 "EINVOICE_SENDCUSTOM": 0,
 "EINVOICE_TAXTYPE": 0,
 "FILL_GL_CODES_CARD": 0,
 "DEVIR": 0,
 "CANT_CRE_DEDUCT": 0,
 "CHECK_CLDAILYDEDUCTLIMIT": 0,
 "OFFER_REFERENCE": 0,
 "NO_CALCULATE": 0,
 "MARKREF": 0,
 "EARCHIVEDETR_LOGICALREF": 0,
 "EARCHIVEDETR_EARCHIVESTATUS": 0,
 "EARCHIVEDETR_SENDMOD": 0,
 "EARCHIVEDETR_INTPAYMENTDATEORG": 0,
 "EBOOK_DOCTYPE": 0,
 "OKCINFO_LIST": {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/OKCINFO_LIST",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 },
 "items": [
 {
 "Meta": {
 "href": "http://localhost:32001/api/v1/salesInvoices/1/OKCINFO_LIST/0",
 "mediaType": "application/json; charset=UTF-8",
 "apiVersion": "1.0"
 },
 "INTERNAL_REFERENCE": 0,
 "INVOICE_REFERENCE": 0,
 "FICHE_TYPE": 0,
 "DATE": "1899-12-30T00:00:00",
 "TIME": 0,
 "LINE_NUMBER": 0
 }
 ]
 },
 "EXIM_PAYTYPEREF": 0
}

Sizlere örnek olması açısından aşığıdaki adreste örnekler mevcuttur yararlanabilirsiniz.

http://docs.logo.com.tr/public/wua/logo-objects-rest-servis/logo-rest-oernekler/postman-kullanim-oernekleri


Kolay gelsin iyi çalışmalar dilerim.



04/02/19 12:11

Cevap vermek için giriş yapmanız gerekmektedir.

Etiketler
LGridList noxrest NetopenX OrderBilling SSO tiger LDataGrid FillAccCodes obje nox netopenxrest cbo browser php user
Tüm Etiketler
Diğer Bağlantılar
Soru Sor

Soru sormak için lütfen oturum açınız.