Announcements
Hello:
What would cause empty batches beginning with the Source Document "RMAPY"?
I know that, in a Multicurrency environment where payments are applied to invoices that are not in the functional currency, applying payments results in gain or loss financial entries that have to be posted.
But, why would these batches be empty? And, is there a way to prevent such empty batches from resulting?
Thanks!
John
*This post is locked for comments
I am seeing the same thing in my environment. We are not using Multicurrency but we are using Discounts and Writeoffs.
Here is the situation for us:
We have high volume of Cash Receipts and applying them in lots of companies.
RMAPY Batches are created from the Application of Payments/Credits to Invoices/Debit Memos when the user adds a discount or writeoff amount.
They inherently don't post "through" to the general ledger because they can't be saved in a Batch. The action happens as soon as one clicks "Ok" on the Apply Sales Documents window. The Journal Entry is created.
We are getting lots of empty RMAPY Batches and yes, they can be deleted, but where we have so much activity and separation of duties, we generally have accounting posting these batches separately from the Cash Team which is applying Cash or Credits. So they see "RMAPY" batches in Series post and then post them - I'd say blindly. I don't blame them if they see 70 individual RMAPY Batches to post. There are so many that it would be a pain to look at them individually and then you risk deleting one by mistake.
But you can't tell when there are "empty" ones by Series post. They just fail to post. Then the user needs to delete the Batch. But if there are 40 of the 70 that are empty, just think of what a pain that it so have to manually delete 40 Batches that have a header and no line Items.
I am trying to figure out how they get created to try and get a process around them. But I can't seem to replicate it. I try to apply cash with discounts and then unapply but it seems to just create 2 separate JE's that offset each other.
Can anyone out there figure out how these are getting created? If I can replicate it, I can do something about it. But thus far, I have not been able to do this.
Hello:
The setting for "Receivables Apply Doc." is set to "Post Through".
The main thing that concerns me, though, about these bathes is that there were several journal entries for the receivables subledger that did not post through the G/L. These journal entries have to do with applying receivables and, specifically, with $0.01 rounding errors for Multicurrency exchange rates.
These $0.01 differences within the journal entries did not make it to the G/L. So, we had to conduct manual journal entries, to get the receivables subledger and the G/L to balance.
Our best guess is that these $0.01 differences should have resided in these "RMAPY" batches but never "made it to those batches". The only thing that we can think of is that a posting glitch must have prevented these $0.01 differences from making it into these batches.
Would you agree?
Thanks!
John
Hi John,
Thank you for the response, as long as they are completely empty you should be able to delete the batch without and problems. Tim is correct that these are created when a RM transaction is applied. It is just weird to me that the batches aren't clearing our but are just empty sitting in available status.
Do you know what the Posting settings for batches are John? Are they supposed to Post to and Through the GL?
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
I have seen this before.
I think these occur when your Accounts Receivable person applies a Receivables Document
Transactions>Sales>Apply Sales Documents.
Example:
$50 (func curr) Credit Note is applied to a $50 (func curr) Debit Note.
GL posting:
Dr Cr
Accounts Receivable $50
Accounts Receivable $50
GP Nets the accounts to 0 - Empty posting
You should be able to use SQL to see the owner of the batch.
This behavior might depend on posting settings.
Tim
Hi Tom:
They are set as available.
Thanks!
John
Hi John,
I have never seen this issue occur, generally the only time I will see an empty batch that has no records is if there was an interruption in the process when the system is removing the batch. Do these batches have any status or are they set as available?
~Thomas Newcomb
------------------------------------------
Microsoft Dynamics GP Support
------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
