I have ‘Master Sheet’ which houses all of our manufacturer serialized assets which will get an unique asset number.
We add the number of each units we are ordering from a manufacturer in our current google sheets master sheet and place the PO we order them from in out ‘PO Number’ Field.
I am building a concept right now and want to basically take the PO we build in XERO, go to a form called ‘New PO’ and do the following:
- enter the make, model, factory build specs, etc. and then the quantity of that build. Do this for however many different builds we are ordering.
-this is what I am wanting to do:
- Using something like convert records, take the the ‘quantity’ of each build and add x number of the specific build to the ‘Master Sheet’
Is this possible?