Thanks guys for help me for Inventory.
Can you please help me to do the same for Order Entry and Purcahse Order please.
That would be highly appreciated.
Hello guys,
Can you please advise, if I delete the Inventory data by using DROP command in SQL. Is there any impact is going on the system?
My inventory team are not wants to see the stock, items detail and items history (almost new database).
Any suggestion please....
Thanks Guys,
I just had a chat with my friend and he advise me to check the Exchange gain or loss details so it will resolve your problem.
He is on client site so unable to talk with me in detail.
Can you guys please navigate me from where I find this exchange gain or loss detail and how I...
Thanks ettienne,
At the time of transcation the rate was 1.8900000 and no body revalued it but when we run the GL we found that system calculate with 1.89435224.......
Thanks Tuba2007 for the clarificaiton.
The problem I diagnose is, In GL when you run the source currency and functional currency report it shows exactly the same exchange rate I put in the system but when we calculate the difference then it shows that system automatically picked the...
Thanks Ettienne,
But this is not I am looking for.
I am looking something round or spread option. I found a Spread option in exchange rate but have no idea about it's formatting.
Can someone help how I format the spread column to change the value from 1.984423232 to 1.98 ?
Thanks.
Absolutely.
But my company found some difference with the dollar values. So they decided to go with the first two digits after the decimal value.
Please suggest.
Dear All gurus,
we set the Accpac to restrict the user from putting zero for any items which have insufficient quantities. So for those taking the chances to put zero and later they will add qty it will block them when they do so. Also qty committed is always equal to qty ordered.
I tested it...
Hi Guys,
Can someone help me to round the exchange rate.
My exchange rate is 1.984329839
Would it be possible I can round this rate to 1.98? If yes please suggest how.
Thanks heaps,.
Thanks Tuba2007,
You are always ready to help.
I am not a programmer, can you please guide me the steps or let me know any document which shows how i do this.
Many many thanks.
Dear all,
I have a one database called ONEDAT in my SQL Server.
I am also creating a new database called TWODAT. Now i copied all the data from ONEDAT to TWODAT.
Problem:
Can someone tell me how I make Inventory ZERO in my TWODAT? I need all the rest information except the inventory details...
Dear all fellows,
My company has a brand logo which prints on every logo.
My company has some subsidary companies as well. Is it possible I can use that subsidary logo on all my reports underneath my company logo?
Thanks in advance.
Dear all gurus,
I have around 10 companies so as 10 databases as well.
The guy who created these databases also created 10 different system files as well. This will give us some hard time when we add new group or security so we need to create the same in each database.
Can some one help me to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.