Collaborate on Create Your Own Invoice Template for Inventory with Ease Using airSlate SignNow

Create your own invoice template for Inventory

hey guys welcome to my youtube channel so in this episode we're going to create the pos system a multi item using up sheet so in this episode we're going to create a sample which is a mobile shop multi-item theory system with inventory management and also it automatically deducts multiple items in inventory during sale and also it's automatically add up in multiple items in inventory during add stocks and also we're gonna create a voided transaction history so let's go first to our phrase first table so my first table here is the inventory inventory this is where your items stored and how much is the available stocks how much is the price and what is the item code so i have a columns of item code uh category item name the unit price the available stocks which is a place most of them i mean all of them are 10 and then i have the photo this is this is an optional i keep this in my google drive all right now let's create an app okay so this is for example is my mobile shop then i'm gonna choose my data okay let's upload the and let's delete this intro and then let's review the table the item code i keep it as a row key and i wanted to be label it and then also the image or the photo i wanted to label it then i tell me i keep it as a text then unit price it's um three digit value and currency is us dollar you can also choose your own currency then available stocks i keep it as a number and that's all then we're gonna go to the ux view then here is the inventory so we'll keep it as a deck view then i keep it on the left most sort by you can have an option for that category so i want to group it in the category then groups aggregate i don't i don't want to use this one so the primary header i want to use the item name secondary let's say the available stocks then the summary let's say what is the uh unit price price all right show option bar we don't need to show it then let's change the icon let's say we're gonna use this okay then i'll go to my ux i wanted to keep this uh this po system as a dark mode let's try before we proceed oh okay that's all okay so we already added our first table which is the inventory so we will open it only to the big screen all right so this is our inventory so if you want just to add any items here you can just click the plus on it then you can put the item code what's the category item name then you can attach a photo and then hit save all right now let's review this uh let's review first our inventory table category here we wanted to put it as you know i have only two categories which is mobile phones and accessories here we just copy this and so it's drop down and okay then the second that we need to add is our sale so in our sale i prepare already my database so we have here column date time receipt number customer name phone number cashier and here if you wanted to create it as a multiple items so you can just follow this so the first item is an item code which is related to this so once the user choose the item code it's automatically generate the unit price item name it's a quantity so this is the first item since you wanted it multiple items so we have to add a button here let's say add item number two so same goes you can just copy this and change it to item code number two then add another button for item number three then item number three then so if you wish to make it up to 20 so you can do up to 20 or whatever you like as much as you can so for the sake of this video we're gonna keep it simple we're gonna make it three items pure system then maybe we can add another bottom here as a separator let's say i want this show order so we're gonna [Music] you can add the button here order summary all right then here i have the since we have a three item only we have the total item one total item two total item three then i have the total amount payment type amount paid if you wish to add the tax or discount you can add another column also you can apply a circuit formula for that all right so now let's upload this table to our app sheet let's go there so we are going to choose sale in this case i don't want uh updates in this we are avoiding updates since this is a pos so we are allowing only ads and the needs to protect you know your sale if someone updated so it will be not uh you know it will you cannot monitor it so you can put ads and deletes on then let's view the column okay then what we're gonna do so here the date so receipt number i wanted to give us a row key then date i'm going to use format then time second so indeed if you wish to add here auto compute you can just put here today then uh go to update behavior and then so every time they open the pos when they punch a transaction it's automatically registered what is the date for today so only they can edit this it's blank this row but so if if the column is empty then you can edit same goes to same goes to time they cannot i don't want them to change the time what time the punch so i can just apply also his blank this row the time and in the receipt number we wanted to have just a random [Music] random code if you wish to have a serialized receipt number you can visit one of my video i explained how to create a automatic serial number or a receipt number in this case i'm gonna just use before we do that i don't want them to edit it so i can just apply also isblab this row dot c number [Music] okay so we're gonna apply here an autocompute initial value so i'm gonna use only this time s r cell is c then i'm gonna use um then unique id maybe yeah so i'm gonna apply a unique id so it will randomly generates um a unique id so okay all good then on cashier or i mean customer name just keep it said text then paul keep it's a text you can keep it support number as well cashier i will keep it as a norm so i will add values here so the value let's say this is cashier one and the shear two i'm gonna use a drop down option then item code so we're going to keep it as reference you can also create a drop down list using valid valid if but in this case i would prefer to use the um reference type so i can go and keep it as ref so item code this is from the inventory so this that we're gonna have there so this is the reference so i'm gonna use the inventory okay then item name we're gonna keep its text and also we're gonna apply some formula in the first item number one so this is the first item yeah so item number one we're gonna apply so i don't want them to i don't want them to edit for example here you know when you when you're adding when you're adding a sale so when you once you choose the category i mean the item code generates the data here so we don't want them to delete the data i mean the values so we're gonna do is same with date we can apply his blank on his law [Music] please draw the name item name one name one you just copy this and item name one okay and then same goes to i can name one so once the place the item code we're gonna generate the initial value by using any select select the inventory and then three then choose the column which is um the column is this one so we were trying to locate this name so this one is item name then comma then um this row that i then name number one so our first item is equals to so item code i mean i can code our rookie so it's not our rookie but an item code item code number one is equals to item vote basically um we can unlock it in sale the item code which is here you can allocate here you can do a query and then once it's matched it will just automatically generate the data okay hit save okay so item one is done and also unit price we will do the same so to do the same just copy that auto compute then unit price we're gonna just uh first we're gonna we don't want them to edit it once it's generated so same goes we're gonna type here is blank it's low the unit price unit price number one ah what's going on then go to the auto compute paste this one the one that you copy then just change the first column to unit price and of course here in the quantity we don't want them to uh here for example here we'd want them to put negative correct here in the quantity so we want to put a minimum value so when you're making a sale there is no negative sale right so the minimum value should be one okay then here before um we have this word name item code one i the name one unit price one if you did not rename this it will display to your app similar like this so what we're gonna do is to rename this renaming this will be easy so crystal display and then i will just simply name this as item code okay and then same goes to item name i'm gonna rename this as i tell name then same goes to qty number one i'm gonna name this to simply as quantity cutie white okay so we done for our first item so the rest that we did is in item code here in the first item we will do it also in all the items i mean in all in our second items which is the item code number two and unit price number two but before we do that as you notice there is ad item number two here so basically uh here in the sale you already encoded the data here so you want if you if you wish to add another item use the user should click add item number two in order for this to show the option for number two items so to do that so first we're gonna rename the ad item number two we don't want them to show it like that so yeah display then i'm gonna name this as add item then what we're gonna do we will only show this button if the user um put something here here let's say he put something in quantity number one it's at least minimum value is one so we can only show this bottom so we're gonna show this apply show if so find the column quantity number one because we don't want them to show all the buttons if i mean all the columns if the customer just order one items so we want to hide this column so it's not maybe we can apply it's not blank so if it's not black okay then we're gonna add uh you can keep it as unknown then add values just put here uh items item then just use buttons this will be nice okay then same goes what we did to item code number one we're gonna use this as a ref then we will show only the item number two if you know the column once the user click add item okay where is it it's gone okay so you're gonna show only the item this item two if user click the add item so we're gonna do is we're gonna use add item number two is equals two equals to add item and then the same time we're gonna keep it as a ref inventory then also the display we don't want them to display as item code number two so i'm going to rename this as item oh simply an item code all right same goes to item number two we will only display this if this is the add item number two is click so here item name show then also the same time we gonna apply a formula so auto compute then select any and select empty and then three columns over choosing item name column name that is its row item code number two is equals to item okay so let's copy this and we need it later then we're gonna apply here uh editable if so it's only editable if of course we're gonna use his blank same what we did in the first items his blank this row dot uh item then of course if you rename it already of course then we're gonna change the display name you don't want them to show it like that so i'm gonna name this as item name item name okay next is the item name is the unit price of course um we're gonna show this only if uh item number two it's been click where is it number two is equals [Music] and of course we're gonna keep it as a three digit us dollar auto compute so we will get the data from the inventory so we're gonna just change this to uni price and of course what we're gonna do we're gonna have update the behavior change only get it edit only if it's blocked it's blank this row the unit price tool okay and of course we have to change the display name we don't want them to display us unit price too just keep it as unit price unit price all right also um also next is the quantity so in the quantity we don't we don't want them to input negative so minimum value should be one and of course we have to rename the display so i'm just simply naming it as qty then we're gonna show only of course if the user click the add item number two okay this equals [Music] then here we go last items we have since we have three items then we will only show this if somebody plays in quantity number two a value so first so now our reference is qty number two is not black then uh we're gonna keep it as unknown then we can add the value add values [Music] of course i'm going to keep it as a bottom and date of display so we're going to name it as item okay then of course the item number three we will only show if the user click the add item number three okay so let's go to edit this so we're gonna show it columns item here's the item number three is equals to uh and we're gonna keep it as ref entry of course we're gonna [Music] display change it to the height all right then next is below that is the number three item text and keep it as a text of course here we will only show if ad item number three has been pressed same goes then i'm gonna display name so i'm just simply name it as item item name how to compute so we're gonna [Music] apply a formula select inventory item name this row that so this time is number three it's safe then unit price same goes equals to item then on display you have to rename it we don't want them to display with numbers then auto compute initial value let's change this to 3 and here unit price okay then done then quantity of course they will show only same goes is and minimum value should be one then display here is then what we have here is show order summary here once the user fill up all this so we want to cut the view so we will only show this total item um total item if if user click show order summary okay so we're gonna do we're gonna keep it as unknown then add values so then then once user click show order summary this should all of this item should be this item should be hide we can only see the summary so what we're going to do we go go back to the item let's say item code from here to item number three you can edit the showing so here in the item one you can just column summary stop here and hopefully you see it should be not equal okay same goes here just space same goes to here yes space so basically all the bottoms only one then add items also here since there is already a formula you can just simply copy this base then add here and and okay then on item number two since that is already here just click this and to use same goes paste that one put up here and close parenthesis here make a name to then unit price 2. okay so even we're going to hide these items so if you have multiple items this might take time to prepare the application [Music] okay then here come on you're almost done okay hit save then we have to rename this total item one total item two and total item three so but first of that we're gonna keep it as price price should be all priced nice okay here in total item we're gonna show only if user click show order summary is equals to shorter summary okay so we're gonna apply that to all our total item okay just minimize you know the screen overcrowded okay it's dollar also the total amount of course i'm gonna include it also then payment type should be show only if then yeah let me put that to payment gosh [Music] don't worry i want paid show me like that then in amount page we want to keep um validity so we're gonna have uh three digits example data so we don't want them to pay less amount versus the total amount so what you're going to do is just put like this this row oh god should not be more than or equals to total amount here okay then we're gonna put total amounts here and up formula so a formula is just uh what is the item total item just insert this insert this and insert this last sign all right then we wanted to rename the total item we don't want it to show like this so what we're going to do guys to rename this so we're going to go to display we're gonna use concatenate let's say this is the item number one so i'm gonna keep it name this as item um number one then let's say i'm gonna use underscore as a separator then we're gonna include the column name what is the name of the product item name okay then we're gonna apply then let's say how many quantity he purchased let's say quantity one here and then we're gonna apply dash for example he says and we'll do a separator then we're going to apply the unit price for example comma then maybe we can put usd per item very unique usd then okay something wrong item name unit price then here oh it's already included included here should be okay then just oops item name quantity pieces unit price still okay okay so copy this and it should be okay then total item number two uh go to display in this space change this to number two and then number two number two then here just space change it to number three number three and number three also okay then one thing what if the customer only order one item so we don't want we don't want to show this in our pos if the order only one item this uh total item number two and number three so what we're gonna do is we will show only if here we're gonna add another and formula and is not bank then fix the column since our reference is number two we're gonna use the reference column item code number two then then put the comma here then close the button close the expression just copy this and [Music] paste it in item code item total item number three change the summary and then change it to number three all right okay we are done for our pos in adding the sale button but first no we don't yet add so after you edit those things you're gonna go to new view you can add a new view sale so i will just name this as sale and i wanted is a stable view and sort by group by let's say i want to group it by date then all the columns what is the display anything here crash register okay here and where do you want to put it so left let's refresh it's there oops it's already added so app sheet basically generate automatically the the okay let's generate automatically the table and the viewers so just rename this as sale should be yep okay then let's refresh so this is the sale then we will add now on items guys so we're gonna add the data so this is there is a receipt number here automatically generated let's say i want it to customer name then six for example cashier is one let's say as you can see it's only displayed unit price and then she orders somebody so it saves the screen so when you put item code let's say number one here i think the component one it's not showing the name so let's go back there and view columns in the inventory so label item code okay and in sale the label should be at custom label should be okay that's fine i believe inventory so we want to put label item name also we will put let's see we'll play okay okay you can put as well uh required here uh here you can restrict the app here you can put all required if you like for example if you want to record like this okay so item code number one here so it's here uh it's an iphone 13 the price as you can see they cannot delete or they cannot edit the item name and the price then the quantity i put it's a negative one it will not allow you so the minimum is one or you can put 10 for example then we have here add item once you click this it shows the item the second item row so here i'm gonna put for example this one then this is then see here i can add also an item so it shows the third row so here i'm gonna add for example we are not 10 but we forgot to add what you call this here this is the problem if you did not put the um see they can edit so in item code number three we forgot to add uh behavior editability item name number three should not be edited here so you can apply this blank [Music] this row but [Music] same goes to the unit price we didn't we forgot to put it also a unit price okay it will be updated later on as you can see then then then if we did not click this one it will not show our total order so once we click it it will hide the data i mean the so it will only show you the date of the customer cashier and this is the order summary here in the order summary as you can see there is item number one it's an eye for iphone 13 128 gb 10 pieces at 800 usd per unit same goes here okay if you have if you click this it will it will show the items okay but click this it will show you only the summary but we did not place it the formula here okay so an item total item here it just can just apply a formula so this is the unit price times times quantity one just copy this then total item tool just place it there and change it to this change to this it goes here yeah i believe uh our sale is already completed so now let's go one now let's add one sample data all okay an item okay order summary it hides then only the summary so there is a summary here so this is the total amount for this each item and total amount and what did i pay the cash amount paid let's say i pay only less 23 000 it will show invalid so it will allow me if it's equal or if it's more than okay so you can allow a name to save if it's then hit save so we will offline sync delete sync okay so we have an order here summary but yeah each item we order is 10 okay it's 10 item what the order but the problem is it should deduct in our inventory here inventory is still here so it's still 10 10 10. so to do that let's do our first step first step is you need to add a virtual column in say like that so you're going to add since we have three items you will have a total of six virtual columns okay so add the vertical column first is we're gonna use it as available stocks and we're gonna apply any here formula of any select so um table is inventory and the column is available just copy this and okay then you get here done add another one then paste the formula against this to number two and then just rename it to available starts add another virtual column paste it change this to number three then in it as available then then hit save we still need to add another three virtual column guys okay okay so now we're gonna add another three virtual column virtual column so here we're gonna name it as new available item what you're gonna do is just go to the columns that you created i'm gonna just item one here so minus column 121 okay then add another add another version add another virtual column in same table advertise column then you're gonna just name it where is the item number two i mean available stocks item number two minus quantity number two okay then name it as new available stocks then add another one so you're going to name it as new available stocks since we have three items item then hold on look for the column i objective stats number three minus quantity number three okay then let's see okay same goes here we don't want to show this uh the stocks item number two we don't want to show if so we're gonna have a column here so this is not um item code number two is not black so we will show only show if is not black okay so same goes here it's not it's not blank then column item code number three okay same goes to new available stocks number two you show it only if same formula is not black [Music] column this same goes here space should be two okay also maybe i keeping it i think that's all all right so now um you can see let's refresh if you want to create a sale as you can see let's say uh this is the name for example item code number one and i have here one so unit price one within a change guys so we have to change it first so you know price one i'm not sure why i'm gonna change it displays nice should be updated later on so here uh i can see the available stocks his available stocks in item in item number one is 10. okay so if i put let's say nine here it should the new available stocks for this item number one it should be one so it should be correct okay so now we're gonna do um we're gonna make a behavior action here action formula so we have to make a new action for inventory so we're gonna name this inventory inventory item one then set the value columns of this row so change available stacks then what you're going to do in this expression and you can select any you can use this expression any select then the name of the table is sale what is the column that we didn't look up is the new available [Music] in this row let's roll the item number one equals two sorry it's not should be item code only 18 code is equals to item code one it should be correct guys so if it's green meaning it's it's correct okay so that's how you're gonna write an expression so what you're gonna do you just copy this you're gonna use it for the next action and just save then appearance just do not display this option then create another action so we're gonna name this as or is it inventory just paste that option available item number two just change this and just change this to two okay and then appearance do not display and add another action same option and this is eventually since we have three items okay available starts then change this to number three then number three and it say appearance do not display okay let's say first so that's the first action in inventory taking then what we're going to do we're going to create another action so in this case we will use execute an action to the set of rows then i'm gonna name this for sale item one so change this from the regular disabled sale and then reference is the inventory then you're gonna use the reference option here the number one person i have been to the item number one then here in the row reference i'm gonna use a formula same uh any select um so we're gonna look up excel then item code so this is item code number one and we're gonna use um that item code [Music] and put one [Music] so this is the first item item code one i'm not sure what's going on should be the expression is valid but the type graph is not an expected type list okay so what we're gonna do we're gonna maybe remove the ali or it should work okay all right so just copy that one and appearance do not display and create also another action a new action here so set the browse then i'm going to name it the same item item 2 reference is inventory then reference option use number 2 and also paste this 2 and appearance should not display then we have to create another action guys new action this is the last action uh still we have another one execute an action so i'm gonna name this sale item entry then reference actions item number three then this so here now should be saved okay it's safe oops something wrong something wrong with the formula what is it sale item unable to find item code number two what is the name i think 2 should be there select say i can fold item code 2 this writing code 2 is equals to column item called 2 ok there is the item code did i rename it i think code number two i cannot find i think code 2 is here should be correct so the error is cell item number two okay so cell item two so let's go there that's here so the error we have here the exp heroin expression cell item i think within this row that this row the item code 2 it's equals to item code hmm something wrong here what's going on this rule something wrong here not sure what's going on [Music] select sale item code wait wait click all right you have to fix this let's play this that's strange that's strange why i'm gonna use this rule here let's try again it's weird that's strange okay let's keep it like that okay now let's create another action how it will work later on you'll see then let's create another action now this time is execute group action so i'm going to name this inventory changer let's see so i'm gonna use this scene then so here we have cell item one sell item one and sale i10 or is sell item number two there is sale item number two should be the resale item number two here so we have a mistake here okay gotcha same that's why it's wrong so now we can use here on this row it's correct so that's mainly the reason why i have an error because i put it in different table then sale here we're gonna use number two and number three appearance of course i don't want to display let's say okay we will only trigger this automation if during add so we're going to create an automation the new boot in a trade custom boot so inventory inventory changer so i will just name it i inventory danger save so i see it so i'm gonna trigger this event during ads only when we creating sale then add step create custom step so this i'm gonna name this indecent then run a data action choose the data action but before you do that okay something wrong here go back choose a table change this table into say then here uh choose an action one data option should be no not this one change them into the same okay let's go back to behavior guys before we proceed so here should be sale correct that's only sale which is correct then here sale run a data action then here should be there is a oh it's not showing yes just a second you change data change adds only which table sale of course conditions no okay then we go back here group actions so you have to click a group action then select here um you can add here wait something wrong let's go back to automation to behavior inventory inventory one two three of course sale because it's here we enter to change it okay maybe we forgot to say so that's why it's not coming there so let's go automation let's configure it and then same okay then run data action then we're gonna okay know what's going on here something wrong let's change this into let me see then okay something wrong let's delete this first let's start fresh okay let's do something wrong okay i cannot review our behavior guys this inventory changer i'm not sure why it's not seeing there okay so go to automation new boot then we're gonna name this as inventory indeed same then create custom event and event imdb for example then you cannot trigger only on add something so choose the table sale then add step create custom step and name this as ind sale so run a data action should be run a data action then here we go so i'm not sure why it's not showing before so use this inventory change yourself then hit save all right apologize for that then what we're gonna do we're gonna test our boot if it's working so let's test we as you know we already added here a data okay so we will test if it's correct if it's uh here it should be trigger changes see as you can see it triggers the changes here it changed to zero okay so this three item change to zero all right so meaning if you are say if you are have a message like this meaning your automation is correct okay now let's add for example i'm gonna add the sale so what if i want to change i want to sale this item code 9 10 11. so as you can see there are 10 items here okay and also in the inventory there is uh 10 items that we have to refresh first here it's zero items already we have so what if i want to sold out this item these three items down here so what you're gonna do the code is the code is 19 and 11 so i'm gonna new sale so i'm gonna create new sale for example yo so one two three four five six i'll show you it is number one then i can code so last number is nine so i'm gonna max out then and add item and item code is 10 i'm gonna max out we'll see if it's become zero then item called number 11 so it's 10 and show already summary so this is my order in cache it says 500 and hit save so we'll see this is our database we'll see if it's become zero as you can see it's become zero here as it becomes zero all right so still loading here so our inventory for this becomes zero you can apply also a format rules if it's zero it will change the color okay so what if you want to you want to add stacks so how you're going to do that so let's go back to our database so let's create a new table here sorry name so i'm going to name this as add stats okay so i'm gonna just this is a multiple item that starts also so i'm gonna have this date time same goes and then reference reference id for example and we're gonna have this one is it delivery is it void and i think code one then name typically you just copy this in our sale we're gonna just copy this head this column so i think from here we're gonna just copy until here okay then add stocks and paste it here all right so not highlighted okay so this is the item code number one item name it's automatically added or you have an option not to include the price you can also do that so but in this case we're gonna just include it then add item add item two same goes here then and then you can just put the marks in here if you want to other remarks then um what you're gonna do is we're gonna upload this in our on our up sheet go to data then new table sit in google this time we're gonna add the add stats and start then we don't we just we don't want delete so let's say we want delete also so this file updates now so it just adds and delete only we will discourage update um because we're gonna create later on avoided transaction okay then here add steps review the column then date so the key column is reference id and then um that's the key column the date should be here so we're going to repeat the procedure what we did in the beginning so we're gonna just date time reference id here we're gonna just use um auto compute so there's a formula already so we're gonna just add from captain nade then since this is uh um adds that so you can eat the es add stocks and maybe we can use brush then they can edit the behavior if it's blank this wrong scroll but reference okay then reason we're going to keep it as in so the reason why i add this is we are not allowing edits in our pos so we can just we can allow delete instead so we're gonna add here reason is delivery for example you can adding stuff to the delivery and then maybe you can add also void void avoid it and then we can add also reform for example this we gonna drop down then item code will be keep it as text so this is a three item add stops inventory so we're gonna keep it as ref by the way guys here in add stats you can add as much as items as possible so you can just uh here you can just add so many items as you like so you can keep adding adding columns and then just rename it one two three four so on and so forth okay so in this case we're gonna just maybe use um let's say we don't want to add up to three items to make this video short so maybe we can just make up to two items for example so we can just make two items possible anyway this is the same concept if you may if i make it 10 will be the same the same procedures then i'm gonna just generate the structure okay so here in add stocks um where are we okay so here in add stats reson so item code i'm gonna name this as i'm gonna display name so this is item and i'm gonna keep it as red so the reference is inventory always then item name i'm gonna keep it as uh item name as well the display so we will do the same [Music] at this time we only create two maximum items then you can apply the behavior here we're gonna also it's blank on this row that item name one okay then autocompute so we're gonna use uh same as what we did in the sale any select so we're gonna use the table inventory then the column is item name then um this row that i can [Music] hold 1 is equals to can okay like this so please did we rename it we rename it unit price rename it so just place it so we're gonna repeat the procedure but this time it's slightly different i'm gonna try it okay then quantity of course um we will minimum value should be one then display should be okay then add item same goes to sale we can just keep it as unknown then use buttons then on item number two we gonna show it if the quantity quantity one is not blank okay then name is art item okay then same goes here ref equal to ref inventory then show only if column item number two is equals to add item [Music] then the display keep it as i think same goes to item name show only if [Music] so this one is item name [Music] unit price so you have an option if you don't want to show the unit price you can do that but this time we're gonna just show it points then here okay display so this is [Music] unit price then quantity of course should be minimum value should be one and i'll show you okay and then display okay so the remark just keep it subtext then you can apply here editable it's blunt okay same goes here just copy this [Music] okay hit save then let's add a view to this column ux new view so add stats so i'm going to name this as add stats table view and i want it let's say in the rightmost the display and maybe we can use this and you can also show if user is admin you can add also show this question okay then let's refresh our application so once tax is here so let's say let's want to listen let's say delivery then item code let's say so here we have already zero i want to add these two items so say i want to add 10 then add item there is no item okay we do not automate it okay okay let's refresh okay let's other stats this on let's say delivery i think called one it's already zero here so we're going to add to them and items fusion items click this one then we have also another remarks that say hello then hit save here in our database it should add automatically 10 automatically 10 here it's not yet added because we need to apply a formula for that so here in our what you call this add stats we're gonna add a virtual column two vertical column this time so available stops we're gonna click any select so go to inventory column this is available stocks it's equals to i think just copy it save and show only if you can also show this if i can code number oh no there's no that's the second column here okay then add another column that's the name of it available [Music] item one item two menus then case enter the two and show it item code 2 is not locked then once you're done hit save something wrong where is it then let's add another virtual column at the virtual column so this time we're going to create new variable [Music] we're gonna just we created the virtual column in the beginning and then before this so we're gonna add that protocol so this time plus so you're gonna use plus sign instead of minus okay copy this or remove it and then add another vertical column so we're gonna get new available [Music] box item 2 yes look for that column number 2 plus of course you want to show this only if it's not blank column item call okay see so now what we're gonna do is create a behavior same goes this time inventory so we're gonna new option okay here in the inventory uh change available stock so i will name this as a s inventory from item one if you have so many items so you can create so much as you can yeah then we're gonna use any select this time uh choose add apps column um new available so this row that i can put is equals to i3 just copy this save clearance do not display and add another one since we have two items here here he is simply item then add another one so this time use set of action so i will get a s item so i'm gonna add stocks then here reference is inventory then reference row is as inventory item one then you're gonna use select follow it [Music] do not um then add another one starts it's action then inventory reference choose number two this one and then change to 2 and change to 2. then it's saved then appearance do not display once you're done for that you create another action [Music] this time group so a s inventory a and b changes choose add stats then choose the two action that you created is one and here is two hit save then you go to automation new boot create custom book so i'm going to name this as a s i can be [Music] so i'm gonna trigger only during then the table is add stats then add step custom step then run get action then choose uh where is the detection here let's delete this first same same goes last last time we create it doesn't uh maybe we're deleting something okay here new event so i'm gonna name this as that's only then add step we goes to another one guys then ks inv then on a data action so a s change the table guys here the table now here add stacks okay then run a data action there should be an aes let's say this one first sorry for that there is something wrong here okay let's go back okay so here adds only table add stocks then the process run a data action then run a data action then we're gonna choose okay later let's delete all of this and hit save so it doesn't show i'm not sure why it doesn't show the price is grouped so the problem here we edited the first table we have so here no sorry it's a mistake let's create a new boot so i'm not sure why the that boot is not showing so we're gonna create new boot hopefully it will pop out so create custom boot as going to name this as yes let's see fabric confusion there is the es okay here he is then i'm going to name a yes that's only then you have to choose the table so add stocks then add step create a custom step so i'm going to name this topic computer a s then run a data action should be here asinb changer should be click okay hit this one save sorry then what we're gonna do we're gonna test our automation so this since we added already a sample we should we should able to test the book sequence is child action failed due to execute national action item tool table at stop fail okay so we have an um execute here data option so in add stocks to execute an option set to browse it as item two for table add stocks fields cannot get keyword parent change okay inventory okay there's no wrong here okay so here so the problem is our group action here in add stocks it's confusing now here he is ginger let's go back to the inventory to investigate it it should be click i don't know what's going on it's this once again okay that's this let's find out what is the issue execute sequence of action so here so to troubleshoot in add stats and stacks and stats so it's saying here as item two so there's the mistake here item one so add stocks inventory here's inventory okay this is should be correct then as2 to check it should be correct then group action what is the aes changer let's go back to our automation so here okay add stats which is correct then group action should be correct okay people like not sure guys what's going on anyway let's try um let's try again why i'm not sure why it's going like this okay let's try to execute so item number two is item number two is the error he has item number two here is action that's mainly the reason guys sorry for the delay then there is problem here so we found they found the mistakes it's a mistake of typing here select add stats item inventory here it should be add stats so it should be inventory let's say um select add stocks item code to this row item code 2 is equals to item code number two guys it's a long video hit save so we found out what is the mistake then let's test our automation let's test this one so we're almost finished for the video so we'll just test this if it said okay as you can notice it's add stats here so it's four then it's added stacks okay now let's add now let's add it's added 20 here because we ordered two two items okay now let's say i want to add code 11 code number 11 at the start okay result let's say delivery so item code is 11 so the num the item here is 0 so and then also item number 10 is zero so we're going to add two stacks so item 11 let's say 10 then add items so i'm going to use item number 10 so i'm gonna add 10. okay if you save it should become 10 10 there we'll see see it's added the stats the same time is added also stacks okay so it's added let's add one more let's say say this number nine we're gonna use only one item so let's say avoid that item code number nine let's say i'm gonna add 200. it's safe so this item number nine should become two hundred all right also in the inventory it becomes 200 all right so for the i'm gonna make a part two for this so we're gonna we're gonna create a voided history so whenever let's say someone avoid this transaction there should be a there should be a in the sale there should be a record for the deleted items or deleted transaction all right so if you learn something in this video please don't forget to subscribe if you have any questions you can leave a comment and we'll see you in the part two we're gonna continue this mobile eos multi-item