Need help with C# - creating a generic class to update different tables

I'm really glad to hear that you found the code and explanations helpful! It's always a pleasure to assist and share knowledge, especially when it can make someone's work easier. As a VB developer, you already have a great foundation in programming and I'm sure you'll continue to do well in C#. Remember, every language is just a tool - the key is understanding the concepts. Don't hesitate to reach out if you have any more questions or if there's anything else I can help you with in the future. Happy coding!

The Acumatica Framework's BQL and DACs are strongly typed and usually do not support dynamic table names and fields. Your approach to using generics in the function is a common way to perform similar actions on different types of tables in Acumatica.

However, with your existing method, you'll still need to call this method for each table individually. The method should work for updating a specified field in any table, assuming the field and table meet the conditions in your where clause.

Here's an updated version of your method, which uses generics to perform the same action on any table/field:

public static void TableUpdate<T, TField>(PXGraph graph, int bAccountFrom, int bAccountTo)
    where TField : IBqlField
    where T : class, IBqlTable, new()
{
    // Build the BQL Command
    var bqlCommand = BqlCommand.CreateInstance(typeof(Select<,>),
                                               typeof(T),
                                               typeof(Where<,>),
                                               typeof(TField),
                                               typeof(Equal<Required<TField>>));

    // Create a View and Select the existing data
    var view = new PXView(graph, true, bqlCommand);
    var existingRecord = view.SelectSingle(bAccountFrom);

    if (existingRecord != null)
    {
        if (!PXDatabase.Update<T>(
            new PXDataFieldAssign(typeof(TField).Name, PXDbType.Int, bAccountTo),
            new PXDataFieldRestrict(typeof(TField).Name, PXDbType.Int, bAccountFrom)))
        {
            throw new PXException(ICSMessages.UpdateFailed, $"{typeof(T).Name}-{typeof(TField).Name}",
                typeof(T).Name);
        }
    }
}

You would call this method with specific table and field like this:

TableUpdate<APInvoice, APInvoice.suppliedByVendorID>(graph, bAccountFrom, bAccountTo);