Disable Auto create Supplier Invoice (SINV) when creating GRN

Objective of this function: 

 

Configurations

1.Add New GL Code for the accruals transaction posting

Menu Path: Accounting > Maintenance > Configuration > Add GL Code

1.1 GL Short Hand : accPayableInTransit

purpose: to record the supplier account when creating GRN. Later will transfer to accPayable when converted GRN to SINV

1.2 GL Short Hand: costVariance

purpose: to record the cost difference between GRN and SINV


1.3 GL Short Hand: gstInputNotDue

purpose: to record Input Tax from GRN, later will transfer to Gst Input tax when converted GRN to SINV

2. System Configurations

2.1 Menu Path: Control Panel > System Admin > EMP Configuration > Procurement > 

1. SINV auto created when creating GRN & CM auto created when creating Purchase Return : Tick Disable

2. Account Payable Not Due GL : GL Short Hand: accPayableInTransit

3. Credit Memo & Supplier Invoice Variance GL Short Hand : GL Short Hand: costVariance


2.2 Menu Path: Control Panel > System Admin > EMP Configuration > Tax > Purchase (Input Tax) > 

Default GL Code for GST Input Not Due: gstInputNotDue



Transactions

Goods Receiving process

1.When receive DO from Supplier, create GRN as normal, after save GRN, system not create any SINV

Menu Path: Procurement > Transactions > Direct Receiving Stock

2. After received Supplier Invoice, Convert GRN to system SINV:

Menu Path: Procurement > Reports > GRN Listing : Actions > Supplier Invoice Create


Goods Return Process

1.Create Purchase Return as usual, system created Purchase Return (PR) document only, without Credit Memo

Menu Path: Procurement > Transactions > Purchase Return by GRN


2.After received Credit Note from Supplier, convert the PR to CM

(Note: for this Supplier CM, is Debit Note record in supplier account)

Menu Path: Procurement > Reports > Purchase Return Listing : Actions > Create Credit Memo


Journal Record

Sample of transaction:

Scenario 1:

GRN and SINV same amount (Qty: 2, Unit Price (Exc. Tax): RM 100, GST: TX 6%, RM 6), PR and CM same amount (Qty: 1)

(Notes: GL code depends on the user server configurations, the scenario based on http://wavelet-training.wavelet.systems/emp server configuration)

GRN

GL NameGL codeDebitCredit
Inventoryinventory200.00 
GST Input Not DuegstInputNotDue12.00 
Account Payable In TransitaccPayableInTansit 212.00

SINV

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit212.00 
Account PayableaccPayable 212.00
GST Input Taxgst_Input12.00 
GST Input Not DuegstInputNotDue 12.00

PR

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit106.00 
Inventoryinventory 100.00
GST Input Not DuegstInputNotDue 6.00

CM

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit 106.00
Account PayableaccPayable106.00 
GST Input Taxgst_Input 6.00
GST Input Not DuegstInputNotDue6.00 

 

Scenario 2:

GRN and SINV with varance amount (GRN: Qty: 2, Unit Price (Exc. Tax): RM 100, GST: TX 6%, RM 6), (SINV: Qty: 2, Unit Price (Exc. Tax): RM 90, GST: TX 6%, RM 5.4), 

PR and CM same amount (PR: Qty: 1 Unit Price (Exc. Tax): RM 100, GST: TX 6%, RM 6), (CM: Qty: 1, Unit Price (Exc. Tax): RM 90, GST: TX 6%, RM 5.4)

GRN

GL NameGL codeDebitCredit
Inventoryinventory200.00 
GST Input Not DuegstInputNotDue12.00 
Account Payable In TransitaccPayableInTansit 212.00

 

SINV

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit212.00 
Account PayableaccPayable 190.80
GST Input Taxgst_Input10.80 
GST Input Not DuegstInputNotDue 12.00
Cost VariancecostVariance 20.00

 

PR

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit106.00 
Inventoryinventory 100.00
GST Input Not DuegstInputNotDue 6.00

CM

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit 106.00
Account PayableaccPayable95.40 
GST Input Taxgst_Input 5.40
GST Input Not DuegstInputNotDue6.00 
Cost VariancecostVariance10.00 



Private & Confidential