Jump to content

Purchasing layout


WMJOBSPINFM

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

Recommended Posts

OK so im planning a purchasing layout and have no idea on how to do it. Basically i have fields for Vendor, Manufacturer, item#, and description (that need to work with this layout).

I want to find all unordered items, sort them by vendor and make a new page (to be printed faxed or emailed) containing all of the items associated with each Vendor. Can anyone give me some hints and ideas?

Thanks!

Link to comment
Share on other sites

I moved your post here as I think this is a more appropriate forum.

Sorry for the confusion. With the double posting issue.

Please elaborate a bit more here so that you may get the assistance you desire.

:)

Link to comment
Share on other sites

Cool thanks for the good move :laugh:

So to elaborate. I have a sales system for a mail order company. I have everything set up on it.

Here are the tables I have:

Main

# There are portals in Main that use data from the tables below

Customer Data [fields include: name, address, phone, etc.]

InvoiceLineItems [fields include: item#, description, price, cost, etc.]

Vendors [fields include: VendorName, VendorPhone, VendorEmail, VendorFax, etc.]

# There are many more tables in the DB, but these are the most pertinent.

My objective is to group all of the unordered line items (from ALL customers) and create a way to send them to a vendor. I can send orders to vendors by phone, email, or fax. To call or fax the order I can use a print script. To email the order, I can obviously use an email script. I want to know the best way to organize the line items (by Vendor) so that I can submit them to the appropriate vendor.

Link to comment
Share on other sites

This topic is 6466 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
×
×
  • Create New...

Important Information

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