a
Aqueel Ahmed
10/07/2021, 3:48 AMmessage has been deleted
b
battk
10/07/2021, 4:20 AMyou are probably looking for data related to approval status
battk
10/07/2021, 4:20 AMan approved journal entry is posting
a
Aqueel Ahmed
10/07/2021, 3:05 PMI checked that but most of the entries have approval status NA (both in the JournalEntry and Journal_Line tables) while they are still being posted
Aqueel Ahmed
10/07/2021, 3:35 PMran a report on the front end to verify and it seems approval status does not signify posting a snippet from the report is below:
b
battk
10/07/2021, 4:10 PMim not really sure what gets an approved journal entry to be non posting
battk
10/07/2021, 4:10 PMyou may to do a transaction search instead to get the posting column
a
Aqueel Ahmed
10/07/2021, 4:15 PMHow would I do that? would I need to go check each document number or is there a table I can pull to do it internally in our DB?
b
battk
10/07/2021, 4:15 PMyou are asking in the suitetalk channel
battk
10/07/2021, 4:15 PMyou get soap or rest api related answers
a
Aqueel Ahmed
10/07/2021, 4:16 PMThis is a SOAP api related question
Aqueel Ahmed
10/07/2021, 4:17 PMI am trying to use soap api for all these operations
b
battk
10/07/2021, 4:18 PMbattk
10/07/2021, 4:18 PMsoap uses saved searches, which are similtar to tables, but not quite
battk
10/07/2021, 4:19 PMyou dont usually try to think of saved searches at the database level
battk
10/07/2021, 4:19 PMespecially not in soap where formulas are uncommon
a
Aqueel Ahmed
10/07/2021, 4:21 PMWe tried the saved search approach that does give the desired results but takes too long to execute >18 Hrs. so that is not a solution we can live with. specially since there is no way to get incremental changes. However we have found that there are tables that can be pulled like "JournalEntry", "Journal_Line" etc. that provide the base information for building the transactions, these tables also provide incremental updates.
Aqueel Ahmed
10/07/2021, 4:22 PMWe want to avoid doing any operations in netsuite since that is pretty slow response the solution we think would be best is to pull the individual tables and then do the processing on internal systems
b
battk
10/07/2021, 4:23 PMagain, your tool is hiding its implementation from you
battk
10/07/2021, 4:24 PMand i suspect hiding how inefficiently its doing its searches
battk
10/07/2021, 4:24 PM18 hours is the performance you get from loading every record
battk
10/07/2021, 4:25 PMyou should see much better performance doing Advanced Searches
a
Aqueel Ahmed
10/07/2021, 4:28 PMWith the saved search solution we do need to load every record. since it does not provide incremental data doing a date based pull or last updated pull would not give us information on deleted entries
b
battk
10/07/2021, 4:30 PMby loading a record, i mean using get or one its related operations
battk
10/07/2021, 4:31 PMor a Basic Search
battk
10/07/2021, 4:32 PMboth of which internally load multiple tables worth of data to represent a record
a
Aqueel Ahmed
10/07/2021, 4:33 PMthanks let me look into this a bit more!
b
battk
10/07/2021, 4:33 PMdoing an advanced search allows you to specify only the columns you need, which is much faster
a
Aqueel Ahmed
10/07/2021, 4:34 PMDoesn't saved search already specify the columns? we have only 10 or so columns that we are trying to pull for all transactions so while the number of transactions is quite large the number of columns is very reasonable
b
battk
10/07/2021, 4:35 PMa basic saved search does not specify columns
5 Views