<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — How to manage local expenses related to international purchase invoice]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=8552</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8552&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in How to manage local expenses related to international purchase invoice.]]></description>
		<lastBuildDate>Thu, 12 Dec 2019 01:47:10 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36594#p36594</link>
			<description><![CDATA[<p>@joe &amp; @itronics will surely find a way forward in FA 2.5 which will probably get released in a few months/years unless someone is willing to sponsor development in that direction to hasten the pace of development. This will certainly take into account your suggestions as well.</p><p>Other topics that discuss this issue are:<br /><a href="https://frontaccounting.com/punbb/viewtopic.php?id=8104">Cost Of Service in FA 2.4.6 only after Sales Invoice posting</a><br /><a href="https://frontaccounting.com/punbb/viewtopic.php?id=7149">Handling, Shipping &amp; Clearance</a><br /><a href="https://frontaccounting.com/punbb/viewtopic.php?id=3320">Landed Costing of Inventory Items</a></p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Thu, 12 Dec 2019 01:47:10 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36594#p36594</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36584#p36584</link>
			<description><![CDATA[<p>@apmuthu, @joe<br />What about the suggestion I have given above?</p><div class="quotebox"><blockquote><p><strong>My Suggestion:</strong><br />At Purchase Invoice, where we can add GL Items. What if their would-be checkbox that can tell either expenses are paid by supplier company or by buying company, if these expenses are paid by the supplier company then the functionality would be same as in current version, but if expenses are paid by buying company then it needs some functionality as follow.</p><p>All expenses are added using GL Items section at Purchase Invoice, and once the Purchase Invoice is proceeded by user, the total payment of items will be in Supplier company account, and GL Items amount will be with relative GL Account, and if we want to check the purchase invoice for cost calculation, we could see those expenses with purchase invoice as well.</p></blockquote></div>]]></description>
			<author><![CDATA[null@example.com (mr.murtaza.abbasi)]]></author>
			<pubDate>Tue, 10 Dec 2019 07:38:48 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36584#p36584</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36581#p36581</link>
			<description><![CDATA[<p>The Wiki and the Forum are the best places to search for &quot;Documentation&quot;.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Tue, 10 Dec 2019 04:56:30 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36581#p36581</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36575#p36575</link>
			<description><![CDATA[<p>Thanks to both of you,<br />I&#039;ve one suggestion for you. </p><p>At Purchase Invoice, where we can add GL Items. What if their would-be checkbox that can tell either expenses are paid by supplier company or by buying company, if these expenses are paid by the supplier company then the functionality would be same as in current version, but if expenses are paid by buying company then it needs some functionality as follow.</p><p>All expenses are added using GL Items section at Purchase Invoice, and once the Purchase Invoice is proceeded by user, the total payment of items will be in Supplier company account, and GL Items amount will be with relative GL Account, and if you want to check the purchase invoice we could see those expenses as well.</p><p>I&#039;m kind of amateur to Back-end programming but here is my idea.<br />You will have to relate GL Account Transaction row with purchase invoice using the foreign key, so every time we try to open the same purchase invoice, the query will also fetch the GL Item transactions related to the purchase invoice.</p><p>I might start playing with FrontAccounting once I learn the back-end, database structure of FrontAccounting. If you can guide me where I can get Documentation for making changes in core functionality or creating Addons or themes, that would be really helpful.</p>]]></description>
			<author><![CDATA[null@example.com (mr.murtaza.abbasi)]]></author>
			<pubDate>Mon, 09 Dec 2019 08:56:16 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36575#p36575</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36567#p36567</link>
			<description><![CDATA[<p>Thanks @joe.</p><p>How do we propose to handle it in FA 2.5? Additional fields or addition line items to Purchase Invoice as re-imbursables or onsite payables to third parties?</p><p>The said link in the post above is PDFed here.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 07 Dec 2019 16:16:19 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36567#p36567</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36566#p36566</link>
			<description><![CDATA[<p>I have no straight solutions. We have been discussing the so called landed costs over the years. You can search the forums for &#039;landed cost&#039; or something like that.</p><p>I found a QuickBook discussion about the subject.</p><p><a href="https://quickbooks.intuit.com/learn-support/en-ca/do-more-with-quickbooks/how-do-you-add-additional-costs-to-inventory-items-e-g-duty-and/00/261126">https://quickbooks.intuit.com/learn-sup … /00/261126</a></p><p>Maybe this info can be of interest.</p><p>Joe</p>]]></description>
			<author><![CDATA[null@example.com (joe)]]></author>
			<pubDate>Sat, 07 Dec 2019 16:01:00 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36566#p36566</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36565#p36565</link>
			<description><![CDATA[<p>FA 2.5 may have some straight forward ways to do this.<br />@joe: any workarounds for now?</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 07 Dec 2019 12:32:45 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36565#p36565</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36564#p36564</link>
			<description><![CDATA[<p>Thanks <em>apmuthu</em>,<br />I&#039;m sorry to say but I still don&#039;t understand your response. I would like to tell you that before posting this question here, I tried to find the solution on this forum and tried to google it and found that there is no straight method in front-accounting. </p><p>This is what I think;<br />At <em>Purchase Invoice</em>, the <strong>GL Items</strong> are entirely related to supplier company, i.e if supplier company is paying all VAT expenses, and if I add these expenses at GL Items on Purchase Invoice, it will be like <em>&quot;Item 1 Total + Item 2 Total + VAT + Freight = Total Purchase Invoice&quot;</em>, it will be straight and proper way <strong>BUT</strong> if WE are paying further expenses <em>(i.e. Freight, VAT...)</em> then we can&#039;t add them in GL Items of Purchase Invoice. </p><p>I think of two methods;<br /></p><ul><li><p>We will have to do a manual calculation on Excel and add them quantity-wise on the purchase invoice, but this is the worst method because we won&#039;t know the expense type and expense amount.</p></li><li><p>We will create Account for all expenses <em>(i.e. Freight Expenses, Agent Expense...)</em> and then once we create a purchase invoice, we will have the invoice reference number and add it in the memo of journal entries of all expenses so that we can know the expense type and amount.</p></li></ul>]]></description>
			<author><![CDATA[null@example.com (mr.murtaza.abbasi)]]></author>
			<pubDate>Sat, 07 Dec 2019 10:10:48 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36564#p36564</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36561#p36561</link>
			<description><![CDATA[<p>Your supplier company&#039;s account is in USD<br />Your home currency is PKR<br />Purchase Invoice is in USD and needs to be settled in USD at a specific exchange rate.<br />Your local expenses are in PKR<br />Make the entry to be:</p><p>By Supplier Company Invoice Cr. USD 100<br />By Local Expenses on Supplier Invoice Cr. PKR 25<br />To Purchases Dr. (USD 100 converted to PKR + PKR 25)</p><p>This should make sure the inventory Qty is properly costed including the local expenses.</p><p>Anyone know of a better idea?</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Fri, 06 Dec 2019 13:46:42 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36561#p36561</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36560#p36560</link>
			<description><![CDATA[<p>Do you mean to convert the expenses from local currency (i.e. PKR) into the Company&#039;s Currency (i.e. USDollar) and add them <strong> GL Items</strong> at <strong>Purchase Invoice</strong>, if that&#039;s what you mean then the expenses will be added in company ledger which we don&#039;t want because these expenses are paid by us.</p>]]></description>
			<author><![CDATA[null@example.com (mr.murtaza.abbasi)]]></author>
			<pubDate>Fri, 06 Dec 2019 10:54:50 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36560#p36560</guid>
		</item>
		<item>
			<title><![CDATA[Re: How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36556#p36556</link>
			<description><![CDATA[<p>Convert to local currency and then enter the expense and the supplier account will have differences in exchange rate gain/loss that gets adjusted with exchange rate on prevailing date entered.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Fri, 06 Dec 2019 05:14:33 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36556#p36556</guid>
		</item>
		<item>
			<title><![CDATA[How to manage local expenses related to international purchase invoice]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=36552#p36552</link>
			<description><![CDATA[<p>We are facing this hurdle, as mentioned in the topic title.<br />On Purchase, where we mentioned the item, further expenses (i.e. freight charges...) can be added, but this is where the problem starts. </p><p>First,<br />We, most of the time pay taxes, freight charges in the local currency, but in Purchase Invoice, we can only add those expenses in that company&#039;s currency which is different from the local currency.</p><p>Second,<br />Adding those expenses will be added in the company general ledger account and it affects the report because those expenses are paid by us not by that company from which we are purchasing.</p><p>Let me know how to handle this thing.</p>]]></description>
			<author><![CDATA[null@example.com (mr.murtaza.abbasi)]]></author>
			<pubDate>Thu, 05 Dec 2019 09:45:26 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=36552#p36552</guid>
		</item>
	</channel>
</rss>
