Notifications
Announcements
No record found.
Hi All,
Can you please let me know how to pick only DEBIT amount from amount cur?
This is my requirement. I need to display vendor account with debit amount and other fields also...
Kindly give me the logic for to pick ONLY DEBIT AMOUNT from amount cur field.
Please give me more shed on this.
Thanks!
Hi @rp@n,
Please check the 'IsCredit' field in table 'GeneralJournalAccountEntry ', and you can use it as a condition of sql statement.
Please see the old thread:
community.dynamics.com/.../869587
Hope this helps.
The IsCredit checkbox is one option to filter the records. Yet, it requires that you don't post with opposite signs on the debit/credit side.
What you can try alternatively is filtering for amounts larger than 0 because debit amounts are 'positive' ones while credit ones are the ones that post with a negative sign.
Best regards,
Ludwig
Thanx Ludwig
As of now I applied logic as you suggested the second one. Could you please let me know how to use the logic for "IsCredit" check box ?
Good Morning @rp@n,
The isCredit checkbox is not available in the VendTrans table but in the GeneralJournalAccountEntry table that Will WU mentioned.
If you want to use this one for vendtrans related records you would have to create some complex query to get a hold on this field as there is no direct relationship between VendTrans and GeneralJournalAccountEntry.
Yet, I am not sure whether this is the better approach because all depends on how your finance colleagues post. As an example posting -5 USD in the credit field could be considered as a debit and vice versa. This transaction can be considered as a debit transaction but it might also be related to a correction that has been made. For that reason, I would recommend not only looking at the sign / column but also to take the additional fields such as e.g. the transaction type into consideration to identify the underlying nature of the transaction.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 551 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
