x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Subscribers 138 subscribers
  • Views 2302 views
  • Users 0 members are here
Browse Forums
Announcements
235
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
411
replies
Sage Intelligence Reporting
121
topics
322
replies
Christine T.

sales order record has null values

SOLVED
Posted By

today we came across something quite bizarre.  A user created a shipment however when she went to tunnel to the sales order from the shipment screen there was an error 'no transaction authorized' .  I went into the sales order function and could not locate the sales order.   I then went to table maintenance on the SORDER table and while the record exists all the fields have a null value.   Fortunately we recently copied our production folder so I was able to compare the SORDER table between the current and former versions.  only the customer# and SO number displayed in the fields of SORDER.  All other fields were blank.  I then compared the SORDERQ table between folders and all was well there.

so my question is- how can something like this happen?  Has anyone experienced anything like this before?  I advised the user to delete the shipment and re-enter a new sales order however for reporting purposes this SO will not display since all fields are null.  I don't even know how to go about duplicating the issue.

Please advise if anyone else has seen this or has an idea on how this can happen. 

Thanks,

Christine

  • 0

    Check access codes. If the function/entry type has an access code on user level, that access code should be given to that user.  What happens if the Admin User tries it?

  • 0 in reply to Craig Wilson

    its not access code related.  I have admin access.  The SORDER table is not holding any values however the SORDERQ table does.  I'm looking directly in the SORDER table in table maintenance and the only values are on the SOHNUM and BPCORD field however when you search the SO number on the screen it doesn't appear (obviously since all the table fields are blank)  it is very strange and i'm concerned that if it happened once it can happen again.  :-0

  • +1
    verified answer

    We have had similar issues that happen sporadically … Delivery created but the SORDER header gets corrupted, missing the SOHCAT settings and all BPC related addresses and billings.

    We have assumed (since it's very sporadic and in frequent) either the Delivery creation process encounters an issue if the SORDER is in use or we had connectivity issue during delivery creation.   We manually fix in Database Maintenance and populate the values in the header.

    Last week we had 4 orders with header issues, but it was months since the last one.  Not clear on the scenario causing issue and have manually fixed.  Our users often get into sales orders and our delivery generation runs automatically, so not sure if its just timing, etc.

    Would be interested in root cause.

  • 0 in reply to Couzins

    WOW! thanks so much for advising you have similar issue.   We create the delivery from within the delivery function by selecting the SO from the drawer (not automatic and not through the SO function) however it is constant that sales orders are locked by other users where I need to go into Verifications to unlock the record.  We also have had some connectivity issues so possibly this record was corrupted at that point where we lost connection.   I was skeptical about adding the missing header details in table maintenance however the missing details would adversely effect reports and inquiries so I will just go ahead and correct manually.

    thanks again for your reply!

  • 0 in reply to Christine T.

    I did find looking at VSORDER that the address info and missing elements are there which I use to re-populate the header from a revision history.

*Community Hub is the new name for Sage City