usage:po2gl
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
usage:po2gl [2014/01/04 17:06] 127.0.0.1 external edit |
usage:po2gl [2015/03/23 12:11] (current) mueed old revision restored (2014/07/12 02:33) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| 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==== | ||
| + | |||
| When a GRN is confirmed, the following accounting entries are created | When a GRN is confirmed, the following accounting entries are created | ||
| ^ 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==== | ||
| + | |||
| When a Supplier Invoice is posted, either from GRN or Payment Milestones, the following accounting entries are created. | When a Supplier Invoice is posted, either from GRN or Payment Milestones, the following accounting entries are created. | ||
| Line 23: | 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==== | ||
| + | |||
| When a Supplier Invoice is posted, either from GRN or Payment Milestones, the following accounting entries are created. | When a Supplier Invoice is posted, either from GRN or Payment Milestones, the following accounting entries are created. | ||
| Line 32: | 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 40: | 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 47: | 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 ^ BaseDr ^ BaseCr ^ Notes ^ | + | ^ GL Interface Type/[Account] ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ 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==== | ||
| //When Country Code of the Business DOES NOT match that of the Supplier.// | //When Country Code of the Business DOES NOT match that of the Supplier.// | ||
| Line 73: | 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.1388855190.txt.gz · Last modified: 2014/01/05 05:24 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
