Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Sales export (2010.2)
I need to export sales from some date. I use v. 2010.2.
Information I need is:
1) List of the items:
Id = internalId,
Name = itemId
2) List of sales:
TransactionDate = tranDate,
Quantity = quantity,
UniqueId = TranInternalId + "." + line + "." + item.InternalId
And I also query for the type of the item to proof my concept.
For the list of the items I use this search (C# code):
var search = new ItemSearchAdvanced { columns = new ItemSearchRow { // Fields to return basic = new ItemSearchRowBasic { internalId = new[] { new SearchColumnSelectField() }, itemId = new[] { new SearchColumnStringField() }, type = new[] { new SearchColumnEnumSelectField() } } } };And get these item types:
_markup,_discount,_subtotal,_description, _service,_otherCharge,_inventoryItem,_nonInventoryItem
For the second list I use this search (C# code):
0