Hi Forum,
I cannot seem to find a way to update the AP_InvoiceRegisterWork table and AP_InvoiceRegister.upd.
We have a Vendor that need to print checks to with different Names. One vendor hundreds of different Names the invoices need to be updated with.
We setup UDFs at the Invoice Data entry. But I cannot see the way to update the registers.
Regards,
Manuel
No script is needed for something like that, up until you get to the check stage (to copy a line value to check header).
To pass invoice UDF data to AP_OpenInvoice, add a UDF to that table and check the…
Yes, add a UDF to the register's work table, and edit the report (changing nothing structural, to preserve report integrity).
Beware when installing updates / upgrades which may overwrite your customized…
No script is needed for something like that, up until you get to the check stage (to copy a line value to check header).
To pass invoice UDF data to AP_OpenInvoice, add a UDF to that table and check the business objects and you'll see a middle step is needed.
Checking the data sources available in AP_InvoiceHeaderPosting and you'll find you can source from the AP_InvoiceHeader table.
Set up this flow through the posting table into the open invoice table, and (as long as you set up the business object links properly), the data should get to the right place.
If you want to show values on the printed register, use a similar process to add a UDF to that work table. (No scripts or extra table links).
Then, add a UDF to the check detail table, sourced from the open invoice table. Script copy the check detail value into a check header UDF, and flow from there to a work table UDF.
