x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 137 subscribers
  • Views 218 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
YONG ZI HEAN

Purchase receipt document missing

SOLVED
Posted By

Hi everyone,

I have encountered an error where the purchase receipt document is missing but the Stock transactions have recorded the product line in the purchase receipt. I found this problem when creating a new purchase receipt and the 'Record already exists' error message popped out, I reviewed the purchase receipt screen and was unable to locate the record and I had to manually change the next value in the 'sequence' to create a new purchase receipt.

The record already exists error message:


Stock transaction record:

Purchase Receipt for PRP00103 does not exist:


I reviewed the database and found out that PRECEIPTD table contains the record while PRECEIPT does not have it.
May I know what might caused the system to not generate the record for PRECEIPT and is there any solution for this issue?

Is it possible to reverse the stock journal or delete the records in STOJOU, and delete the records in PRECEIPTD table, then redo the purchase receipt again?

Current version and patch: 12.0.31

Thanks in advance for your assistance

Top Replies

  • +1
    verified answer

    Hi  

    This is not a known issue (as far as I know).

    You should report it to your support team.

    YONG ZI HEAN said:
    Is it possible to reverse the stock journal or delete the records in STOJOU, and delete the records in PRECEIPTD table, then redo the purchase receipt again?

    Usually you can delete a receipt that will create a second record in STOJOU with a negative quantity and remove the stock (only possible if the period is opened the receipt not invoiced and if the stock still exist unchanged).

    Of course, with a missing header record (in the table PRECEIPT) you will never be able to select the receipt and to delete it. So you can try to re-create the missing header record to be able to delete it. But we don't know the extend of the data corruption (is the PO line considered as received? for instance). So it's is difficult to say if this will work.

    In anycase, be sure to test this process in a test environment before creating record in the database of the Live environment.

  • 0 in reply to Julien Patureau

    Hi Julien Patureau,

    I've conducted tests in the TEST environment by inserting records into PRECEIPT, and it's successful!

    The inserted record appeared on the purchase receipt screen, allowing me to delete the purchase receipt. However, the process of inserting records into the database can be frustrating, especially when dealing with data like the AUUID, which has a very long value such as '0xC2A1290D8A298547A60D8C6659A7B'. I'm uncertain about its significance and affect to the system, so I ended up filling it with '1'.

    Thank you very much for your assistance.

  • 0 in reply to YONG ZI HEAN

    I am very glad that it helped you.

    At the end of the day the AUUID is not meaningful as you will delete this record afterward along with the linked records in the other tables.

*Community Hub is the new name for Sage City