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

[josecarmo]

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é