<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — Match SO and Invoice numbers?]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8191&amp;type=atom" />
	<updated>2019-07-04T04:19:45Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8191</id>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35372#p35372" />
			<content type="html"><![CDATA[<div class="quotebox"><cite>poncho1234 wrote:</cite><blockquote><p>the only thing I can think of is that you have in a previous direct invoice changed the Reference: manually?</p></blockquote></div><p>Maybe? Thinking the reverse of this would solve my issue I followed a simplified version of your instructions ... backed up, manually incremented the reference in a live invoice and processed it, printed a statement and ... back on track!!</p><p>I must have backed that up one number thinking I would fix an invoice. So I incremented it to match the expected number on the statement and it did.</p><p>Odd, changing the reference to {100} did NOT change the invoice number ...</p><p>Thanks, I&#039;m able to match invoice numbers on my statements now and that&#039;s what I needed.</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-07-04T04:19:45Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35372#p35372</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35190#p35190" />
			<content type="html"><![CDATA[<p>Hi, the only thing I can think of is that you have in a previous direct invoice changed the Reference: manually?<br />This is not advisable.</p><p>So try the following:-</p><p>1. <strong>Most importantly - Create a backup</strong><br />2. Find the highest invoice number used so far, lets say its 961<br />3. Got to Setup-Transaction References.<br />4. Edit the Sales Invoice number to read {962} (If you&#039;re not bothered about missing invoice numbers, then change it to 971 as long its a higher number)<br />5. Now create some made up invoices for various customers - They should all start from the number(or number +1)you entered.</p><p>Do the reference numbers for these <strong>new</strong> invoices now match up from a statement?</p><p>If yes then restore the backup you made in step one and make the changes to the transaction ref</p><p><strong>Please note this will not change any previous reference numbers, just new invoices</strong> To change existing invoice reference numbers you would have to edit the database manually; which is unadvisable unless you really know what you are doing.</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2019-06-14T16:38:54Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35190#p35190</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35188#p35188" />
			<content type="html"><![CDATA[<p>Sorry it took me a while to do this in a way that it doesn&#039;t expose data.</p><p>See<br /><a href="http://technicavolous.com/fa/lvcstatement_edited.pdf">Statement</a> <br />against<br /><a href="http://technicavolous.com/fa/lvcinvoices_edited.pdf">Invoices</a></p><p>I can&#039;t use the statement as the invoice numbers on it are one number off from the number on the invoice itself. </p><p>Screenshots of what section in FA would be helpful next?? I&#039;m baffled by this behavior and trying to figure out what I did wrong. I don&#039;t really care about work order, sales order and invoice number matching, but the invoice number on the statement HAS to match the invoice number on the invoice.</p><p>??</p><p>Thanks in advance</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-06-14T15:10:12Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35188#p35188</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35119#p35119" />
			<content type="html"><![CDATA[<p>Please send some screenshots of the issue and some more detail.</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2019-06-07T18:15:31Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35119#p35119</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35118#p35118" />
			<content type="html"><![CDATA[<p>The problem manifests itself when I send a statement. &quot;Outstanding Transactions&quot; shows a list of &quot;Sales Invoice&quot; numbers. But those numbers are off from the numbers on the Sales Invoices I sent them previously ...</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-06-07T18:11:07Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35118#p35118</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35109#p35109" />
			<content type="html"><![CDATA[<p>Have you voided an invoice? Sure you have not done a sales order?</p><p>At some point, depending on what you have done they will not match, the reference number is different to the system number.<br /><strong>The reference number is your unique number/ value for each transaction:</strong> But the system needs a unique number too - <br /><a href="https://frontaccounting.com/punbb/viewtopic.php?pid=32931#p32931"> read here</a> and<br /><a href="https://frontaccounting.com/punbb/viewtopic.php?id=7870"> also read this topic.</a></p><p><strong>So in all the inquiries, use the &#039;Reference&#039; column to find the right transaction,</strong> from there you can see the sys# or order# related to your reference number and then for further investigation if required. (so for the moment ignore sys#, order# look for your unique reference number)</p><p>Yes using a &quot;Direct Invoice&quot; does create &#039;background&#039; transactions<br />Have a good read about:-</p><p>Simple Sales Process<br />Intermediate Sales Process<br />Complex Sales Process<br /><a href="https://frontaccounting.com/fawiki/index.php?n=Help.Sales">here</a> and the related linked pages</p><p>You can &#039;reset&#039; the reference number in Setup-&gt;Transaction References, but at some point they will go out of synch again so not advised. </p><p>Best advice for a FA beginner is to setup a training company, try things out on there; along with a good read of wiki and this forum, using the training company you can make as many mistakes as you like.</p><p>If you are doing something you are not quite sure about on your actual accounts, always make a backup 1st.</p><p>There&#039;s also some links to learn the basics of accountancy in the wiki as well</p>]]></content>
			<author>
				<name><![CDATA[poncho1234]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=19944</uri>
			</author>
			<updated>2019-06-04T23:34:24Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35109#p35109</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Match SO and Invoice numbers?]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35108#p35108" />
			<content type="html"><![CDATA[<p>I&#039;m not understanding what I may have done to have my SO numbers not match my Invoice numbers and it&#039;s driving me nuts. If I send a Statement to one of my customers the numbers seem to be wrong.</p><p>I&#039;ve been using &quot;Direct Invoice&quot; to bill my customer and I think it automatically creates a SO and a Delivery Note? But the numbers do not match.</p><p>What should I set up or correct to get the SO and Invoice numbers to match up?&nbsp; What other information should I post to give the info you need to help ...</p><p>Love the package, but I&#039;m no where near an accountant and have probably muxed something up.</p><p>Thanks in advance for any pointers advice or help.<br />Tracy</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-06-04T22:48:22Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35108#p35108</id>
		</entry>
</feed>
