Business Analytics Data - Purchase Order Vendor Number
in progress
M
Mark Cohea
In the Purchase Order section and the Purchase Order Item section of Business Analytics we are looking for one data field to be added - it seems counterintuitive that it's not available. We need the Vendor ID number. This is a unique identifier in D-Tools for vendors AND it is in other software programs. So, when we export the PO data from Business Analytics, we can't import it into our accounting software because the Vendor ID number is not there.
We are having to change all of our vendor names with the number.
How we'd like to have the data:
Vendor Name: ABC Distributor
Vendor Number: 12345
But since the vendor number is not available, we have to change our vendor names to this format:
Vendor Name: 12345 - ABC Distributor
PLEASE HELP
N
Naresh Nichani
marked this post as
in progress
Mark Cohea Kevin Frye - This is doable and we will look at getting this done in a v23 fix soon. Will keep you posted.
K
Kevin Frye
Thanks for the feedback. Can I ask how exactly you use the Vendor Number? It would seem to me the that Vendor name is more important. I think it should be a simple update to get this in the report but I'm always interested in understanding workflows.
M
Mark Cohea
Kevin Frye, our accounting software needs the vendor number in order to import PO's. That's how they tag the vendor info in the PO. But as a matter of fact, there are a lot of data fields that would be helpful to have. Any of these business analytics reports would do well to make any and all data fields available - not limit them to a select few. This gives us the most flexibility. For example, we would really like to have product custom fields available in the Item PO module. We use one of the fields for cost codes. This would give us the ability to import line-item cost codes on our PO's. As it is we currently have to make one cost code per PO. And we are using the Vendor Reference number to do this. It makes everything manual
K
Kevin Frye
Mark Cohea The PO data flows back to the project where you then have access to custom fields. Maybe a project items BA report would give you what you are looking for. Also consider an Excel report which has access to a large number of data fields.