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
divide by zero error on purchase order report
Mar 20, 2007
2 Replies
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 C> On a clean install of headquarters manager I get a divide by zero error on
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required