Best Of
Spit a Decimal Value
Hi,
I have a decimal field amount having value say 35.65.
I want to separate the left and right parts of the decimal and show in different fields. How to do that?.
I have a decimal field amount having value say 35.65.
I want to separate the left and right parts of the decimal and show in different fields. How to do that?.
souravb
1
Re: BC ExternalSql
Create a view based on the external SQL table. In this view, you can cast the datatype from original ext sql table to the type of datatype supported by NAV. Then use this view as external table to your BC installation.
jordi79
1
SSO
Hi, we are still using NAV 5.0 (with file database), yeah quite lol these days, but it still works nicely.
We use windows domain accounts for signing, but the corporation now pushes SSO and Azure for all apps and my question is- could this be possible? Anyone experienced in such scenario?
We use windows domain accounts for signing, but the corporation now pushes SSO and Azure for all apps and my question is- could this be possible? Anyone experienced in such scenario?
miknav
1
Re: Strange code on Sales Order List page
"Then there was the presence of a local variable that still cause the page to not show anything, so I had to remove that local variable as well."
Come on, this is so 1999 😄
Come on, this is so 1999 😄
TallyHo
1
Re: NAV default rounding
Sounds like you have a problem with "Unit Cost" also. You should not be seeing more than 5 decimal places there either.
bbrown
1
Microsoft Dynamics 365 Business Central Financial Consultant Services
Let me introduce Simplanova's Dynamics 365 Business Central Financial Consultant Service.
This new service includes Continia DC implementations & training, your end-customer's company setup, implementation support & training, defining design documents, and development.
We help support your end-customers with the following consulting activities:
Don’t turn off projects because you don’t have time or expertise –
extend your team using our senior consultant with deep finance knowledge -> https://simplanova.com/dynamics-nav-365-business-central-services/financial-consultant-services/
This new service includes Continia DC implementations & training, your end-customer's company setup, implementation support & training, defining design documents, and development.
We help support your end-customers with the following consulting activities:
- Continia Document Capture implementation and training
- Your end-customer’s company setup
- Your end-customer’s training (except localization part; English only)
- Support your end-customer’s implementation process
- Define functional design documents
- Use Simplanova’s flexible development team together with our consultants to build customizations
- Dynamics NAV migration Services
Don’t turn off projects because you don’t have time or expertise –
extend your team using our senior consultant with deep finance knowledge -> https://simplanova.com/dynamics-nav-365-business-central-services/financial-consultant-services/
Records, RecordIDs, and RecordRefs OH MY!
Arg.
Ok, I grew up on MS C/Side documentation examples like:
Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy reactions to her cat(s). So she turns to Todd's boss Anne. She escalates her request to management with a proposal that includes new servers, a company car, and a corner office. When in that office she turns to Mibuso and within five minutes has his answer. Copy - Paste - and Viola!
:-)
Ok (again) - I'm Todd - sort-of. (I'm not allergic to cats - just crummy documentation.) All I need is a nudge here. (And maybe win Sally back)
I've read about and played with RecordRefs, etc, and have a headache. This is all I want to do:
Function1
Customer.GET('C1');
or
Item.GET(I1);
// Whatever
Now I want to call Function2 with some sort of variable that Function2 can determine what table number / record type (Customer or Item) the caller is sending, and what the key field(s) are for that record.
Function 2
// Takes a parameter that - like specified above - allows me to determine what table number (Customer or Item) I'm called with, and the primary key(s) of that record. I then want to retrieve that record using a 'normal' record variable using a CASE statement like
CASE TableNo OF
## - Get a ## record using primary key value(s)
### - Get a ### record using primary key value(s)
I can't promise a company car for help here - only my sincere thank!
Bob
Ok, I grew up on MS C/Side documentation examples like:
Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy reactions to her cat(s). So she turns to Todd's boss Anne. She escalates her request to management with a proposal that includes new servers, a company car, and a corner office. When in that office she turns to Mibuso and within five minutes has his answer. Copy - Paste - and Viola!
:-)
Ok (again) - I'm Todd - sort-of. (I'm not allergic to cats - just crummy documentation.) All I need is a nudge here. (And maybe win Sally back)
I've read about and played with RecordRefs, etc, and have a headache. This is all I want to do:
Function1
Customer.GET('C1');
or
Item.GET(I1);
// Whatever
Now I want to call Function2 with some sort of variable that Function2 can determine what table number / record type (Customer or Item) the caller is sending, and what the key field(s) are for that record.
Function 2
// Takes a parameter that - like specified above - allows me to determine what table number (Customer or Item) I'm called with, and the primary key(s) of that record. I then want to retrieve that record using a 'normal' record variable using a CASE statement like
CASE TableNo OF
## - Get a ## record using primary key value(s)
### - Get a ### record using primary key value(s)
I can't promise a company car for help here - only my sincere thank!
Bob
bhalpin
1
Re: Better way to insert dimension set ID from AL Code (BC SaaS)
this post is by mistake
