Sage 100

Upgraded customer to 2014.4 middle of December (vanilla system). They started getting OOB sales journals. Since they have Gold support, they have been working with Sage. The sales tax shows up on the printed invoices but then disappears when updating and the journal updates OOB along with invoice history doesn't show the sales tax. Sage indicated this is a known issue and engineering is working on it. This is the first I've seen or heard of this issue, wanted to let others know in case they come across it. Anybody else seen or heard this?

WHAT????!!!!?????

More details when you get them plz

We also have a client experiencing this. When the Sales Order Invoice is printed, it displays the correct amount of sales tax. However, after updating the Sales Journal and Daily Transaction Register, the Sales Journal is not out of balance, but it is missing the sales tax and the Daily Transaction Register is out of balance missing the credit amount for the sales tax. The invoice when viewed in Customer Maintenance is missing the sales tax. This is happening sporadically with no apparent patern. We have a case open with Sage and have submitted our clients company data.

We also have a client with this issue and we have a case open with Sage, too. Have not heard anything back yet.

Did Sage indicate that this is an issue that came with PU4 ?

I have a client that has experienced this intermittently since we went live on a 3.71 Advanced to 2014.3 upgrade. Thing is that it only happens when invoices are printed to one of the two printers they use. After they discover it's happened they go through the batch and click on the tax detail button for each invoice and it fixes the invoice. It happens in groups starting with a particular invoice and ends later in the same batch or next batch. Invoice is OK when printed but has no tax after the print and is OOB. Since it first happened the client has been reviewing the sales journal before posting to catch this and fix it.

@RonGouveia - are you indicating after invoices are updated, they can click on tax detail and it fixes it or after printing but before updating. Our invoices print ok so customer doesn't know that it's going to happen till the OOB shows up in the DTR.

Now that they know it happens they review the sales journal before posting and it's evident that some invoices have no tax. they fix it then post.

Our client was upgraded this summer to from 3.71 to Standard 2014.3 and Sage indicated it was because they were using an alpha characters as the first number of the invoice and some of their invoice numbers were LESS than 7 characters. We did NOT submit any data as Sage was able to reproduce it. Our customer watches it closer now, too but it continues to happen randomly.

@MaryMays I relayed this info to my customer and she indicated that they too are using alpha characters for some invoices (they have for several versions) and it appears to be only happening to those. She is going to try the tax detail resolution from @RonGouveia as a workaround. Thanks everyone for your help!

Client says the issue is happening to invoices that start with a letter although all invoices have seven characters and it is intermittent. they are going to start these invoices with a 9 rather than a letter for now until this bug is fixed because it's time consuming to fix the errors. Thanks @MaryMays for the tip. Very helpful.

Blogged on 90 Minds - http://community.90minds.com/2015/01/07/out-of-balance-sales-journals-with-missing-sales-tax-sage-100-erp-2014/ x-post Sage Linkedin Sage 100 Grp

I had the same about 3 months ago. Didn't know it was an issue because we found the culprit and I had to go to DFDM to correct several things. We found that 2 of the tax schedules were corrupted during conversion to 2014.

If I recall correctly, the detail lines of the Tax Schedule were duplicated. I had to delete some of the lines. Any invoice that was posted with that Schedule was causing an OOB journal.

I think that's a different issue because this issue only causes OOB invoices that start with a letter and only after they are printed.

I've run into the issue that @KennyDaniel describes in 2014. I think I've also been able to get journals to post OOB if I change the tax status on a line in an invoice.

I went over the client's office and watched them fix the OOB invoices. They changed the tax schedule on the header and clicked Accept. Then they went back into the invoice and changed the tax schedule back and it fixed the invoice. They confirmed that it was only invoices that started with a letter.

Thanks @RonGouveia - I'll pass it along to my customer.

Fix: https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=52666&sliceId=1&cmd=displayKC&dialogID=60652&docType=kc&isLoadPublishedVer=&stateId=60653&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

NOTE: The above hot fix also requires the latest product updates for both 2014 and 2013.

great thread!!!