Depot Process - A different requirement

[Lakshmipathi]

Dear All

The process is STO Depot scenario.

In standard depot process, while selling from depot, the STO ED values will be populated to sale invoice. But the client requirement is that ED should be calculated on the sale price and simultaneously, the STO values should also be populated.

To explain in a better way, let us assume,

STO ED is               10.00
STO Cess is             0.20
STO HCess is           0.10

Total ED Payable is     10.30


Sale ED is                   15.00
Sale Cess is                 0.30
Sale HCess is               0.15

Total ED debited on customer 15.45

Here the difference is 5.15 and with my current configuration 5.15 is posted in FI with one line item, whereas, the client requirement is the break up of 5.00, 0.10 & 0.05 should be posted with three line items but with same G/L Account.

I know if we have different G/L Account, this can be achieved but client is not prepared to have different G/L Account. I just wonder whether this can be addressed through SD configuration. Any thoughts that helps to address this requirement is appreciated.

Going for some Enhancement is the last option.

G. Lakshmipathi

[Former Member · Accepted solution]

Hi,

I think in Depot scenario what ever value in STO should be passed on or captured during the delivery to the customer ie through J1IJ , and the value must not exceed in depot. Hope i am rite on this part.

their should not be any difference at all.

Sudhir

[Lakshmipathi · Accepted solution]

what ever value in STO should be passed on or captured 
   during the delivery to the customer ie through J1IJ

You are absolutely right. But the client is selling at a higher rate (ofcourse they got permission from Central Excise) at which, duty is calculating.

Now in order to know the differential duty, they have created one G/L Account but in FI posting it should show with three line items as I said above.

Thanks for posting your suggestion.

G. Lakshmipathi

[Former Member · Accepted solution]

ok In that case, you create some equilant condition types and from that you post the values to the different line items in billing document with different account key.

Regards,

Sudhir

[jignesh_mehta3 · Accepted solution]

If your requirement is :

the break up of 5.00, 0.10 & 0.05 should be posted with three line items but with same G/L Account.

Then can you have different Tax Codes for 5.00, 0.10 & 0.05 & all these Tax Codes will post in Same GL Account?

This will make sure that in Accounting Doucment there are three seperate Line Items posting to same GL Account.

Hope this helps,

Thanks,

Jignesh Mehta

[Lakshmipathi · Accepted solution]

Thanks for both Ravi and Jignesh

Ravi - I have created three condition types to capture the difference and assigned three different account keys to these condition types.

Jignesh - My original configuration was like that only. That is I created the Account Key and ticked the box Tax code in OB40 but unfortunately, since the condition records are huge, users are unwilling to maintain tax code to each and every condition type apart from maintaining UTXJ. Without this setting (after removing the tick in OB40), is there any alternative to assign a different tax code in condition record

That is why, I am trying to find out a different option.

G. Lakshmipathi

[former_member184555 · Accepted solution]

Hi Lakshmipathi,

In one of the tax projects, we were supposed to calculate prorated tax values when there are two tax rates in one billing period. We have created a prorata tax condition type and assigning a routine in the alternate calculation type with the logic for handling this proration we could get the desired result.

SImilarly assigning a routine in the alternate calculation type with required logic might be helpful for your scenario also.

Thanks,

Ravi

[Lakshmipathi · Accepted solution]

SImilarly assigning a routine in the alternate calculation 
    type with required logic might be helpful

Thanks again for the suggestion Ravi. The issue here is not arriving at the value but splitting into three line items in FI posting. Value is arriving correctly. Hope you got the point

G. Lakshmipathi

[Lakshmipathi]

Convinced the client that it is not possible unless they provide a different G/Ls.

Thanks again to all who shared your ideas

G. Lakshmipathi

[former_member184555]

Hi Lakshmipathi,

Here the difference is 5.15 and with my current configuration 5.15 is posted in FI with one line item

Could you please let us know the config maintained for capturing the value of difference 5.15.

Regards,

Ravi

[od_manikandan]

Hai Lakshmipathy,

Very nice to see a question posted by you.

In you post i have some doubts, Just thought to explain the stock transfer process used in ours.

We manufacture in plant and send to depots too for selling.

In this scenario,

We do stock transfer from plant to depot.

Pricing condition

ZDPR and the basic rate will be calculated depot Basci price including ED (X) = (Basic price at depot/1.1442)

and in the ED and CESS HCESS will get calculated.

Now when we sell from depots the price will X Basic Price including ED.

When i discuss your scenario, with our FI consultant

If you show ED again in Depot sales it will become Double taxation paying to ED department.

And since the ED will be paid only at the time of Goods removal from manufacturing plant.

STO ED is 10.00

STO Cess is 0.20

STO HCess is 0.10

Total ED Payable is 10.30

The pricing is enough.

In depot you can have Basic price including ED.

We have 3 pricing procedure for this

Plant to customer - ZPLANT

Basic

ED

VAT

Plant to Depot - ZSTKTR

Basic (will be calculated by Depot basic/1.1442 and feed in the condition record)

ED

Depot to Customer - ZDEPOT

Basic

Vat

Since ED already paid.

May be i have not give the exact solution, but if you discuss reg this with client, you will do easier.

Regards,

Mani

[Lakshmipathi]

If you show ED again in Depot sales

No it is only for internal purpose, users can see in SAP but in output, only one ED will flow. In fact, this process is running for quite a long time but the only change is in FI Posting.

G. Lakshmipathi

Edited by: Lakshmipathi on Aug 12, 2011 1:48 PM

[Former Member]

hi,

if i am not wrong for utilization level if you are able to maintain the trasaction vs account,

UTLZ Credit PLA AED account

UTLZ Credit PLA AT1 Account

UTLZ Credit PLA BED account

UTLZ Credit PLA cess account

UTLZ Credit PLA ECS Account

UTLZ Credit PLA NCCD Account

UTLZ Credit PLA SED account

UTLZ Credit RG 23 AED account

UTLZ Credit RG 23 AT1 Account

UTLZ Credit RG 23 BED account

UTLZ Credit RG 23 ECS Account

UTLZ Credit RG 23 NCCD Account

UTLZ Credit RG 23 SED account

UTLZ Debit CENVAT clearing account

instead of Clearing account maintain BED, ECs, and Shecess, then i thing during utilization the posting will happen to the specific gl accounts.

regards,

Sudhir

[Lakshmipathi]

Thanks for the suggestion. But if you see my above explanation, ED values are posting correctly in FI with three line items but the requirement is the difference should also be posted with three line items like

a) difference in ED in one line item

b) difference in Cess in one line item and

c) difference in ECess in one line item

Currently, it is cumulating the difference and posting with one line item.

G. Lakshmipathi

[Former Member]

Hi,

As like sales pricing procedure account key's there are account keys assigned in TAX pricing procedure

In that account key detail option for posting indicator is available

Go to OBCN and check whether this can helpful

Kapil

[Lakshmipathi]

Thanks for the information. In OBCN, Posting indicator 2 is maintained (Separate line item)

G. Lakshmipathi

[Lakshmipathi]

I forget to mention that in my pricing procedure, I have different Account Keys assigned to the differential ED, Cess & HCess condition types.

G. Lakshmipathi

[former_member188076]

wrongly posted

Edited by: Amitesh Anand on Aug 12, 2011 1:00 PM