×
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

Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

(OP)
Hi Folks,
I have recently been tasked with overseeing our Macola ES system.
I have used this forum extensively to resolve several issues but have encountered an issue that does not seem to have come up in the forums.

One of our users uses Shop Floor Order Entry when manufacturing items.
We do not use this feature very often, the last time was in December 2021.
The user attempted to enter a new Order in February 15, 2022, but got stuck on the Start Date.
Message indicates "Shop Calendar Detail Record Does Not Exist".

I checked the Shop calendar and sure enough the end date of the calendar was December 31, 2021.

I have tried the following to resolve the issue:
1. I modified the end date of the calendar but the message persisted.
2. I created a new calendar with new start/end dates.
3. I deleted all existing calendars and created a new calendar, making sure the calendar number was the same as the original.
4. After creation of new calendar I went into SQL Studio Manager and verified that a record for 2022 dates are listed in the hzshpdtl_sql table.

If any of you have seen this or have any idea what I am missing please let me know.

RE: Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

1 System Mfg - Global - Calendars - Check both the Shop Calendar and the Reporting Calendars
2 System - Package Setting - Mfg Setup - Check which Calendar Numbers are your defaults

RE: Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

(OP)
NEmacGuy,
Thank You!
The default calendar in Mfg Setup referenced a calendar that had been deleted.
Updated to the new calendar that was created and all is working.

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