!What! ERP
CHeck out my new project (BETA) on !What! ERP. IT is a small, fast flexible ERP package for commercial agents and self employed agents. Everyone who is working on a commission basis
EBS Vat declaration issues
What i am wondering is why there is nobody who has a good realiable working solution for the VAT declaration in Oracle E-business suite. I am working for a company who has legal entities (ORG_ID) in about 10 different countries. Each month and each quarter the rumble starts again. The VAT declaration which i have to do out of queries, excelsheets and copy-pasting.
Some former users had this issue with payments. They have taken up the issue and started APRO as the oracle payment gateway.
Shall we do the VAT hell ????
if somebody has an exellent solution please let me know. We have used Wordtax, esstax and now do it ourselves throug scripting. But that cannot be!
EBS : Thing to do when period closes
Complete manual payments and adjustments for the period (including cleanup of ‘Out of Balance’ batches)
Check and Complete final Receivables Interface from Order Management
Complete manual invoices, DEBIT Memos and credit memos
Run your final Auto Invoice process
Correct ALL Auto Invoice rejects and re-run
Clear all receipts from Cash Management
Apply receipts against Invoices and Debit Memos
Review the Unapplied Receipts Register
Reconcile receipts
Apply Credit memo to Debit Memo and Invoices
Approve or reject ALL Pending Adjustments
Complete or delete ALL ‘Incomplete’ invoices
Complete or delete ALL ‘Incomplete’ credit memos
Correct and post ALL open Lockbox batches (If Lock Box Implemented)
Print Dunning (Reminder) Letters (Optional)
Run Journal Entries Reports
Review Journal Entries reports for ‘unusual’ accounts and correct as needed
Run Period End Reports
Balance to the Aged Trial Balance
Post to the General Ledger using the period start date through the period end date - verify that ALL steps completed successfully.
Close the period - verify that there are no items in error
Open the next period and the next Future period
Post Journal Entries (In General Ledger)
Balance to the General Ledger (for the key accounts)
Oracle new Metalink??
You all know the horrors of metalink but surfing my favorite EBS blogs, I saw something nice on the Apps DBA blog. It seems Oracle had developed a new Metalink. Looks a lot better then the old one, check it out for yourself !
New and improved metalink
Oracle E-Business Pocket guides....
Sometimes when surfing the internet you find something interesting. I don't know exactly how, but I arrived at the following site with a lot of handy guides for the dba or EBS dba.
Solutionbeacon.com
Have fun!!
Oracle E-Business Pocket guides....
Sometimes when surfing the internet you find something interesting. I don't know exactly how, but I arrived at the following site with a lot of handy guides for the dba or EBS dba.
Solutionbeacon.com
Have fun!!
C# Brainteaser compiler
Should this code compile? Does it? What does it mean?
using System;
class Test
{
enum Foo { Bar, Baz };
static void Main()
{
Foo f = 0.0;
Console.WriteLine(f);
}
}
Answer: This shouldn't compile, but it does under the MS compilers for both C# 2 and 3 (and probably 1 as well - I haven't checked). It shouldn't compile because only the literal 0 should be implicitly convertible to the default value of any enum. Here the decimal is 0.0. Just a little compiler bug. The result is to print Bar as that's the 0 value of the Foo.
C# Brainteaser print
Here's some code using the anonymous method feature of C# 2. What does it do?
using System;
using System.Collections.Generic;
class Test
{
delegate void Printer();
static void Main()
{
Listprinters = new List ();
for (int i=0; i < 10; i++)
{
printers.Add(delegate { Console.WriteLine(i); });
}
foreach (Printer printer in printers)
{
printer();
}
}
}
Answer: Ah, the joys of captured variables. There's only one i variable here, and its value changes on each iteration of the loop. The anonymous methods capture the variable itself rather than its value at the point of creation - so the result is 10 printed ten times!
C# Brainteaser arithmetic
Computers are meant to be good at arithmetic, aren't they? Why does this print "False"?
double d1 = 1.000001;
double d2 = 0.000001;
Console.WriteLine((d1-d2)==1.0);
Answer: All the values here are stored as binary floating point. While 1.0 can be stored exactly, 1.000001 is actually stored as 1.0000009999999999177333620536956004798412322998046875, and 0.000001 is actually stored as 0.000000999999999999999954748111825886258685613938723690807819366455078125. The difference between them isn't exactly 1.0, and in fact the difference can't be stored exactly either
C# Brainteaser Order it
What will be displayed, why, and how confident are you?
using System;
class Foo
{
static Foo()
{
Console.WriteLine ("Foo");
}
}
class Bar
{
static int i = Init();
static int Init()
{
Console.WriteLine("Bar");
return 0;
}
}
class Test
{
static void Main()
{
Foo f = new Foo();
Bar b = new Bar();
}
}
Answer: On my box, Bar is printed and then Foo. This is because Foo has a static constructor, which cannot be run until the exact point at which the class first has to be initialized. Bar doesn't have a static constructor though, so the CLR is allowed to initialize it earlier. However, there's nothing to guarantee that Bar will be printed at all. No static fields have been referenced, so in theory the CLR doesn't have to initialize it at all in our example.
C# Brainteaser Overloading
What is displayed, and why?
using System;
class Base
{
public virtual void Foo(int x)
{
Console.WriteLine ("Base.Foo(int)");
}
}
class Derived : Base
{
public override void Foo(int x)
{
Console.WriteLine ("Derived.Foo(int)");
}
public void Foo(object o)
{
Console.WriteLine ("Derived.Foo(object)");
}
}
class Test
{
static void Main()
{
Derived d = new Derived();
int i = 10;
d.Foo(i);
}
}
Answer: Derived.Foo(object) is printed - when choosing an overload, if there are any compatible methods declared in a derived class, all signatures declared in the base class are ignored - even if they're overridden in the same derived class!
Oracle E-Business Error Bill's Receivable
Well everybody is making mistakes so am i. And what kind of mistake. Today our company in France called. We are trying to get a new run of Bill's receivable with the due date of 10 july 2008. It runs for about 10 minutes (quick he!!) but the batch keeps up turning empty.
For your information. This kind of batch is only used in France (within our company) to create so called ' Traite l'acceptee ' or just a kind of check which the customer has to sign and sent back to us in order to cash in the money. So very important because everybody knows that if the money stops coming in, the lights will go out. And the usual pain in the ass manager will become an even bigger pain.
Analyse:
Okay user. Let me have a go at it. I go to
->Accounts Receivable ->Bills Receivable -> Batches
create a new batch with payment methode TP. Checked the view Request in order to follow the process. What do you think " The user is right ".
after an afternoon testing, trying, toad, quering i finaly got one invoice in the batch instead of the expected 1400. But we are getting there.
Solution:
On the payment methode the Lead days where set to zero days. Which means that invoices only due to the current date are selected. Thank god for audittrail but as usual the user has not done it!!. Issue solved and i will never forget this.
Oracle E-Business Suite 12
I didn't look at R12 too much yet. To busy keeping 11.5 up and running. I installed it once, and that went smooth enough. But i made the decision to not offer a complete PC to it but go virtual :-). If have downloaded from edelivery.oracle.com a nice VMWARE (89GB!!!!, are they nuts).
Next week I intend to build R12 on top of an 11g database. The OS of choice is Ubuntu.
Let do some upgrade knowledge digging here. All to impress the boss :-(
Profiling ASP.NET 2.0 Web Applications with Red Gate’s ANTS Profiler and Microsoft’s Cassini Webserver
Recently I was in the need to speed up an ASP.NET 2.0 application.
Since I already own Red Gate’s ANTS Profiler and successfully managed to profile .NET 2.0 Windows Forms applications, I decided to use it for profiling my web application, too.
ANTS Profiler supports profiling web applications by attaching to a Microsoft Internet Information Services (IIS) webserver. Since I’m only using the Cassini webserver that ships with Visual Studio .NET 2005, I didn’t want to install a full blown IIS on my Windows XP development machine.
To get a solution, whether it is possible to profile web applications with Cassini, too, I started up the ANTS Profiler online manual, but found no related help. Next, I went straight to the online forum and found one thread discussing profiling an ASP.NET application indirectly by profiling the webserver as a Desktop application.
Following, I try to describe the steps how I succeeded.
First, you need to determine the command line to pass to ANTS Profiler. ANTS Profiler needs to be passed an executable (which is the path to the webserver executable) and the command line arguments.
The easiest way I found to determine all that information is to start the website from within Visual Studio .NET 2005 (e.g. by pressing “F5″). Next, start Process Explorer and inspect the properties of the “WebDev.Webserver.exe” process.
Copy/remember the settings displayed in this dialog box. Then, start up ANTS Profiler and select to profile a Desktop application and fill the values from Process Explorer.
Complete the wizard and be sure to stop the currently running webserver process before actually starting the profiler. This is required to free the port that the current running webserver occupies, since only one port can be used by one application at the same time.
After you closed/ended the running process, you can start profiling.
Fire up a web browser and simply let your application run as you previously did from within Visual Studio (be sure that you also have remembered the URL when initially starting the webserver from within Visual Studio when pressing “F5″, as described above).
Basically, that’s it!
Now you can normally click hyperlinks, visit pages, etc. Take snapshots as required to see the current profiler results.
The name of the component(s) is used within the Windows Form Designer
While opening the windows form designer the following error pops up
"The name '
Cause:
The designer probably needs prozac . General error :-)
Solution:
Microsoft self writes on there website:
"please write down the exact message and contact microsoft supper " Yeah right, like that will bring a solution.
I say. go back one backup of your sourcefile and bringin adjusted again. This is the fastest solution. Another tip from experience " You probably have one line of code duplicate in the designer. Open the .CS and the generated code file and check it. 99% sure that this will solve your issue"
Sharepoint
Everywhere you talk to people in the document management industry the word Sharepoint is popping up. I have looked at sharepoint 2000 for the first time and was not impressed. However as a Microsoft Consultant i new that if Microsoft wanted they will assemble a team of 500 programmers and managers and will give sharepoint a boost.
Here here..Sharepoint 2007 was released and did they made an impression. At that time i was implementing document management systems like Hummingbird, OpenText and Worksite. Ok sharepoint did not have the functionality like these systems. Is Worksite mainly focussed on proffessional services and Hummingbird on the goverments. Sharepoints aims its arrows at the "lower" businesses and seems to be an entry package. And microsoft is not Microsoft with there concept. "Once in we never get out"
My dear DMS consultants and vendors. Do not underestimate the power of Microsoft. If you cannot beat them, join them.
Regards, a freelance Microsoft Consultant who does it for the extra hours of service :-)
A way of life
// "In the end it's a little boy expressing himself." Marcel
while (I_am_alive)
{
cout<<"I love to do more than just programming.";
}
A way of life
// "In the end it's a little boy expressing himself." Marcel
while (I_am_alive)
{
cout<<"I love to do more than just programming.";
}
Subscribe to:
Posts (Atom)