Page Comparison

...

...

2. EMP Configuration

2.1 Control Panel > System Admin > EMP Configurations > Trading

 Account Payable Not Due GL Short Hand: Select: accPayableInTransit

Image Modified

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

Supplier Consignment GL Short Hand > Select: suppConsignmentStock

Supplier Consignment Variance GL Short Hand > Select: consignmentStockVariance

Image Modified

3. Received Consignment Stock from Supplier

    Procurement >  Supplier Consignment > Create Supplier Consignment

• the UI for this function is similar to Direct Receiving Stock .(GRN)
• 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

• Must Keyed in the Consignment Value and record the gst
• it will not create the Supplier Invoice (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. Sold out and send statement to Supplier, Received Supplier Tax Invoice

    Procurement > Supplier Consignment > Billing

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

...

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

• Supplier Consignment Convert (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

• Supplier Invoice (SINV)

...

• GST will only be recorded for the SINV
  -| gst_Input| XXX | | This GL is taken from Input Tax Default GL Code for filling

Image Modified

Image Modified

Image Modified

5. Un-sales items, return back to supplier 

    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
  consignmentStocksuppConsignmentStock		1000	This will follow the consigned in price
  accPayableInTransit	1000		This will follow the consigned in price

   

  

  

  

   

6. Supplier Consignment ListingListing 

• 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

Procurement > Supplier Consignment > History 

Image Added

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

...

    Procurement > Supplier Consignment > Stock Balance

Image Added

8.  Supplier Consignment Stock Movement Report

     Procurement > Supplier Consignment > Reports > Consignment Stock Card Report

    Image Added

 9.  To view particular date report (e.g Balance as at 31 March 2015)

     Procurement > Supplier Consignment > Reports > Supplier Stock Balance Historical Report