web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Batch with void status.
Microsoft Dynamics SL (Archived)

Batch with void status.

(0) ShareShare
ReportReport
Posted on by Noraini Ishak 340

What process can change the batch status from void to 'S' (suspended).

Can i just run the sql 'delete from batch where status = 'V' . Is there any bad impact in Solomon.

 

Best Regards

Nani 

 

*This post is locked for comments

I have the same question (0)
  • Darin Madsen Profile Picture
    Darin Madsen on at

    Hi Nani,

    Thanking for posting to this forum. 

    Scope:

    You have asked if there is a process that can change the batch status from void to 'S' (suspended).  And also can you just run the sql 'delete from batch where status = 'V' . Is there any bad impact in Solomon.

    Assessment: 

     

     There is no process in SL that changes a batch status from V to any other status.  We’re not sure why you would want to do this.  Also, we don’t recommend deleting records from the Batch table.  You might have records in other tables that would be left stranded without a corresponding batch record.  If you would like to give us your reasons for the above two questions, perhaps we can offer some suggestions. 

     

    Darin Madsen
    Support Escalation Engineer
    Microsoft Dynamics SL

  • Toni Savage Profile Picture
    Toni Savage 260 on at

    Interesting!  One of our clients is reporting the same thing, I think.

    If you delete the "V" batches and they are really NOT void batches, then there will be "orphan" transactions and/or documents out there.

    What kinds of batches do they appear to be?  Or is the info in the "S" batches blank?

    What MIGHT be happening is that the system is trying to create new batches using the same batch number and is getting mixed up.

    If I were you, I'd try to research more carefully to see exactly what is being created.  For example, for the "S" batches, are there any transcation or doc records that belong to that batch?  If so, are they valid?  Were they created more recently than the batch record create date?  (Crtd_date, I think?)

  • Noraini Ishak Profile Picture
    Noraini Ishak 340 on at

    Hi ,

    need to know :-

    Select * from batch where batnbr = '123'   :-  result 1 records found

    Select * from aradjust where  adjbatnbr  = '123'  :-  is adjbatnbr is the correct field to get related records as batch in  '123' from batch table.

    Select * from ardoc where batnbr = '123'  :- is batnbr is the correct field to get the  related records as batch '123' from batch table

    Select * from artran where batnbr = '123'    :- id batnbr is the correct field to get the  related records as batch '123' from batch table.

     

    Best Regards

    Nani

     

     

     

     

     

     

  • Toni Savage Profile Picture
    Toni Savage 260 on at

    OK-- 1 record found is good.

    The ARADJUST table mostly connects payments and credit memos to invoices and debit memos.  Theonly batch number referenced is the Payment/CM batch, so if there is no matching ADJBATNBR then it maybe just means your batch was invoices and not payments/credits.

    But for ARDOC and ARTRAN, yes the BATNBR field is correct.

  • Noraini Ishak Profile Picture
    Noraini Ishak 340 on at

    Hi , 

     When is the batnbr is the correct field.

    Select * from batch where batnbr = '123'   :-  result 1 records found and having status = 'V'

    Select * from aradjust where  adjbatnbr  = '123'  :-  result no records

    Select * from ardoc where batnbr = '123'  :- result no records

    Select * from artran where batnbr = '123'    :- result no records.

    When i executed the above sql statement i can't find the related records for batch '123'. Seems that the batch '123' only exists in batch table.Just wonder why the status can be changed from 'V' to 'S'.

    Since i can't find the records to avoid the changing occurs , i would like to delete the batch '123' records in batch table.

    Thank You in Advance and Best Regards

    Nani

     

     

  • Toni Savage Profile Picture
    Toni Savage 260 on at

    yes, if there are no related records, you can either delete the batch, or make it suspended and re-use the batch.  Probably safer to delete it.

     

  • Noraini Ishak Profile Picture
    Noraini Ishak 340 on at

    Hi ,

     

    Tq very much.One question there is a field name applbatnbr in ardoc table what records are related to this batch number or what process will update this field.

     

     

    Many thanks and Best Regards

    nani

  • Toni Savage Profile Picture
    Toni Savage 260 on at

    I THINK that is only used while there is an un-released batch out there.

    If you run the AR Batch Register set to periods 01-1980 to 12-9999 and the parameters of BATCH.STATUS    IN        S,H,I,R,T,B,K   You will see any batches that are not released.

    (this set of letters, an easy-to-remember mnemonic, works in all modules' batch registers.

  • Noraini Ishak Profile Picture
    Noraini Ishak 340 on at

     

  • Noraini Ishak Profile Picture
    Noraini Ishak 340 on at

     

    Hi Toni ,

     

    Many Thanks and Happy New Year.

     

    Best Regards

    Nani

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans