How to Accumulate the Amount of Condition Types in an Accounting Document Without Affecting Pricing Display

Introduction

In SAP, businesses often need to accumulate the amounts of multiple condition types in an accounting document while ensuring that the pricing display in the billing document remains intact. This helps in maintaining a clear and detailed pricing structure while simplifying financial postings. 

This article explores an efficient method to achieve this without disrupting the pricing view, ensuring that all condition types appear separately in the pricing screen but are grouped in the financial postings. 

Example Scenario

Consider the following condition types in a billing document: 
 

Condition Type	Amount
ZPXX	3,500
ZDXX	-1,000
ZWXX	-500

All condition types are displayed separately in the pricing view. However, the financial journal entry should reflect a single consolidated posting as follows: 

Journal Entry:
- Dr Vendor: 2,000 
- Cr Sales: 2,000 (ZPXX - ZDXX - ZWXX) 

Steps to Accumulate Condition Types in Accounting Document

2. Remove Account Assignment Key
Since statistical condition types should not post individually to the accounting document, remove the account assignment key for the relevant condition types. This prevents them from generating separate financial postings. 

3. Create a Subtotal in the Pricing Procedure
In the pricing procedure, define a subtotal that sums up the selected condition types. This subtotal will act as the final amount that needs to be posted in the accounting document. 

4. Assign Account Assignment Key to the Subtotal
Once the subtotal is calculated, assign the account assignment key to it. This ensures that only the accumulated total is posted in FI, while the individual condition types remain visible in the pricing screen. 

5. Verify Pricing and FI Posting
- Check the pricing screen to confirm that all condition types are displayed separately. 
- Verify the FI document to ensure that only the accumulated value is posted as a single entry. 

Conclusion

By following this method, businesses can maintain detailed pricing information while simplifying financial postings. This approach ensures clarity in pricing views while preventing unnecessary complexity in financial accounting documents. 

Related SD Queries:

• Difference between Condition Type
• SD Questions About Pricing Condition

SAP Sales and Distribution Tips
SAP SD - Sales/Distribution Tips

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com