Search results for query: *

Hmmm- could anyone help me with this query I started. I want pull the customers information if they are more than 5 days late on a payment- I'm getting a error message SELECT dbo.AROBL.CODETERM AS "Terms Code", dbo.ARCUS.EMAIL1 AS "E-Mail Address", dbo.ARCUS.IDCUST AS "Customer #"...

Hello, I'm trying to send customers escalating emails based upon how many days late they are. I tried exporting a list out of AR Customers where I set the criteria to day's overdue to 7, 14, 21- When I pull the report, there is a bunch of 0's in the days overdue column? Is their a way to...

I updated the customer master and it worked like a charm[bigsmile]

No sure- I'm a novice, does this help http://screencast.com/t/HaYhFkc2teC

The objective is to record the sales to the correct group. When we look at the sales report we want these customers sales to be displayed in the correct group.

Can I export the customers I submitted in the wrong group, do a find and replace to the correct group and then export back in?

Hello, I accidentally submitted orders- about 700 of them- each a unique customer with the wrong group code. These orders have been shipped, invoiced, and the batches posted. Is there a way to go back in and change their group code after this has been done?

Worked great- thanks[bigsmile]

Hello, We would like to export an existing batch edit the file and import back in the updates. Is this possible? How do we change our file. Currently when we try to import it back in it is trying to create new records and not update the existing records.

Do you think a professional could customize to apply the payments differently?

Unfortunately the prepayments are not consistent-

Hmmmm- At the end of they day we collect $14.95 up front with the order and then would like to collect three equal payments of $99.95. Is there a way to apply the prepayment from the order to accomplish this. Thanks for your patience[bigsmile]

Let me try again. Why doesn't the payment schedule reflect the prepayment on the Invoice?

Is there a way to reaply the prepayment to the invoice and how does it affect a multiple payment schedule.http://screencast.com/t/HeozSq3vx3UD

He is OE invoice screen http://screencast.com/t/yDNETOeMQ

This is what we are seeing http://screencast.com/t/f2AEUP2Ud22g We have version 5.5

We can see the prepayment in OE-order entry, we ship and invoice from OE-Order Entry. Then when we pull up the Invoice in OE-invoice entry we cannot see the prepayemt.

Yes - we have posted invoice in A/R. Here is the posting order of documents. Are we posting in the wrong order? Order created Prepayment created – applied to ORD Shipment created Invoice posted End of Day Invoice Batch posted Receipt Batch posted

Yes

There is a prepaid document that is applied to the order but when we post the invoice it is not automatically reapplying to the invoice. Example- order is $315 with a $15 prepayment and then the terms codes splits the balance into 3 payments. The invoice is showing the full balance and not...