Nemokama apskaitos programa

duomenys -bendras- likučių perkėlimas
O kur ten įvesti skola pradžioje?

Toks klaus. ar aš galiu susuvesti likučius 2015 balandžio 31 dienai ir nuo tos dienos kiekvieną mėn. suvesti iki 2015.11.25.. Ar atbulinėm datom negalima?

[quote=Polik]
duomenys -bendras- likučių perkėlimas
O kur ten įvesti skola pradžioje?

Štai čia

Laba diena,

ar bus galimybe nuo 2016 sausio 1 importuoti banko israsus nauju ISO 20022 XML formatu, nes kiek zinau pereisime prie europinio standarto, nes kitaip teks rankomis visus mokejimus susivedineti , kike zinau bankai jau dabar leidzia generuoti najaji israsa, o LITAS_ESIS nebeliks....aciu uz info

Sveiki,

Susiinstaliavau paskutinį atnaujinimą, padariau duomenų bazių taisymą.

Skaičiuojant Darbo užmokestį, viską leidžia ir viskas ok. Bet išsaugojus ir uždarius žiniaraštį, norint vėl jį pakartotinai atsidaryti metą klaidą:

Klaidos duomenys:
Klaidos tekstas:
Exception has been thrown by the target of an invocation.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
_InvokeMethodFast
Klaidos stekas:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ApskaitaWUI.BOMapper.LoadObject[T](T ObjectInstance, String MethodName, Boolean AllowCancel, Object[] Params)
at ApskaitaWUI.F_WageSheet.F_WageSheet_Load(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.OverflowException: Arithmetic operation resulted in an overflow.
at AccCommon.CommonMethods.CRound(Double d, Int32 r)
at ApskaitaObjects.Workers.WageItem.Fetch(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItem..ctor(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList.Fetch(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList..ctor(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageSheet.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccCommon.CommonMethods.CRound(Double d, Int32 r)
at ApskaitaObjects.Workers.WageItem.Fetch(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItem..ctor(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList.Fetch(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList..ctor(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageSheet.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
at Csla.DataPortal.Fetch(Type objectType, Object criteria)
at Csla.DataPortal.Fetch[T](Object criteria)
at ApskaitaObjects.Workers.WageSheet.GetWageSheet(Int32 nID)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Fetch method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccCommon.CommonMethods.CRound(Double d, Int32 r)
at ApskaitaObjects.Workers.WageItem.Fetch(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItem..ctor(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList.Fetch(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList..ctor(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageSheet.DataPortal_Fetch(Criteria criteria)
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Arithmetic operation resulted in an overflow.
Klaidos šaltinis(Ex.Source):
AccCommon
Klaidos metodas (Ex.TargetSite):
CRound
Klaidos stekas:
at AccCommon.CommonMethods.CRound(Double d, Int32 r)
at ApskaitaObjects.Workers.WageItem.Fetch(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItem..ctor(DataRow dr, CompanyWageRates parentRates, Int32 parentYear, Int32 parentMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList.Fetch(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageItemList..ctor(DataTable myData, CompanyWageRates nWageRates, Int32 nYear, Int32 nMonth, Boolean nFinancialDataCanChange)
at ApskaitaObjects.Workers.WageSheet.DataPortal_Fetch(Criteria criteria)


O ankstesnius žiniaraščius (kurie buvo skaičiuoti iki atnaujinimo) leidžia atsidaryti.

Sveiki. Po vakaryksčio programos atsinaujinimo neberanda programa nei vienos išrašytos sąskaitos faktūros. Meta klaidą prisegtą faile.. Su gautomis problemų nėra. Prašau pagelbėkit..

Bendras Query Browser įvykdykite
SELECT * FROM du_ziniarastis_d WHERE Z_ID=1111;
vietoj vienetukų įrašę probleminio žiniaraščio ID.
Rezultatą (paspausti ant lentelės bet kur, ctrl-a, ctrl-c, excelyje ctrl-v) atsiųskit man e-paštu.

Klaida: Apskaita5_klaida.xlsx

Pataisiau.

O čia bus dar vienas atnaujinimas, ar man pačiai kažką reikia pasitaisyti?

Laba diena,
man irgi metaklaidas. Neranda nei išrašytų nei išrašyti leidžia

Sąskaitų registremeta:
Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, C.ID, C.Pavad, C.Kodas, C.SP_kodas, C.E_Mail, b.Op_data, b.Op_Dok, b.Op_turinys, O.CurrencyCode, O.CurrencyRate, O.LanguageCode, O.CommentsInternal, MAX(I.Tar), SUM(I.SumOriginal), SUM(I.SumVatOriginal), SUM(I.SumLTL), SUM(I.SumVatLTL), SUM(I.Discount), SUM(I.DiscountVat), SUM(I.DiscountLTL), SUM(I.DiscountVatLTL), O.AccountPayer, SUM(CASE WHEN I.VatIsVirtual>0 THEN I.SumVatOriginal - I.DiscountVat ELSE 0 END) AS VirtualVat, SUM(CASE WHEN I.VatIsVirtual>0 THEN I.SumVatLTL - I.DiscountVatLTL ELSE 0 END) AS VirtualVatLTL FROM bz b LEFT JOIN InvoicesMade O ON O.ID=b.Op_ID LEFT JOIN sfd as I ON I.SF_ID=O.ID LEFT JOIN asmenys C ON C.ID=b.Op_analitika WHERE b.Op_data>=$DF AND b.Op_data<=$DT AND NOT O.ID IS NULL GROUP BY O.ID ORDER BY b.Op_data;=b.Op_ID LEFT JOIN sfd as I ON I.SF_ID=O.ID LEFT JOIN asmenys C ON C.ID=b.Op_analitika WHERE b.Op_data>=$DF AND b.Op_data<=$DT AND NOT O.ID IS NULL GROUP BY O.ID ORDER BY b.Op_data;], Params: ?DF=2015-01-01; ?DT=2015-11-24;
Klaidos turinys: 'SQLite error
no such column: I.VatIsVirtual'.

Išrašant Sąskaitą
Klaida transakcijoje vykdant SQL sakinį [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'SQLite error
table sfd has no column named VatIsVirtual'.'.

Įėjus detaliau :
Klaidos duomenys:
Klaidos tekstas:
Exception has been thrown by the target of an invocation.
Klaidos šaltinis(Ex.Source):
mscorlib
Klaidos metodas (Ex.TargetSite):
_InvokeMethodFast
Klaidos stekas:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at ApskaitaWUI.BOMapper.LoadObject[T](T ObjectInstance, String MethodName, Boolean AllowCancel, Object[] Params)
at ApskaitaWUI.F_InvoiceMade.SaveObj()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Update failed (System.Exception: Klaida transakcijoje vykdant SQL sakinį [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'SQLite error
table sfd has no column named VatIsVirtual'.'. ---> System.Exception: Klaida vykdant SQL komandą: [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'SQLite error
table sfd has no column named VatIsVirtual'. ---> System.Data.SQLite.SQLiteException: SQLite error
table sfd has no column named VatIsVirtual
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteScalar()
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.Documents.InvoiceMadeItem.Insert(InvoiceMade parentInvoice)
at ApskaitaObjects.Documents.InvoiceMadeItemList.Update(InvoiceMade parent)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Insert())
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Update
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.Documents.InvoiceMadeItem.Insert(InvoiceMade parentInvoice)
at ApskaitaObjects.Documents.InvoiceMadeItemList.Update(InvoiceMade parent)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Insert()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)
at Csla.DataPortal.Update(Object obj)
at Csla.DataPortal.Update[T](T obj)
at Csla.BusinessBase`1.Save()
at ApskaitaObjects.Documents.InvoiceMade.Save()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal_Insert method call failed
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
CallMethod
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.Documents.InvoiceMadeItem.Insert(InvoiceMade parentInvoice)
at ApskaitaObjects.Documents.InvoiceMadeItemList.Update(InvoiceMade parent)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Insert()
at Csla.MethodCaller.CallMethod(Object obj, MethodInfo info, Object[] parameters)
at Csla.MethodCaller.CallMethod(Object obj, String method, Object[] parameters)
at Csla.Server.SimpleDataPortal.Update(Object obj, DataPortalContext context)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida transakcijoje vykdant SQL sakinį [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'SQLite error
table sfd has no column named VatIsVirtual'.'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
TransactionRollBack
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.TransactionRollBack(Exception e)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Execute()
at ApskaitaObjects.Documents.InvoiceMadeItem.Insert(InvoiceMade parentInvoice)
at ApskaitaObjects.Documents.InvoiceMadeItemList.Update(InvoiceMade parent)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Insert()

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
Klaida vykdant SQL komandą: [INSERT INTO sfd(SF_ID, Rusis, P_ID, Preke, NameAltLng, Kiekis, Kaina, SumOriginal, Tar, SumVatOriginal, UnitValueLTL, SumLTL, SumVatLTL, Discount, DiscountLTL, DiscountVat, DiscountVatLTL, Vnt, MeasureUnitAltLng, P_Sas, A_Sas, AccountDiscount, IncludeVatInObject, VatIsVirtual) VALUES($AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AK, $AL, $AM, $AN, $AO, $AQ, $AP, $AR, $AT, $AU, $AV, $AW, $BA, $BB, $BC);], Params: ?AB=302; ?AC=2; ?AD=13; ?AE=Kadastriniai matavimai ir kadastrinės bylos sudarymas; ?AF=; ?AT=Paslauga; ?AU=; ?AG=1; ?AH=10; ?AI=10; ?AJ=21; ?AK=2,1; ?AL=10; ?AM=10; ?AN=2,1; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=505; ?AW=4484; ?BA=0; ?BB=0; ?BC=0;
Klaidos turinys: 'SQLite error
table sfd has no column named VatIsVirtual'.

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
table sfd has no column named VatIsVirtual
Klaidos šaltinis(Ex.Source):
System.Data.SQLite
Klaidos metodas (Ex.TargetSite):
Prepare
Klaidos stekas:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteCommand.ExecuteScalar()
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.ExecuteCommand(SQLCommand CommandToExecute, Int32& RowsAffected)

Jau įkėliau atnaujinimą.
Dar pataisiau gramatinę klaidą tabelyje ir defaultinį failo pavadinimą išsaugant faktūrą.

O paskaityti bent vieną puslapį orumas neleidžia? Visiems reikia personalinio atsakymo?

Taip

Dėkui

Sveiki,!

Ačiū Tau Žmogau,!

Peace!

Leidžia leidžia orumas. Susitvarkė. Atsiprašau, kad iš karto nepanaršiau po puslapius. Tiesiog pamačiau kad dabar to klausia tai ir pagalvojau kad šviežia klaida. Įsivaizduoju kaip patį "užknisa" tie patys klausimai
Ačiū už kantrybę

Sveiki,

po 24 d. atnaujinimo tebemeta klaidą renkantis išrašytų sąskaitų registrą :)

Ankstesnis Niemand patarimas padėjo
1. Bendras - DB struktūra
2. Tikrinti klaidas
3. Taisyti klaidas

Ačiū Niemand!

Ačiū, viskas susitvarke