usage:po2gl
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
usage:po2gl [2014/01/05 05:29] asok |
usage:po2gl [2015/03/23 12:11] (current) mueed old revision restored (2014/07/12 02:33) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| Prior to version 5.3, Taxes and duties were posted when a GRN was confirmed. However, many customers are of the view that the taxes and duties should be based on Supplier Invoices and Not when a GRN is posted. This is particularly important when invoices from suppliers are based on milestones and not GRN. The new interface fixes this problem. It also takes care of Purchase Discounts which were automatically deducted from price instead of crediting to discounts earned, even when a separate account was specified in GL Interface table for that purpose. | Prior to version 5.3, Taxes and duties were posted when a GRN was confirmed. However, many customers are of the view that the taxes and duties should be based on Supplier Invoices and Not when a GRN is posted. This is particularly important when invoices from suppliers are based on milestones and not GRN. The new interface fixes this problem. It also takes care of Purchase Discounts which were automatically deducted from price instead of crediting to discounts earned, even when a separate account was specified in GL Interface table for that purpose. | ||
| - | \\ | + | |
| ====Confirm GRN==== | ====Confirm GRN==== | ||
| Line 9: | Line 9: | ||
| ^ GL Interface Type ^ Sub-account ^ Currency ^ Dr ^ Cr ^ Notes ^ | ^ GL Interface Type ^ Sub-account ^ Currency ^ Dr ^ Cr ^ Notes ^ | ||
| - | ^ Purchase Commission | | Prime | (PurchasePrice-Discount)*Commission%/100 | | | | + | ^ Purchase Commission | | Prime | (PurchasePrice-Discount)*Commission%/100 | | | |
| - | ^ Accrued Purchases-Supplier | Agent | Prime | | (PurchasePrice-Discount)*Commission%/100 | | | + | ^ Accrued Purchases-Agents | | Prime | | (PurchasePrice-Discount)*Commission%/100 | | |
| - | ^ Accrued Purchases-Supplier | Vendor | Prime | | PurchasePrice-Discount | | | + | ^ Accrued Purchases-Supplier | | Prime | | PurchasePrice-Discount | | |
| ^ Purchase Discount | | Prime | | Discount | | | ^ Purchase Discount | | Prime | | Discount | | | ||
| ^ Accrued Purchases-Sundries | | Base | | AdditionalCost | | | ^ Accrued Purchases-Sundries | | Base | | AdditionalCost | | | ||
| ^ Inventory/Accruals | | Base | StandardCost | | | | ^ Inventory/Accruals | | Base | StandardCost | | | | ||
| ^ Purchase Variance | | Base | PurchasePrice*ExchangeRate+AdditionalCost-StandardCost | | | | ^ Purchase Variance | | Base | PurchasePrice*ExchangeRate+AdditionalCost-StandardCost | | | | ||
| - | |||
| \\ | \\ | ||
| + | |||
| ====Post Supplier Invoice - Local Purchases==== | ====Post Supplier Invoice - Local Purchases==== | ||
| Line 27: | Line 27: | ||
| ^ [Accounts Payable] | Vendor | Prime | |(PurchasePrice-Discount)*(100+TaxRate)/100 | | | ^ [Accounts Payable] | Vendor | Prime | |(PurchasePrice-Discount)*(100+TaxRate)/100 | | | ||
| ^ [Tax] | | Prime | (PurchasePrice-Discount)*TaxRate/100 | | | | ^ [Tax] | | Prime | (PurchasePrice-Discount)*TaxRate/100 | | | | ||
| + | \\ | ||
| - | \\ | + | |
| ====Post Supplier Invoice - Imports==== | ====Post Supplier Invoice - Imports==== | ||
| Line 38: | Line 39: | ||
| ^ [Accounts Payable] | Vendor | Prime | |(PurchasePrice-Discount) | | | ^ [Accounts Payable] | Vendor | Prime | |(PurchasePrice-Discount) | | | ||
| ^ [Tax] | | Prime | (PurchasePrice-Discount)*TaxRate/100 | | | | ^ [Tax] | | Prime | (PurchasePrice-Discount)*TaxRate/100 | | | | ||
| - | ^ Contingent Duties | | Prime | | (PurchasePrice-Discount)*TaxRate/100 | | | + | ^ Taxes/Duties Payable Contra((This a new Interface Type that must be defined.)) | | Prime | | (PurchasePrice-Discount)*TaxRate/100 | | |
| + | \\ | ||
| =====Examples===== | =====Examples===== | ||
| Line 46: | Line 47: | ||
| Say, PucrchasePrice=USD 100 Discount=10% Commission=5% ExchangeRate=1.5 BaseCurrency=SGD StandardCost=SGD 70 AdditionalCost=SGD 35 Vendor=SUP-000001 Agent=AGNT000001 TaxRate=7% | Say, PucrchasePrice=USD 100 Discount=10% Commission=5% ExchangeRate=1.5 BaseCurrency=SGD StandardCost=SGD 70 AdditionalCost=SGD 35 Vendor=SUP-000001 Agent=AGNT000001 TaxRate=7% | ||
| - | The generated vouchers will contain | + | The generated vouchers will contain: |
| - | \\ | ||
| ====Confirm GRN==== | ====Confirm GRN==== | ||
| Line 54: | Line 54: | ||
| ^ GL Interface Type ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | ^ GL Interface Type ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | ||
| ^ Purchase Commission | | USD | (100-10)*5/100=4.50 | | 6.75 | | | | ^ Purchase Commission | | USD | (100-10)*5/100=4.50 | | 6.75 | | | | ||
| - | ^ Accrued Purchases-Supplier | AGNT000001 | USD | | (100-10)*5/100=4.50 | | 6.75 | | | + | ^ Accrued Purchases-Supplier | | USD | | (100-10)*5/100=4.50 | | 6.75 | | |
| - | ^ Accrued Purchases-Supplier | SUP-000001 | USD | | 100-10=90.00 | | 135.00 | | | + | ^ Accrued Purchases-Supplier | | USD | | 100-10=90.00 | | 135.00 | | |
| ^ Purchase Discount | | USD | | 10.00 | | 15.00 | | | ^ Purchase Discount | | USD | | 10.00 | | 15.00 | | | ||
| ^ Accrued Purchases-Sundries | | SGD | | 35.00 | | 35.00 | | | ^ Accrued Purchases-Sundries | | SGD | | 35.00 | | 35.00 | | | ||
| ^ Inventory/Accruals | | SGD | 70.00 | | 70.00 | | | | ^ Inventory/Accruals | | SGD | 70.00 | | 70.00 | | | | ||
| - | ^ Purchase Variance | | SGD | 100*1.5+35-70=105 | | 105.00 | | | | + | ^ Purchase Variance | | SGD | 100*1.5+35-70=115 | | 115.00 | | | |
| - | ^ Totals ^ ^ ^ ^ ^ 181.75 ^ 181.75 ^ ^ | + | ^ Totals ^ ^ ^ ^ ^ 191.75 ^ 191.75 ^ ^ |
| - | + | ||
| \\ | \\ | ||
| ====Post Supplier Invoice - Local Purchases==== | ====Post Supplier Invoice - Local Purchases==== | ||
| Line 68: | Line 66: | ||
| //When Country Code of the Business matches that of the Supplier.// | //When Country Code of the Business matches that of the Supplier.// | ||
| - | ^ GL Interface Type/{Account] ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ | + | ^ GL Interface Type/[Account] ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ |
| - | BaseDr ^ BaseCr ^ Notes ^ | + | |
| ^ Accrued Purchases-Supplier | | USD | 100-10=90.00 | | 135.00 | | | | ^ Accrued Purchases-Supplier | | USD | 100-10=90.00 | | 135.00 | | | | ||
| ^ [Accounts Payable] | SUP-000001 | USD | | (100-10)*(100+7)/100=96.30 | | 144.45 | | | ^ [Accounts Payable] | SUP-000001 | USD | | (100-10)*(100+7)/100=96.30 | | 144.45 | | | ||
| ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | ||
| ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | ||
| - | |||
| - | |||
| \\ | \\ | ||
| ====Post Supplier Invoice - Imports==== | ====Post Supplier Invoice - Imports==== | ||
| Line 85: | Line 80: | ||
| ^ [Accounts Payable] | SUP-000001 | USD | | 100-10=90.00 | | 135.00 | | | ^ [Accounts Payable] | SUP-000001 | USD | | 100-10=90.00 | | 135.00 | | | ||
| ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | ||
| - | ^ Contingent Duties | | USD | | (100-10)*7/100=6.30 | | 9.45 | | | + | ^ Taxes/Duties Payable Contra | | USD | | (100-10)*7/100=6.30 | | 9.45 | | |
| ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | ||
/srv/www/htdocs/wiki/data/attic/usage/po2gl.1388899760.txt.gz · Last modified: 2014/01/05 05:29 by asok
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
