Recent content by hungtran817

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.