Forum Discussion
Freeze Database every month
Thanks for the reply.
Unfortunately, i can't provide data, because is classified. I can provide the headers, so you can understand better what i'm saying.
| Purch.Doc. | Item | Purch.Req. | Item_1 | Order Date | Vendor Name | Net Value USD | Delivered in USD | Invoiced in USD |
So, I'm extracting this from tables in SAP and a I need to build a payment report.
I need to freeze the status of all payments every end of month, and if I refresh the database using only the refresh button I overwrite the payment status that were written there.
So I need to find a way to increment the database with the new month information, so i can compare the status of the payment with the last month.
Basically, I need to create a new column that refers to the month that I'm updating the payment report and next month increment that database with the same purchase orders and requirements to see how the payment status has changed.
Did you understand? It's kind difficult indeed to explain.
Thank you!!
Hi Anonymous
You may vote for this similar idea.Please check if this post could help you.
Regards,
Cherie