Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

SL 7 Inventory Shipped Not Invoiced

Posted on by 2,165

I have a client that has numerous items showing in INTran with quantities in the Shipped Not Invoiced. These are not appearing in the IN Release Batch screen. They are not on hold and are not on shippers that haven't been invoiced. What steps can be used to get these transactions corrected?

Thank you.

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    This resolved the issue.

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    I am having the client review to see if this will resolve the issue. Thank you.

  • Verified answer
    Fujimi DB Profile Picture
    Fujimi DB 275 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Did you re-run the specific sales journal for the voided issues batch?

    You can get the sales journal id by either:

    A. Customizing the Shippers screen to include the SOShipHeader.INBatNbr field.

    B. Running a query against the SL app databse, such as this:

    select ShipRegisterID

    from SOShipHeader

    where INBatNbr = 'Batch Number of Voided Issues batch'

    Once you have the specific sales journal ID, then follow these steps:

    Open the Sales Journal report, enter the Sales Journal ID into the field on the Options tab, then click Print (or Print Preview).

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    I have tried re-running the sales journals and same result.

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Oh... I see what you are referring to now. I do have a batch in issues that has a status of 'V' Void. How can this be corrected?

  • Fujimi DB Profile Picture
    Fujimi DB 275 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Hmmm, whenever I've run into this problem before, it was due to an interrupted sales journal process. I would check to make sure that there aren't any hung (status is S or V) Issue or AR batches related to these products.

    You could also try re-running the specific sales journal related to one of these shippers. Get the Sales Journal ID from the Other Information tab in the Shippers screen. Open the Sales Journal report, enter the Sales Journal ID into the field on the Options tab, then click Print (or Print Preview).

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    No, none of the batches are void.

  • Fujimi DB Profile Picture
    Fujimi DB 275 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Do you have any Issue batches with a V (Void) status?

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Yes, the sales journal has been run several times with no change in the results.

  • Fujimi DB Profile Picture
    Fujimi DB 275 on at
    RE: SL 7 Inventory Shipped Not Invoiced

    Deb,

    Have you tried running the Sales Journal?

    Thanks,

    db

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans