Duplicate Invoice Records in ARYMST When Archiving Accounts Receivable Records

  • Created:
  • / Author: tombucci
Issue

Duplicate invoice records in arymst when archiving AR. This occurs when converting from an installation prior to Sage Pro 7.4 to Sage Pro 7.5
Build Info
———–
Sage Pro 7.5 Build 3500

Solution or Workaround

The following issue has been reported in PTR 89613 and has been in addressed in Sage Pro 2010.

Steps to Duplicate

Was only able to reproduce when converting a Pro 5.0 installation provided by a customer. Could not reproduce when converting from Sage Pro 7.3B to Sage Pro 7.5

The following steps were recreated using customer data company 01.

  1. Locate an unpaid invoice that is in both ARYMST and ARMAST, use invoice 81985 for customer 2735 in Pro Series 5.0
  2. Convert Pro Series 5.0 to Sage Pro 7.5 VFP.
  3. Create a cash receipt (payment on account) and apply it to invoice 81985.
  4. Archive AR .
  5. Check ARYMST, there are two invoice records in ARYMST
  6. View Customer Inquiry for Invoices set to previous periods, you will see duplicate invoice records for both paid and unpaid invoices (ie 81851).

© Copyright Sage Software

Leave A Comment?