Skip to Content
0
Former Member
Dec 05, 2006 at 09:27 AM

Save to Database

25 Views

<b>Dear SBOers</b>

I would like to save to my user table, but always error "method 'Code' of object 'IUserTable' failed" in line oUserTableTaxInvoice.Code and error "Invalid Field Name" in line oUserTableTaxInvoice.UserFields, any suggestion ??

codding:

Private oCompany As SAPbobsCOM.Company

Private oUserTableTaxInvoice As SAPbobsCOM.UserTable

Set oUserTableTaxInvoice = oCompany.UserTables.Item("TAX_INVOICE")

oUserTableTaxInvoice.Code = lCode

oUserTableTaxInvoice.Name = lCode

oUserTableTaxInvoice.UserFields("U_FiscalYear").Value = sYear

oUserTableTaxInvoice.UserFields("U_CustomerID").Value = sCustID

oUserTableTaxInvoice.UserFields("U_CustomerName").Value = sCustName

oUserTableTaxInvoice.UserFields("U_PostingDate").Value = sPostingDate

oUserTableTaxInvoice.Add

<b>thx</b>