Wednesday 10 February 2016

compare common record with sales table or purchase table


        for (i=tableFlag; i <=fr.dataSourceCount();i++)
        {
            fds = fr.dataSource(i);
            if(flag==0)
            {
                currentRecord  = currentQuery.get(fds.table());
                linesBuffer    = currentRecord;
            }
            else
            {
                if( currentRecord.TableId == tableNum(SalesTable) ||  //if the common record is salestable
                    currentRecord.TableId == tableNum(PurchTable))   //if the common record is purch //table
                {
                    currentRecord = this.queryXMLNodeSalesPurchase(currentRecord.TableId, fds.table(), currentRecord.RecId);
                }
                else
                {
                    currentRecord = this.queryXMLNode(currentRecord.TableId, fds.table(), currentRecord.RecId);
                }
            }

No comments:

Post a Comment

intercompany PO multiple product receipt by x++

public void processStampICPO(PackingSlipId _deliveryNote,                             Transdate _deliverydate,                             ...