J1is

[Former Member]

I have following Questions

1. When Return delivery is done after that J1IS is performed

2. Where is the Excise Invoice which is generated after doing j1is is stored

3. Whether J1iv display this Excise invoice whether reversal of excise duty and i.e basic excise,additional excise and s&h ecess will a debit entry will be passed automatically actually the procedure not very clear

can anyone help for because i need to generate excise invoice for rejected material and my input fields include Return delivery number that is provided by Stores department

Please help

thanks in advance

[Former Member]

No further reply from any one

[Former Member]

this question is closed because their was no reply from anyone issue i unresolved but since i can't ask any further question without closing earlier one so closing but unsatisfied

[Former Member]

Hi Shruti,

1. J1IS is the correct transaction for Return Delivery.

2. The Exc. Inv. number will get stored in two tables: J_1IEXCHDR (Header Table) and J_1IEXDTL (Item table). In table J_1IEXCHDR, the Transaction type will be OTHR for such documents.

3. You can display the Excise Invoice in J1IS Transaction or in J1IH Transaction.

4. J1IV is used to Post the Accounting Document related with that Excise Invoice. But J1IV is used only when accounting documents are not automatically posted. Generally, these documents get Posted Automatically as soon as you do the Transaction.

In J1IS Transaction, Take following selection:

REF. Doc. Type = MATD

Doc. num. = Num. given by Stores Deptt.

Doc. Yr = Excise Yr. of Posting

Series Gp = ur wish

Excise Gp = ur wish

Vendor = Give Vendor Code

If still have any doubts then revert back.

Regards,

vishal

[Former Member]

Thank u very much Vishal, atleast u responded to my question

Actually problem is that i have reverse excise thr my program how will i know whether has been debited or not

and even if i use bdc for both transaction whether it will because this is very crucial even if single entry is passed in incorrect way the accounting will get affected so any other another transaction which can used for reversal

[Former Member]

Hi Shruti,

Can you please elaborate your question little more. And please mention clearly.

Regards,

Vishal

[Former Member]

Hi Vishal,

My Question is that I have the return delivery Document i get the excise duty for reversal

1>but thr J1is the problem is that every entry has to be passed manually and for programming purpose i have to pass thr internal table

2> thr j1iv u said that it will post debit entry(i.e. reversed excise duty) whether it goes correct a/c or not how will i determine

3> what is use of j1ih

but when i confimed this with my senior this not correct way he said that both reversal of excise duty and excise invoice generation of returnable material their should be 1 transaction only.

[Former Member]

wat happened u have not responded

[Former Member]

Hi,

1. I think you have written your own program for J1IS for multiple entries. If I got the correct conclusion of then instead of writing your program, you can also go with Recording Process through LSMW. That process will be easier and correct. In J1IS transaction, you can not see the G/L Accounts (or Registers) in which accounting entries will get posted. So first you have to check in Development Server by testing it. In J1IH transaction, you are having an option to see the G/L Accounts in which entries will be posted.

2. J1IV is only meant for release of Accounting Document in Accounts or Excise Department. Now whether it is a Debit Entry or Credit Entry, it does not matter.

3. If you want to cancel the Excise Invoice (which was originally created by J1IS), then you have to cancel it through J1IH Transaction. If you cancel it through J1IS itself, then its Accounting Entry will not be genarated and also you will not be able to post the Cancellation Accounting Document Entry through J1IV transaction also. Cancellation through J1IS will only change the Status of Excise Invoice No. So for cancellation, you must have to cancel the Excise Invoice through J1IH Transaction only. In J1IH transaction, you are having an option to see the G/L Accounts in which entries will be posted by clicking on DETERMINE G/L ACCOUNTS button on top.

4. Other uses of J1IH: Actually J1IH transaction is made for passing the Excise JV entries for Registers. Also those entries can be done through J1IH which are not having any reference. Remember J1IH is always used for passing the JV entries in Excise.

Regards,

Vishal

[Former Member]

Thank u very much Vishal

I think so that my problem get solved if their is problem can i ask u questions

Thank u very much for ur kind help

[Former Member]

Hi Shruti,

You are always welcome. You are free to ask any sort of questions.

Regards,

Vishal

[Former Member]

Hi Vishal,

This another issue which i have posted long back but since i did not receive any answer so i am posting here

Overview: I am Creating Program for Die materials this basically for PP module

4 machine are their through diff. materials pass and they get died before reaching final stage

so i want to find which material for been died for particular date or for particular period

i have selection as the date, die no.( i.eEQUZ-EQUNR ), Plant

Complete Flow. 1> I get material details thr z1 which stores materials for all plant along with machine no.

and i will also get the qty

2> I will get the Die No. (Equnr) from Equz for particular date

3> I have created zdie which stores the machine no. material range of lines, number of boxes, this table is created bcoz for machines the boxes and lines are fixed

total no. of lines and boxes

for e.g.

machine no. line from. line upto box from box upto total lines total boxes

123 L1 L8 B1 B10 8 10

4> This zdie table has been maintained becoz the died quantity will be

died qty = z1 /total no. of lines

5> but i also want fetch those objid(CRFH-OBJID) which have passed thr L1 and L8

but unable to get this

Main Issue: How will i get objid from L1 to L8

Following things i have Tried

Internal table IT_TRSFR_123 stores range L1 to L8

loop at IT_TRSFR_123

SELECT * FROM CRFH WHERE ( FGRU1 BETWEEN IT_TRSFR_123-FRGU1 AND IT_TRSFR_123-FRGUL ).

endloop.

but it gives all records

so how exactly the query should be defined

Thanks,

Shruti

[Former Member]

Hi,

Can you please also tell what is the Basic Condition of Dying of Material? Means on what basis, how can I declare that X material is now DEAD?

Regards,

Vishal

[Former Member]

Hi,

Basic concept of dieing

Actually a copper wire is o/p from another machine which has to be died (Means it is encapsulated with PVC

PVC means a material which is used coating the copper wire)

The Basic Condition is as follows

1>Their are 4 machines which is specially for dieing purpose

2> i am fetching only those material against to the defined machines through ztable because material has been defined against machines

3> since materials are passing thr these machine means they are for dieing purpose

This is how we will come to know that it is died.

Shruti

[Former Member]

Hi Vishal,

Still u not Replied Vishal

Shruti

[Former Member]

Hi Shruti,

Sorry for late reply.

Internal table IT_TRSFR_123 stores range L1 to L8

loop at IT_TRSFR_123

SELECT * FROM CRFH WHERE ( FGRU1 BETWEEN IT_TRSFR_123-FRGU1 AND IT_TRSFR_123-FRGUL ).

endloop.

FGRU1 field I have checked. But can you tell me what data is getting stored in FGRU1.

Regards,

Vishal

[Former Member]

Hi Vishal,

The Internal table has the following values

FRGU1 has the value L1 FRGUL has value L8

but the crfh table has only single values

for e.g

objid line

100000001 L1

i am facing lot of difficulties in this so i request to reply soon

as it is pending from long.

Shruti