web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    In system B is SOShipheader.SlsperId populated?  If it's not populated in OM then when the invoice is created it will not update ARDOC.  The default for setting the salesperson Id is controlled by OM Setup - default salesperson id field.

  • Butu60 Profile Picture
    Butu60 160 on at

    hi, sorry for my lately reply. I just back from location where no access to internet.

    anyway, yes, in system B soshipheader.slsperid populated, also I already make it as required field (blankerr set true).

    then, why in ardoc not update? also I looked in artran, artran.slsperid also blank.

    how to fix it? thanks before.

  • Community Member Profile Picture
    Community Member on at

    Try running a SQL trace on each of the db's and compare the results.  

  • Butu60 Profile Picture
    Butu60 160 on at

    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

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    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

    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

    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

    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

    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

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans