QSB - script to load temporary table based on sales transactions and purchase transactions

josecarmo — Mon, 15 Mar 2021 11:37:19 GMT

Hi,

I need help from anyone who have the same situation, to write a script to create a table to be used on UI with the result of data from 2 transaction tables.

The idea is for each calendar day and product code I need to create a record on the new table with sales amount (from the sales transaction file) and the purchase amount for the same date from the purchase transaction file)

The result should be :

Date; ProdutcCode;SalesAmount;PurchaseAmount

I have data files with:

Product codes

Sales transactions

Purchase transactions

Thanks in advance,

José

topic QSB - script to load temporary table based on sales transactions and purchase transactions in App Development

QSB - script to load temporary table based on sales transactions and purchase transactions