Excise Invoice Details

J1IEX – Incoming Excise Invoice

a)                  Excise Invoice is an integral part of the procurement process

b)                  contains information relating to goods movements and taxes

c)                  business documents that supplier of goods (vendor or supplying plant) sends along with deliveries of excisable goods

d)                  It lists the goods and states, quantity and how much excise duty applies on them.

e)                  used to claim back the excise duty that a buyer has paid from the excise authorities

f)                    proof of the excise duty that he has paid, so that he can then offset the duty against the excise duty that he levy on outputs

g)                  Enter incoming excise invoices in the R/3 System for goods receipts arising from the following type pf procurements:

1. External procurement
2. Subcontracting
3. Stock transfer

J1IIN – Outgoing Excise Invoice( Reference )

a)                  prepare when you issue excisable goods from a manuf.plant

b)                  lists the goods that you have issued and states how much excise duty applies.

c)                  Your customer uses the excise invoice to claim back the excise that it has paid from the excise authorities.

d)                  there are three different procedures for creating excise invoices

1.  Sales direct from the factory

This procedure is for when you sell manufactured goods straight from the factory at which they were produced, in which case you levy excise duty when the goods leave the factory on their way to the customer.

If, when you send the goods to the customer, you enclose the commercial invoice, you create the excise invoice with reference to the commercial invoice. If you want to send the commercial invoice after you have dispatched the goods, however, you create the excise invoice with reference to a pro forma commercial invoice. For more information about these procedures, see Sales from Factories.

1. Sales from depots

A depot is a site at which the goods are stored, away from the factory at which they were produced.

you have to levy the excise duty when you transfer the goods from the factory to the depot, and then make sure this is passed on to the customer when it makes a purchase.

1. Sales (other goods movements)

Outgoing excise invoices have two numbers

1)                 internal document number

2)                 excise invoice number

Internal document number, which is assigned immediately you create an excise invoice

Excise invoice number, which is not assigned until you have verified and posted

1)                 you have to number your outgoing excise invoices in sequential order

2)                 starting each year on 1 April.

3)                 You must notify the excise authority of the jurisdiction of the invoicing location.

4)                 The serial number must be printed on each page of the excise invoice.

5)                 Each number range is governed by a series group

6)                 Some states allow you to include only a limited number of items for each page of an excise invoice

List of CIN Transactions

List of CIN Transactions

1. J1IEX – Incoming Excise Invoice
2. J1IIN – Outgoing Excise Invoice
3. J2IF – Excise Document Flow
4. J1IDUELIST – Due List of Billing Documents for Excise Invoice Creation
5. J1IP – Printout of Outgoing Excise Invoice
6. J1I7 – List of Excise Invoices
7. J1IH – Excise JV
8. J2I8 – Transfer Balance Credit of Capital Goods
9. J2I9 – New Monthly Returns Report Rule 57AE
10. J1I2 – Sales Tax Register
11. J1I5 – Register creation for RG23 and RG1
12. J2I5 – Extract
13. J2I6 – Print Utility
14. J2IUN – Monthly Utilization
15. J1INLIC01 – Capture License Details
16. J1IA301 – ARE-3 Processing
17. J1ILICSUM – Deemed Export License Summary
18. J1IARE_AGE – Ageing Analysis for ARE Documents
19. J1IBN01 – Create Excise Bond
20. J1IA101 – ARE-1 Processing
21. J1IBONSUM – Bond Summary Report
22. J1IANX18 – Pro Forma of Running Bond Account

List of Transaction Codes for Domestic Procurement : -

1. ME21N – Create Purchase Order
2. MIGO – Goods Receipt against PO (Here capture Vendor Excise Invoice)
3. J1IEX – Post Vendor Excise Invoice
4. MIRO – Enter Vendor Invoice

List of Transaction Codes for Import Procurement: -

1. ME21N – Create Purchase Order
2. MIRO – Enter Customs Invoice
3. J1IEX – Capture Bill of Entry
4. MIGO – Goods Receipt against PO
5. J1IEX – Post Bill of Entry
6. MIRO – Enter Vendor Invoice
7. MIRO – Enter Clearing Agent’s Invoice

What isRG1 and RG23

What isRG1 and RG23

RG1 is for finished product (saleable). It is updated by GR of production order. RG1 balance means remaining FG goods in your stock.

There are two types of RG23. One is RG23A for raw materials. and RG23C which is for asset purchase. Here you have part-1 and Part-2. Part-1 means Just quanity Part-2 means Value.

For example when you buy a raw material from vendor for INR 100 and taxes will be 17.25 (BEDECessSEcess) + Vat 13

Total you will pay 130.25 to vendor. In this 100 will go to inventory, 17.25 will go to cenvat and 13 will go to VAT.

Then When you sell a finished goods for INR 200 You will get from customer 200 + 34.5 (BEDEcessSEces) + VAT 26

Now during utilization You will pay goverment 34.5 – 17.25 that is nothing but PLA (personal ledger account)

When you buy a material During GR part-1 is updated then in J1iex or posting excise invoice Part-2 is updated.

Transaction J1I5, is used to updated tables from which register reports are extracted. In SAP transaction tables are different. Register reporting tables are different to update register for reporting in CIN we run J1I5

26 Items to Include in Your Organization’s ERP Implementation

26 Items to Include in Your Organization’s ERP Implementation

1. Process Definition and Workflow
2. Training Needs Assessment
3. PMO (Project Management Office)
4. Communications Plan
5. Customize and/or Tailor Training Materials
6. Customization Requirements
7. Fit-Gap Analysis
8. Security Profiles
9. System Validation
10. Sarbanes-Oxley Compliance and/or Internal Controls
11. Go-Live Checklist
12. Go or No-Go Assessment
13. Conference Room Pilots
14. Testing – Software and Integration
15. Core Team Training
16. End-User Training
17. Forms Definition and Reports
18. Data Migration Planning and Execution
19. Benefits Realization Plan
20. Technical Solution Architecture
21. Post Go-Live Audit
22. Help Desk And Support
23. Global and/or Localization
24. Requirements and Validation
25. Solid Budget
26. Business Case

SAP TIPS ON TRANSACTION CODES

SAP TIPS ON TRANSACTION CODES:

A list of transaction codes may be found in table TSTC. The list with a description of the transaction codes is in table TSTCT (note the ‘T’ added at the end of table TSTC indicates the text description for the data in table TSTC is in TSTCT. SAP follows this standard most of the time). The data in the tables may be viewed in TRAN: SE16.

Remember, when searching that the description field in table TSTCT is case sensitive.

Read More

FI-MM Integration

Process Flow in MM
Step 1 Generating purchase requisition( PP-MM involved)
Step 2 Making inquiries (MM)
Step 3 Raising purchase order (MM)
Step 4 Release of purchase order ( MM)

Step 5 Goods received from vendor ( MM and FI )
Entry will be
Raw Material Inventory a/c Dr.
GR/IR clearing a/c Cr.

Step 6 Invoice verification and quality assurance (FI and MM)
Entry will be
GR/IR clearing a/c Dr
Vendor a/c Cr

Step 7 Goods issued for consumption(MM, FI and PP)
Entry will be
Raw material consumption a/c Dr
Raw material inventory account Cr

Step 8 Production receipt( FI, MM & PP)
Entry will be
Finished goods inventory a/c Dr
Change in stock Cr

Step 9 Finished goods delivered to customer(MM, SD & FI)
Entry will be
Change in stock Dr
Finished goods inventory a/c Cr

Step 10 Raising invoice on customers( SD & FI)
Customers a/c Dr
Sales a/c Cr

Step 11 Receipt of payment from customers( Same as SD-FI integration)
CUSTOMIZATION STEPS

Main screen of FI-MM integration is OBYC
Here we have to link the MM movement types to FI G/L accounts

Assign Following G/L accounts to movement type according to valuation class.
BSX- Raw material Inventory account
GBB- Raw material consumption account
WRX- GR/IR clearing account

Download session log

The following steps show how to download session log to your PC.
Go to SM35 (Batch Input: Session Overview)
Select your session

Click Log Button 
Double click on your session then type =pri in command field

Download file to your PC

The following steps show how to download session log to your PC.

Go to SM35 (Batch Input: Session Overview)

Select your session

Click Log Button

Double click on your session then type =pri in command field

Download file to your PC

 

The Movement Type Concept

What Is a Movement Type?

When you enter a goods movement in the system, you must enter a movement type
to differentiate between the various goods movements. A movement type is a threedigit
identification key for a goods movement. The following table contains examples
of movement types.
Description of Movement Types

Read More

User Exits in SAP

To find User Exits in SAP please follow the steps given below.

1) Run Transaction SE81
2) Select SD
3) From the Menu Click on Edit
4) Select the option ‘Select Subtreee +/-‘
5) From the Menu bar click on Information system
6) From the R/3 Repository information System open the Envir option
7) Select Exit Techniques
8) Select Customer Exits
9) Double click on Enhancements
10) Press F8

See the screen shots given below.
Run Transaction SE81.

Select SD and then from the Edit menu click on Select Subtree

Click on Information System or press Shift+F4

Menu for ‘R/3 Repository Information Sys’ opens up

Follow the menu path Envir—–> Exit Techniques—-> Customer Exits—-> Enhancements

Click on the Execute button or press ‘F8′

The following list is displayed.

Follow the above mentioned steps to find user exits for other modules

MM Process Flow

The typical procurement cycle for a service or material consists of the following phases:
1. Determination of Requirements
Materials requirements are identified either in the user departments or via materials planning and control. (This can cover both MRP proper and the demand-based approach to inventory control. The regular checking of stock levels of materials defined by master records, use of the order-point method, and forecasting on the basis of past usage are important aspects of the latter.) You can enter purchase requisitions yourself, or they can be generated automatically by the materials planning and control system.
2. Source Determination
The Purchasing component helps you identify potential sources of supply based on past orders and existing longer-term purchase agreements. This speeds the process of creating requests for quotation (RFQs), which can be sent to vendors electronically via SAP EDI, if desired.
3. Vendor Selection and Comparison of Quotations
The system is capable of simulating pricing scenarios, allowing you to compare a number of different quotations. Rejection letters can be sent automatically.
4. Purchase Order Processing
The Purchasing system adopts information from the requisition and the quotation to help you create a purchase order. As with purchase requisitions, you can generate Pos yourself or have the system generate them automatically. Vendor scheduling agreements and contracts (in the SAP System, types of longer-term purchase agreement) are also supported.
5. Purchase Order Follow-Up
The system checks the reminder periods you have specified and – if necessary – automatically prints reminders or expediters at the predefined intervals. It also provides you with an up-to-date status of all purchase requisitions, quotations, and purchase orders.
6. Goods Receiving and Inventory Management
Goods Receiving personnel can confirm the receipt of goods simply by entering the Po number. By specifying permissible tolerances, buyers can limit over- and under deliveries of ordered goods.
7. Invoice Verification
The system supports the checking and matching of invoices. The accounts payable clerk is notified of quantity and price variances because the system has access to PO and goods receipt data. This speeds the process of auditing and clearing invoices for payment.