on 09-29-2010 5:08 PM
I have a requirement from a client that a condition be created in the sales order to deduct money from customer's sales and post the deductions into a special GL account. After a certain limit is reached, a sales order will be created based on the deductions and the system should issue a warning not to exceed the amount deducted. Any help will be appreciated. Thanks.
hi
I have a requirement from a client that a condition be created in the sales order to deduct money from customer's sales and post the deductions into a special GL account.
This can be possible by amintaining Some Different Condition type such as K007 Customer Discount but Acc. Seq. should have Sales Organization, Department, Sold-to party.
Might be this will not be applicable to all you customers, so better have requirment type also.
Then to post to special GL account, use the Account determination but Z development.
After a certain limit is reached, a sales order will be created based on the deductions and the system should issue a warning not to exceed the amount deducted. Any help will be appreciated.
Not to achive this, you might need to compair total values for the Z* condition for the perticuler customer, and then you might need to use to USER EXIT at the time of Save order USEREXIT_SAVE_DOCUMENT, USEREXIT_SAVE_DOCUMENT_PREPARE
but to compair total values you have to pass sold to party to VBAK table take Doc. Condition (KNUMV) number for all orders for this customer, and pass this to KONV table and check values for your Z condition.
Also to maintain the limit for your customer, you need to Creat Z table with S.Org., Customer, amount limit,
If required, maintain, one more Field as ACTIVE and use this field in your user exit,
If ACTIVE is Flagged for the customer in Z* table then only go to check the total amount for customer else not
Further, if you need any clarification, let us know
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Seem like you needed to deduct an amount and at the same time accrue it for later settlement. Perhaps, you may try setting up a discount condition for the charge and the rebate process for the accrual. The effective entry results in an A/R reduction and a posting to accrual in lieu of the SPGL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.