Finance | Project Operations, Human Resources, ...

Bank rec - outstanding transactions by debit/credit?

(0) Share

Report

Posted on by Reddog94

I love the unreconciled bank transactions report in SmartList. However, every amount shows up as a positive number, making it difficult to find offsetting transactions (vs. if they're been double booked). Is there a way to pull (in excel) unreconciled transactions that show debit or credit (or payment/deposit, etc). Thanks!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Reddog94,

Can you explain what SmartList is?

Is this a form that has been embedded to your D365FO software or is it an external tool?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Like Dr. Ludwig said, is SmartList is ISV solution?

Also, in Standard Dynamics FO, you can see Debit Credit option in Bank reconciliation.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Reddog94,

We don't have smartlist in D365 Finance and operation, SmartList Designer is within Dynamics GP only but not in Finance and operation. If your quesiton is related to D365 FO then yes you can export unreconciled/not cleared transactions from the bank recon screen but what do you mean by Debit/Credit? Do you want to see positive and negative transactions (Payments/Deposits) or voucher information of any unreconciled transaction, For example: Customer receipt: Debit Bank and Credit Customer.

Was this reply helpful? Yes No
Reddog94 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! Thanks for the response. I am a new GP user and don't know the difference between FO and what I'm apparently using. Is there a better place to post my questions that isn't FO specific?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Reddog94,

We have D365 General forum as well.

Here you go:

community.dynamics.com/.../dynamics-365-general-forum

I suggest you to post your question to relevant community forum to get proper answers from members.

If nothing else is needed then please be so kind and verify the answer.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

moved to the gp forum

Was this reply helpful? Yes No