General Discussion Topics

[neald996]

OK - so I've looked through the forums but didn't see this question previously posted, so I'm curious as to how others have dealt with a problem that we occasionally encounter.

We are running MAS500, with the standard modules (AP, AR, CM, PO, IM, etc.) and a number of users.

Every once in a while, one of our users enters an item into a module with a transaction date that falls into a period outside of the period being posted to the GL, which results in a discrepancy between the GL balance and the subledger balance as of the same date.

Our 'fix' has been to either reverse the original transaction and re-post if/when possible or to record a GL reversing entry between the 2 periods, which effectively adjusts the difference in the GL but seems to be a back-handed way of fixing the problem, especially when the transaction date might have been the one entered incorrectly.

What I'd really like to do is modify the transaction date for a previously posted item and put it in the same period as was posted to the GL, but I don't see any ability to do this within MAS (e.g. transaction dates are always grayed-out when viewing a posted invoice, sales order, etc.).

If that functionality does exist within MAS500, can someone tell me how to go about enabling it?

Thanks in advance.

[snolte]

As far as I am aware there is no capability to modify transaction dates on posted transactions.  The methods you are using are the ways we use to correct these items where necessary - usually we opt to post a reversal of the original transaction plus the corrected transaction, in the same GL period.  In the AR and AP we usually leave the variance and list the item as a reconciling item on our monthly reports.

[nomdepomme]

Does the run date affect either the posting date or module date? How would the run date be changed?

[trodman]

Which sub-ledger normally has the problem? On a number of the sub-ledger reports you have the option to run based on Posted Date instead of Transaction Date.

[aclark]

Do your sub-ledger trial balances match the GL trial balance?  These are based on Posted Dates, so they should tie.

As has already been said, the AR Aged Recievables report and the AP Aged Payables reports can be run using the Posting Date to tie them to the GL.  These amounts should be the same.  If not, there is another issue.

You shouldn't need to reverse any entries.  You should be able to reports that tie without doing this.