Supplier Consignment

2. EMP Configuration

2.1 Control Panel > System Admin > EMP Configurations > Trading

 Account Payable Not Due GL Short Hand: Select: accPayableInTransit

2.2 Control Panel > System Admin > EMP Configurations > Procurement > 

Supplier Consignment GL Short Hand > Select: suppConsignmentStock

Supplier Consignment Variance GL Short Hand > Select: consignmentStockVariance

3. Received Consignment Stock from Supplier

    Procurement > Create Supplier Consignment

• the UI for this function is similar to Direct Receiving Stock.
• however, the document that will be created is called Supplier Consignment In (SCI). The tables involved are :
  • inv_consignment_index
  • inv_consignment_item
  • inv_stock
  • inv_stock_delta
  • acc_journal_transaction
  • acc_journal_entry

• it will not create the SINV

• sample JTXN @ RM 1000 + 6% GST

  	Debit	Credit
  suppConsignmentStock	1000		This GL is taken from EMP Configuration > Procurement > Supplier Consignment GL
  accPayableInTransit		1000	This GL is taken from EMP Configuration > Trading > Account Payable Not Due GL

  To view the Journal Entry: Accounting > Journal and Ledger > Jtxn Listing

  

   

4. Procurement > Supplier Consignment Billing

• • 1. specify the supplier, branch, date, remarks, reference number
  • 2. add item by selecting from a list of items that the supplier has yet to bill 

• however, the document that will be created is SINV +  Supplier Consignment Convert (SCC)
  
  

• Changes sample JTXN (Let’s say supplier bills cheaper @ RM 900 + 6% GST)

• SCC

  	Debit	Credit
  inventory	1000		This will follow the consigned in price
  suppConsignmentStock		1000	This will follow the consigned in price
  consignmentStockVariance		100	Difference btw consigned in price and actual billing price
  accPayableInTransit	100		consignmentVariance * -1

• SINV

  	Debit	Credit
  accPayableInTransit	900		This will follow the actual supplier price
  accPayable		954	This will follow the actual supplier price
  gstInput	54		This will follow the actual supplier price

   

  

  
  

5. Procurement > When return to supplier without billing

• the document that will be created is called Supplier Consignment Out (SCO). The tables involved are :
  • inv_consignment_index
  • inv_consignment_item
  • inv_stock
  • inv_stock_delta
  • acc_journal_transaction
  • acc_journal_entry

• it will not create the CM

• Changes sample JTXN @ RM 1000

  	Debit	Credit
  consignmentStock		1000	This will follow the consigned in price
  accPayableInTransit	1000		This will follow the consigned in price

   

  

  

  

   

6. Supplier Consignment Listing

• filters
  • Branch
  • Supplier
  • Date
  • Consignment Type (SCI, SINV from Consignment, SCO)
  • SCO without CM

• listing columns
  • No
  • Consignment No
  • Branch Running No
  • Date
  • Supplier Pkid
  • Supplier Name
  • Description
  • Type
  • User
  • Amount

7. Supplier Consignment Stock Balance

• filters
  • Branch
  • Supplier
  • Items

• listing columns
  • No
  • Supplier Pkid
  • Supplier Name
  • Item Code
  • Item Name
  • Balance Qty

8.  GST will only be recorded for the SINV

• -| gstInput| XXX | | This GL is taken from Input Tax Default GL Code for filling