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     www.energyefficientbuild.com.   Dec-31-2015

post by: nischal prasad:

https://productforums.google.com/forum/#!topic/docs/v_35hwd43BU;context-place=forum/docs

i am creating google spreadsheet for inventory

Hello 

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

------------------------------------------------------------------------------------

Timestamp

Select

Job Number

Customer

Part Number

Part Description

Quantity removed from Inventory

Sell Price

Date Removed

Reason for parts removal

Job Number

Customer Name

Part Number

Part Description

Quantity

Buy Price (Each)

Buy Price (Total)

Vendor

Location

Date Received

12/29/2015 9:45:13

Inventory Recieved

FC5-8829-000

Drum Cleaning Blade

10

R2S5

12/23/2015

12/29/2015 9:52:55

Inventory Removal

1512

Sir Speedy

FC5-8829-000

Drum Cleaning Blade

4

12/28/2015

Customer Approved Estimate