Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Dear Sir in vidoe
Auto PO Process Smart Inventory | Master Business Accounting 28
at 30:14 i solved the issue in following way; frm_Stock was bounded with a query "q_Stock". In the expression builder it was StockStatus: IIf([ItmOStock]=0,"Zero Stock",IIf([ItmOStock]<[ItmWarningUnits],"Low Stock","Stock Ok")). I changed it as StockStatus: IIf([ItmOTotal]=0,"Zero Stock",IIf([ItmOTotal]<[ItmWarningUnits],"Low Stock","Stock Ok")). I applied this change becasue i noticed that in "tbl_Items" we are changing ItmOTotal field througout this tutorial series. It solved the issue and now frm_Stock shows correct StockStatus. I want to know is this method is fine or we have to do some other changes? Is it the correct way?
