23 | NetSuiteSalesExport (Custom Report)

Learn how to demonstrates an example of a Custom NetSuite Sales Export Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

This article demonstrates an example of a Custom NetSuite Sales Export Report.

Disclaimer:

This report may need modifications or alterations base on each system setup and configuration.

Report Query:

<?xml version="1.0" encoding="utf-8"?>

<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<iListType>25</iListType>

<dtDateUpdated>2012-07-10T11:27:17</dtDateUpdated>

<iOperatorID>0</iOperatorID>

<sName>C:\BEpoz\NetSuite\SExport.csv</sName>

<sViewXML><?xml version="1.0" encoding="utf-16"?><cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><sReportName>NetSuite Export</sReportName><sSQL>SELECT CONVERT(varchar(10), Transactions.DateTimeTrans, 103) AS Date, CONVERT(varchar(10), Transactions.DateTimeTrans, 108) AS Time, Transactions.TransactionID, Transactions.TillID, Store.Name AS Store, Workstation.Name AS TillName,Operator.OpNumber, Operator.FirstName AS OpName, Product.ProdNumber, 'Size' = Case When TransLines.Size = 1 then Product.SizeName_1 When TransLines.Size = 2 then Product.SizeName_2 When TransLines.Size = 3 then Product.SizeName_3 When TransLines.Size = 4 then Product.SizeName_4 When TransLines.Size = 5 then Product.SizeName_5 When TransLines.Size = 6 then Product.SizeName_6 When TransLines.Size = 7 then Product.SizeName_7 When TransLines.Size = 8 then Product.SizeName_8 When TransLines.Size = 9 then Product.SizeName_9 When TransLines.Size = 10 then Product.SizeName_10 else 'UNDEFINED' END, 'SizeDetail' = Case When Product.SizeStockType_1 = 0 then cast(Product.SizeQty_1 as char (3))+ 'Items' When Product.SizeStockType_1 = 1 then cast(Product.SizeQty_1 as char (3))+ 'Mills' When Product.SizeStockType_1 = 2 then cast(Product.SizeQty_1 as char (3))+ 'Grams' When Product.SizeStockType_2 = 0 then cast(Product.SizeQty_2 as char (3))+ 'Items' When Product.SizeStockType_2 = 1 then cast(Product.SizeQty_2 as char (3))+ 'Mills' When Product.SizeStockType_2 = 2 then cast(Product.SizeQty_2 as char (3))+ 'Grams' When Product.SizeStockType_3 = 0 then cast(Product.SizeQty_3 as char (3))+ 'Items' When Product.SizeStockType_3 = 1 then cast(Product.SizeQty_3 as char (3))+ 'Mills' When Product.SizeStockType_3 = 2 then cast(Product.SizeQty_3 as char (3))+ 'Grams' When Product.SizeStockType_4 = 0 then cast(Product.SizeQty_4 as char (3))+ 'Items' When Product.SizeStockType_4 = 1 then cast(Product.SizeQty_4 as char (3))+ 'Mills' When Product.SizeStockType_4 = 2 then cast(Product.SizeQty_4 as char (3))+ 'Grams' When Product.SizeStockType_5 = 0 then cast(Product.SizeQty_5 as char (3))+ 'Items' When Product.SizeStockType_5 = 1 then cast(Product.SizeQty_5 as char (3))+ 'Mills' When Product.SizeStockType_5 = 2 then cast(Product.SizeQty_5 as char (3))+ 'Grams' When Product.SizeStockType_6 = 0 then cast(Product.SizeQty_6 as char (3))+ 'Items' When Product.SizeStockType_6 = 1 then cast(Product.SizeQty_6 as char (3))+ 'Mills' When Product.SizeStockType_6 = 2 then cast(Product.SizeQty_6 as char (3))+ 'Grams' When Product.SizeStockType_7 = 0 then cast(Product.SizeQty_7 as char (3))+ 'Items' When Product.SizeStockType_7 = 1 then cast(Product.SizeQty_7 as char (3))+ 'Mills' When Product.SizeStockType_7 = 2 then cast(Product.SizeQty_7 as char (3))+ 'Grams' When Product.SizeStockType_8 = 0 then cast(Product.SizeQty_8 as char (3))+ 'Items' When Product.SizeStockType_8 = 1 then cast(Product.SizeQty_8 as char (3))+ 'Mills' When Product.SizeStockType_8 = 2 then cast(Product.SizeQty_8 as char (3))+ 'Grams' When Product.SizeStockType_9 = 0 then cast(Product.SizeQty_9 as char (3))+ 'Items' When Product.SizeStockType_9 = 1 then cast(Product.SizeQty_9 as char (3))+ 'Mills' When Product.SizeStockType_9 = 2 then cast(Product.SizeQty_9 as char (3))+ 'Grams' When Product.SizeStockType_10 = 0 then cast(Product.SizeQty_10 as char (3))+ 'Items' When Product.SizeStockType_10 = 1 then cast(Product.SizeQty_10 as char (3))+ 'Mills' When Product.SizeStockType_10 = 2 then cast(Product.SizeQty_10 as char (3))+ 'Grams' else 'UNDEFINED' END, Barcode.Barcode, Product.Name AS ProdDesc, Product.ProdType, TransLines.UnitqtySold, TransLines.Gross, (TransLines.NettTotal/(TransLines.UnitqtySold)*100) as NettExEach, 'TaxType' = Case When Translines.TaxType = 1 then 'GST10' When Translines.TaxType = 0 then 'GSTFR' else 'UNDEFINED' END, TransLines.Nett / CONVERT(decimal(9, 4), 100) - TransLines.NettTotal AS GSTAmount,'Payments' = Case When(TransPayments.PaymentType = 1 and TransPayments.TypeItem = 0) then Venue.Cashname When(TransPayments.PaymentType = 2 and TransPayments.TypeItem = 0) then Venue.EFTPOSName When(TransPayments.PaymentType = 3 and TransPayments.TypeItem = 0) then 'Cheque' When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 1) then Venue.CardName_1 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 2) then Venue.CardName_2 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 3) then Venue.CardName_3 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 4) then Venue.CardName_4 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 5) then Venue.CardName_5 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 6) then Venue.CardName_6 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 7) then Venue.CardName_7 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 8) then Venue.CardName_8 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 9) then Venue.CardName_9 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 10) then Venue.CardName_10 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 11) then Venue.CardName_11 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 12) then Venue.CardName_12 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 13) then Venue.CardName_13 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 14) then Venue.CardName_14 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 15) then Venue.CardName_15 When(TransPayments.PaymentType = 4 and TransPayments.TypeItem = 16) then Venue.CardName_16 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 1) then Venue.CurrName_1 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 2) then Venue.CurrName_2 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 3) then Venue.CurrName_3 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 4) then Venue.CurrName_4 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 5) then Venue.CurrName_5 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 6) then Venue.CurrName_6 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 7) then Venue.CurrName_7 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 8) then Venue.CurrName_8 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 9) then Venue.CurrName_9 When(TransPayments.PaymentType = 5 and TransPayments.TypeItem = 10) then Venue.CurrName_10 When(TransPayments.PaymentType = 16 and TransPayments.TypeItem = 0) then 'Account Charge' else 'UNDEFINED' END, Account.AccNumber FROM Transactions INNER JOIN

TransLines ON Transactions.TransactionID = TransLines.TransactionID INNER JOIN

TransPayments ON TransLines.TransactionID = TransPayments.TransactionID INNER JOIN

Workstation ON Transactions.TillID = Workstation.WorkstationID INNER JOIN

Operator ON Transactions.OperatorID = Operator.OperatorID INNER JOIN

Product ON TransLines.ProductId = Product.ProductID INNER JOIN

Store ON Workstation.StoreID = Store.StoreID LEFT OUTER JOIN

Venue ON Transactions.VenueID = Venue.VenueID FULL OUTER JOIN

Barcode ON TransLines.ProductId = Barcode.ProductID FULL OUTER JOIN

Account ON Transactions.AccountID = Account.AccountID where transactions.shiftid &gt;= {ShiftFrom} and transactions.shiftid &lt;= {ShiftTo}

and transpayments.paymenttype &lt;&gt; 15 and transpayments.paymenttype &lt;&gt; 14</sSQL><oColumnDefs><dictionary><item><key>0</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;0&lt;/sKey&gt;&lt;sText&gt;Date&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>1</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;1&lt;/sKey&gt;&lt;sText&gt;Time&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>2</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;2&lt;/sKey&gt;&lt;sText&gt;TransID&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>3</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;3&lt;/sKey&gt;&lt;sText&gt;TillID&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>4</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;4&lt;/sKey&gt;&lt;sText&gt;Store&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>5</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;5&lt;/sKey&gt;&lt;sText&gt;Till Name&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>6</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;6&lt;/sKey&gt;&lt;sText&gt;OperatorNum&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>7</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;7&lt;/sKey&gt;&lt;sText&gt;OperatorName&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>8</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;8&lt;/sKey&gt;&lt;sText&gt;ProductCode&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>9</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;9&lt;/sKey&gt;&lt;sText&gt;SizeName&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>10</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;10&lt;/sKey&gt;&lt;sText&gt;SizeDetail&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;StockType&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>11</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;11&lt;/sKey&gt;&lt;sText&gt;Barcode&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>12</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;12&lt;/sKey&gt;&lt;sText&gt;ProdDesc&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>13</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;13&lt;/sKey&gt;&lt;sText&gt;Type&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;Type&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>14</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;14&lt;/sKey&gt;&lt;sText&gt;Qty&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Dec2Int&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>15</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;15&lt;/sKey&gt;&lt;sText&gt;Gross&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;CurrInt&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>16</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;16&lt;/sKey&gt;&lt;sText&gt;NettExEach&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;CurrDbl&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>17</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;17&lt;/sKey&gt;&lt;sText&gt;TaxCode&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>18</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;18&lt;/sKey&gt;&lt;sText&gt;TaxAmount&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;CurrDbl&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>19</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;19&lt;/sKey&gt;&lt;sText&gt;PaymentType&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;PaymentNamex100&lt;/eList&gt;&lt;/cColInfo&gt;</value></item><item><key>20</key><type>Xfer.cColInfo</type><value>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cColInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sKey&gt;20&lt;/sKey&gt;&lt;sText&gt;AccountNum&lt;/sText&gt;&lt;Hidden&gt;No&lt;/Hidden&gt;&lt;Read_only&gt;Yes&lt;/Read_only&gt;&lt;Total&gt;No&lt;/Total&gt;&lt;FixedColumn&gt;No&lt;/FixedColumn&gt;&lt;ParentCol&gt;No&lt;/ParentCol&gt;&lt;eFormat&gt;Text&lt;/eFormat&gt;&lt;eList&gt;None&lt;/eList&gt;&lt;/cColInfo&gt;</value></item></dictionary></oColumnDefs></cCustomReport></sViewXML>

</cViews>

Other Parameter Settings:

This file needs to be saved as a *.REP file using a document editor

23 | NetSuiteSalesExport (Custom Report)

Learn how to demonstrates an example of a Custom NetSuite Sales Export Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.

Disclaimer:

Report Query:

<?xml version="1.0" encoding="utf-8"?>

<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<iListType>25</iListType>

<dtDateUpdated>2012-07-10T11:27:17</dtDateUpdated>

<iOperatorID>0</iOperatorID>

<sName>C:\BEpoz\NetSuite\SExport.csv</sName>

TransLines ON Transactions.TransactionID = TransLines.TransactionID INNER JOIN

TransPayments ON TransLines.TransactionID = TransPayments.TransactionID INNER JOIN

Workstation ON Transactions.TillID = Workstation.WorkstationID INNER JOIN

Operator ON Transactions.OperatorID = Operator.OperatorID INNER JOIN

Product ON TransLines.ProductId = Product.ProductID INNER JOIN

Store ON Workstation.StoreID = Store.StoreID LEFT OUTER JOIN

Venue ON Transactions.VenueID = Venue.VenueID FULL OUTER JOIN

Barcode ON TransLines.ProductId = Barcode.ProductID FULL OUTER JOIN

Account ON Transactions.AccountID = Account.AccountID where transactions.shiftid &amp;gt;= {ShiftFrom} and transactions.shiftid &amp;lt;= {ShiftTo}

</cViews>

Other Parameter Settings:

This file needs to be saved as a *.REP file using a document editor

Account ON Transactions.AccountID = Account.AccountID where transactions.shiftid >= {ShiftFrom} and transactions.shiftid <= {ShiftTo}