Item sales not to be accounted

[Former Member]

Hi Experts,

Business wants to do a setup such that the sales of one material should not be accounted in company's total sales value. The sales order of the material will have non-zero sales value and the customer will be charged for that material . Please advise as how to exclude material from company/district net sales value .

Thanks for your help.

[reazuddin_md · Accepted solution]

1)- Dont maintain the "Material Statistics group" in Material Master- Sales Org-2 view.

Then It will not consider in your reports, accounts will be triggered, as you want to collect from the customer. as per accounting Dr/Cr should be balanced.

2)- Create seperate Material Account assignment group- (eg:Non accountable Mat group) - assign this in Material Master record- Account assignment group field- Sales Org-2 view.

Maintain VKOA-account determination, maintain dummy rev account for this kind of materials. Exclude this G/L account from your sales reports or company accounts.

try n revert

[Former Member · Accepted solution]

Excellent. It works:)

Thanks a lot.

Could you please let me know the significance of material statistics group field?

[Lakshmipathi · Accepted solution]

Significance of material statistics group field is that if you maintain "1" in this field, all your sales will be updated in the respective transactions / reports and will have financial impact. On the other hand, if you dont maintain 1, then as explained above, sales of that material will not be accounted.

thanks

G. Lakshmipathi