Spread Income

[gidon500]

Hi guys

i have a request from a customers who whats to spead income according to fixed rules

for each customer i get invoice number , date , sales amount and numbers of months to speard

each invoice can get different no of months .

those sales as service contracts , so  in finance report , the CFO need to spread the income

for the life of the contracts .

enclosed  is a file  where the yellow colour is the data i get

and green is the data i need to create

the file is a sample , the real file is very big

thanks

gidon

[MK_QSL · Accepted solution]

Use below script

================================

Temp:

Load *, Months as TotalMonths Inline

[

  Customer, Date, Invoice, Sales, Months

  200, 01/02/2014, I100, 5000, 5

  210, 01/04/2014, I150, 7200, 6

];

NoConcatenate

Data:

Load

  Customer,

  Date(AddMonths(Date,(IterNo()-1))) as Date,

  Invoice & '-' & (IterNo()) as Invoice,

  Sales/TotalMonths as Sales,

  Months

Resident Temp

While IterNo() <= Months;

Drop Table Temp;

[gidon500]

hello

thanks for your help

gidon