BILLING_SEQ value, not cleared

Modified on Fri, 10 Feb, 2023 at 1:19 PM

Issue: The BILLING_SEQ value is not cleared. This means that the process could of been aborted, or the user broke out of the process causing the value to not clear.

Solution: Clear the value using the steps below.

The ticket will display a table like the image below. Use the "Bill Seq" number for queries below.

1. First check memo_hdr table to see if Bill Seq is still present.

select * from bol_hdr where sales_ccn= 'HG0101' and MAS_LOC='11' and packlist = LPAD('&PACK_LIST_NUM',15)

2. Check with Customer Support to see if anyone is currently working with the order or billing seq.

3. If customer support is not working on the order, and its still in the memo_hdr table, run the following SQL to update the table, setting the billing seq value to "null". Then it will be invoiced the next time the job runs.

update memo_hdr
set billing_seq = ' '
where sales_ccn = 'HG0101' and billing_seq = '&BILLING_SEQ_VAL' and memo_type = 'C'

Then Commit (Do NOT forget to click Commit!!! Changes will not be saved without issuing a commit. )