There is a method at the line detail level that needs to be called <header object>'Lines'DistributeBalance()

In the A/P tasks, you are correct, this is called from the UI objects.

Thanks for the confirmation Steve.  Is there a way I can trigger that method within a VI job?

On the Configuration folder, click on Perform.  On the Perform Maintenance dialog choose Perform Type=Before Write, File Type=Header.  In the Command field enter coBusiness'Lines'DistributeBalance() and Accept

That worked perfect Steve... thank you very much!

When I get to the Perform Maintenance screen, I entered the following:

I cannot enter a Table Name, and obviously not a Column Name, as I am sure that is available only after a table is selected. Is this where I would point to the Expense Distribution Table? 

How do I get access to the Table Name selection?

I am using Sage 100cloud Standard 2020, Version 6.20.0.1

The Table Name and Column Name should be left blank.

If I am creating a batch of invoices to be imported via VI, at what point do I designate the A/P Expense Distribution Table?

Do I understand correctly that I do not need any 'L' line records? Where would I add Comments for the line distributions?

Sorry for all the questions, but I feel I am getting close to accomplishing updating a monthly batch with invoices from several Vendors, each of which is distributed to multiple Accounts.

The TableCode for the A/P Expense Distribution Table can be assigned to each Vendor and then will automatically be set in the Invoice entry being imported or it can be imported as part of the V/I job.

To answer the question about the 'L' records, if you are using the perform logic to force the expense distribution to create the detail lines then no, you do not need them.

Unfortunately, if you want to import comments for each line then you would need the 'L' records.  

Someone else may have a workaround for you to get both the expense distribution and then import the comments into that detail.  Is the comment different for each detail line?

No, I am sure the AP folks will be willing to give up the line comments to get the batch imported each month with the Distribution Accounts and Amounts included.

In the Import Job Maintenance Screen, 2.Data tab, Do I need to enter anything in the H.TableCode field?

Thank you for your assistance. I will mark your response as the Suggested Answer. Is there anything else I need to do so you get credit?

No, I am sure the AP folks will be willing to give up the line comments to get the batch imported each month with the Distribution Accounts and Amounts included.

In the Import Job Maintenance Screen, 2.Data tab, Do I need to enter anything in the H.TableCode field?

Thank you for your assistance. I will mark your response as the Suggested Answer. Is there anything else I need to do so you get credit?

If each Vendor is already assigned an Expense Distribution Table Code then no it does not have to be in the import file.  

Assigning a default Expense Distribution Table Code to a Vendor was just added as a feature a couple of years ago.  If your current version of Sage 100 does not have that feature the table code will have to be imported.

I am using Sage 100cloud Standard 2020, Version 6.20.0.1

I didn't see it in the sample, but the invoice total amount should be in H.InvoiceAmt, I would assume. Is there a recommendation for where that should be inserted? Before or after Table Code, for example? 

It shouldn't make a difference before or after. 

The integration failed due to the Distribution Table not exploding into the constituent account numbers, causing the record to be evaluated as out of balance.

Is a path, or some other additional context, needed before the string ‘coBusiness’Lines’DistributeBalance()’ ?

I got past the records failing because the Perform Command Line did not did not explode into all the Expense Distribution Table Account Distribution Lines.

When I execute the integration every line passes validation. An AP batch is created but there are still no distributions accounts. The Control Totals are all zeroes.

Any suggestions would be appreciated.