Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / why field slsperid in ...
Microsoft Dynamics SL (Archived)

why field slsperid in table ardoc is empty, each time we create Sales Order

(0) ShareShare
ReportReport
Posted on by Butu60 160

Hi there,

I have two system which using dynamic SL. version we use is 6.0. those use different database, they are completely independent from each other.

I applied report which I've built for system A to system B, but not run well in system B. I looked where is the problem and found like this:

- in system A, field slsperid on table ardoc (for doctype = IN), filled up same info with field slsperid on table soshipheader.

- in system B, field slsperid on table ardoc (for doctype = IN), not filled up (blank/empty).

transaction for create invoice use Sales Order screen.

 

why this is happen? how to solve/fix it? I wanna fix in system B.

if necessary, I have access to customization menu.

thanks before.

*This post is locked for comments

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    hello,

    I plan to update table over sql query, for slsperid.

    ardoc and artran will be updated based info from soshipheader.

    will it affect to other process? especially to AR Process? thanks before.

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    hi,

    sorry to ask again. what about customization you'd said? can you please give me the detail?

    I think it is similar for the code. thanks before

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    Hello,

    Version 6.0 hasn't been supported for several years.  Version 6.5 isn't supported either.  I can not provide further assistance with this issue.  Perhaps another customer or partner will respond with some ideas for a customization.

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    hello,

    we use SL 6.x (I think 6.0).

    can we use "Sales by Commission - All" report in SL 6.x (let say 6.0)?

    or otherwise, I make custom report, but firstly I need to know the way to develop customization module/screen in OM, so every time we create Sales order in OM, will update ardoc.slsperid and/or artran.slsperid

    thanks before

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    Hello,

    I don't know which version of SL you are using, however, in SL 2011, there is a new report in AR called Sales by Commission - All.  This report contains the sales person commission from both AR and OM documents that contain a Slsperid.

    If you are using version 7, you would need to build a report or expand on the AR report to include the OM table (SOShipSplit).  Maybe another customer or partner will respond if they have developed or customized a report to give you the information you are looking for.

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    hello,

    so by default isn't update neither artran or ardoc,, is it?

    I need to customization report, which can represent sales info without connected to OM (directly). I wanna make as possible as not use many table.

    hope you can understand.

    anyway, can you please tell/guide me how to develop customization in my case? thanks before

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    Hello,

    No it does not update ARtran.  The OM code does not update the AR tables with a Slsperid.   Is there a reason why you need to have the AR tables updated with a Slsperid?  The only way you could update them is to develop a customization, such as a trigger.

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    Hi Carolyn,

    thanks for reply and info.

    is it will update artran?

    anyway, we implement policy, that we only can make sales order for one sales person, can't combine.

    if that so, is there a way to update ardoc.slsperid while we create sales order in order management? thanks before

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    Hello,

    The Slsperid field in ARdoc will not be updated by invoices generated in Order Management.  This is by design as a sales order can have more than one Slsperid on a line item.  ARdoc can only handle one Slsperid per invoice.

  • Butu60 Profile Picture
    Butu60 160 on at
    Re: why field slsperid in table ardoc is empty, each time we create Sales Order

    hi,

    do you refer to some kind utility "sql trace" ? or you mean tu run sql analyzer and compare one to one table?

    anyway, do you mean, it is by default that when we create so, and put sales info, it will record to all these tables, soshipheader, soshipline,ardoc and artran?

    if yes, then when this not happened, how to solve/fix it? thanks before

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.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,923 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,788 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans