Known Issues

From Executive Jeweller
Revision as of 08:12, 7 April 2011 by Executive (talk | contribs) (Created page with "#On Purchase Orders, if you begin receiving a PO and quit partway through receiving, in some situations the PO will be marked as incomplete, but you will not be able to return th...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  1. On Purchase Orders, if you begin receiving a PO and quit partway through receiving, in some situations the PO will be marked as incomplete, but you will not be able to return the items. This is because when receiving it, the POReceive tables have already been filled in, which ensures that the items cannot be returned multiple times, but the PurchaseOrderReceive tables were not yet filled in, as the process was exited before that point. The only way to fix this is to open the database in MS Access and remove the records from the POReceive table that should not have been there.
  2. On Gift Certificates, there have been cases where partially using a Gift Certificate will appear correct and create the correct credit, but the Gift Certificate itself doesn't remove the credit amount. This can be observed on the Daily Balance and Deposit report, where the Gift Certificate line doesn't reflect the full amount being removed, with the Credit balance not being factored in. This can be corrected by editing the Payment table record for type GCEO for the full amount. See other similar gift certificate records for examples of a correct entry and replicate that.
  3. If a sale has been partially entered but is incomplete, it will have a -ve InvoiceId (such as -1). These are removed during compacting, but if the Daily Balance and Deposit report is run at the end of the day before compacting, these sales may show on the Daily reports and cause discrepancies. If this is found, simply compact the data and re-run the reports to get the correct figures.
  4. Service Reports 3/4/5 do not accept the No Charge filter. Will give the pop up 'Enter Parameter Value', so it must be left blank on these reports.
  5. When doing a Transfer In, if you leave the Transfer and reopen it later through Functions-Find Transfer, in some situations it will change the To and From Locations so that both are the same location. If this happens, the best option is to start the transfer over again and complete it without exiting.
  6. On Appraisal Retail Replacement Certificates, if you use an Appraisal SKU with no weight entered in the original SKU, it will transfer the weight as 0.0 instead of blank, which is then printed on the certificate.