topic Re: J1is in Application Development and Automation Discussions

J1is

Former Member — Fri, 10 Apr 2009 08:43:23 GMT

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

Re: J1is

Former Member — Tue, 14 Apr 2009 06:38:14 GMT

No further reply from any one

Re: J1is

Former Member — Sat, 25 Apr 2009 08:08:47 GMT

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

Re: J1is

Former Member — Sat, 25 Apr 2009 15:06:37 GMT

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

Re: J1is

Former Member — Mon, 27 Apr 2009 08:36:37 GMT

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

Re: J1is

Former Member — Mon, 27 Apr 2009 13:59:47 GMT

Hi Shruti,

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

Regards,

Vishal

Re: J1is

Former Member — Tue, 28 Apr 2009 06:39:12 GMT

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.

Re: J1is

Former Member — Tue, 28 Apr 2009 11:07:18 GMT

wat happened u have not responded

Re: J1is

Former Member — Tue, 28 Apr 2009 16:07:08 GMT

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

Re: J1is

Former Member — Wed, 29 Apr 2009 04:27:27 GMT

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

Re: J1is

Former Member — Wed, 29 Apr 2009 14:22:56 GMT

Hi Shruti,

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

Regards,

Vishal

Re: J1is

Former Member — Thu, 30 Apr 2009 09:35:47 GMT

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

Re: J1is

Former Member — Thu, 30 Apr 2009 13:48:40 GMT

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

Re: J1is

Former Member — Sat, 02 May 2009 05:21:23 GMT

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

Re: J1is

Former Member — Mon, 04 May 2009 04:40:42 GMT

Hi Vishal,

Still u not Replied Vishal

Shruti

Re: J1is

Former Member — Mon, 11 May 2009 03:24:56 GMT

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

Re: J1is

Former Member — Mon, 11 May 2009 04:27:40 GMT

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