Nemokama apskaitos programa

Sveiki,
nežinau kas pasidarė-po paskutinio atnaujinimo 11.27d.nebeatsidaro programa. Iki tol viskas buvo gerai, o dabar ištisai sukasi tas mėlynas ratukas, o programa neatsidaro. Perkroviau ir kompą, bet nieko nepadėjo. Gal kas žinote kokių "vaistų"

Sveiki, po paskutinio atnaujinimo meta klaidas, neleidzia issaugoti darbo uzmokescio zinerascio.
dar susiduriau su problema, kaip ivesti dvi ligos dienas apmokamas darbdavio?
aciu

Sveiki,
atsirado tokia problema. Bandant sukurti atsarginę kopija (arba atkurti duomenų bazę iš kopijos) gaunu lentelę pavadinimu: "Klaida kuriant atsarginę kopiją : The system cannot find the path specified."
Gal kas turite kokių minčių?

Dėkoju

DU ziniarastyje atsistojus ant stulpelio antrastes ir desiniuoju klavisu paspaudus ismes lentele, o ten galima pasirinkti kas reikalinga skaiciavimui t.y. uzdeti varnele

Paskutiniam atnaujinime buvo vos keli smulkūs pataisymai ir viskas veikia normaliai. Problema jūsų kompe.

Kokias klaida? Bendras\DB struktūra bandėt?

Su mysql serveriu ar be?

Sveiki,
Labai patinka programa, bet po paskutinių atnaujinimų, labai daug lentelių meta ir daug ko neišsaugo. Bandžiau įvesti išrašomą sąskaitą, bet man jos neišsaugo ir meta tokią informaciją.
Gal galite padėti? Ačiū,

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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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=1044; ?AC=0; ?AD=0; ?AE=Pavyzdžių pasiuvimas; ?AF=; ?AT=EUR; ?AU=; ?AG=1; ?AH=13,6; ?AI=13,6; ?AJ=21; ?AK=2,86; ?AL=13,6; ?AM=13,6; ?AN=2,86; ?AO=0; ?AQ=0; ?AP=0; ?AR=0; ?AV=500; ?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)

čia tų klaidų galėjot taip plačiai ir nedemonstruoti, pataupyti kitų kantrybę

o apie paskutines klaidas skaitėt bent 5psl atgal? neradot atsakymo? DB išsitaisėt? tada laukit pagalbos

O kaip laiko apskaitos ziniarastyje zymeti L? Kuris DU ziniarastyje stulpelis uz ligos dvi dienas, nes nerandu, o nuo tu sumu turetu neskaiciuoti psd.

Klaida transakcijoje vykdant SQL sakinį [INSERT INTO du_ziniarastis_d(Z_ID, AK, DS_NR, Kruvis, Priedai, Premija, Pr_tipas, Kitos, Dien, Val, NV, PS, YS, Prav, D_val, D_dien, Atost, Nedarb, P_Atost, II, NPD, PNPD, Issk, VDU_d, VDU_v, VDU_u, VDU_dien, VDU_val, DU, DU_tipas, Kitos_s, Avans, AT_K, Atost_n, DU_pr, DU_is, DS_serija, BaseGPM, BasePSD, BasePSDSickLeave, BaseSODRA, BaseGuaranteeFund, HolidayDaysCompensated, CalculatedWage, CalculatedExtraPay, CalculatedHR, CalculatedON, CalculatedSC, CalculatedSickLeave, DeductedGPM, DeductedPSD, DeductedPSDSickLeave, DeductedSODRA, ContributionPSD, ContributionSODRA, ContributionGuaranteeFund, PayableTotal, Ismoketa) VALUES($BD, $AK, $DN, $KR, $PR, $PM, $PT, $KN, $FD, $FV, $NV, $PS, $YS, $PV, $GV, $GD, $HW, $SC, $HP, $RP, $NPD, $PNPD, $DD, $VDU_d, $VDU_v, $VDU_u, $VDU_dien, $VDU_val, $WC, $WT, $KS, $IM, $HT, $HR, $WO, $WP, $DS, $AA, $AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AL, $AM, $AN, $AO, $AP, $AR, $AQ, $AV, $AZ, $AW, $BA);], Params: ?BD=392; ?AK=8; ?DS=; ?DN=2; ?KR=0,5; ?WC=290; ?WT=p; ?PR=0; ?PM=0; ?PT=k; ?KN=0; ?FD=21; ?FV=84; ?NV=0; ?PS=0; ?YS=0; ?PV=0; ?GV=84; ?GD=21; ?HW=0; ?HP=0; ?HT=0; ?HR=0; ?AF=0; ?SC=0; ?RP=0; ?NPD=0; ?PNPD=0; ?DD=0; ?VDU_d=21; ?VDU_v=84; ?VDU_u=290; ?VDU_dien=0; ?VDU_val=0; ?KS=0; ?IM=0; ?WP=217,5; ?WO=290; ?BA=Nothing; ?AA=290; ?AB=290; ?AC=0; ?AD=290; ?AE=290; ?AG=290; ?AH=0; ?AI=0; ?AJ=0; ?AL=0; ?AM=0; ?AN=43,5; ?AO=17,4; ?AP=0; ?AR=11,6; ?AQ=8,7; ?AV=81,14; ?AZ=0,58; ?AW=217,5;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO du_ziniarastis_d(Z_ID, AK, DS_NR, Kruvis, Priedai, Premija, Pr_tipas, Kitos, Dien, Val, NV, PS, YS, Prav, D_val, D_dien, Atost, Nedarb, P_Atost, II, NPD, PNPD, Issk, VDU_d, VDU_v, VDU_u, VDU_dien, VDU_val, DU, DU_tipas, Kitos_s, Avans, AT_K, Atost_n, DU_pr, DU_is, DS_serija, BaseGPM, BasePSD, BasePSDSickLeave, BaseSODRA, BaseGuaranteeFund, HolidayDaysCompensated, CalculatedWage, CalculatedExtraPay, CalculatedHR, CalculatedON, CalculatedSC, CalculatedSickLeave, DeductedGPM, DeductedPSD, DeductedPSDSickLeave, DeductedSODRA, ContributionPSD, ContributionSODRA, ContributionGuaranteeFund, PayableTotal, Ismoketa) VALUES($BD, $AK, $DN, $KR, $PR, $PM, $PT, $KN, $FD, $FV, $NV, $PS, $YS, $PV, $GV, $GD, $HW, $SC, $HP, $RP, $NPD, $PNPD, $DD, $VDU_d, $VDU_v, $VDU_u, $VDU_dien, $VDU_val, $WC, $WT, $KS, $IM, $HT, $HR, $WO, $WP, $DS, $AA, $AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AL, $AM, $AN, $AO, $AP, $AR, $AQ, $AV, $AZ, $AW, $BA);], Params: ?BD=392; ?AK=8; ?DS=; ?DN=2; ?KR=0,5; ?WC=290; ?WT=p; ?PR=0; ?PM=0; ?PT=k; ?KN=0; ?FD=21; ?FV=84; ?NV=0; ?PS=0; ?YS=0; ?PV=0; ?GV=84; ?GD=21; ?HW=0; ?HP=0; ?HT=0; ?HR=0; ?AF=0; ?SC=0; ?RP=0; ?NPD=0; ?PNPD=0; ?DD=0; ?VDU_d=21; ?VDU_v=84; ?VDU_u=290; ?VDU_dien=0; ?VDU_val=0; ?KS=0; ?IM=0; ?WP=217,5; ?WO=290; ?BA=Nothing; ?AA=290; ?AB=290; ?AC=0; ?AD=290; ?AE=290; ?AG=290; ?AH=0; ?AI=0; ?AJ=0; ?AL=0; ?AM=0; ?AN=43,5; ?AO=17,4; ?AP=0; ?AR=11,6; ?AQ=8,7; ?AV=81,14; ?AZ=0,58; ?AW=217,5;
Klaidos turinys: 'SQLite error
table du_ziniarastis_d has no column named BaseGPM'.'.

Norint atidaryti ankstesnius DU ziniarascius irgi meta klaida ir neatidaro!?

Klaida transakcijoje vykdant SQL sakinį [INSERT INTO du_ziniarastis_d(Z_ID, AK, DS_NR, Kruvis, Priedai, Premija, Pr_tipas, Kitos, Dien, Val, NV, PS, YS, Prav, D_val, D_dien, Atost, Nedarb, P_Atost, II, NPD, PNPD, Issk, VDU_d, VDU_v, VDU_u, VDU_dien, VDU_val, DU, DU_tipas, Kitos_s, Avans, AT_K, Atost_n, DU_pr, DU_is, DS_serija, BaseGPM, BasePSD, BasePSDSickLeave, BaseSODRA, BaseGuaranteeFund, HolidayDaysCompensated, CalculatedWage, CalculatedExtraPay, CalculatedHR, CalculatedON, CalculatedSC, CalculatedSickLeave, DeductedGPM, DeductedPSD, DeductedPSDSickLeave, DeductedSODRA, ContributionPSD, ContributionSODRA, ContributionGuaranteeFund, PayableTotal, Ismoketa) VALUES($BD, $AK, $DN, $KR, $PR, $PM, $PT, $KN, $FD, $FV, $NV, $PS, $YS, $PV, $GV, $GD, $HW, $SC, $HP, $RP, $NPD, $PNPD, $DD, $VDU_d, $VDU_v, $VDU_u, $VDU_dien, $VDU_val, $WC, $WT, $KS, $IM, $HT, $HR, $WO, $WP, $DS, $AA, $AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AL, $AM, $AN, $AO, $AP, $AR, $AQ, $AV, $AZ, $AW, $BA);], Params: ?BD=392; ?AK=8; ?DS=; ?DN=2; ?KR=0,5; ?WC=290; ?WT=p; ?PR=0; ?PM=0; ?PT=k; ?KN=0; ?FD=21; ?FV=84; ?NV=0; ?PS=0; ?YS=0; ?PV=0; ?GV=84; ?GD=21; ?HW=0; ?HP=0; ?HT=0; ?HR=0; ?AF=0; ?SC=0; ?RP=0; ?NPD=0; ?PNPD=0; ?DD=0; ?VDU_d=21; ?VDU_v=84; ?VDU_u=290; ?VDU_dien=0; ?VDU_val=0; ?KS=0; ?IM=0; ?WP=217,5; ?WO=290; ?BA=Nothing; ?AA=290; ?AB=290; ?AC=0; ?AD=290; ?AE=290; ?AG=290; ?AH=0; ?AI=0; ?AJ=0; ?AL=0; ?AM=0; ?AN=43,5; ?AO=17,4; ?AP=0; ?AR=11,6; ?AQ=8,7; ?AV=81,14; ?AZ=0,58; ?AW=217,5;
Klaidos turinys: 'Klaida vykdant SQL komandą: [INSERT INTO du_ziniarastis_d(Z_ID, AK, DS_NR, Kruvis, Priedai, Premija, Pr_tipas, Kitos, Dien, Val, NV, PS, YS, Prav, D_val, D_dien, Atost, Nedarb, P_Atost, II, NPD, PNPD, Issk, VDU_d, VDU_v, VDU_u, VDU_dien, VDU_val, DU, DU_tipas, Kitos_s, Avans, AT_K, Atost_n, DU_pr, DU_is, DS_serija, BaseGPM, BasePSD, BasePSDSickLeave, BaseSODRA, BaseGuaranteeFund, HolidayDaysCompensated, CalculatedWage, CalculatedExtraPay, CalculatedHR, CalculatedON, CalculatedSC, CalculatedSickLeave, DeductedGPM, DeductedPSD, DeductedPSDSickLeave, DeductedSODRA, ContributionPSD, ContributionSODRA, ContributionGuaranteeFund, PayableTotal, Ismoketa) VALUES($BD, $AK, $DN, $KR, $PR, $PM, $PT, $KN, $FD, $FV, $NV, $PS, $YS, $PV, $GV, $GD, $HW, $SC, $HP, $RP, $NPD, $PNPD, $DD, $VDU_d, $VDU_v, $VDU_u, $VDU_dien, $VDU_val, $WC, $WT, $KS, $IM, $HT, $HR, $WO, $WP, $DS, $AA, $AB, $AC, $AD, $AE, $AF, $AG, $AH, $AI, $AJ, $AL, $AM, $AN, $AO, $AP, $AR, $AQ, $AV, $AZ, $AW, $BA);], Params: ?BD=392; ?AK=8; ?DS=; ?DN=2; ?KR=0,5; ?WC=290; ?WT=p; ?PR=0; ?PM=0; ?PT=k; ?KN=0; ?FD=21; ?FV=84; ?NV=0; ?PS=0; ?YS=0; ?PV=0; ?GV=84; ?GD=21; ?HW=0; ?HP=0; ?HT=0; ?HR=0; ?AF=0; ?SC=0; ?RP=0; ?NPD=0; ?PNPD=0; ?DD=0; ?VDU_d=21; ?VDU_v=84; ?VDU_u=290; ?VDU_dien=0; ?VDU_val=0; ?KS=0; ?IM=0; ?WP=217,5; ?WO=290; ?BA=Nothing; ?AA=290; ?AB=290; ?AC=0; ?AD=290; ?AE=290; ?AG=290; ?AH=0; ?AI=0; ?AJ=0; ?AL=0; ?AM=0; ?AN=43,5; ?AO=17,4; ?AP=0; ?AR=11,6; ?AQ=8,7; ?AV=81,14; ?AZ=0,58; ?AW=217,5;
Klaidos turinys: 'SQLite error
table du_ziniarastis_d has no column named BaseGPM'.'.

Bendras\DB struktūra padariau ir susitvarke, klaidu nemeta. Sorry. Aciu

Ačiū, pasitaisiau DB struktūrą ir viskas gerai.

Sveiki, baigiu išsikraustyti iš proto.
Įmonė pirko įvairių medžiagų ir agregatų, viską sudėjo į keletą objektų.
Viską susikroviau į 2011, pasidariau sandėlį Medžiagos. Nieko nebesuprantu nei kaip, nei kur, nei kada tas medžiagas (ne)nurašyti. Gal kas gali žingsnis po žingsnio pakonsultuoti, kaip teisingai buhalteriškai susitvarkyti Apskaitoj 5. Galim tartis ir už atlygį

Norint peržiūrėti ankstesnes išrašytas sąskaitas neleidžia ir meta klaidą. Tai ką dabar daryt ???

Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'

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.F_InvoiceMade_Load(Object sender, EventArgs e)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'. ---> System.Data.SQLite.SQLiteException: SQLite error
no such column: O.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.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
--- End of inner exception stack trace ---
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.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.Documents.InvoiceMade.GetInvoiceMade(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 AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.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:
Klaida vykdant SELECT sakinį (statement): [SELECT O.ID, O.Preke, O.NameAltLng, O.Kiekis, O.Kaina, O.SumOriginal, O.Tar, O.SumVatOriginal, O.UnitValueLTL, O.SumLTL, O.SumVatLTL, O.Discount, O.DiscountLTL, O.DiscountVat, O.DiscountVatLTL, O.Rusis, O.P_ID, O.Vnt, O.MeasureUnitAltLng, O.P_Sas, O.A_Sas, O.AccountDiscount, O.IncludeVatInObject, O.VatIsVirtual FROM sfd O WHERE O.SF_ID=$MD GROUP BY O.ID;=$MD GROUP BY O.ID;], Params: ?MD=2855;
Klaidos turinys: 'SQLite error
no such column: O.VatIsVirtual'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
FetchCommand
Klaidos stekas:
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLUtilities.FetchCommand(SQLCommand SelectCommand)
at AccDataAccessLayer.DatabaseAccess.SQLCommand.Fetch()
at ApskaitaObjects.Documents.InvoiceMadeItemList.Fetch(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMadeItemList..ctor(InvoiceMade parentInvoice, SimpleChronologicValidator baseChronologyValidator)
at ApskaitaObjects.Documents.InvoiceMade.DoFetch(Int32 invoiceID, Boolean skipValidationAndMarkOld)
at ApskaitaObjects.Documents.InvoiceMade.DataPortal_Fetch(Criteria criteria)

----------------------------
Vidinės klaidos (internal exception) duomenys:
Klaidos tekstas:
SQLite error
no such column: O.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.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at AccDataAccessLayer.SqlServerSpecificMethods.SQLiteCommandManager.FetchCommand(SQLCommand SelectCommand)

tereikia ant rekiamos dienos spragtelet ir per trikampiuka pasirinkt raide L, ne kuris stulpelis , juk rasiau kad reikia pazymet varnele kad atsirastu tas stulpelis t.y. uzdeti varnele ant nedarb.dienos ir val.VDU ar dien.VDU

Sveiki,

po 2015-11-18 atnaujinimo sąskaitos apyvartos žiniaraštis nusprendė toliau nebeįrašinėti duomenų. SF registras veikia tvarkingai, o "sąskaitos apyvartos žiniaraščio" darbas sustojo ties 2015-11-18 diena.

Ačiū.! Peace!

[quote=Niemand]


Dabar dar patogiau, pačiame žiniaraštyje yra stulpelis, kur galima įvesti išmokėjimo datą.



Anksčiau buvo galimybė priskirti visiems iš karto vienu paspaudimu, jeigu atlyginimas išmokamas tą pačią dieną.

Sveiki, atnaujinau programa, ir dabar noriu issaugot faktura ir man ismeta klaida...prisegu paveiksleli, gal galit padeti. aciu. untitled.bmp