Home Button  Buy Button 

Topic:   New feature request: import purchase order from csv

By: GuestPosted on: Jun 5 2023 at 12:11:49 PM
It would be handy to allow bulk import of items on a PO from a spreadsheet. I typically order 40+ parts at a time from Digikey. Digikey provides a nice spreadsheet where they give you the quantity, part number, etc, of everything on an order. It would be nice to be able to import this instead of typing it all in. Thanks!

By: GuestPosted on: Jul 6 2023 at 09:44:16 AM
This probably would not be well supported and may cause issues that I do not fully understand but you could create an Excel Macro that would add the required entries to the database to create a PO using spreadsheet data.

You would need to make sure that all of the part numbers and revisions are correct and that they exist. This could also be done using Access Queries.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- New feature request: import purchase order from csv

Enter the numbers.

Your name here is optional