Order did not transfer to Inv completely

(0) Share

Report

Posted on by MRushing

140

Hello,

I have a users that has completed the process to transfer an order to an invoice. The process appears to have completed correctly, and an invocie number was generated. The order is now in history, however, when a sales document inquiery is ran the Invoice does not appear.

It appears the the process did not finish completely. Is there a way to move the order out of history or re run the transfer to invocie?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Order did not transfer to Inv completely

Hopefully you have master number tracking turned on. Find the MSTRNMBR value from the original sales order and then run this script.

select * from SOP10100 where MSTRNMBR = 'xxx'

select * from SOP10200 where MSTRNMBR = 'xxx'

select * from SOP30200 where MSTRNMBR = 'xxx'

select * from SOP30300 where MSTRNMBR = 'xxx'

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

Mahmoud, thanks for the update and corrected as below.

MRUSHING, run Check Links(Tools-->Maintenance-->Check Links) for Sales History and Work.

Hope this helps!!!

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

There would be no problem at all with choosing all the selection, take a backup just in case.

Was this reply helpful? Yes No
MRushing 140 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

When I am in the check links window I have a drop down for Series: with Sales, Purchasing, inventory, etc...

Under each of those selections ther is a selection for logical tables.

To run the checklink which Series should I select and what tables from that selection

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

keep us updated with the results.

Was this reply helpful? Yes No
MRushing 140 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

I have found an artilce at support.microsoft.com/.../en-us

and running a queery for the invoice number that the users says was shown gives no results

select * from SOP10100 where SOPNUMBE = 'xxx'

select * from SOP10200 where SOPNUMBE = 'xxx'

select * from SOP30200 where SOPNUMBE = 'xxx'

select * from SOP30300 where SOPNUMBE = 'xxx'

(sorry for the multiple posts trying to make sure it is replying to your post)

Was this reply helpful? Yes No
MRushing 140 on at

Like (0)

Report
RE: Order did not transfer to Inv completely

I have found an artilce at support.microsoft.com/.../en-us

and running a queery for the invoice number that the users says was shown gives no results

select * from SOP10100 where SOPNUMBE = 'xxx' select * from SOP10200 where SOPNUMBE = 'xxx' select * from SOP30200 where SOPNUMBE = 'xxx' select * from SOP30300 where SOPNUMBE = 'xxx'

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

I believe there is a bit of typo in here,

Soma meant to run the check links for sales module not purchasing.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Order did not transfer to Inv completely

How did you identify whether the order is not finish completely?

Anyway, try to run Check Links(Tools-->Maintenance-->Check Links) for Purchasing History and Transactions.

Hope this helps!!!

Was this reply helpful? Yes No