You’re offline. This is a read only version of the page.
Announcements
295
The General Journal, User see the string of the Document Type: Payment, Invoice, Credit Memo, etc
But in GL Entry, they are store as 0, 1, 2,3.
How I know exactly Number 0 presents for Invoice or Credit Memo
Thanks Nitin
Is there any table that define this so it can be easier to join table together ?
There are many columns have the value list as same as Document Type, I would like to know about them.
[/quote]The option fields are a zero based index so the first option you see in the list will always have value 0 and the second one will have the integer value 1 and so on.
And in code you can use the option value if you use the syntax fieldname::OptionCaption.
And there is intellisense so AL will help you display the option capotions when you add the double colon.
Hi,
In SQL Option fields of BC D365 shown in the numbers.
Pls use Case Statement in SQL and write Case 1 = Payment and so on.
https://erpconsultors.com/how-to-use-case-statement-in-d365-bc/
If not solve, pls send SQL Query i wll correct it.
Regards
Amit Sharma
www.erpconsultors.com
Hi,
you can still join with their index values as Bc will understand it automatically
Thanks Nitin
Is there any table that define this so it can be easier to join table together ?
There are many columns have the value list as same as Document Type, I would like to know about them.
Hi,
In SQL table it shows like this only, you can start counting from 0 in BC. That is the index value of the option type
so now in your case its
0 = Blank
1= Payment
2 = Invoice
3=Credit Memo
4=Finance Charge Memo
5 = Reminder
6 = Refund
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
