web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Employees sales
Microsoft Dynamics AX (Archived)

Employees sales

(0) ShareShare
ReportReport
Posted on by Ramy Mohamed 7

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

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

  • Ramy Mohamed Profile Picture
    Ramy Mohamed 7 on at

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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 7 on at

    Thanks Ludwig

    I will try using customer account only

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans