Thursday, December 31, 2015

yogi_Update Inventory Based On Qty Removed and Qty Received From 'Form Responses 1' Sheet

Google Spreadsheet   Post  #2001
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-31-2015
post by: nischal prasad:!topic/docs/v_35hwd43BU;context-place=forum/docs

i am creating google spreadsheet for inventory

I need help with inventory of all my copier/printer parts
i have a form designed in google forms that gives me response data in a spread sheet 
now my problem is this
the form has 2 sections 
1. Inventory received 
2. Inventory removed (for service calls etc)

when we receive inventory we select the Inventory received section and  the form takes us to that area where we enter al the details of the parts received
and when we remove parts for a service call we go to the Inventory removed section and take out parts and fill out the details 

so the spread sheet generated is like this below

TimestampSelectJob NumberCustomerPart NumberPart DescriptionQuantity removed from InventorySell PriceDate RemovedReason for parts removalJob NumberCustomer NamePart NumberPart DescriptionQuantityBuy Price (Each)Buy Price (Total)VendorLocationDate Received
12/29/2015 9:45:13Inventory RecievedFC5-8829-000Drum Cleaning Blade10R2S512/23/2015
12/29/2015 9:52:55Inventory Removal1512Sir SpeedyFC5-8829-000Drum Cleaning Blade412/28/2015Customer Approved Estimate