SharePoint 2010 Inventory Tracking

[loustarrrr]

Hi,

 

I have setup an inventory tracking system on SharePoint 2010 with two lists in the structure below.

 

Stock Levels

Item Name (Single Line Of Text)

Item Quantity (Number)

 

Logged Transactions

Title (Single Line of Text) *not used*

Item Name (Lookup)

Item Quantity (Number)

 

What I want to happen is when I put in a value for Item Quantity in the Logged Transactions list, I want it to be subtracted from the Item Quantity in the Stock Levels.

 

I have designed a workflow to do this, however it throws up an error whenever it is ran.

 

[ChrisCarr]

Oh workflows...my best friend...

 

What is the error you get?

 

It could be title related as you will be updating a specific stock level and you will need to reference a unique field in the list or it will error.

 

Chris

[loustarrrr]

Hi Chris,

 

I do not remember what the error was that I was receiving, however, I have now resolved it after a few hours of troubleshooting. I resorted to printing the variable as an email to me throughout each step to see I was getting the right number, it turned out it was trying to subtract a minus number from the inventory level.

 

Thanks,

Louis