Every sales order line for the beer industry must produce following three lines :
1) Beer Bottle or Beer case charges. This is business as usual. This is taxable based on state/province.
This goes to revenue account and tax goes to tax account.
2) Beer bottle deposit amount that is charged say 5 cents per bottle. Should go to a different revenue account. No tax on this.
3) Environment charge of say 2% on total sale. There is tax on this. Environment surcharge must go to a different account and the tax goes to tax account.
Any suggestions such as, is there something in SAP B1 that allows us to :
A) have multi lines created for every item of sale?
B) the ability to handle bottle charges to different account
C) excise tax that gets created based on sale item and has tax on top?