Stock movement in close cash report

Use this code to print stock movement in close cash report


Note: Stock movement report is available in Saleculator 3.8u1 onwards only.

Administrator Menu > Maintenance > Resources
Add the below template into close cash reports:
<!-- STOCK REPORT START -->
        <line>
            <text bold="true">Stock Report</text>
        </line>
        <line>
            <text align ="left" length="18">Name</text>
            <text align ="right" length="6">In</text>
            <text align ="right" length="6">Out</text>
            <text align ="right" length="6">Bal</text>
            <text align ="right" length="12">Value</text>
        </line>
        <line>
            <text>------------------------------------------------</text>
        </line>

#set($cat = "")
        #foreach ($line in $payments.getProductStockLines())
 #if ( $cat != ${line.printCategoryName()} )
 #set( $cat = ${line.printCategoryName()} )
 <line></line>
            <line>
            <text align ="left" length="48">${line.printCategoryName()}</text>
            </line>
 #end
<line>
<text align ="left" length="18">${line.printProductName()}</text>
<text align ="right" length="6">${line.printStockIn()}</text>
<text align ="right" length="6">${line.printStockOut()}</text>
<text align ="right" length="6">${line.printCurrentStock()}</text>
<text align ="right" length="12">${line.printStockValue()}</text>
</line>
        #end
        <line>
            <text>------------------------------------------------</text>
        </line>
<!-- STOCK REPORT END -->

Save & restart

0 Comments

Leave a Reply

Arrow-up