Disable Auto create Supplier Invoice (SINV) when creating GRN - (No GST)

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



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


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
Account Payable In TransitaccPayableInTansit
200.00

SINV

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit200.00
Account PayableaccPayable
200.00

PR

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit100.00
Inventoryinventory
100.00

CM

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit
100.00
Account PayableaccPayable100.00


Scenario 2:

GRN and SINV with variance amount (GRN: Qty: 2) Unit Price: RM 100. (SINV: Qty: 2) Unit Price RM 90

PR and CM same amount (PR: Qty: 1) RM 100. (CM: Qty: 1. Unit Price: RM 90

GRN

GL NameGL codeDebitCredit
Inventoryinventory200.00
Account Payable In TransitaccPayableInTansit
200.00

 

SINV

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit200.00
Account PayableaccPayable
180.00
Cost VariancecostVariance
20.00

 

PR

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit100.00
Inventoryinventory
100.00

CM

GL NameGL codeDebitCredit
Account Payable In TransitaccPayableInTansit
100.00
Account PayableaccPayable90.00
Cost VariancecostVariance10.00



Private & Confidential