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
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.