Evopos Help - 2.09.068

Check / Fix Data

Check / Fix Data

Previous topic Next topic  

Check / Fix Data

Previous topic Next topic JavaScript is required for the print function  

This option is designed to check for any problems in the Evopos Sales and Purchase Data that could cause information to be displayed incorrectly and if possible fix them.

These problems could be caused by a number of scenarios including:

A payment date before the transaction date (Should not now be possible)

A computer failing in the middle of a multi-stage transaction and not updating all tables

A Transaction or Payment record being edited or deleted incorrectly

Previous issues importing sales history from Business Manager

Bugs or Changes in the software (normally in early versions)


The Check / Fix Data procedure performs the following functions that fixes (changes) the data:

Update Sales Transactions Lines with no Header ID with a Header ID (Used to link only by Transaction No)

Ensure all Sales Payments for Trade-Ins are marked as Banked

Fixing the result of an old bug where Sales Payments could have a Nominal of: 01-08-?? instead of 01-09-04

Ensure Sales Journals have a Sales Type 'JOURNAL' rather than the older 'CONTRA' previously used

Sales Temp Credits - Date correction set PaidDate and CreatedDate to ModifiedDate and SalesSubType =TEMP-CREDIT if Sales InvNo<>0 and SalesType=TEMP-CREDIT and SalesSubType <>TEMP-CREDIT.

Ensure all Sales Transactions have an associated Payment record (Payment records created will have a Payment Method of Sale Contra (In-Hand-Contra) and Payment dates the same as the Invoice Date). If this is in the current year you may wish to Journal the Banked amounts from the Sales Contra to the Bank, if any of the amounts are still on Account then create a negative pre-payment on the Sales Contra account. (Note: Old importing of Business Manager sales did not create these sales payments)

Change Sales Payment date to Invoice date if the dates are different and Paid=True and (Is Account=False or Nominal=01-09-04)

Checks for duplicated Sales Payment records for the one Sale and deletes the other payment records if the first payment record amount is correct

Setting Purchases Statement Date to the same as Paid date if not set (Null)

Ensure Purchase Journals have a Sales Type 'JOURNAL' rather than the older 'CONTRA' previously used

Purchase Payments - Updating Payment Nominal to  01-08-99 if incorrectly set to: 01-09-??

Used Units - Cost price updated to Purchase Trans amount if different

Used Units - Sold price updated to Sales Trans amount if different


It also details suspected issues in the following areas that it cannot fix automatically

Sales Transactions dated later than the current date

Sales Transaction Header with No Sales Lines Records

Sales Transactions where the Total and Tax on the Header is different to the sum of the Lines

Sales Transactions where the Payment amount is different to Transaction amount and the PaymentSummary Contains the text 'TRADE'

Same as above but there is no text of 'TRADE'

Sales Transactions where the Payment Discount amount is different to Transaction Discount amount

Purchase Payments where the PaymentType='BANK' (Bankings) and the associated Banked Sales Payments have a different total

Used Units - No Purchase Trans for Sold Consignment

Used Units - No Purchase Trans for purchased unit

Used Units - No Sales Trans No for sold unit


At the completion Evopos writes the information to the Operator Log and gives the option to produce separate reports for:

1).The issues Fixed

2).The suspect Issues marked as TODO


Note: There is also a new option for deleting data (including Sales and Purchases) before a date in Settings (on the System / General tab under Change Database options). Sales and Purchases will only be deleted if the Transaction and the Payment dates are both before specified date.