Inventory totals

Re: Inventory totals

A sample would be nice. What method of inventory valuation are you using? LIFO, FIFO, Average? That would be necessary to understand the inventory you have and its value.

Re: Inventory totals

To add an attachment, when you reply choose "Go Advanced" --> "Manage Attachments" --> "Add Files" --> Done

Re: Inventory totals

hmm...not sure the issue. Cytop posted this in another thread. See if it helps

How to Attach a Sample Workbook

To attach a workbook:

Click 'Go Advanced' at the bottom right of the Reply Box.
In the new window click the Paper Clip Icon.
In the new window that pops up click 'Add Files'.
Click 'Select File' and browse to the required file.
Click 'Upload File'.
Click 'Done' when the selected file appears in the box at the bottom of the window.

The maximum file size allowed is 110kb, if your file is larger than this you can try zipping it to reduce the size. If still too large, or if your actual file contains sensitive data, then create a sample workbook with reduced amount of data or with sanitised data.

When creating a sample workbook it is essential that the structure of the actual workbook is retained.
If data has been sanitised, then the sanitised data must be of the same type as the original (text still text, numbers still numbers, dates still dates etc.).
The Layout of data on each sheet remains the same.
If actual data contains blank rows, columns or cells then include the same in the sample data.
If a cell contains a formula keep the formula in the sample, in other words do not create the sample file by pasting just values from the actual file.

An accurate sample workbook will help us to help you.

[hr]*[/hr]
Actual template text...
[sw]*[/sw]

Re: Inventory totals

Quote

...posted this in another thread...

That's actually a 'template' - to insert the (formatted) text just type

[noparse][sw]*[/sw][/noparse]

(SW = Sample Workbook as a mnemonic)

You won't see anything while typing the message but the template text will be inserted when you post the message.

Re: Inventory totals

thx cytop

Re: Inventory totals

There is nothing on the download tab...please update

If I understand correctly.

1) Amazon provides you a report ("Downloaded Repart") that gives you info on inventory that has been sold.
2) The tab "Daily Process" has all of your purchase orders for each item
3) The tab "Inventory Total" will have inventory values in column C. You want to add to these values received inventory from the PO's and subtract used inventory.

Right?

It feels like you wont need VBA for this. Sumifs should work

Re: Inventory totals

what about this. In this sample I used the sumif to count what was sold (column D) and purchased (column E). I am guessing FBA Inventory Total (column C) is the current inventory. If so, then C - D + E = New current Inventory (column F).

Then just before you are about to add another download to your file click the "Total The Inventory" button which will transfer the values from F to C.

this is the code

Sub moveData()
    Dim ws As Worksheet
    Dim lastrow As Integer
    
    Set ws = ThisWorkbook.Sheets("Inventory Total")
    
    lastrow = ws.Range("A" & Rows.Count).End(xlUp).Row
    ws.Range("C8:C" & lastrow).Value = ws.Range("F8:F" & lastrow).Value


End Sub