Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1168 Zobrazení

I’m encountering a critical issue with the Payroll module in Odoo 17 related to accounting entries when using Gross and Net salary rules. The problem causes duplicate amounts in the journal items, leading to incorrect totals. Here’s a detailed breakdown:

Scenario & Configuration

  1. Salary Structure:
    • Basic Wage: 10,000 (Account: Salary Expense)
    • Allowance: 1,000 (Account: Allowance Expense)
    • Tax Withholding: -180 (Account: Tax Liability)
    • Gross: 11,000 (Category: Gross, Code GROSS, aggregated from Basic + Allowance)
    • Net: 10,820 (Category: Net, Code NET, calculated as GROSS - Tax Withholding)
  2. Expected Result:
    • Journal entries should reflect:
      • Debit Salary Expense (10,000) + Allowance Expense (1,000) = 11,000
      • Credit Tax Liability (180) and Net Payable (10,820).
  3. Actual Result:
    • Journal entries include duplicate amounts for Gross and Net:
      复制
      DEBIT:  
        - Basic Wage: 10,000  
        - Allowance: 1,000  
        - Gross: 11,000  ❌ Duplicate  
        - Net: 10,820    ❌ Duplicate  
      CREDIT:  
        - Tax Liability: 180  
        - Net Payable: 10,820  
    • Total debits = 10k + 1k + 11k + 10.82k = 32,820 (3x inflated).

Suspected Causes

  1. Salary Rule Configuration:
    • Gross/Net might be set as "Appears on Payslip" with their own accounts, causing them to post separately even though they are aggregates.
    • Rules for Gross/Net may have "Account Debit/Credit" assigned, overriding the default behavior.
  2. Category Types:
    • Gross/Net categories (e.g., Total, Deduction) might incorrectly trigger accounting entries.
  3. Accounting Logic:
    • Odoo’s default payroll accounting logic may not handle aggregated categories (Gross/Net) correctly, treating them as separate inputs instead of derived values.

Steps Tried

  • Removed explicit accounts for Gross/Net rules → No change.
  • Set Gross/Net rules to "Not Applicable" for accounting → Journal items omit them but lose tax/Net tracking.
  • Reviewed documentation/forum posts but found no clear guidance for Odoo 17.

Questions

  1. Should Gross and Net ever have their own accounting entries, or are they purely computational?
  2. How to configure salary rules to ensure only actual components (Basic, Allowance, Tax) post to accounts, while Gross/Net act as totals?
  3. Is there a hidden setting or a workaround to prevent aggregated categories from generating duplicate entries?

Any insights or examples of a working salary structure in Odoo 17 would be greatly appreciated!

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
kvě 25
765
1
bře 25
989
1
pro 24
1695
0
lis 24
108
1
čvc 24
5175