A/R Invoice Problem

[SusanD5320]

SQL 7.6.200

We have had this happen 3 times (2 different customers) in the last 2 months. When printing invoices, the total sales printed on the invoice and posted to A/R is zero. Line item extended price is correct and posts correctly to Sales account. COGS/inventory post correctly. So when trying to post from A/R to G/L the amounts are out of balance.

When it happened yesterday, we caught it while reviewing the printed invoices. The invoice did not show on the Pre-post invoice report. The order status displayed 8-Selected on the OE header. There was some confusion on unselecting the order. The cust serv rep indicated that she couldn't unselect it but I was able to. We re-selected for billing and everything went fine after that.

There were no printing issues and the invoice immediately before and after printed correctly.

The customer and items on 1/20 are the same as on 12/17. However, there were 6 line items 12/17 and only 3 on 1/20. Also, the ship-to addresses are different.

We invoiced this same customer on 1/19. The 3 items on the 1/20 invoice were invoiced on 1/19 plus one additional item.

These items are sold frequently to multiple customers.

We ran the validation in SM on the customer, item master and item/loc for the specific records involved and no errors were found.

This order already existed in our test company. So I selected the order for billing and printed the invoice and there were no problems.

This is happening too frequently and I'm open to suggestions on how to resolve.

Thanks, Sue

 

[crystalreporting]

Does the sales order audit trail show that these orders were selected for billing, and then unselected? Macola flags both the OEORDHDR and the OEORDLIN files when an order is selected to be billed. I have seen where an unselected order leaves the sales order line selected (select_cd = 'X'). I believe there is (or was) an inconsistency depending on how you unselected an order i.e. via the unselect function, or select the order again and electing to clear the previous selections. There was also a bug with 7.6.200 where unselected orders would print invoices - make sure the patch was applied, and maybe consider moving to 7.6.300 as it is much more stable than 7.6.200.

Peter Shirley

http://www.linkcorp.com

 

[dgillz]

The invoice printing issue for orders not selected for billing was in 7.6.300, not 7.6.200. If you go to 7.6.300 be sure to install service pack a.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[crystalreporting]

That'll teach me to answer questions late at night - thanks Don, 7.6.300 was indeed the version with the OE selection/invoice bug. I'd still look closely at the audit trails to see if you can identify a pattern - somewhere in the back of my mind (a long way back) I remember a similar problem when selecting/unselecting orders..

Peter Shirley

http://www.linkcorp.com

 

[SusanD5320]

The audit trail on the order header shows that it was selected by the customer service rep. It also shows my unselection and then cust serv re-selecting.

 

[AKPolarBear]

We have had the same issue in 7.6.100a. Finding no solution from Macola, we created a couple of Crystal reports to help us find and correct the problems as part of our OE processes.