Morning People,
I am trying to generate a report of our Master Order we place every 6 Months. [s]but what I want it to do is show our estimate = What we placed say a cup we think we will sell 50 of them, so when the sales order come through we want to minus those and find out how many we have left. I do not know if I need the estimater register report and again have no experience in Reports. :h_a_w:[/s]
ok sorted the inventory item and create 2 custom fields (estimate Master Order) & (Estimate to go) with a formula and it works (even though I do not understand Nvl function lol.
so if only half of the stock comes in, it changes the field to show what we have left. only have to update Master Order Field. and estimate changes
Woo-Pee