<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — Extend for Customer Ledger & Profit Loss Statement with Dimensions]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=8096</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8096&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in Extend for Customer Ledger & Profit Loss Statement with Dimensions.]]></description>
		<lastBuildDate>Mon, 15 Apr 2019 10:47:42 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Extend for Customer Ledger & Profit Loss Statement with Dimensions]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=34668#p34668</link>
			<description><![CDATA[<p>Have been using FA quite long, and tried to have report that generated from FA directly for calculating sales commission based on the payment term,</p><p>as I&#039;m quite knowing for PHP code, but not quite understand to newly generate report in FA, looking for advice</p><p>We want to generate the report as below, required to grab data for the invoice customer and the cogs and cost related to dimensions<br />No.&nbsp; &nbsp; Date&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Invoice#&nbsp; &nbsp; Dimension&nbsp; &nbsp; Customer&nbsp; &nbsp; Description&nbsp; &nbsp;Revenue&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COGS&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cost&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GP&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GP (in %)&nbsp; &nbsp; Payment Term &nbsp; &nbsp; Due Date&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Payment&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Over Due&nbsp; &nbsp; <br />1&nbsp; &nbsp; 8-Jan-2018&nbsp; &nbsp; 137&nbsp; &nbsp; &nbsp; &nbsp; VXXX&nbsp; &nbsp; &nbsp; &nbsp; PT. XXX&nbsp; &nbsp; UPS 650V&nbsp; &nbsp; &nbsp;1,325,454.55 &nbsp; &nbsp;&nbsp; 934,454.56 &nbsp; &nbsp;&nbsp; 100,000.00&nbsp; &nbsp; &nbsp; 290,999.99&nbsp; &nbsp; &nbsp; 28.13%&nbsp; &nbsp; 14 days&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22-Jan-2018&nbsp; &nbsp; 31-Jan-2018&nbsp; &nbsp; 9 days&nbsp; &nbsp; </p><p>No.&nbsp; &nbsp; -&gt; reference counter only<br />Date&nbsp; &nbsp; -&gt; Invoice date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />Invoice#&nbsp; &nbsp; -&gt; Invoice no <br />Dimension&nbsp; &nbsp; -&gt; We tag dimension for transaction (dimension in item, dimension in supplier invoice, dimension in customer invoice, dimension in bank payment) <br />Customer&nbsp; &nbsp; -&gt; Customer name<br />Description&nbsp; &nbsp;-&gt; one of items name <br />Revenue&nbsp; &nbsp;&nbsp; &nbsp; -&gt; total invoice<br />COGS&nbsp; &nbsp;&nbsp; &nbsp; -&gt; total from COGS for the items goods sell&nbsp; &nbsp; &nbsp; <br />Costs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt; cost related from &quot;Bank Payment&quot; that we tag through Dimension<br />GP&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -&gt; Profit<br />GP (in %)&nbsp; &nbsp;&nbsp; &nbsp; -&gt; Profit %<br />Payment Term -&gt; Payment term in the customer information &nbsp; &nbsp; <br />Due Date&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;-&gt; Due Date in Customer Invoice&nbsp; <br />Payment&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;-&gt; Payment Date<br />Over Due&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&gt; show duration for Payment Date - Due Date</p><p>with this report (able to export to spreadsheet) we can calculate more flexible in spreadsheet for sales commission percentage depend on the payment date</p><p>checking from FA extension this should can be basis report<br />https://github.com/apmuthu/FA24extensions/tree/master/Extensions/rep_customer_ledger</p><p>secondly:<br />checking with https://github.com/apmuthu/FA24extensions/tree/master/Extensions/pl_dimension<br />and Report &amp; Analysis, that already can printed Profit Loss Statement with Dimension, <br />do this can be print dimension more than once, from &quot;Dimension A&quot; to &quot;Dimension Z&quot;</p><p>please advice, or this should posting in Jobs wanted/offered, non-free offers, pls give us quote.<br />thanks</p>]]></description>
			<author><![CDATA[null@example.com (ichtus)]]></author>
			<pubDate>Mon, 15 Apr 2019 10:47:42 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=34668#p34668</guid>
		</item>
	</channel>
</rss>
