×
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

Incomplete Post

Incomplete Post

Incomplete Post

(OP)
Can someone tell me what would cause only one line item to get moved into history when an invoice is posted? The other line item is still in the oeordlin table. Both items were selected for billing.

RE: Incomplete Post

When you go into the order, do you get a message that says, "Order is incomplete, Do you want to reset the order status to complete?"

RE: Incomplete Post

Also, if you're in progression, you may want to check here, according to Exact:

How to correct OE order partially posted to history

Revision Date: 07/29/2015
Module: Order Entry
Version: 7.7.XXX

Description: What can be done to correct an order in a partial posting where some of the line items appear to be in history, but one or more lines are still on the open order along with the header?

Solution: If the decision has been made to push the order through to posting, you can verify that the line items are in history by going to Order Entry\Processes\Sales History\Sales History Load. Enter the order number, invoice number, invoice date and customer number. When you tab off the customer number, the screen should fill in from the defaults on the customer. Verify the data and save the header record. Exit out of the header and reopen. When you go to page two, the line items in history will have reconnected with the header. Add the line items from the open order to make the order complete. This will write the completed order to the OE Header History and the OE Line History tables. This functionality does not affect inventory and makes no distributions.

RE: Incomplete Post

(OP)
The issue has been corrected already. But the next time it happens I'm going to backup the db and restore it to another company so i can perform these tests. Thanks.

RE: Incomplete Post

Are you using Progression, Macola ES or Macola 10?

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: Incomplete Post

In the case of a partially posted order, there are a lot more places you should check besides the OE history:

* Did open AR get updated? (AROPNFIL table)
* Did your inventory get decremented? (IMINVTRX, IMINVLOC, and if there were bin/lot/serial items, IMLSMST, IMINVBIN, IMLSTRX and IMBINTRX)
* Did the proper debits and credits to A/R, Sales, COGS and Inventory take place in the ARDISFIL and IMDISFIL tables?

I would also reset allocations and run the Load OE View Master file utilities. You should also check every order in that day's billing comparing the physical invoices to the Macola data. Make sure what is left in open orders is correct (normally just whatever was backordered).

As to why this happened, typically it would be a lost network connection or the machine that ran the post was shut down or crashed in the middle of the post.

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: Incomplete Post

(OP)
I will definitely check all these great answers the next time this happens. We run Macola Progression in a virtual environment and the users all connect through a terminal server that is in the same Vmware environment, so I wouldn't think network connection could be an issue. We didn't have any power issues that day either. I was hoping it could have been missing data on the item that didn't get posted, maybe an issue with record locking, or something else. I let you guys know what i find. Thanks.

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