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
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
Thanks Ludwig
I will try using customer account only
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156