{"id":306,"date":"2022-12-01T12:46:26","date_gmt":"2022-12-01T06:46:26","guid":{"rendered":"http:\/\/itllive.com\/knowledgebase\/?p=306"},"modified":"2022-12-01T12:46:26","modified_gmt":"2022-12-01T06:46:26","slug":"how-to-resolve-duplicate-record-number-issue-for-open-item-adjustment-in-qad","status":"publish","type":"post","link":"https:\/\/itllive.com\/knowledgebase\/2022\/12\/01\/how-to-resolve-duplicate-record-number-issue-for-open-item-adjustment-in-qad\/","title":{"rendered":"How to resolve Duplicate Record Number issue for Open Item Adjustment in QAD"},"content":{"rendered":"

First, find out Journal ID associated with the Daybook.<\/p>\n

for each journal where journalcode = \"CUSADJST\":
\ndisplay journal_id.<\/code><\/p>\n

Then, find the last sequence used for that Daybook and Year.<\/p>\n

find last posting where postingyear = 2022 and journal_id = 00000430293.
\ndisplay postingvouche.<\/code><\/p>\n

Finally, update the sequence if the numbers skipped to a difference sequence altogether.<\/p>\n

for each company where companycode = \"ent002a\",
\neach numbr of company where numbryear = 2022 and numbrtype = \"cusadjst\" :
\nupdate numbr.numbr numbrstatus.<\/code><\/p>\n

Reopen Open Item Adjustment and try to create again. Before saving note the voucher number generated by the system and check if that is what you want.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

First, find out Journal ID associated with the Daybook. for each journal where journalcode = “CUSADJST”: display journal_id. ...<\/p>","protected":false},"author":1,"featured_media":307,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,1],"tags":[36,37],"class_list":["post-306","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qad","category-uncategorised","tag-number-table","tag-record-number"],"_links":{"self":[{"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=306"}],"version-history":[{"count":1,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/306\/revisions"}],"predecessor-version":[{"id":308,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/306\/revisions\/308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/media\/307"}],"wp:attachment":[{"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itllive.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}