Ge Process.xlsx

CREATE GATE ENTRY HEADER DETAILS: Gate Enrtry No

INWARD

Number Range

Plant

✘

IN

OUTWORD

1888

Gate Entry Date

Vehicle No

Text

Document Type

LR No

text

Vehicle Type

Truck

Forwarding Agent

TEXT

EWB No

text

Driver Name

TEXT

Contact No

text

Date

text

Remarks

Customer Dispatch Gate Entry Time

01/04/2019

TEXT

Document LE N(document number provided by the gatekeeperInvoice based No: on the selected Doctext type Number

Supplier Code ITEM DETAILS: SR NO 1

09:23 AM

TABLE

Desription

MATERIAL NO DESCRIPTION DATA WILL BE BASED ON DOCUMENT REFERENCE

Supplier description

QTY

UOM 100

Rule

1 User will select gate inward or outword 2 If select Inward Document No field is mandatory 3 Purchase Order / Sales Agreement / Inbund Delivery should be mandatory based on Document Type 4 Purchase order and Schedule agreement should be released 5 Supplier or customer code will be come automatically based on Document reference and for Outward wi 6 item details will come automaticalle based on document number for inwards and In outword it will come 7 If It is Purchase order or Schedule Agreement User can select he line Item and Edit QTY and Non selected 8 If It is inbound delivery All item details, Invoice no and date will come automatically item details not edita 9 If User has selected Outword Gate Entry Document Number Field is not mandtory 10 Incase of outword Invoice no and date is mandatory and Item details will come Automatically which is no 11 For Inward while doing MIGO Header Text Field shoul be validated with Gate Entry No with reference to P 12 Once Vehicle is out User can click on Out so Gate Entry will be closed and no one can edit it again, Chang

O UT

01/04/2019 09:23 AM TEXT text

text

on

SELECT

ed on Document Type

erence and for Outward with reference to Invoice and In outword it will come based on Invoice no Edit QTY and Non selected Item will be deleted from List tically item details not editable

e Automatically which is not editable ntry No with reference to Purchase order no and Invoice no and date ne can edit it again, Change will be possile before closing gate entry

Optional Mandatory

Purchase Order Inbound Delivery Scheduling Agreement By Courier Subcontracting

Check if PO created and released. Then when gate keeper gives the Po number, get all the materails Here the user cannot amend the quantity and UoM

customer returns

based on a returns sale order goods returns is taken. This is for any damaged product which custom This case will not have any document number mandatory. User will enter materail and quantity man

Customer Dispatch

This is the goods issue process - Mandatory fields - invoice number to be mandatory, system will get EWB number (row number 6) is mandatory

reference of PO or without any reference (511 mov type). If user selects courier, document number This can be both inward and outward case1 raw materials are sent to the subcontractor - 541 document number or PO number -PO n case 2 finished goods from sub-contaractor - this would be the same case as PO or SA or IBD - so

OPTION 2 Only header of gate entry and user will give gate entry number manually in the GR number and validate

mber, get all the materails and quantities and populate in the items. Incase of PO the user cannot edit the quantity and UoM. The quantity

courier, document number would not be mandatory.

umber or PO number -PO not mandatory to be confirmed case as PO or SA or IBD - so no need of separate process

ged product which customer is returning to the plant back materail and quantity manually

mandatory, system will get the invoice date

invoice number and invoice date is mandatory in case of subcontractor

IN`/OUT The gate man would give all the details in

quantity and UoM. The quantity should not exceed the PO open quantity. If PO already delivered, error message

atory in case of subcontractor

man would give all the details in the gate entry and save - Then the IN would be marked against the gate entry. Once the goods are unloade

ntry. Once the goods are unloaded in the warehouse and it is returning, the same Goods slip number would be given and only the OUT can

d be given and only the OUT can be edited, and the gate entry is marked as out, whic means it has left the premises