5 replies to this topic

[Egan]

Is there a way to build a report for specific order types that also includes the item#'s on each order?

[dseibold]

Is there a way to build a report for specific order types that also includes the item#'s on each order?

It's important to say what version of MOM you are using and what program you want to use to create the report.
Yes, it's possible if you have a report program that works with your version of MOM.

Then, it's helpful to give an example of what you mean such as:

I want to create a report of drop shipments that lists the item numbers, quantities, order number, and date ordered. I want the report sorted by item number.

Then those of us who are familiar with reports can give you assistance.

[Egan]

MOM Version 7i.
I was building reports out of what is available in MOM already, Can you suggest a couple good reporting programs?

The report I was asking about was for orders (dropship and shipped from us) with a specific order type (which is simple in MOM), but I also need it to show the item #'s that were on each order.

[dseibold]

With MOM 7i, I believe you are limited to the MOM Report Builder. I haven't begun to work with that so I won't be able to give you details.
Basically, you want to link the CUST table with the CMS table to get any customer data you need (name, address, etc.)
The CMS table will provide the order number and type for the transaction.

Then link the CMS table to the ITEMS table to get a list of items on the order. You might want to select items by date ordered, status or shipmethod, etc.

Hopefully, someone who knows Report Builder can fill in the blanks for you.

[planetdj]

MOM Version 7i.
I was building reports out of what is available in MOM already, Can you suggest a couple good reporting programs?

The report I was asking about was for orders (dropship and shipped from us) with a specific order type (which is simple in MOM), but I also need it to show the item #'s that were on each order.

Hi Egan,

Do you have Report Builder installed for 7i yet? If not, contact Dydacomp for a 1-user license and then report back here.

[Megan]

Hi Egan,

Do you have Report Builder installed for 7i yet? If not, contact Dydacomp for a 1-user license and then report back here.

Okay, Finally got report builder installed and ready to go. Can anybody assist me with the following reports:

1. Report for a specific order type, with order numbers, and items on the orders.

2. Report for Serialized Inventory and the specific orders that they were shipped on.

Thank you for your time it is much appreciated.