Posting stock take is throwing an error. See figure 1 below for error message.

Steps to replicate:

1. Create stock take for Items A001 and A002
2. Counted items to have a variance
3. Post stock take adjustment. System throws an error

1. The following changes were made(Include Database object names, Program classes and any other relevant information):|

1. Increased database size for inventory adjustment to 50 characters.
2. Changed backoffice inventory adjustment screen to allow for 50 characters.
3. Next number validations are as follows:

   1. IF @Flag IN ('pos_next_trans_no'

      ,'next_prescr_no'

      ,'next_redeem_no'

      ,'next_return_no','POS_next_Wholesale_No','pos_next_receipt_no','pos_next_wholesale_return_no','pos_next_adj_no','pos_next_quote_no','pos_next_accpay_no'

      ,'next_shift_no'

      ,'NextCustomerNumber'

      ,'NextEFTReferenceNumber'

      ,'pos_next_batch_no'

      ,'pos_next_payment_adj_no','pos_next_creditnote_no'

      ,'pos_next_deposit_no'

      ,'NextDoctorNumber'

      ,'next_adj_no'

      ,'next_cost_upd_no'

      ,'next_product_code'

      ,'next_po_no'

      ,'next_req_no'

      ,'hr_next_leave_no'

      ,'next_rate_upd_no'

      ,'next_roster_sched'

      ,'hr_next_emp_exit_code'

      ,'next_app_code'

      ,'next_emp_dis_code'

      ,'next_emp_edu_code'

      ,'next_emp_exp_code'

      ,'next_memo_id'

      )

      AND (LEN(@Value) < 4 OR LEN(@Value) > 16)

      BEGIN

      SET @Result = 'Next number must be between 4 and 16 characters in length'

      END

       

      --Validate min/max length for next numbers

      IF @Flag IN ('next_stk_take_no'

      ,'next_xfer_no'

      ,'inv_next_receive_no'

      ,'next_cash_rec_acc'

      ,'next_trx_no'

      ,'next_adv_code'

      ,'next_appr_no'

      ,'next_claim_no'

      ,'next_inc_no'

      ,'next_perf_plan'

      ,'next_trg_plan'

      ,'next_trg_sched'

      )

      AND (LEN(@Value) < 4 OR LEN(@Value) > 12)

      BEGIN

      SET @Result = 'Next number must be between 4 and 12 characters in length'

      END

       

      --Validate min/max length for next numbers

      IF @Flag IN ('next_emp_code') --validated at 10 characters

      
      

Hi Sanjay, 

This case has been successfully tested.

Documentation on the case is not required.

Test Environment 

• Version 9408 Beta 5
• LINKSOFT on QA1.

Test Plan

1. Create a Stock Take for item R1001 and LB1001 (Lot Bin Item). Current In stock for both items is 10.
2. Verify the Stock Count Sheet.
3. Update the count entry. R1001 count = 30 and LB1001 count = 5.
4. Post the Adjustment, the adjustment should be posted without errors - Pass.
5. Create another stocktake as above but Void the adjustment, the adjustment should be voided without errors - Pass
6. Verify the Invnetory Adjustment is correctly created on 520-1. - Pass

Figure 1: Adjustment Posted

Thanks

Rashna