| Purchase of Raw Materials |
|
|
|
|
|
|
|
|
|
| Document |
Action |
FROM |
TO |
Item |
Qty |
Rate |
Total |
Data Picked from |
Business Rules |
Owner |
|
| Supplier
Registration |
Enter |
Supplier |
Purchase |
Tin |
|
10 |
|
Supplier filled forms |
Supplier has to fill
registration forms online or send filled forms via mail or courier to
purchase department for registration |
Leyelet |
|
Approve |
Management |
Purchase |
Lead |
|
10 |
|
Management approves for
registrations / DACA Approves registration |
|
|
Registered |
|
Approved Supplier can also be
edited for Item registrations for that supplier. |
|
|
| Accounts |
SundryCreditors |
Purchase |
Accounts |
|
Supplier Name from supplier
master |
Supplier Account should be
automatically created under Sundry Creditors group, when supplier
registration is done and approved. Supplier mapped to accounts here. |
Leyelet |
|
| PR |
Enter |
Store/Mktg. |
Purchase |
Tin |
30 |
|
PR can be created using many
methods like Manual Entry, Auto via ROP, Kanban, MRP |
Leyelet |
| Purchase Requisition |
Approve |
|
Lead |
70 |
|
ROP to be determined from last 2
year data available in excel. |
|
| Indent |
Closed |
|
|
PendingPR |
|
All PR whose items are not
ordered are considered open |
|
|
| RFQ |
Enter |
Purchase |
Supplier |
Tin |
30 |
|
From open PR whose PO not
prepared |
RFQ to be auto filled for all
items from PR. Purchase can then deselect the items. |
Leyelet |
| Request for Quotations |
Approve |
|
Lead |
70 |
|
RFQ can be sames as RFI or
RFP |
|
|
Print |
|
open RFQ |
Only active RFQs should be
allowed to be printed based on validity dates. Email/Printing should be
allowed once only. |
|
|
Closed |
|
Outside validity dates RFQ
should be moved to closed folder. |
|
| Inquiry |
|
| Quote |
Enter |
Supplier |
Purchase |
Tin |
30 |
10 |
300 |
Against open RFQ |
Quotes entry
should only be possible for valid RFQs. |
Leyelet |
|
Approve |
|
Lead |
70 |
10 |
700 |
auto |
Approval is required for
selected Quote on which PO is prepared. |
|
|
Closed |
|
1000 |
auto |
All approved quotes should be
closed. |
|
|
Rejected |
|
auto |
All unapproved quotes should be
rejected. |
|
| Quote Amedment |
|
|
|
|
|
|
| Compare |
Show |
ERP |
Purchase |
|
Show list of All Quotes against
this PR, Last 5 PO, Supplier master rates. |
Comparison to be shown only
after RFQ is closed based on validity date and for Open PRs only. No printing
of comparisons to be allowed. |
Leyelet |
|
| PO |
Enter |
Purchase |
Supplier |
Tin |
30 |
10 |
300 |
Based on Last Quote Rate |
PO can be prepared using many
methods like Manual Entry, Auto against PR based on Best Quote Rate, Last PO
Rate and Supplier Master rate. |
Leyelet |
| Purchase Order |
Approve |
|
Lead |
70 |
10 |
700 |
|
Purchase manager should approve |
|
|
Print |
|
1000 |
|
Purchase exective should
print/email once only. Once printed this PO should get closed. Viewing of PO
should be possible at time of Approval. |
|
|
OpenPO |
|
based on GRN |
PO for which items are yet not
received and pending from suppliers. |
|
|
Closed |
|
All PO whose material supplied
is considerd closed. |
|
| PO Amendment |
|
|
|
| PO short close |
|
|
|
| Stores
receives raw materials |
|
|
|
| Document |
Action |
FROM |
TO |
Item |
Qty |
Rate |
Total |
Data Picked from |
Business Rules |
|
| DO |
Enter |
Supplier |
RM Stores |
Tin |
30 |
|
Against Open PO |
DO
to be auto entered against PO. Select stores and enter QTY received & QTY
Rejected if needs to bypass IQC. |
|
| Delivery Order |
Approve |
|
Lead |
70 |
|
Select Store where you are
receiving the material |
Store manager should approve |
|
|
Closed |
|
more then x% should be allowed
to be set in item master |
|
| IQC |
OnHold |
RM Stores |
QC |
Tin |
0 |
|
Against Open DO |
IQC auto entered when DO
approved. IQC can be manually edited for entering Test Certificates,
Rejection Reasons or Quantities. |
|
| In Coming Quality Control |
Closed |
|
Lead |
0 |
|
IQC should be closed when
GRNPosting done. |
|
|
| Charge Sheet |
OnHold |
RM Stores |
Accounts |
Freight |
|
100 |
From Transporter invoice or
payments |
ChargeSheet to be auto entered
on approval of DO similar to IQC. |
Leyelet |
|
Closed |
|
ChargeSheet should be closed
when GRN Posting done. |
|
|
if charges not there then system
should bypass it |
|
| GRNPosting |
Post |
RM Stores |
ERP |
|
Rate picked from PO |
Item rate recalculated |
new rate of material with
charges computed |
|
|
Tin |
30 |
10 |
300 |
330 |
11 |
|
|
Lead |
70 |
10 |
700 |
770 |
if non-stock
item then no stock card, item master |
|
|
Freight |
|
100 |
100 |
|
Postings done are as follows |
|
|
1100 |
1100 |
1. above rates entered in GRN
RATE Field |
|
|
2. Wtd Avg rate computed from
all previous GRNs for this year and entered in STDCOST field of ITEM Master. |
|
| Voucher |
Auto |
RM Stores |
Accounts |
Cr. Supplier Controlling A/c |
|
1000 |
mapped in product group |
3. Accounting entries in voucher
done automaticaaly by posting program as shown here. |
|
|
Dr. RM Stock A/c |
|
1100 |
mapped in item master |
4. Accounting entries can be |
|
|
GIT A/C |
|
Cr. Freight Controlling A/c |
|
100 |
mapped in charges master |
bypassed if flag set off in |
|
|
calender master |
|
|
DOC |
RCV |
ISS |
Bal Qty |
Bal value |
5. stock increased in stock
card, item master and store for that year. |
|
| Stock Card |
Print |
RM Stores |
Management |
Tin GRN |
30 |
0 |
30 |
330 |
A history sheet for ITEMs in
that store. This card will link to all source documents like GRN and Voucher. |
|
|
Lead GRN |
70 |
0 |
70 |
770 |
|
|
| GRN |
Print |
RM Stores |
Supplier |
Tin |
30 |
11 |
330 |
Values taken from DO |
Generated for print once for all
good Qty received against PO. |
|
| Goods Receipt Note |
|
Lead |
70 |
11 |
770 |
|
|
1100 |
|
|
| Rejection Note |
Print |
RM Stores |
Supplier |
Tin |
0 |
|
Values taken from DO |
Will be generated with printonce
only if Reject Qtys are entered |
|
|
Lead |
0 |
|
Special entry for mining screen |
|
|
| PI |
Enter |
Supplier |
Purchase |
Tin |
30 |
10 |
300 |
Rate pickedup from PO |
Taxes to be entered manually |
Leyelet |
| Purchase Invoice |
Approve |
|
Lead |
70 |
10 |
700 |
Qty pickedup from GRN |
|
|
Closed |
|
Taxes |
|
50 |
|
|
Total |
|
1050 |
|
|
| PI Posting |
Post |
Accounts |
ERP |
Cr. Supplier |
|
1050 |
mapped to supplier master |
Purchase should be booked for supplier |
Leyelet |
|
Dr. Supplier Controlling A/c |
|
1000 |
mapped in product group |
Sundry creditors are raised |
|
|
Dr. Taxes |
|
50 |
mapped to tax structures |
Under Duties and taxes |
|
|
| Payments to Suppliers |
|
Dr. Supplier |
|
1050 |
|
|
|
Cr. Cash or Bank |
|
1050 |
Reflects in Balancesheet |
|
|
|
| Computation
of Taxes to be paid |
|
Cr. Taxes e.g. VAT Input
from Sales |
100 |
from Sales Voucher |
|
|
|
Dr Taxes e.g. VAT Output
from Purchase |
50 |
from Purchase Voucher |
|
|
|
Taxes to be paid |
|
50 |
|
|
|
| Payments
to Taxes via Challan |
|
Dr. Taxes |
|
50 |
|
|
|
Cr. Cash or Bank |
|
50 |
Reflects in Balancesheet |
|
|
|
| Entry of Freight Invoice |
|
Cr. Freight Supplier |
|
100 |
|
|
|
Dr. Freight Controlling A/c |
|
100 |
|
|
|
| Payment
to Freight Suppliers |
|
Dr. Freight Supplier |
|
100 |
|
|
|
Cr. Cash or Bank |
|
100 |
Reflects in Balancesheet |
|
|
|
| Production
of Billets sub assemblies |
|
| Document |
Action |
FROM |
TO |
Item |
Qty |
Rate |
Total |
Data Picked from |
Business Rules |
|
|
| ProductionMR |
Enter |
Production |
RM Stores |
Billets |
10 |
|
DA or MRP II |
Subassembly picked from MRP or from SO |
|
| Material Requisition |
Approve |
|
Tin |
30 |
|
from BOM |
Materials are auto picked with qty from BOM |
|
|
Closed |
|
Lead |
70 |
|
from BOM |
On approval of this Production
MRP Billet GRN is generated. |
|
|
GRN is linked to this MR as per
FIFO Method by default. |
|
| MI Posting |
Post |
RM Stores |
Production |
Tin |
30 |
11 |
330 |
rate picked from GRN |
on posting of MR stock is
reduced in stock card, item master for that store and total item stock. |
|
| Material Isse Note |
|
Lead |
70 |
11 |
770 |
rate picked from GRN |
voucher is auto posted to post
consumtion as mentioned in voucher here. |
|
| GRN
Selection with store filter |
|
1100 |
materials issued by stores |
production order is created with
process and operations copied in details. |
|
|
non-stock item should not
display for the issue |
|
| Voucher |
Auto |
RM Stores |
Accounts |
Dr. Consumption A/c |
|
1100 |
mapped to item master |
data for posting pickedup from
above MR |
|
|
Cr. RM Stock |
|
1100 |
mapped to item master |
select capital consumption for
assets |
|
|
Cost center A auto entered |
|
1100 |
mapped from MR |
|
| DO |
AutoEnter |
Production |
Production |
Billets |
10 |
110 |
1100 |
Against above mentioned
productionMR |
ENTER
QTY Rejected if needs to bypass IQC and enter production rejects or
salvages. |
|
| Delivery Order |
Approve |
|
Select prodcution Store where
you are receiving the sub assembly |
production manager should
approve |
|
|
Closed |
|
rate is auto computed based on
above MR |
|
|
|
|
Production |
Accounts |
Production cost |
|
0 |
From time taken to produce this
order |
Production cost transferred via
separate voucher |
|
|
|
|
|
|
|
| GRNPosting |
Post |
Production |
ERP |
|
Rate picked from PO |
Item rate recalculated |
new rate of SA with charges
computed |
|
|
Billet |
10 |
110 |
1100 |
1100 |
ONE GRN TO ONE VOUCHER |
|
|
| Voucher |
Auto |
Production |
Accounts |
Cr. Consumption A/c |
|
1100 |
mapped to product group |
|
|
Dr. WIP Stock A/c |
|
1100 |
mapped to item master |
|
|
|
|
|
|
DOC |
RCV |
ISS |
Bal Qty |
Bal value |
|
| Stock Card |
Print |
Production |
Management |
Billets |
10 |
0 |
10 |
1100 |
|
|
| GRN |
Print |
Production |
Management |
Billets |
10 |
110 |
1100 |
Values taken from DO |
|
| Goods Receipt Note |
|
|
| Rejection Note |
Print |
Production |
Management |
Billets |
0 |
|
Values taken from DO |
If any rejection via LineQA |
|
|
| Work Order |
Print |
Production |
Operator |
Billets |
10 |
|
auto entered by MR |
print and give to operator on shopfloor |
|
|
|
Operation |
Intime-Outtime |
Cycletime |
RejQty |
Costs |
Entered at each ops on shopfloor |
|
| Shopfloor Tracking |
MoveLot |
Operator |
Op1 |
10am-11am |
1 |
|
0 |
50 |
|
|
Op2 |
11am-12am |
1 |
|
0 |
50 |
|
|
100 |
|
| Voucher |
|
Production |
Accounts |
Dr. Labour Cost |
|
100 |
|
|
Cr. Cash & Bank |
|
100 |
|
| Production
of Wires Finished Goods |
|
| Document |
Action |
FROM |
TO |
Item |
Qty |
Rate |
Total |
Data Picked from |
Business Rules |
|
|
| ProductionMR |
Enter |
Production |
FG Stores |
Wires |
10 |
|
DA or MRP II |
Subassembly picked from MRP or from SO |
|
| Material Requisition |
Approve |
|
Billets |
10 |
|
from BOM |
Materials are auto picked with qty from BOM |
|
|
Closed |
|
On approval of this Production
MRP Billet GRN is generated. |
|
|
GRN is linked to this MR as per
FIFO Method by default. |
|
| MI Posting |
Post |
Production |
Production |
Billets |
10 |
110 |
1100 |
rate picked from GRN |
on posting of MR stock is
reduced in stock card, item master for that store and total item stock. |
|
| Material Isse Note |
|
voucher is auto posted to post
consumtion as mentioned in voucher here. |
|
|
SA issued by production stores |
production order is created with
process and operations copied in details. |
|
|
| Voucher |
Auto |
FG Stores |
Accounts |
Dr. Consumption A/c |
|
1100 |
mapped to item master |
data for posting pickedup from
above MR |
|
|
Cr. WIP Stock |
|
1100 |
mapped to item master |
|
|
| DO |
AutoEnter |
Production |
FG Stores |
Wires |
10 |
110 |
1100 |
Against above mentioned
productionMR |
ENTER
QTY Rejected if needs to bypass IQC and enter production rejects or
salvages. |
|
| Delivery Order |
Approve |
|
Select prodcution Store where
you are receiving the finished goods |
production manager should
approve |
|
|
Closed |
|
rate is auto computed based on
above MR |
|
|
| Voucher |
|
Production |
Accounts |
Dr. Labour costs |
|
0 |
From time taken to produce this
order |
Production cost transferred via
separate voucher |
|
|
|
|
|
|
|
| GRNPosting |
Post |
Production |
ERP |
|
Rate picked from PO |
Item rate recalculated |
new rate of SA with charges
computed |
|
|
Wire |
10 |
110 |
1100 |
1300 |
130 |
|
|
| Voucher |
Auto |
Production |
Accounts |
Cr. Consumption |
|
1100 |
mapped in product group |
|
|
Dr. FG Stock A/c |
|
1100 |
mapped in item master |
|
|
|
|
|
|
|
DOC |
RCV |
ISS |
Bal Qty |
Bal value |
|
| Stock Card |
Print |
Production |
Management |
Wire |
10 |
0 |
10 |
1300 |
|
|
| GRN |
Print |
Production |
Management |
Wire |
10 |
130 |
1300 |
Values taken from DO |
|
| Goods Receipt Note |
|
|
| Rejection Note |
Print |
Production |
Management |
Wire |
0 |
|
Values taken from DO |
If any rejection via LineQA |
|
|
| Work Order |
Print |
Production |
Operator |
Wire |
10 |
|
auto entered by MR |
print and give to operator on shopfloor |
|
|
|
Operation |
Intime-Outtime |
Cycletime |
RejQty |
|
| Shopfloor Tracking |
MoveLot |
Operator |
Op1 |
10am-11am |
1 |
|
0 |
Entered at each ops on shopfloor |
|
|
Op2 |
11am-12am |
1 |
|
0 |
|
|
| ISSUES
of Wires Finished Goods TO SALES |
|
| Document |
Action |
FROM |
TO |
Item |
Qty |
Rate |
Total |
Data Picked from |
Business Rules |
|
|
| ProductionMR |
Enter |
FG Stores |
Sales |
Wires |
10 |
|
DA or MRP II |
FG picked from MRP or from SO |
|
| Material Requisition |
Approve |
|
Wires |
10 |
|
from BOM |
|
|
Closed |
|
|
|
|
GRN is linked to this MR as per
FIFO Method by default. |
|
| MI Posting |
Post |
FG Stores |
Sales |
Wires |
10 |
130 |
1300 |
rate picked from GRN |
on posting of MR stock is
reduced in stock card, item master for that store and total item stock. |
|
| Material Isse Note |
|
voucher is NOT created and
posted in this condition. |
|
|
FG issued by FG stores |
production order is created with
process and operations copied in details. |
|
| Voucher |
Auto |
FG Stores |
Accounts |
Dr. Consumption A/c |
|
1100 |
mapped to item master |
data for posting pickedup from
above MR |
|
|
Cr. FG Stock |
|
1100 |
mapped to item master |
|
|
| Sales Invoice |
|
Cr. Sales |
|
2500 |
selected at time of posting |
|
|
Dr. Customer |
|
2600 |
mapped to customer master |
|
|
Cr. Taxes |
|
100 |
mapped to tax structure |
|
|
| Receipt Payments |
|
Cr. Customer |
|
2600 |
manual entry |
|
|
Dr. Cash & Bank |
|
2600 |
manual entry |
|
|
| |
|
|
|
| TRIAL BALANCE |
Cash & Bank |
|
From Customer |
|
2600 |
|
|
To Material Supplier |
|
1050 |
|
|
To Taxes |
|
50 |
|
|
To Freight Supplier |
|
100 |
|
|
To Labour Supplier |
|
100 |
|
|
Balance |
|
1300 |
|
|
|
| PROFIT & LOSS |
|
Cr. |
Sales |
|
2500 |
|
|
Dr. |
Less: Cost of Sales |
|
1100 |
Material Consumption |
|
|
Less: Labour costs |
|
100 |
|
|
Profit |
|
1300 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|