BrianHunot1
3 years agoQrew Cadet
Carryover or running total inventory help
Hello everybody, I've searched the forums and can't seem to find an answer to what is probably a fairly common inventory problem. We track inventory by period. I have fields for Beginning Inventory, Inventory Received, Inventory Used and then Ending Inventory. What I'd like to do is have the Ending Inventory of one period automatically carryover to the next period's Beginning Inventory. In our company we use Bimonthly Invoice Periods, the 15th and the 31st. I may not have the terminology right here regarding carryover or running total.
In a perfect world that same Beginning Inventory would default to the prior period's Ending Inventory OR would allow manual entry to a selected value, for the first period of the year, or a non standard entry. But I realize that would add complexity. We are coming from FileMaker and we had this formula there that worked both ways like this. Thank you in advance.
------------------------------
Brian Hunot
------------------------------
In a perfect world that same Beginning Inventory would default to the prior period's Ending Inventory OR would allow manual entry to a selected value, for the first period of the year, or a non standard entry. But I realize that would add complexity. We are coming from FileMaker and we had this formula there that worked both ways like this. Thank you in advance.
------------------------------
Brian Hunot
------------------------------