Jacob D
02/03/2022, 10:30 PMsuitecore
02/16/2022, 7:06 PMDeveR
02/24/2022, 4:22 PMMySuite
03/01/2022, 5:26 PMJonathan Acoca
03/03/2022, 1:59 PMAK47
03/03/2022, 7:54 PMAK47
03/03/2022, 8:01 PMSlackbot
03/18/2022, 11:06 AMRoc127
03/24/2022, 8:55 AMJacob D
03/28/2022, 8:19 PMJ-Mack
03/29/2022, 5:27 PMmescalante
03/31/2022, 11:07 PMDrVeeVah
04/05/2022, 12:04 PMJonah Ludas
04/14/2022, 4:48 PMmescalante
05/06/2022, 9:00 PMMRJG
05/11/2022, 5:12 PMThis record contains duplicated key or keys. Please correct it before next update.
I am only mapping internal id, item id, rate, quantity, location. We do not use external ids. Any ideas? ThanksBetsy Barefoot
05/20/2022, 8:33 PMAn error occurred while processing item options
error. I'm guessing it has to do with the multiple lines, but I can't find a line ID or line # field on Invoices like there is with SOs. I tried using a line ID we use with outside vendors, but those didn't work either.
I never use Netsuite templates anymore, but I dug the invoice template out of the file cabinet, and it references multiple line invoices, but the field it references itemLine_itemRef
doesn't show up in the import mapping. I've looked at the form to see if we'd removed it, but I don't see it.
Any ideas? Thanks!RJMNS
05/20/2022, 10:07 PMArūnas Žindžius
05/25/2022, 9:57 AMRoc127
05/27/2022, 10:51 AMSue Bhuvan
07/08/2022, 4:11 PMJosh Godfrey
08/02/2022, 3:53 PMRUN SERVER SUITESCRIPTS AND TRIGGER WORKFLOW
Option for about 30 different saved templates. Don't particularly want to track down all 30 csv files and save each template the long way.Luis
08/02/2022, 3:58 PMScruffy
08/11/2022, 5:21 PMStephan Vagner
08/16/2022, 10:44 AMArūnas Žindžius
08/19/2022, 1:19 PMNS Admin
08/25/2022, 6:18 PMSub splitFileGS()
Dim ACS As Range, Z As Long, New_WB As Workbook, _
Total_Columns As Long, Start_Row As Long, Stop_Row As Long, Copied_Range As Range
Dim Headers() As Variant
Set ACS = ActiveSheet.UsedRange
With ACS
Headers = .Rows(1).Value
Total_Columns = .Columns.Count
End With
Start_Row = 2
Do While Stop_Row <= ACS.Rows.Count
Z = Z + 1
If Z > 1 Then Start_Row = Stop_Row + 1
Stop_Row = Start_Row + 24500 'edit your record count here. Mine is 24,500 rows per file.
With ACS.Rows
If Stop_Row > .Count Then Stop_Row = .Count
End With
With ACS
Set Copied_Range = .Range(.Cells(Start_Row, 1), .Cells(Stop_Row, Total_Columns))
End With
Set New_WB = Workbooks.Add
With New_WB
With .Worksheets(1)
.Cells(1, 1).Resize(1, Total_Columns) = Headers
.Cells(2, 1).Resize(Copied_Range.Rows.Count, Total_Columns) = Copied_Range.Value
End With
'can find more file types here: <https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat>
'you will need extension: .csv .xlsx etc and file format id. 6 is .csv
'you can change filename by editing in the quotes. e.g. file-z. z is the count
.SaveAs ACS.Parent.Parent.Path & Application.PathSeparator & "file-" & Z & ".csv", FileFormat:=6
.Close
End With
If Stop_Row = ACS.Rows.Count Then Exit Do
Loop
End Sub
NS Admin
08/25/2022, 6:19 PMNS Admin
08/25/2022, 6:21 PMmartha
08/26/2022, 5:44 PM