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.
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
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.
RE: Incomplete Post
RE: Incomplete Post
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
RE: Incomplete 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
* 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