Search results for query: *

Hi- I'm trying to true up the cost of an item, here's the history. 1/13- 0 onhand, $10.90 1/14-recvd 12 @$12 then sold 1@$11.78 same day. 2/22- matched invoice 12@$12.58 Now- 11@$12.24 I'm puzzle at the point where we sold it at $11.78. I would think that once we received it at $12, it...

Yes, I'm testing with new transactions, my shipping method is delivery. Are there any other setting I need to changed.

On the Sales entry, I'm trying to charge tax on freight based on the customer. Here's what I tried so far: 1) Setup "Frt tax" tax schedule and added the customer's tax detail that will be affected. 2) SOP setup options, changed the freight- tax options to "taxable" and added the "Frt tax" tax...

we use not to depreciated these assets, so we had them in inventory. Now we have to continue the depreciation. The main reason why we putting them in inventory is because it's not in use and stored at our warehouse. We never had an issue til now. Our main use of GP was as an inventory system...

Hi, I wrote some report but everytime I open it in ePortfoilo, it ask me for database login. I read that you can't save the password on the reporting side. How do you save the obdc login in RAS9 ePortfoilo lite or how could I fix this problem? thanks,

We are having a change in our depreciation policy. The old policy allows us to suspend the depreciation on our used assets that were sent back to our warehouse to be refurbish and sent out to other locations. Sometimes the asset could sit at the warehoue for months. Now they changed it to...

Thanks for the response. I had someone manually go thur all the orders and voided them already, but will keep these tips in mind next time. It was less than I expected. Hung

What's the best way to void (>900) old sales orders? I've tried Integration Manager but no success. GP 9.0 Thanks, Hung

I'm trying use IM to create sales order with multiple items per order. I've tried with two source - Header and Item. Linked both by Doc Number. My result came out with only one item on each order. What am I doing wrong? IM v9 GP9 Thanks,

It works , thanks. My other options was inserting a subreport.

I'm creating a report that shows all orders for a particular day but can't get the correct data. I'm looking for a table that contains both SOP live and history. I've tried using SOP10100 and SOP30200 but had no success. Is there a table that has this or what other tables do I need to join to...

It works, thanks.

Is there a formula to convert a date to month-year format so I can group in my charts and reports?

I'm using CR XI and I'm trying to display my amounts in thousand. Example: 238,893 display 239 Thanks, Hung

It works, thanks.

I've tried the crosstab route and it didn't like the way to worked. Most of my summaries are running totals. The subreport works perfectly, the only thing is that when I run the report, it ask for the parameter twice. -Hung

Hi, I got this report that I want for the report footer to print as the first page. The reason is that when I place all the summaries on the header, my totals doesn't tie up. So the only way is to have it at the footer. Any suggest either about printing the footer or redoing my summaries would...

Hi Madawc, Thanks for the quick response. It's the variable formula that I'm having trouble with. At the moment, I'm trying a formula to concatenate the item number with each incrument number so I could get (7) different records. After that I hope I could just use the 'new page after'. Think...

Hi, I'm trying to insert a page break after each individual qty. For example, if my query pulls Item A with (5) qty and Item B with (2) qty. Even though, my query returns (2) records, I want to insert a page break after all (7) items. Any suggestion would be appreciated. Using CR 9.0. Thanks...

Hi, We just recently upgraded from GP 7.5 to GP9.0 and imgrated all our Crystal Report (CR) forms ei. Purchase orders, sales order, and etc. from CR 9 to CR 11. We are using terminal services and Thin Print for printing. My two problem, (1) is that when printing a PO, a CR's page setup box...