Transactions are missing on the Invoices and Transaction tabs in Customer Maintenance after running Period End Processing if the billing method is mixed (open item and balance forward) in MAS 90 and 200
Transactions are missing on the Invoices and Transaction tabs in Customer Maintenance after running Period End Processing if the billing method is mixed (open item and balance forward)
Entry Type: Program Issue
Product: Sage MAS 90 ERP, Sage MAS 200 ERP
Application: Accounts Receivable
Version Reported: 4.40.0.0
Status:
Resolved with Product Update 2 for Sage ERP MAS 90 and 200 4.40 (4.40.0.02).
This issue was also resolved with the following hot fixes: Note: Install the hot fix only for the specific version that it applies to. Apply the hot fix before running period end processing. If the issue has already occurred, see the possible workaround below.
Transactions are missing on the Invoices and Transaction tabs in Customer Maintenance after running Period End Processing, if the company's billing method is both open item and balance forward (mixed).
Steps to Duplicate:
In ABC company:
Expand Accounts Receivable and Main. Double-click Accounts Receivable Options.
Click the Additional tab, and verify the following setting:
Open Item or Balance Forward = Mixed
In Accounts Receivable, expand Main. Double-click Customer Maintenance.
Select customer 02-ATOZ, and click the Invoices tab.
Click on invoice 0000145 and note the the Trans Date for the following Trans Types:
Invoice = 3/31/2010
Payment = 5/31/2010
Click on invoice 0000126 and note the the Trans Date for the following Trans Types:
Invoice = 2/28/2010
Payment = 5/31/2010
In Accounts Receivable, expand Period End. Double-click Period End Processing.
Click Proceed, and then click Print.
Click Yes at the message "Do you want to complete period end processing?"
Open Customer Maintenance again.
Select customer 02-ATOZ. and click the Invoices tab.
Click on the invoices reviewed above. Note that the transaction dates are changed. The transaction amount and the payment transactions are missing. Note: The transactions are combined in AR_TransactionPaymentHistory.m4t during period end processing.
Expected Behavior:
Transactions should not be removed or combined during period end processing.
Possible Workaround:
Restore from the last good backup prior to running period end processing, and recreate any transactions (if necessary).
If no backup is available, contact Sage Customer Support.