Circular
sivashankar/paradeep/iffco
Created: 29/01/2021 12:46
IFFCO-Paradeep

Circular Title:

Important Value Additions & Validations in ERP - Finance and Materials*

Deptt./Section:

System*

Never Expired : Yes

In continuation of our efforts for further Value Additions in ERP, the following features, validations & reports have been released for the users.

Control / Check applied on following:

I. We have put a check on "

AP Invoice – India Tax Screen

”

to alert user through an advisory message on the screen if already existing

Supplier's Invoice Number & Date

are entered by the user. This will help our users to avoid such mistake.

II. A check has been applied to restrict

un-checking “Inventory Asset Value Flag” for Insurance & Capital Spares Items

if the transactions related to it exist in Draft mode PSL.

III. A check has been applied at

RFQ Screen for prevention of deletion of RFQ

once the release date of the RFQ has been entered.

Provision of e-mail Alerts:

Alert to Supplier to remind for timely delivery of items:

Written program to

send e-mail alert to Supplier with CC to Indenters & Buyer

, 7 days before due date of delivery of an Item/Service against a PO/WO. It has been requested by Paradeep unit and enabled for them only.

II. A feature to send

e-mail alert

to Indenter has been made on

rejection of Requisition by the buyer

Developed following custom Web ADI Tool in Inventory to provide ease to the users for handling the mass transactions:

Sample Web ADI data template is attached herewith.

Web ADI for Misc Issue

II. Web ADI for Misc Receipt

III. Web ADI for adjustment for Excess items found during physical verification

IV. Web ADI for adjustment for shortage of items found physical verification

Value Addition in e-Invoicing Solution:

I. Provision made to capture Cancelled status also through API.

II. There are some cases where no response is received through API of e-Invoicing from NIC portal on sending the request for IRN generation. Provision made to

resend the request & retrieval of IRN & QR

in such a case.

III.

E-mail alert program written and schedule to notify the error

response received from NIC portal. Initially it will being sent to respective IT team, later on it can be scheduled to send alert to the concerned users.

5. Development of New Reports:

I. New report with the name “

IFFCO-Vendor GST vs PAN Mismatch Report

” has been developed and made available in Payables responsibility. Users need to generate the report and take suitable action for mismatch cases.

II. Developed the report with name "

IFFCO-IRN Exception Report

" and made available in Receivable responsibility (AR Module). Users need to see this exception report regularly.

6. Value Additions in the existing Reports:

I. Report

'IFFCO-Requisition Status with Parameters'

has been modified to provide additional information - the totals of ’Requisition Value' and 'Order Value' at the end of the report.

II. Modified the report “

IFFCO-AR TCS Transaction Details Report

” to add the new columns PAN No., TAN No., Taxable Amount and TCS Rate Percentage.

III. Modified the Report “

IFFCO-Vendor wise PO wise MIC/CWIP/TCS Schedule Report

” to include the TCS Account Code 2740015 in the report.

7. Automation of Buy Back of an item / Sale of Asset by creating AR Tax Invoice on retirement from FA module: Automated this process as per the steps attached. This will provide ease to the users while transacting for buy back cases or Sale of the Assets.

8. Changing Project Items to General Spares: We have written programs to automate the process of TAV-Out Transactions for Project items and TAV-In Transactions for respective general items. The steps of the process is given in the file attached herewith. This program will be helpful while mass conversion of Project Items to General Items required after commissioning of the projects at Plants.

9. In order to provide further ease to the user, we have merged B2B and B2C AR Tax Invoice while printing the report through Tool menu. Now User can use the same menu to print B2B Tax Invoice as well as B2C Tax invoice. User need not to submit the report for B2C Tax Invoice through the request.

All the Users are requested to make use of the above features provided and provide feedback if any, to us.

Steps for Buyback or sale of Assets.docx

Transfer of Project Inventory into General Inventory (002).docx

Sample_WebADI-Inventory_Module.xlsx

Regards,
Amitabh Mishra,
Dy General Manager (IT Services),
IFFCO Sadan, C - 1 , District Centre, Saket Place,
New Delhi - 110017
(Off.) 011-42592642, Mobile : 9810286655
IP Phone : 011238