Jump to content

Inventory report


Santiago
 Share

This topic is 6508 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi

Perhaps this is a simple problem but I can not find a solution for it

I am working on an inventory system. So far I made everything except for the final report.

I have several products and I use one new record for every transaction (purchases, sales, transfers from one warehouse to another, etc.). Every record has the item number, item description, quantity for the transaction and price.

For the final inventory report, I need one single line for each product with the item number, item description, current product quantity (the sum for all the transactions in the database with that item number), the price (from any of the records as all the records are updated with the last price), the total amount for each line and a grand total at the end.

I have tried with subsummarys, summarys, running totals, etc. but I could not find a way to get this report out

Can somebody help a beginner with problems ?

Many thanks !!

Version: v6.x

Platform: Windows 2000

Link to comment
Share on other sites

  • Newbies

No at all. I have a single file with all the data.

I guess there should be a simple way to get a report with the data grouped and summarized by one field (item number for example) including all the records in the DB but so far I could not write it down.

Link to comment
Share on other sites

Inventory management is a good place to use multiple tables (files). It allows you to simplify data-entry tasks by reusing and linking related data.

That said, I think you can summarize your inventory table using sub-summary parts and a couple summary fields.

Create summary fields:

Count of Records=Count of <Record ID> (whatever your field is for a unique ID.)

Total Value=Total of Cost (whatever fieldyour using for the cost of the item.

On a list layout, create a part for each breakdown category, specifying to Sub-summarize by that field. Then put the fields on the layout. To get the summary parts to show up, you must sort the records by the fields that you used for your summary parts, and you can only see the parts in Preview mode.

Is this any help? Too basic? Too advanced?

Link to comment
Share on other sites

This topic is 6508 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.