GP Receivables Mass Transaction Document Date Change

(0) Share

Report

Posted on by Napolo

766

Our GL Team has imported a large receivables batch of 800 transactions. About 200 of those transactions posted with a document date of 4/22/2024. Not sure how this is possible, but at this point need to know the best way to handle getting the 200 transactions voided. With the research I have done, it looks like a manual process. Wondering if someone else had another solution. I tried to find a smartlist that would allow the void to occur there, so I can create a macro, but that doesn't seem to allow a void. Any help is appreciated.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Napolo 766 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

p.s. Has anyone ever seen a portion of a batch change dates in the middle of an integration? Entire column showed up as 7/31/15, but 200 records decided to take on 4/22/2024. Has never happened in the past.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

Hi Nicole,

Have you tried write macro to void the 200 transactions.

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

I have not gotten that far yet. Right now, I am trying to isolate the 200 transaction in Smartlist Builder, so that we can pull the macro through. However, when I am pulling the invoice in Smartlist, I am not seeing where the transaction can be voided. I have gone to Sales>Receivables Transactions. When I double click on the item, I get the inquiry zoom only. I must be missing something very simple.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

If all these transactions is posted then you go to Transactions-sales-posted transactions and enter the customer ID select document type and enter the document number and press void.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

Hi,

First, no, I personally have never heard of dates changing in the middle of the import. I second Babu's macro suggestion. You can use SmartList to build your list of items to be voided, export it to Excel and then use the Mail-Merge feature in Word to construct a giant macro. Question, what happened on the general ledger side of things? It wouldn't post an entry to 2024 unless you had that year already setup. Have you already removed the GL entry created when you posted the RM documents? Will you be 're-importing' the 200 documents?

Kind regards,

Leslie

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

The document date is only affected, not the GL Posting date. Yes, we would re-import, if we can find an easy solution to void. Below is an image of my smartlist. My thinking was to isolate the transacitons, Like I did here and open each transaction and void. Either manually or creating a macro. However, whenI open the transaction, it is in inquiry zoom and I can not void from here. What am I missing? I should be able to void a receivable straight from a smartlist, correct? don't have much time to venture off on the giant macro idea, but appreciate the thought:)

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

SmartList does not have a 'goto' that ends up on the Receivables Posted Transaction Maintenance window. You need to be on that window in order to void a posted transaction. If you have SmartList Builder you could build your own object and GoTo if you want to navigate to where you can void the entry. Out of the box, you cannot do that. The macro isn't so bad once you have the list of items you want voided. If you want to attempt it today, I'll be happy to help. You'll need to call me at 972-814-8550 and we can walk through it together.

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (2)

Report

RE: GP Receivables Mass Transaction Document Date Change

Just to follow up, Nicole called me and I walked her through how to create a SmartList and a GoTo that opened the window for voids. Now, someone can double-click on one of the list items and it will open the window where a void can be executed.

Kind regards,

Leslie

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

Yes! Sorry for the delay in response. A few emergencies popped up. Thank you so much for the tutorial and conversation, very very kind of you. I learned something new "Go To". A piece I have been missing all along. We are now able to isolate the problem transaction and quickly void. Thanks again!

Was this reply helpful? Yes No
Napolo 766 on at

Like (0)

Report

RE: GP Receivables Mass Transaction Document Date Change

HI Leslie!

I am attempting my first Go To Smartlist, on my own.. I am trying to replicate what we did a few days ago, but for Payables Transactions. Below is what I have setup. It appears to be correct, however I can not double click to open each transaction. I have to click on the drop down in the far right. Screen shots below for both. Hope you can help! :)

Was this reply helpful? Yes No