marketing-assistant.com

Is there a wild card character for this program. Like in SQL or Ms Access.  If I wanted to pull a report but not limit it to a certain customer or product how would this be done. For example when product comes in I want to be able to inventory and package all in one shot. See all my customers orders on one page and the person who ordered.

I think the first report you mentioned.

It would look something Like this. Ideally you would be able to control the sort.
Usually I would do a data extract for something like this but I don't have ODBC driver for TPS. 


000-000   some description  Joe Somebody
001-002   other description  Joe Smith

Qty field is a must.
Regarding Sort
I would like to see user control added here. One might like the sort by product number or by customer or by product description. As you know users generaly have diferrent preferences.

I'm wondering if anybody else has any imput on this.

How are you getting you data in Excel?

I guess I just print out my invoices for each campaign and use those to check against my invoice and my order.  Then I make the adjustments to those that I need to and reprint them for the customer. I keep the ones I made changes to for my records.  Works well for me.  I do everything in MBA...guess I never saw the need to use Excel as well, but everyone likes to do their business differently.

Here is what I do when my order arrives:
I print out all my customer invoices as they were when I submitted my order to Avon.
I take the first invoice and get the prodcuts out of my order that belong to that invoice.  I then check the price I had charged the customer against the invoice I received from Avon to make sure I am charging the customer the same retail price I was charged....I have had many instances where that has differed and was burned...so I always make sure to check this now.
Then I mark off on the customer invoice that it was ok, or make the price adjustment necessary.  I also mark it off of the Avon invoice so I know that item was received.
At this time, I also check the customer invoce to make sure tax is calculating correctly, or that their previous balance is correct, etc.  Since I give my customers a free gift after every 15th item purchase, I write the new total on their invoice so I can enter that into MBA in the Points feature.
Once I have gone through all the invoices and made adjustments and matched them to the Avon invoice, I go back into MBA and make the changes that I put on each invoice.  Then print the final copy out for the customer. 
With all the changes I make to each invoice while unpacking my order, I need to see the invoice rather than a report...for two reasons:
1.  Not all the information I need to see would be on the report
2.  Not always do the reports match with the final results and I want to make sure the invoice going to the customer shows the correct amounts.
If someone has an easier way to do this, I would certainly like to hear it! 

I submit mine on Mondays at noon so on Sunday night, I make sure that ALL my orders are posted in MBA.   Then I print out the Purchase Order report by product number.  I go into Avon website and use that report to enter my purchases all at once.   I used to use the upload features but I kept having problems with it and decided it was easier just to manually enter my stuff.   Plus, I didn't like that MBA doesn't combine product #s so if you have 3 different customers order the same product, you'd see that item 3 times on the invoice.   Takes me 15 minutes to plug it all in.  Then I print my order from Avon website and compare to my purchase order to make sure I didn't key it wrong.   I submit as usual on Monday and when my invoice posts, I print it out.  I enter my shorts into MBA so that it will adjust my customer invoices and then print them out.   When my order arrives, I check everything off on both the Avon invoice and the purchase order report to make sure everything was received and for the correct amount.    Then I start bagging according to the customer invoices.   Anything left over is extra inventory, supplies, or personal stuff and I check that off the Avon invoice.