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:24] asok |
usage:po2gl [2015/03/23 12:11] (current) mueed old revision restored (2014/07/12 02:33) |
||
|---|---|---|---|
| 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==== | ||
| //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.1388899494.txt.gz · Last modified: 2014/01/05 05:24 by asok
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
