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
[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
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
[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
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
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
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
RE: Invoice Stuck in Posting
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Invoice Stuck in Posting
RE: Invoice Stuck in Posting
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Invoice Stuck in Posting
RE: Invoice Stuck in Posting
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Invoice Stuck in Posting
RE: Invoice Stuck in Posting
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com
RE: Invoice Stuck in Posting