Sveiki,
O kaip yra su automobilio panaudos sutartim su juridiniu asmeniu? Ar galima neatligintinai?
Iš anksto ačiū

Labas rytas,
Gal is ryto galva neveikia, bet nesugebu ivęsti naujos arba pakeisti dokumento serijos. Gal kas gali padėti.
Ačiū

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

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'.'.

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'.'.

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

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

Sveiki,
Po atmaujinimo norint pasirinkti Sf paslauga, kai paspaudi ant pasirinktos paslaugos meta klaida:
Klaida. Nežinomas SQL sakinys (statement), kurio kodas 'FetchRegionalContentEntryList'
Detaliau:
Klaidos duomenys:
Klaidos tekstas:
DataPortal.Fetch failed (System.Exception: Klaida. Nežinomas SQL sakinys (statement), kurio kodas 'FetchRegionalContentEntryList'.
at AccDataAccessLayer.DatabaseAccess.SQLCommand..ctor(String ComKey)
at ApskaitaObjects.HelperLists.RegionalContentEntryList.Fetch()
at ApskaitaObjects.HelperLists.RegionalInfoDictionary.DataPortal_Fetch(Criteria criteria))
Klaidos šaltinis(Ex.Source):
Csla
Klaidos metodas (Ex.TargetSite):
Fetch
Klaidos stekas:
at AccDataAccessLayer.DatabaseAccess.SQLCommand..ctor(String ComKey)
at ApskaitaObjects.HelperLists.RegionalContentEntryList.Fetch()
at ApskaitaObjects.HelperLists.RegionalInfoDictionary.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.HelperLists.RegionalInfoDictionary.GetList()
at ApskaitaWUI.F_InvoiceMade.AddAttachedObjectButton_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

----------------------------
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.DatabaseAccess.SQLCommand..ctor(String ComKey)
at ApskaitaObjects.HelperLists.RegionalContentEntryList.Fetch()
at ApskaitaObjects.HelperLists.RegionalInfoDictionary.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. Nežinomas SQL sakinys (statement), kurio kodas 'FetchRegionalContentEntryList'.
Klaidos šaltinis(Ex.Source):
AccDataAccessLayer
Klaidos metodas (Ex.TargetSite):
.ctor
Klaidos stekas:
at AccDataAccessLayer.DatabaseAccess.SQLCommand..ctor(String ComKey)
at ApskaitaObjects.HelperLists.RegionalContentEntryList.Fetch()
at ApskaitaObjects.HelperLists.RegionalInfoDictionary.DataPortal_Fetch(Criteria criteria)

Sveiki,
Noriu importuoti faila is banko, bet meta klaida:
Klaida. Faile nurodyta sąskaitos valiuta LTL nesutampa su pasirinktos sąskaitos valiuta

Ka ne taip darau? Bandziau pakeisti valiuta saskaitos, bet vis vien tas pats?
Is anksto aciu :)

Reikia pagalbos
Norint sukurti darbo laiko apskaitos žiniaraštį meta tokią klaidą, sukurtas tipinis darbo laiko rūšių planas.
Ko nepadarau?