Daily Sales

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have been running a PC 2.76 shop for many years, and recently upgraded all the way to 4.
One feature that I'm missing is the ability to quickly see our current daily sales.  Just viewing the sales reports section in 2.76 would provide that data.

Has it been relocated?  If yes, where?  If no, any easy hack to bring it back? 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
amgqmp1 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 01-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote amgqmp1 Report Post Thanks(0) Quote Reply Topic: Daily Sales Posted: 11-March-2010 at 4:10pm
	I have been running a PC 2.76 shop for many years, and recently upgraded all the way to 4. One feature that I'm missing is the ability to quickly see our current daily sales. Just viewing the sales reports section in 2.76 would provide that data. Has it been relocated? If yes, where? If no, any easy hack to bring it back?

whizzinpc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 17-January-2006 Location: California Status: Offline Points: 20	Post Options Post Reply Quote whizzinpc Report Post Thanks(0) Quote Reply Posted: 12-March-2010 at 11:37am
	I don't think it can be found anywhere unless you run a report. We added it manually. I just modified the code. invoicing.asp look for the following section. <% While Not rs.eof pTotal=rs("total") pIdOrder=rs("idOrder") pIdOrder=scpre + int(pIdOrder) %> <li><%response.write "Order #: "&pIdOrder&" - Total: "&scCurSign & money(pTotal)%> - <a class="resultslink" href="Orddetails.asp?id=<%=rs("idorder")%>" onFocus="if(this.blur)this.blur()">View details >></a></li> <%rs.MoveNext%> <%Wend%> </ul> <% end if Set rs=Nothing %> and change it to: <% While Not rs.eof pTotal=rs("total") pIdOrder=rs("idOrder") pIdOrder=scpre + int(pIdOrder) pTotalDay = pTotalDay + pTotal %> <li><%response.write "Order #: "&pIdOrder&" - Total: "&scCurSign & money(pTotal)%> - <a class="resultslink" href="Orddetails.asp?id=<%=rs("idorder")%>" onFocus="if(this.blur)this.blur()">View details >></a></li> <%rs.MoveNext%> <%Wend%> </ul> <p>Today's total: <% Response.write scCurSign & money(pTotalDay)%><br> </p> <% end if Set rs=Nothing %> It basically adds the daily total to this page just below the list of all orders for the day. You get to the page from Orders>Locate an Order. Edited by whizzinpc - 12-March-2010 at 11:38am

amgqmp1 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 01-November-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote amgqmp1 Report Post Thanks(0) Quote Reply Posted: 12-March-2010 at 12:41pm
	You are my hero for the day! That worked out beautifully, and I'll learn from that code to add it to the home page too. Thank you!