divide by zero error on purchase order report

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date divide by zero error on purchase order report RichyRich 03-20-2007  Re: divide by zero error on purchase order report Glenn Adams [MVP - Retail... 03-20-2007  Re: divide by zero error on purchase order report RichyRich 03-21-2007
Posted by RichyRich on March 20, 2007, 6:04 am Please log in for more thread options On a clean install of headquarters manager I get a divide by zero error on the standard purchase order report. Regardless of what date range I put in it generates the same error. Any one else had this problem? Thanks Posted by Glenn Adams [MVP - Retail Mgmt on March 20, 2007, 11:00 am Please log in for more thread options You have a purchase order in the system with an exchange rate of zero. Run the following SQL Statement from HQ Administrator: Select PONumber, POTitle, StoreID, ID, ExchangeRate from PurchaseOrder where ExchangeRate = 0 This will tell you which PO is causing the error, but fixing it will be a problem as there is really no PO Editing function in HQ. You could use a SQL Update statement to change it, but that is not necessarily as safe course of action. See if you can find the PO in question and investigate what happened at the Store - if you end up needing to update the record, post back if you need to. Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information. RichyRich wrote: > On a clean install of headquarters manager I get a divide by zero error on > the standard purchase order report. Regardless of what date range I put in it > generates the same error. > Any one else had this problem? > Thanks Posted by RichyRich on March 21, 2007, 5:21 am Please log in for more thread options Thanks for your help. I updated the records and the report now runs perfectly. "Glenn Adams [MVP - Retail Mgmt]" wrote: > You have a purchase order in the system with an exchange rate of zero. > > Run the following SQL Statement from HQ Administrator: > > Select PONumber, POTitle, StoreID, ID, ExchangeRate > from PurchaseOrder > where ExchangeRate = 0 > > This will tell you which PO is causing the error, but fixing it will be > a problem as there is really no PO Editing function in HQ. > > You could use a SQL Update statement to change it, but that is not > necessarily as safe course of action. See if you can find the PO in > question and investigate what happened at the Store - if you end up > needing to update the record, post back if you need to. > > Glenn Adams > Tiber Creek Consulting > http://www.tibercreek.com > glenn@tibercreek.com > ---------------------------------------------- > Please DO NOT respond to me directly but post all responses here in the > newsgroup so that all can share the information. > > > RichyRich wrote: > > On a clean install of headquarters manager I get a divide by zero error on > > the standard purchase order report. Regardless of what date range I put in it > > generates the same error. > > Any one else had this problem? > > Thanks > Similar Threads Posted Error when trying to Create Purchase Order based on re-order information April 9, 2008, 3:56 pm odd purchase order error March 22, 2006, 7:33 pm Purchase Order Create Error June 14, 2006, 3:03 pm purchase order report May 9, 2008, 11:01 am Purchase Order Receipt report June 29, 2005, 1:53 pm Purchase Order List Report November 12, 2005, 5:44 am Editing Information on Purchase Order Report that's printed out July 20, 2005, 6:38 am Include List Price in Purchase Order Report August 11, 2009, 2:46 pm Associate a purchase order with a work order or back order June 9, 2006, 3:18 pm Customer Properties:Purchase History should be Purchase/Order Hist July 18, 2006, 1:18 pm