Supplier Consignment

1. EMP Configuration

Changes

• New configurations :
  • Supplier Consignment GL Short Hand
  • Supplier Consignment Variance GL Short Hand
• Rename existing configurations
  • Consignment GL Short Hand --> Customer Consignment GL Short Hand
  • Supplier Consignment Variance GL Short Hand --> Customer Consignment Variance GL Short Hand

2. 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

• Changes sample JTXN @ Rm100 + 6% GST

  	Debit	Credit
  consignmentStock	100		This GL is taken from EMP Configuration > Distribution > Supplier Consignment GL
  accPayableInTransit		100	This GL is taken from EMP Configuration > Trading > Account Payable Not Due GL
  gstPayable	6		This GL is taken from Input Tax Default GL Code

3. Procurement > Supplier Consignment Billing

• the functionality is almost similar to Distribution > Consignment > Billing (which is Customer Consignment)
  • 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 (refer to Distribution > Consignment > Billing > Add Item for the logic)

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

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

• SCC

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

• SINV

  	Debit	Credit
  accPayableInTransit	90		This will follow the actual supplier price
  accPayable		95.4	This will follow the actual supplier price
  gstPayable	5.4		This will follow the actual supplier price

• Changes
  consignmentVariance 
  = [ ConsignedInPrice - ActualBillingPrice ] * -1
  = [ 100 - 90 ] + * -1
  = -10

4. Procurement > When return to supplier without billing

• Changes the UI for this function is similar to Distribution > Consignment > Return (which is Customer Consignment)
  • however, user can only return items that have yet to be billed by supplier (similar to the Add Item function in Supplier Billing > Add Item)

• however, 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 @ Rm100

  	Debit	Credit
  consignmentStock		100	This will follow the consigned in price
  accPayableInTransit	106		This will follow the consigned in price
  gstPayable		6	This will follow the consigned in price

5. 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

6. Supplier Consignment Stock Balance

• filters
  • Branch
  • Supplier
  • Items

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

7. Input Tax Filling GST will only be recorded for the SINV

• User can only file the SINV. User cannot file SCI, SCO or even the CM
• Moved to Supplier Consignment Billing for easier manipulation of the double entries
• Once the SINV is filed, below Jtxn should be created
  | | Debit | Credit |
  -| gstPayableFiled | XXX | | This GL is taken from Input Tax Default GL Code for filling
  | gstPayable | | XXX |