• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

stock statement preparation purpose which formula using

GVN KUMAR

Member
Sir

our software only give purchase wise and sale wise data not generated stock statement each item wise

so we are trying to vlookup formula it's not accurate (we are using not successfully)

could you help of stock statement of (B) purchase - (C) sale = (D) balance= (E) delay days

delay days
♦ no of old days purchase till date
 

Attachments

vletm

Excel Ninja
GVN KUMAR
Should You sell more different items that there could be same amount items in Sales and Purchases?
= cannot have Sales for all items.
Sale's 'vlookup's formula should have fixed range.
= cannot have Sales for all items.

Could You add Your needed results?
 

GVN KUMAR

Member
sir
we are fining of
F column based purchase (day by day purchase of some items )
A column based name based selling (not sell all product at a time day by day selling of all item its continue process )

we required how many purchases of items (name based items entered our software )
we required how many selling of items (name based same items selling in our software)
we required a balance of stock (Name based each items balances )
we required each item till date how old purchase date - till date

its simple stock statement required to sir
our software we are entered purchase base each item same way selling the same name but the balance of stock in identifying sir in our software
 

Attachments

vletm

Excel Ninja
GVN KUMAR
You cleared all Your something away.
Could You add Your needed results?
I required answers.
If those are something which start with s-word then why to ask?
 
Top