purchase

I am trying to figure out a way to get the most current average cost of however many units are still in stock. An example is shown below of the type of list that I will keep adding to whenever I make a purchase or a sale. The part that I am having trouble calculating is the average cost of what...

Dear people, We have received an Excel sheet of our supplier with our purchase prices from the beginning of 2017 with the invoice numbers. I want to check our latest purchase prices with the purchase prices in our ERP system. I do not know how to make one list with article numbers on the left...

Hi, I have a series of transactions and need to calculate the average cost which includes both buys and sells. E.g. Purchase 100 shares @£1/share Purchase 50 shares @£1.50/share Sell 25 shares @£2/share Purchase 30 shares @£1.60/share Weighted total cost after each transaction £100 (100 *...

Hi, I was wondering if anyone here knew of an alternative to the Print2Excel software which has been retired and no longer for sale: http://print2excel.com/ I have a client that was using the free version but would like to purchase the paid version but is, obviously, not able to do so...

Dear all, I am currently receiving a large number of purchase invoices and sales invoices into 2 email address: - Purchase invoices are sent to AP@htc-ABNAO-services - Sales invoices are sent to AR@htc-ABNAO-Services I have to drag the attachment from the email to the invoice Folders one by...

Hi all, Apologies if this has been answered somewhere else but if it is, I can't find it. I'm setting up a budget spreadsheet where I download all of my transactions from my bank and run a little macro that automatically categorizes all of my transactions based on an existing table. So for...

Hi I was really hoping someone can help me. I currently have a workbook set up that is a purchase order form. This form gets completed and I press the 'Print and Save' Macro which is at the bottom of the form. What this macro does is save the document to a specific folder on the network drive...

Hi I've created an inventory tracker with the help of @My Awser Is This The inventory tracker has 3 worksheets, Dashboard, Released Items and Purchase Orders In the Dashboard worksheet, I already have 2 command buttons (Add Released Items and Add Purchase Order) which pops up UserForms...

i buy and sell 4 items no more, the problem is the items prices changes everytime i buy it. let's say one of the items is a "sugar" ... i bought it yesterday for 1$ for 1kilo and i bought 50, then after a week 2$ for 1 kilo and i bought 50 etc... when i sell 30, it costs me 30$ cuz it came from...

What steps should I take to group these pivot tables together ? An Excel workbook (ERPSim Logistics Data) is attached to this midterm that contains data from the ERPSim Logistics Game with two worksheets: (a) ERPSim – Purchase Order and (b) ERPSim – Sales. For each of these, build a...

An Excel workbook (ERPSim Logistics Data) is attached tothis midterm that contains data from the ERPSim Logistics Game with twoworksheets: (a) ERPSim – Purchase Order and (b) ERPSim – Sales. For each of these, build a hypercube (pivottable) that summarizes and compares data from two countries...

I have used Excel 2010 for years - does everything I need. I have hundreds of excel 2010 spreadsheets. Brought home a file from work to troubleshoot - work uses Excel 2016. Now all my excel sheets have been "disabled" by Microsoft. They want me to purchase MS 2016. I've tried entering the 2010...

Hello, I am trying to convert the following table: <tbody> ID Number Purchase Amount Purchase Type 23 $86 Product X 24 $56 Product Y 25 $66 Product X 23 $88 Product Y 23 $90 Product Z </tbody> into this format: <tbody> ID Number Purchase Amount 1 Purchase Type 1 Purchase Amount...

Hi, I have list of data where I need to analyze the frequency of when my employees are buying mobile phones. I have a list consisting of the following information: - Employee - Date of purchase I want to find out how often each employee orders a new phone (number of days between each...

Hi, I was just curious if this was possible - and could not find any further information anywhere else. I am in the service business, for each of our service jobs that we perform there are many different steps to completing the job for example-- the quoting phase - receiving a purchase order...

Hi guys, I'm sure this is stupidly simple, but my brain doesn't want to point me in the right direction.... I am selling products, I have my purchase cost, my sale price and I want excel to calculate the price of the product after a given % discount. At the moment, if i type in 15% into the...

Dear All, I want to check whether the delivery dates of SKUs in any Purchase Order have the same date or not. In case the delivery dates are different in any Purchase Order, the remarks should be FALSE or if the dates are same, then it should be TRUE. I am providing a sample set with desired...

Hi In the table below I have a extract of a daily delivery status report. End of day I can see which department has failed to deliver some order lines! This specific extract contain one sales order containing 5 sales order lines. The sales order is characterised by that the customer doesn't...

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> #D9D9D9[/URL] "]Name #D9D9D9[/URL] "]Tx #D9D9D9[/URL] "]Product #D9D9D9[/URL] , align: right"]Price #D9D9D9[/URL] , align: right"]Fees #D9D9D9[/URL] , align: right"]Total John Purchase...

hello i have been trying to get the program to record the worksheet name into a cell but i could not get it working. anyone can advice? here is my code Sub ButtonPRGenerator_Click() x = MsgBox("Welcome to Purchase Request Generator.", vbOKOnly + vbInformation, "Purchase Request Generator")...