DynDeveloper.com

Normally, a receivings view has three tables

But if you want distributions, I don't see where you can have the lines because there is no link from the lines to the dists. 

I have a string field (Resident Name) in my database that I need to parse to be First Name and Last Name.

Seems easy - I have it working most of the time.

Sometimes my string field has a & character to indicate a married couple. 

I need to modify my script to work when the resident name is formatted with a &.

Here's a picture of the dataset: 

Here's my script for first name and last name being 'parsed' out of the resident name

LEFT([ResidentName], charindex(' ', [ResidentName]) - 1) as [First Name],
SUBSTRING([ResidentName], CHARINDEX(' ', [ResidentName]) + 1, LEN([ResidentName]) - CHARINDEX(' ', [ResidentName])) as [Last Name], 

How can I modify my LEFT syntax to be something like left of & - rather than simplistic left of the first space if there is a & or simply left of first space if we don't have a & in the field? 

Thanks in advance,

Bron 

Good day team,

Is it possible to generate and print the inventory subledger in Dynamics GP 2018 with accurate theoretical quantities as of August 31? I would appreciate your guidance on this.

Thank you in advance.

Best regards,

I have a customer who wants me to use econnect to do what they call a bin allocation. I can probably do this in SQL, but they want me to use econnect.

Basically, we have transferred a SOP to the WMS. Once someone picks a SO line in the WMS, we need to get that picked qty back to GP. I believe it updates a picked qty in the SOP10200 table. The question is, is there a method to do this in econnect?