Follow

Formatting mask Purveyor order

When you use the supplier to supplier module, inONE will process the orders from the purveyor digitally and convert those to sales orders and provide you with a packinslip

 

Principles purveyor order format:

  • All purveyororders are placed on a FTP folder provided bij inONE
  • One order per file with the name: debitorname_dd-mm-yyyy-mm-ss.csv
  • You can supply 1 debitnumber for "unknown" debitors (standard 9999)
  • Orderfile can be supplied in CSV or XML

 

Content order header:

OH;

Customername;

Debitnumber customer;

customernumber purveyor (optional)

Deliverydate;

Buyerordernumber;

Reference (optional);

 

Content Orderline:

OL;

Articlenumber;

articlenumber purveyor;

amount;

portioning;

linecomment;

 

Content Ordertext:

OT;

Rowcomment;

 

CSV Example File

OH;Restaurant Mill;48666;30-10-2014;29-10-2014;1432943;897

OL;1432943;30355;2,5;Kg;0;123,00;Vacumated;

OL;1432943;46260;8;Stuk;0;123,00;Per 5;

OL;1432943;46261;5;Gr/portie;180;;

OT; Key below mat;

 

XML Example file

 

<?xml version="1.0" encoding="UTF-8"?>
 <order>
	<orderid>QSUFG2-1</orderid>
	<deliverydate>08-04-2016</deliverydate>
	<creationdate>07-10-2016 10:23:22</creationdate>
	<supplierid>SMWTY3</supplierid>
	<suppliername>Smit en Dorlas</suppliername>
	<buyerid>QSUFG2</buyerid>
	<buyername>IND Kantoor Zwolle</buyername>
	<debitorid>1000099</debitorid>
	<totalorderprice>70,90</totalorderprice>
	<remark><![CDATA[]]></remark>
	<orderrow>
		<productid>101000</productid>
		<productname>Smit en Dorlas Special</productname>
		<productunit>Stuk</productunit>
		<productportion></productportion>
		<quantity>1</quantity>
		<productprice>12,95</productprice>
		<productrowprice>12,95</productrowprice>
		<rowremark><![CDATA[-]]></rowremark>
	</orderrow>
	<orderrow>
		<productid>201003</productid>
		<productname>Kaldi After Dinner</productname>
		<productunit>Stuk</productunit>
		<productportion></productportion>
		<quantity>2</quantity>
		<productprice>10,00</productprice>
		<productrowprice>20,00</productrowprice>
		<rowremark><![CDATA[-]]></rowremark>
	</orderrow>
	<orderrow>
		<productid>300253</productid>
		<productname>Kaldi Barista Blend 250</productname>
		<productunit>Stuk</productunit>
		<productportion></productportion>
		<quantity>3</quantity>
		<productprice>12,65</productprice>
		<productrowprice>37,95</productrowprice>
		<rowremark><![CDATA[-]]></rowremark>
	</orderrow>
 </order>

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk