Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Image Added

1.2 GL Short Hand: costVariance

purpose: to record the cost difference between GRN and SINV

Image Added

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

Image Added

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

Image Added

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

Default GL Code for GST Input Not Due: gstInputNotDue

Image Added


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

Image Added

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

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

Image Added

Image Added

Image Added

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

Image Added

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

Image Added

Image Added

Image Added

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