Increase Excise Duty Payable GLs amount in SAP

Problem: MRP was revised of certain finished products after removal from excise warehouse. stocks were out of the system and bringing them back to excise warehouse was not possible. Stock counting of such items at all india level was done and differential duty of increased MRP was calculated manually.

In SAP J2IUN transaction the value of Excise Duty related payable GLs was to be increased with this manually calculated amount.

Solution:
1. Create a new customer (name anything like MRP Revision Excise Duty Difference etc.
2. Create a FG material having stock value of Rs. 0.01 only
3. Upload intial stock of 1 qty into this newly created material
4. Create FOC Invoice from Excise Plant

At the time of Sales order creation, change the MRP in pricing (AFS Conditions) so that system calculates exact differential duty payable.

Excise payable GLs would get updated automatically on saving of excise invoices.

Block the customer
Block the material

Same procedure to be used in future.

Billing of Items having MRP < 300 in Delhi

Provision has been made in SAP to get that. A new table has been added to ZVAT condition type which comes first in the access sequence. If any material is maintained in this table then it would be free from taxes.

Discussions on SAP - Internal

1. How can we force MRP RUN in plants only for PIRs. MRP Run in Production Plants should not include any open sales orders, Transfer Requests, Purchase orders.

In other words, when MRP run is exectued it should only consider the PIR Quantities nothing else. This functionality is required only for MFG Plants.

2. It was discussed earlier that orders from RWH would be generated based on Safety Stock. This means that RWH will generate Transfer orders for MFG Plants based on Safety Stock. All open sales orders and purchase orders would get terminated at RWH Plants. No further action. Need to explore this feature.

3. if Make To Order Stock is not accepted by the customer. can we use that stock for some other order / customer ?

4. How to close open sales orders quickly. Right now we are closing the orders size wise by specifying ORDER REASON in sales order. This is too cumbersome and time consuming. Is there any way using which the sales order can be closed in a single click?

5. Production Order Settlement for FI guys needs to be explained once more.

6. Concerned HODs to be approached for suggestion on improvement, additions in SAP.

Participants: Bhai Ji, Shishir

Blocking Certains Materials from Billing to Certain Customers

We had a requirement from Sales where they wanted to prevent sales of selected items to selected customers.

This can be done in SAP thru LISTING AND EXCLUSION Feature.

T-CODE: VB01
Select list/excl. type: B001
Select the Customer: Customer code on whom the blocking is to be applied.
Select the materials: Material Codes which will not be allowed to this customer
Save

If even after specifying the customer and material in VB01, the sales is not getting blocked then please inform the BPO who will ensure that necessary configuration is done. (SPRO->S&D->Basic Functions->Listing/Exclusion->Activate Listing/Exclusion by Sales Document Type)

J_1IRG1 Number Range - Year End Activity

RG1 Number range has to be maintained thru T-CODE J1I9 or SNRO (Object name- J_1IRG1) for each year. The number range from last year has to be edited to adjust the TO column with last number and that number plus 1 would appear in from column of current year. Serial number for all the years would remain 01.

Promotional Items

Decision was taken to maintain inventory of promotional items and it was made clear that such items can be shown as consumed at the time of purchase.

Billing of such items to third parties at Rs. 1 from taxation angle was also decided long back, if FI wants, then they can pass reversal entries for adjusting this Rs 1 and tax thereon.

Shishir, Bhai Ji

Quarterly TDS Returns using J1INQEFILE

Solved the puzzle at last!!!.

Created the E-File and got the same validated using the validation tool from NSDL Site.

System was giving problem with Bank Key and rounding of TDS Amount but those were resolved and now we can get the e-file validated.

Screenshots: Selection Screen: J1INQEFILE and results. Output text file is generated which can be validated using NSDL Utility. After successful validation FVU file would be generated which needs to be submitted to the Govt.

Physical Counting Report - New

A new physical counting variance report has been developed to ensure that counting and postings are accurate.

It is now mandatory to TCode - ZCOUNT before posting inventory differences using MI07.

The T-Code will display, for the entered parameters combination, the book stock quantity, Book Stock value, counted quantity and value.