0

Sum from linked tables

 Hello - trying to create a sales report that pulls in sales and credit memo data from the value entry table. I would like to be be able to pull the data into the report by the Sell-To customer (which can be different from the Bill-To - which is the "Source No." in the value entry table. So I have the Sell-To #, which is in the Sales Header table and the link to the 2 tables is the document #. I just don't know how to create an NL function. I was able to create a Table but the table is too big and I only need several Sell-To accounts and the table lists out each invoice and credit memo for the period (I would need to sum the invoices and credit memos in order to get the report).

 

 

 

0 comments

Please sign in to leave a comment.