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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

shipper whitout INTRAN records

(0) ShareShare
ReportReport
Posted on by 101

Hello everyone,
we have a problem with a shipper in the OM module, we created a shipper in the Shipper Screen (4011000) and we had an INBatNbr but the INTran table has no records. the ARBatNbr its OK in ARdoc and Batch Tables

Any idea? 

thks 

I have the same question (0)
  • Brian_IL Profile Picture
    719 on at
    RE: shipper whitout INTRAN records

    A "C"ompleted status batch indicates that all processing is done for the batch, that there wouldn't be a GL entry created from the IN batch to update the financials. This matches your earlier description, that there were no INTran records that would be the basis of a GL entry.

    You may try reviewing the Eventlog created by that sales journal, to see what it explains about that batch. As mentioned by Mark, you may need to update the batch status to have a batch to process, but without transaction records for that batch there would still be nothing to process. You can also review the orders in the batch that created AR transactions, to see what makes them different than other OM sales orders that process normally by printing the sales journal. The descriptions given make this sound like the orders contained price adjustment entries with no net change in inventory.

  • develop Profile Picture
    101 on at
    RE: shipper whitout INTRAN records

    Hi, thanks for answering, I checked the table but the problem batch is in status C and there is no other with status V

  • develop Profile Picture
    101 on at
    RE: shipper whitout INTRAN records

    Hi, I try this, but I still dont see the batch in the INTran table

    the first time we ran the sales journal, the batch was recorded in the Batch table in zero quantities and status "C" but without records in the INTRAN table,

    if I run it again, I see the shippers in the report but it doesn't generate the batch in INtran table

  • Mark E Profile Picture
    6,451 on at
    RE: shipper whitout INTRAN records

    Most likely what occurred is when the SJ was interrupted or aborted, it left the AR & IN Batches in a Voided Status.  Run the following SQL scripts to locate and correct the batches, then you can release the from the Release AR/IN Batches screens.

    select * from Batch where Module = 'IN' and Status = 'V' and Crtd_Prog = '40690' and Crtd_DateTime >= 'mm/dd/yyyy'

    order by Crtd_DateTime desc

    --update Batch set Status = 'B' where Module = 'IN' and Status = 'V' and BatNbr = 'XXXXXX'

    select * from Batch where Module = 'AR' and Status = 'V'  and Crtd_Prog = '40690' and Crtd_DateTime >= 'mm/dd/yyyy'

    order by Crtd_DateTime desc

    --update Batch set Status = 'B' where Module = 'AR' and Status = 'V' and BatNbr = 'XXXXXX'

    Change mm/dd/yyyy to the date your SJ was run, then execute the select query

    Once you have a BatNbr identified, replace XXXXXX with the value and run the update query.

    Repeat for each batch type.

    Once each batch has been changed to Balanced, release it from the appropriate Release Batches screen

  • Brian_IL Profile Picture
    719 on at
    RE: shipper whitout INTRAN records

    Similar answer as the AR missing Batch question:

    Running the order management report "Sales Journal" creates the Inventory batch and the AR batch to record the sale. If processing was interrupted, reprinting the report and entering the sales journal ID on the report's options tab will complete processing and create the missing AR batch.

    If a required field is missing data, the Eventlog entry created by that process should include information that would be needed to fix the problem batch.

    Check the inventory items in that sales journal batch; the event log is the first place to check for errors in the data - it reflects what issues SL has identified.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,351

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 874 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 638 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans