×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Invoice Stuck in Posting
2

Invoice Stuck in Posting

Invoice Stuck in Posting

(OP)
I'm not well versed in the ES menus (or accounting terms) so bare with me while i try to explain as best as I can. I have an invoice number that is stuck before posting. I can see the order number in the following tables.

[dbo].[oeinqord_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oeordhdr_sql].[ar_reference]
[dbo].[oeordhdr_sql].[ord_no]
[dbo].[oeordlin_sql].[ord_no]
[dbo].[oepdshdr_sql].[ord_no]

A good order that finished going through from the same batch shows up in these tables.

[dbo].[amutas].[bkstnr_vrz]
[dbo].[gbkmut].[bkstnr_sub]
[dbo].[oehdrhst_sql].[ar_reference]
[dbo].[oehdrhst_sql].[ord_no]
[dbo].[oeinqord_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinhst_sql].[ord_no]
[dbo].[oepdshdr_sql].[ord_no]
[dbo].[oepdshdr_sql].[ord_no]

I'm sure I'm not giving enough information but any help would be greatly appreciated. I'm more than happy to follow up with more info.

Macola ES version 9.6.900
~N

RE: Invoice Stuck in Posting

If you run the pre-post invoice register after everything has posted, then the 'stuck' order/invoice should show there and you will often be able to tell why. The most common reasons are duplicate invoice number and invalid GL accounts. Looking at your list of tables that the order/invoice exists in, it is not partially posted so you should be able to correct it by doing the following;

1). Print the invoice again (by enabling the print duplicates check box).
2). Respond NO when asked if the invoice printed OK.
3). Unselect the order.
4). Review the order and make any required changes.
5). Print the order.
6). Post the order.

Note that the steps above will assign a new invoice number.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Invoice Stuck in Posting

(OP)
OK I tried what you recommended CrystalReporting, but my AR clerk got an error message. Now the order is in the following tables, still unable to post.

[dbo].[oeinqord_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oelinaud_sql].[ord_no]
[dbo].[oeordhdr_sql].[ar_reference]
[dbo].[oeordhdr_sql].[ord_no]
[dbo].[oeordlin_sql].[ord_no]
[dbo].[oepdshdr_sql].[ord_no]

One thing that jumped out at me is that in the table [dbo].[oeordhdr_sql] the status column value is 9.

RE: Invoice Stuck in Posting

What was the error message? On which of the 6 steps did it appear? How about a screenshot? Peter's solution should work perfectly.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Invoice Stuck in Posting

(OP)
The error messages is
Error Number 94
Source Bank\CreateTransaction
Invalid use of Null.

The error message came on step 6



Edit: Performing the above 6 steps a second time somehow fixed it. I'm not sure why it didn't work the first time but did the second.

RE: Invoice Stuck in Posting

If you take step 4 - review the order for accuracy seriously - and by that I mean tabbing thru every single field of the order header and order lines - you should never get this again.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Invoice Stuck in Posting

(OP)
I have this issue again and it's slightly different now. At the reprint order step (1) I'm getting an error "No data which meets the criteria entered" It's also not showing up on the pre post.

RE: Invoice Stuck in Posting

In order view, what is the status of the sales order in question?

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Invoice Stuck in Posting

(OP)
The status says open.

RE: Invoice Stuck in Posting

Click on the Order Header Info. button in the Order View Screen - the status should show there. It will show 1 - Booked, 8 - Selected etc.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Invoice Stuck in Posting

(OP)
OK the status there says 9. Invoice PRT

RE: Invoice Stuck in Posting

An order in status 9 is printed (from Macola's perspective). You should be able to print it again using the regular invoice print function as long as you are using the 'Print Duplicates' option. If you are using the 'Print Duplicates' option and are still getting the 'No data' message, then try using the regular (non Crystal) invoice print (assuming you are using the Crystal invoice).

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Invoice Stuck in Posting

(OP)
My AR person just went in and tried looking at it and the status changed to 8 - Selected

RE: Invoice Stuck in Posting

The only way the status would change from 9 to 8 is if someone completed the step you were trying to do i.e. print the invoice with 'print duplicates' enabled and respond no to the invoice printing OK.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Invoice Stuck in Posting

(OP)
OK. I verified that she (AR clerk) did do that. I'm still getting the same error though.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close