Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Employees sales

Posted on by 5

Hello guys

I have a problem with employees sales 

We defined an employee with code different from the same employee in customers 

Which mean the employee in human resources have a code 100001 and the same person have a customer account # 800001

In human resources we defined employees dimension and link it with employee profile 

In account receivable we defined customer dimension and link it with customer profile and also link employee dimension for the same customer

When the employee buy a products from entity we make an invoice for a customer code 800001 which generate an entry Dr. Customer    Cr. Sales ( ledger entry _ Dr. employees sales loans - employee dimension. Cr. Sales

When posting  payroll  (Cr. Employees sales loans - employee dimension) 

In ledger reports the process is good - employee dimension reported that employee dibitor for sales and creditor deduction from salary

but in account receivable in customer statement still debitor for this process and no creditor yet 

My question is 

Is this process and this settings are correct ? 

Or any one can help me what settings which supposed to do for similar processes

Thank you for your help in advance

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Employees sales

    Hi Ramy,

    Once you have checked this let us know if this resolved the issue.

    If so, please verify the answers to let also other community members know what helped.

    Many thanks and best regards,

    Ludwig

  • Ramy Mohamed Profile Picture
    Ramy Mohamed 5 on at
    RE: Employees sales

    Thanks Ludwig

    I will try using customer account only

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Employees sales

    Good Morning Ramy,

    How do you post the loan?

    Do you debit and credit ledger accounts or do you use the customer account?

    What I would expect is the following

    1. Sale of goods

    DR: Customer account (ledger account automatically selected via posting profile)

    CR: Employee sales

    2. Loan to employee (Initial loan posting)

    DR: Customer account (ledger account automatically selected via posting profile)

    CR: Bank

    3. Loan repayment/deduction from employee

    DR: Transfer account (bank, bridging, or something alike)

    CR: Customer account (ledger account automatically selected via posting profile)

    If you don't use the customer account and the customer transaction type your ledger postings will be complete but the customer statement from AR won't.

    Best regards,

    Ludwig

  • Ramy Mohamed Profile Picture
    Ramy Mohamed 5 on at
    RE: Employees sales

    Dear Ludwig,

    Thank you so much for your fast support

    Simply , I would like to inform you that we have an employees buying product from company on credit and we have to collect this amounts monthly when the employees get their salaries

    When we applied AX 2012 the cosultants told us that in this case you must define a customer account for the employee 

    But when we make an invoice for this customer he debited by this amount 

    And when we deduct this amount from his salary it credit in GL only and not credit customer account 

    So in GL the transaction is correct and the employee dimension show that he debited by sales and credired on payroll - but if you make a customer statement from receivables you will find debit sales only without the deduction transaction

    Note : we made a financial dimension for both employees and customers

    in employee profile we link it with employee dimension - and in customer profile we link it with both employee dimension and customer dimension

    If you didn't get it yet i will support you by vouchers but after you know our case can you tell me what is the correct way to make and link sales and deduction for employees sales

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Employees sales

    Hello Ramy,

    I get lost a bit after you explained the product sales.

    What I understand is that you sell some products to the customer and have a customer findim (800001) and a employee findim (100001) recorded with this sale.

    Is this correct?

    Can you possibly share the voucher?

    Where I am lost is when you describe about the employee sales loans.

    Can you provide more details here especially about the voucher created and where the problem is located exactly?

    Many thanks and best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans