Stack Overflow
Stack Overflow

Questions tagged [dynamics-sl]

Microsoft Dynamics SL (Originally named Solomon) is one of Microsoft’s Enterprise Resource Planning software products. It is part of the Microsoft Dynamics family. The main programming language is in VB.Net to new screens developed, actual screen customization can be done thru VBA with the help of SL APIs. Older versions were using VB and BSL (Basic Script Language).

15 questions
3
votes
4 answers

intelligent database search

The issue is there is a database with around 20k customer records and I want to make a best effort to avoid duplicate entries. The database is Microsoft SQL Server 2005, the application that maintains that database is Microsoft Dynamics/SL. I am…
stephenbayer
  • 12,373
  • 15
  • 63
  • 98
1
vote
1 answer

VBA how to replace "As Any" in function

I have a dll that use this signature: SFetch(cursor As Integer, pstruct As Any, size As Integer) As Integer I can call it with simple variables like Integer or more complexe one with custom types. I want to create a function that would receive a…
Alex Dupuis
  • 366
  • 3
  • 14
1
vote
1 answer

Dynamics SL Field Length limit / Invoice Number length

If anyone can point me to the documentation for SL, which address the field length limits, right now i need to know about the length limit of invoice number.
devkhalid
  • 13
  • 4
1
vote
2 answers

MS Dynamics - permissions on modules

I am entirely new to MS Dynamics and have inherited an MS Dynamics environment with my new job. I replaced an employee who had sole ownership and knowledge about the Dynamics set up. So I am slowly going through all the database tables and fields…
Perplexed
  • 877
  • 2
  • 19
  • 32
1
vote
1 answer

Good online resources for Microsoft Dynamics SL?

Does anyone know of good online resources for Microsoft Dynamics SL (Solomon)? I'm interested in general support information and back end SQL support information, as well.
Jim
  • 624
  • 8
  • 20
1
vote
1 answer

Discovering Dynamics SL (Solomon) Customizations

I'm in the midst of upgrading a MS Dynamics SL (6.5sp1) installation, and was wondering if there was an easy way to review the BSL/VBA code involved in screen customizations. Or at least a way to be able to discover each and every form that has…
Stephen Wrighton
  • 36,783
  • 6
  • 67
  • 86
0
votes
0 answers

Inconsistent Results from Cross-Server Query

I have a query that yields inconsistent results. I receive a different number of rows almost every time I run the query. I receive no errors. I have tried running the query from all of the servers in the query. I also tried running the query…
Brendan Lesinski
  • 115
  • 7
0
votes
1 answer

Microsft Dynamics SL SoHeader And SalesPerson relationship- Not able to link

I am trying to create SalesOrder via api and inserting them into SQL database . Tables I am using : SOHeader and SOLine Column to insert into both object : SlsperID I am able to link line wih SLsperId but not with Soheader. I tried to create it…
Piyush Kalra
  • 21
  • 4
0
votes
1 answer

How can I fix Run-time error 430 from importing custom DLL in VBA project

I've struggle several hours on that and I can't find what I'm doing wrong. I created a new C# dll project, here is the content of the only class it contain: using System; using System.Runtime.InteropServices; namespace PolygonSl { …
Alex Dupuis
  • 366
  • 3
  • 14
0
votes
1 answer

How to jump to a tab using VBA code

I'm using VBA code to enter a SiteID on the Purchase Order Maintenance screen while I'm in the Line Items tab. Unfortunately, it jumps to the shipping information tab when I do this. What is the vba code to refocus the Line Items tab?
pmfith
  • 831
  • 6
  • 24
0
votes
1 answer

VBA: Only user-defined types defined in public object modules can be coerced to or from a variant or passed to a late-bound functions

Compile Error: Compile Error: Only user-defined types defined in public object modules can be coerced to or from a variant or passed to a late-bound functions. I'm new to VBA and I was tasked with debugging some code for a custom screen in…
Jonathan Porter
  • 1,365
  • 7
  • 34
  • 62
0
votes
1 answer

Dynamics Solomon Customization

My company wants me to create a custom screen in solomon to load some data from a table in the database. They said used visual studio .net and i see manuals it says use VBA. What should I use? VBA or visual studio 5? How do I create a new…
mark
  • 1
  • 2
0
votes
1 answer

Need SQL data structure information

I am looking a SQL query which will help me to auto generate Voucher and Adjustment Entry records. I did not able to locate tables for below values. PrePay and Landed Cost Please let me know if any one has idea or any one have data structure…
Asif Huddani
  • 14
  • 5
0
votes
1 answer

Microsoft Dynamics SL window opens minimized. Must hit ALT + Spacebar and then maximize

We currently use microsoft dynamics sl. It is a miserable program but there are two reports that when you click on them they open minimized. you have to hit alt+spacebar and then select maximize to see the screen. If you drag the screen or move it,…
dalearyous
  • 169
  • 1
  • 4
  • 15
0
votes
0 answers

Do synonyms work in Dynamics SL (Solomon)?

A client has a highly customized SL 2011 FP1 installation with numerous table names starting with "x". They would like to move these custom tables to either a different database or different schema (long story). I originally thought we could use…
Elton Pruitt
  • 1
  • 1