Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.

StockStatus in frm_...
 
Notifications
Clear all

[Solved] StockStatus in frm_Stock

2 Posts
2 Users
0 Reactions
104 Views
Posts: 4
Topic starter
(@khuram-shahzad)
Active Member
Joined: 5 months ago

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?


1 Reply
Posts: 22
 ursh
Admin
(@ursh)
Member
Joined: 2 years ago

Yes, it's great. You are right 35:38


Reply
Share: