Core Financial Modules

[Natasha]

Kathy,

This hotfix is for 4.50 only.  Do not apply it to 4.20.  If your customer has posting issue in 4.20, it must be a different issue.

[SAGEMAS90CONSULT]

Natasha: Thank you for the reply and clarification.  I see that some of the other posters in this thread are on v.4.5 but many other MAS users are not. Perhaps it would be good for Software Engineering to look at my original post in this thread - there is a good explanation of the problem that occurs in v.4.2, which is also still supported.

[TomTarget]

I share your frustration on issues like that.

Can you duplicate the issue in 4.2 on demand,  or is it entirely random and you can't predict it?   First situation is definitely easier to nail down and fix than the second.  

Hard to fix something the techs can't duplicate.  I know I've got a couple of those random things for a couple of clients, but they normally notice the problems weeks after they happen and they are once or twice a year so it's nearly impossible to give the techs a direction to go.   One of them is dropped detail lines on sales invoices.

[SAGEMAS90CONSULT]

Thank you for the reply, Tom. The problem is in the random category.  I had asked the A/R clerk who inputs cash receipts to keep a log of the duplicate/triplicate invoices she finds as she is applying payments to the invoices, and in reviewing the log and postings, there is no recognizable pattern. She was mystified at first, but now that we know it is a programming issue that won't be fixed until the custom programming is updated and we can upgrade, she is always on high alert to look for duplicates/triplicates, to prevent showing additional sales income that the system seems to post all by itself. Hmmm.

[TomTarget]

---

SAGEMAS90CONSULT wrote:

Thank you for the reply, Tom. The problem is in the random category.  I had asked the A/R clerk who inputs cash receipts to keep a log of the duplicate/triplicate invoices she finds as she is applying payments to the invoices, and in reviewing the log and postings, there is no recognizable pattern. She was mystified at first, but now that we know it is a programming issue that won't be fixed until the custom programming is updated and we can upgrade, she is always on high alert to look for duplicates/triplicates, to prevent showing additional sales income that the system seems to post all by itself. Hmmm.

---

Custom programming?

From an earlier post you made.

----------------------------------------

I searched the Sage KB and found nothing there. The Sales Orders and following Sale Order Invoices have been entered manually and not from a VI import or other Auto generation task such as SO from PO, nor is there an extended solution used.

-----------------------------------------

Are you positive that this custom programming might not be related?  Especially since there are no other reports of this in 4.2?  

[RosieD]

I just wanted to chime in here (I often read the forums, but rarely comment).

My company was on 4.2 until June of 2011, when we upgraded to 4.4 (could not upgrade to 4.5, as we use a 3rd party addon that wasn't yet compliant).

In 4.2, we oftentimes experienced double posting in the sales order module.  Sometimes it would be entire invoices, sometimes it would be sales tax, and sometimes it would be a random line item from a sales order invoice that would double post.  It appeared to be random.  Sometimes it would post one sided journals and pull the trial balance out of balance.  I made a lot of one sided journal entries.

My reseller at first told me I was lying (not kidding).  He told me there was no way the software would just hiccup from time to time and double post things. 

... Until I showed him.

Then he suggested it was our third party software.  When I showed him that it was happening from sales order invoices, regardless of the source of those invoices (even data entered directly into sales order invoice data entry would sometimes double post), he told me he would 'get back to me'.

That was two years ago.  I'm still waiting.

The problem appears to have resolved itself once we upgraded to 4.4.  I haven't had the sales order trial balance out of balance with the GL since we upgraded. 

Just wanted to report, that's the only thing that fixed our problem.  I had both the reseller and a technician directly from Sage dial in and look at the issue and they were both mystified.  Both suggested at one point that it was my hardware causing the software to malfunction--a theory disproved as soon as we upgraded and the problems disappeared... when we still have the same hardware.

Good luck.

Rosie

[TomTarget]

My understanding,  is run the sales journal twice.