8.х Бух учет не сходится

Discussion in 'Отчеты и обработки для "1С:Предприятие 8"' started by VitosBBC, Aug 14, 2013.

0/5, 0 votes
  1. TopicStarter Overlay
    VitosBBC
    Offline

    VitosBBC

    Joined:
    Aug 11, 2013
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    1
    Подскажите пожалуйста делаю проводки по счетам но ни как не пойму у меня считается не правильно, привязал модуль объекта документа оказание услуг.
    Спасибо!

    Attached Files:

    VitosBBC, Aug 14, 2013
    #1
  2. TopicStarter Overlay
    VitosBBC
    Offline

    VitosBBC

    Joined:
    Aug 11, 2013
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    1
    Привожу пример
    Делаю приход
    Материал_____НаборСвойств_______Количество________Цена_________Сумма
    Гвозди________1,2х16______________50_______________50___________2500
    Гвозди________1,4х25______________75_______________40___________3000
    Гвозди________1,6х25______________50_______________30___________1500
    Гвозди________1,8х20______________50_______________40___________2000

    Делаю ОказаниеУслуг
    Материал_____НаборСвойств_______Количество________Цена_________Сумма
    Гвозди________1,2х16_______________10______________75____________750

    В итоге получается

    <html xmlns:v="urn:schemas-microsoft-com:vml"
    xmlns:eek:="urn:schemas-microsoft-com:eek:ffice:eek:ffice"
    xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel"
    xmlns="http://www.w3.org/TR/REC-html40">

    <head>
    <meta name="Excel Workbook Frameset">
    <meta http-equiv=Content-Type content="text/html; charset=windows-1251">
    <meta name=ProgId content=Excel.Sheet>
    <meta name=Generator content="Microsoft Excel 12">
    <link rel=File-List href="Desktop.files/filelist.xml">
    <![if !supportTabStrip]>
    <link id="shLink" href="Desktop.files/sheet001.htm">

    <link id="shLink">

    <script language="JavaScript">
    <!--
    var c_lTabs=1;

    var c_rgszSh=new Array(c_lTabs);
    c_rgszSh[0] = "TDSheet";



    var c_rgszClr=new Array(8);
    c_rgszClr[0]="window";
    c_rgszClr[1]="buttonface";
    c_rgszClr[2]="windowframe";
    c_rgszClr[3]="windowtext";
    c_rgszClr[4]="threedlightshadow";
    c_rgszClr[5]="threedhighlight";
    c_rgszClr[6]="threeddarkshadow";
    c_rgszClr[7]="threedshadow";

    var g_iShCur;
    var g_rglTabX=new Array(c_lTabs);

    function fnGetIEVer()
    {
    var ua=window.navigator.userAgent
    var msie=ua.indexOf("MSIE")
    if (msie>0 && window.navigator.platform=="Win32")
    return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
    else
    return 0;
    }

    function fnBuildFrameset()
    {
    var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
    "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
    "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
    "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
    "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
    "</frameset></frameset><plaintext>";

    with (document) {
    open("text/html","replace");
    write(szHTML);
    close();
    }

    fnBuildTabStrip();
    }

    function fnBuildTabStrip()
    {
    var szHTML=
    "<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[6]+";cursor:default;line-height:10pt;}"+
    ".clScroll2 {font:10pt Arial;color:"+c_rgszClr[6]+";cursor:default;line-height:11pt;}</style></head>"+
    "<body onclick=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" onselectstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
    "<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
    "<tr><td style=\"font:1pt\">&nbsp;<td>"+
    "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>&#171;</a></td>"+
    "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(0);\" ondblclick=\"parent.fnScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(1);\" onmouseout=\"parent.fnMouseOutScroll(1);\"><a>&lt</a></td>"+
    "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(1);\" ondblclick=\"parent.fnScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(2);\" onmouseout=\"parent.fnMouseOutScroll(2);\"><a>&gt</a></td>"+
    "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>&#187;</a></td>"+
    "<td style=\"font:1pt\">&nbsp;<td></tr></table></body></html>";

    with (frames['frScroll'].document) {
    open("text/html","replace");
    write(szHTML);
    close();
    }

    szHTML =
    "<html><head>"+
    "<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
    ".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:9pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
    ".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
    "</style></head><body onload=\"parent.fnInit();\" onselectstart=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+
    " topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";

    var iCellCount=(c_lTabs+1)*2;

    var i;
    for (i=0;i<iCellCount;i+=2)
    szHTML+="<col width=1><col>";

    var iRow;
    for (iRow=0;iRow<6;iRow++) {

    szHTML+="<tr>";

    if (iRow==5)
    szHTML+="<td colspan="+iCellCount+"></td>";
    else {
    if (iRow==0) {
    for(i=0;i<iCellCount;i++)
    szHTML+="<td height=1 class=\"clBorder\"></td>";
    } else if (iRow==1) {
    for(i=0;i<c_lTabs;i++) {
    szHTML+="<td height=1 nowrap class=\"clBorder\">&nbsp;</td>";
    szHTML+=
    "<td id=tdTab height=1 nowrap class=\"clTab\" onmouseover=\"parent.fnMouseOverTab("+i+");\" onmouseout=\"parent.fnMouseOutTab("+i+");\">"+
    "<a href=\""+document.all.item("shLink").href+"\" target=\"frSheet\" id=aTab>&nbsp;"+c_rgszSh+"&nbsp;</a></td>";
    }
    szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab>&nbsp;</a></td><td width=100%></td>";
    } else if (iRow==2) {
    for (i=0;i<c_lTabs;i++)
    szHTML+="<td height=1></td><td height=1 class=\"clBorder\"></td>";
    szHTML+="<td height=1></td><td height=1></td>";
    } else if (iRow==3) {
    for (i=0;i<iCellCount;i++)
    szHTML+="<td height=1></td>";
    } else if (iRow==4) {
    for (i=0;i<c_lTabs;i++)
    szHTML+="<td height=1 width=1></td><td height=1></td>";
    szHTML+="<td height=1 width=1></td><td></td>";
    }
    }
    szHTML+="</tr>";
    }

    szHTML+="</table></body></html>";
    with (frames['frTabs'].document) {
    open("text/html","replace");
    charset=document.charset;
    write(szHTML);
    close();
    }
    }

    function fnInit()
    {
    g_rglTabX[0]=0;
    var i;
    for (i=1;i<=c_lTabs;i++)
    with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
    g_rglTabX=offsetLeft+offsetWidth-6;
    }

    function fnTabToCol(iTab)
    {
    return 2*iTab+1;
    }

    function fnNextTab(fDir)
    {
    var iNextTab=-1;
    var i;

    with (frames['frTabs'].document.body) {
    if (fDir==0) {
    if (scrollLeft>0) {
    for (i=0;i<c_lTabs&&g_rglTabX<scrollLeft;i++);
    if (i<c_lTabs)
    iNextTab=i-1;
    }
    } else {
    if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
    for (i=0;i<c_lTabs&&g_rglTabX<=scrollLeft;i++);
    if (i<c_lTabs)
    iNextTab=i;
    }
    }
    }
    return iNextTab;
    }

    function fnScrollTabs(fDir)
    {
    var iNextTab=fnNextTab(fDir);

    if (iNextTab>=0) {
    frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
    return true;
    } else
    return false;
    }

    function fnFastScrollTabs(fDir)
    {
    if (c_lTabs>16)
    frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
    else
    if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
    }

    function fnSetTabProps(iTab,fActive)
    {
    var iCol=fnTabToCol(iTab);
    var i;

    if (iTab>=0) {
    with (frames['frTabs'].document.all) {
    with (tbTabs) {
    for (i=0;i<=4;i++) {
    with (rows) {
    if (i==0)
    cells[iCol].style.background=c_rgszClr[fActive?0:2];
    else if (i>0 && i<4) {
    if (fActive) {
    cells[iCol-1].style.background=c_rgszClr[2];
    cells[iCol].style.background=c_rgszClr[0];
    cells[iCol+1].style.background=c_rgszClr[2];
    } else {
    if (i==1) {
    cells[iCol-1].style.background=c_rgszClr[2];
    cells[iCol].style.background=c_rgszClr[1];
    cells[iCol+1].style.background=c_rgszClr[2];
    } else {
    cells[iCol-1].style.background=c_rgszClr[4];
    cells[iCol].style.background=c_rgszClr[(i==2)?2:4];
    cells[iCol+1].style.background=c_rgszClr[4];
    }
    }
    } else
    cells[iCol].style.background=c_rgszClr[fActive?2:4];
    }
    }
    }
    with (aTab[iTab].style) {
    cursor=(fActive?"default":"hand");
    color=c_rgszClr[3];
    }
    }
    }
    }

    function fnMouseOverScroll(iCtl)
    {
    frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[7];
    }

    function fnMouseOutScroll(iCtl)
    {
    frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[6];
    }

    function fnMouseOverTab(iTab)
    {
    if (iTab!=g_iShCur) {
    var iCol=fnTabToCol(iTab);
    with (frames['frTabs'].document.all) {
    tdTab[iTab].style.background=c_rgszClr[5];
    }
    }
    }

    function fnMouseOutTab(iTab)
    {
    if (iTab>=0) {
    var elFrom=frames['frTabs'].event.srcElement;
    var elTo=frames['frTabs'].event.toElement;

    if ((!elTo) ||
    (elFrom.tagName==elTo.tagName) ||
    (elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
    (elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {

    if (iTab!=g_iShCur) {
    with (frames['frTabs'].document.all) {
    tdTab[iTab].style.background=c_rgszClr[1];
    }
    }
    }
    }
    }

    function fnSetActiveSheet(iSh)
    {
    if (iSh!=g_iShCur) {
    fnSetTabProps(g_iShCur,false);
    fnSetTabProps(iSh,true);
    g_iShCur=iSh;
    }
    }

    window.g_iIEVer=fnGetIEVer();
    if (window.g_iIEVer>=4)
    fnBuildFrameset();
    //-->
    </script>
    <![endif]><!--[if gte mso 9]><xml>
    <x:ExcelWorkbook>
    <x:ExcelWorksheets>
    <x:ExcelWorksheet>
    <x:Name>TDSheet</x:Name>
    <x:WorksheetSource HRef="Desktop.files/sheet001.htm"/>
    </x:ExcelWorksheet>
    </x:ExcelWorksheets>
    <x:Stylesheet HRef="Desktop.files/stylesheet.css"/>
    <x:WindowHeight>5895</x:WindowHeight>
    <x:WindowWidth>11400</x:WindowWidth>
    <x:WindowTopX>0</x:WindowTopX>
    <x:WindowTopY>0</x:WindowTopY>
    <x:TabRatio>0</x:TabRatio>
    <x:RefModeR1C1/>
    <x:protectStructure>False</x:protectStructure>
    <x:protectWindows>False</x:protectWindows>
    </x:ExcelWorkbook>
    </xml><![endif]-->
    </head>

    <frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
    <frame src="Desktop.files/sheet001.htm" name="frSheet">
    <frame src="Desktop.files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
    <noframes>
    <body>
    <p>Эта страница использует рамки, но ваш обозреватель их не поддерживает.</p>
    </body>
    </noframes>
    </frameset>
    </html>
    VitosBBC, Aug 14, 2013
    #2
Похожие темы
  1. frashman

    7.7 Не сходится налоговый и бухгалтерский учет

    frashman, Oct 29, 2007, in forum: Общие вопросы "1С:Предприятие 7.7"
    Replies:
    0
    Views:
    630
    frashman
    Oct 29, 2007
  2. Пастор

    8.х БП книга продаж не сходится с 60 счетом

    Пастор, Jan 17, 2011, in forum: "1С:Бухгалтерия БП"
    Replies:
    1
    Views:
    438
    1cUserAndrew
    Jan 18, 2011
  3. mob51

    8.х не сходится товарный отчет

    mob51, May 6, 2011, in forum: Общие вопросы "1С:Предприятие 8"
    Replies:
    2
    Views:
    1,189
    for_maricat
    May 11, 2011
  4. Yana

    8.х БП Не сходится дебиторская и кредиторская задолженность в балансе

    Yana, Mar 13, 2013, in forum: "1С:Бухгалтерия БП"
    Replies:
    0
    Views:
    406
    Yana
    Mar 13, 2013
  5. Victoria_Bugatti

    Не сходится актив с пассивом. Помогите!

    Victoria_Bugatti, Aug 5, 2013, in forum: Общие вопросы по бухгалтерии
    Replies:
    0
    Views:
    370
    Victoria_Bugatti
    Aug 5, 2013
Loading...

Share This Page