usage:op2gl
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
usage:op2gl [2014/07/12 02:35] julie [Post Sales Invoice - Exports] |
usage:op2gl [2014/07/13 11:15] (current) julie [Confirm DO] |
||
|---|---|---|---|
| Line 58: | Line 58: | ||
| ^ Cost of Sales | | SGD | 40.00 | | 40.00 | | | | ^ Cost of Sales | | SGD | 40.00 | | 40.00 | | | | ||
| ^ Cost of Sales Variance | | SGD | 20.00 | | 20.00 | | | | ^ Cost of Sales Variance | | SGD | 20.00 | | 20.00 | | | | ||
| - | ^ Inventory | | SGD | | 60.00 | | 60.00 | | | + | ^ Inventory | | SGD | | 60.00 | | 60.00| | |
| - | ^ Totals ^ ^ ^ ^ ^ 60.00^ 60.00^ ^ | + | ^ Totals ^ ^ ^ ^ ^ 60.00 ^ 60.00^ ^ |
| \\ | \\ | ||
| ====Post Sales Invoice - Local==== | ====Post Sales Invoice - Local==== | ||
| ^ GL Interface Type ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | ^ GL Interface Type ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | ||
| - | ^ Commission (Pay) | | SGD | (100-10)*5/100=4.50 | | 4.50 | | | | + | ^ Commission (Pay) | | SGD | (100-10)*5/100=4.50 | | 4.50 | | | |
| ^ Trade Creditor-Control A/C |AP | SGD | | (100-10)*5/100=4.50 | | 4.50 | | | ^ Trade Creditor-Control A/C |AP | SGD | | (100-10)*5/100=4.50 | | 4.50 | | | ||
| - | ^ Sales Discount | | SGD | (100*10)/100=10.00 | | 10.00 | | | | + | ^ Sales Discount | | SGD | (100*10)/100=10.00 | | 10.00 | | | |
| - | ^ Sales | | SGD | 100.00 | | | 100.00| | | + | ^ Sales | | SGD | 100.00 | | | 100.00| | |
| - | ^ Trade Debtor-Control A/C | | SGD | (100-10) + 7/100 +90 =96.3 | | 96.30 | | | | + | ^ Trade Debtor-Control A/C | AR | SGD | (100-10) + 7/100 +90 =96.3 | | 96.30 | | | |
| - | ^ GST Output Tax (Sales) | | SGD | (100-10)*7/100=6.30 | | | 6.30 | | | + | ^ GST Output Tax (Sales) | | SGD | (100-10)*7/100=6.30| | | 6.30 | | |
| ^ Totals ^ ^ ^ ^ ^ 110.80 ^ 110.80^ ^ | ^ Totals ^ ^ ^ ^ ^ 110.80 ^ 110.80^ ^ | ||
| \\ | \\ | ||
| Line 76: | Line 76: | ||
| Export Sales: Say, SalesPrice=USDD100, ExchangeRate=1.5 BaseCurrency=SGD, Discount=SGD10.00 Commission=5%, Agent=SUP-000001. Stock Item StandardCost=SGD40.00, ActualCost=SGD60.00 and TaxRate=7% | Export Sales: Say, SalesPrice=USDD100, ExchangeRate=1.5 BaseCurrency=SGD, Discount=SGD10.00 Commission=5%, Agent=SUP-000001. Stock Item StandardCost=SGD40.00, ActualCost=SGD60.00 and TaxRate=7% | ||
| - | The generated vouchers will contain: | + | The generated vouchers will contain: |
| - | //When Country Code of the Business matches that of the Supplier.// | + | ====Confirm DO==== |
| - | ^ GL Interface Type/[Account] ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | + | ^ GL Interface Type ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ |
| - | ^ Accrued Purchases-Supplier | | USD | 100-10=90.00 | | 135.00 | | | | + | ^ Cost of Sales | | SGD | 40.00 | | 40.00 | | | |
| - | ^ [Accounts Payable] | SUP-000001 | USD | | (100-10)*(100+7)/100=96.30 | | 144.45 | | | + | ^ Cost of Sales Variance | | SGD | 20.00 | | 20.00 | | | |
| - | ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | + | ^ Inventory | | SGD | | 60.00 | | 60.00 | | |
| - | ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | + | ^ Totals ^ ^ ^ ^ ^ 60.00^ 60.00^ ^ |
| \\ | \\ | ||
| - | ====Post Supplier Invoice - Imports==== | ||
| - | //When Country Code of the Business DOES NOT match that of the Supplier.// | ||
| - | ^ GL Interface Type/{Account] ^ Sub-account ^ Currency ^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ | + | ====Post Sales Invoice - Exports==== |
| - | ^ Accrued Purchases-Supplier | | USD | 100-10=90.00 | | 135.00 | | | | + | |
| - | ^ [Accounts Payable] | SUP-000001 | USD | | 100-10=90.00 | | 135.00 | | | + | ^ GL Interface Type ^ Sub-account ^ Currency ^ExchRate^ PrimeDr ^ PrimeCr ^ BaseDr ^ BaseCr ^ Notes ^ |
| - | ^ [Tax] | | USD | (100-10)*7/100=6.30 | | 9.45 | | | | + | ^ Commission (Pay) | | USD |1.50 | (100.00-10.00)*5/100=4.50 | | 6.75 | | | |
| - | ^ Taxes/Duties Payable Contra | | USD | | (100-10)*7/100=6.30 | | 9.45 | | | + | ^ Trade Creditor-Control A/C |AP | USD |1.50| | (100-10)*5/100=4.50 | | 6.75 | | |
| - | ^ Totals ^ ^ ^ ^ ^ 144.45 ^ 144.45 ^ ^ | + | ^ Sales Discount | | USD | 1.50| (100.00*10)/100=10.00 | | 15.00 | | | |
| + | ^ Sales-Exports | | USD | 1.50| |100.00 | | 150.00| | | ||
| + | ^ Trade Debtor-Control A/C |AR | USD | 1.50|(100.00-10.00)=90.00 | | 135.00 | | | | ||
| + | ^ GST Output Tax (Sales) | | | | | | | | | | ||
| + | ^ Totals ^ ^ ^ ^ ^ ^ 156.75^ 156.75^ ^ | ||
| + | |||
| + | \\ | ||
/srv/www/htdocs/wiki/data/attic/usage/op2gl.1405132521.txt.gz · Last modified: 2014/07/12 02:35 by julie
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
