2. EMP ConfigurationChanges
...
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
...
2. > 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
Changes sample sample JTXN @ Rm100 RM 1000
+ 6% GSTDebit Credit consignmentStocksuppConsignmentStock 1001000 This GL is taken from EMP Configuration > Distribution Procurement > Supplier Consignment GL accPayableInTransit 1001000 This GL is taken from EMP Configuration > Trading > Account Payable Not Due GL gstPayable6This GL is taken from Input Tax Default GL Code
...
To view the Journal Entry: Accounting > Journal and Ledger > Jtxn Listing
4. 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)- bill
- however, the document that will be created is SINV + Supplier Supplier Consignment Convert (SCC)
- Changes sample JTXN (Let’s say supplier bills cheaper @ Rm90 RM 900 + 6% GST)
SCC
Debit Credit inventory 1001000 This will follow the consigned in price consignmentStocksuppConsignmentStock 1001000 This will follow the consigned in price consignmentVarianceconsignmentStockVariance 10100 Difference btw consigned in price and actual billing price accPayableInTransit 10100 consignmentVariance * -1
SINV
ChangesDebit Credit accPayableInTransit 90900 This will follow the actual supplier price accPayable 95.4954 This will follow the actual supplier price gstPayablegstInput 5.454 This will follow the actual supplier price
consignmentVariance
= [ ConsignedInPrice - ActualBillingPrice ] * -1
= [ 100 - 90 ] + * -1
= -10
...
5. Procurement > When return to supplier without billing
...
- 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 @ Rm100RM 1000
Debit Credit consignmentStock 1001000 This will follow the consigned in price accPayableInTransit 1061000 This will follow the consigned in price gstPayable6This 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
67. Supplier Consignment Stock Balance
...
- listing columns
- No
- Supplier Pkid
- Supplier Name
- Item Code
- Item Name
- Balance Qty
7. Input Tax Filling GST 8. GST will only be recorded for the SINV
User can only file the SINV. User cannot file SCI, SCO or even the CMMoved to Supplier Consignment Billing for easier manipulation of the double entriesOnce the SINV is filed, below Jtxn should be created| | Debit | Credit |
-| gstPayableFiled -| gstInput| XXX | | This GL is taken from Input Tax Default GL Code for filling| gstPayable | | XXX |