04-10-2009 9:43 AM
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
04-25-2009 4:06 PM
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
04-14-2009 7:38 AM
04-25-2009 9:08 AM
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
04-25-2009 4:06 PM
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
04-27-2009 9:36 AM
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
04-27-2009 2:59 PM
Hi Shruti,
Can you please elaborate your question little more. And please mention clearly.
Regards,
Vishal
04-28-2009 7:39 AM
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.
04-28-2009 12:07 PM
04-28-2009 5:07 PM
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
04-29-2009 5:27 AM
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
04-29-2009 3:22 PM
Hi Shruti,
You are always welcome. You are free to ask any sort of questions.
Regards,
Vishal
04-30-2009 10:35 AM
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
04-30-2009 2:48 PM
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
05-02-2009 6:21 AM
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
05-04-2009 5:40 AM
05-11-2009 4:24 AM
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
05-11-2009 5:27 AM
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