Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Sales Order pick list, packing slip dates

Posted on by Microsoft Employee

I recently did a mod to force the sales order invoice dates to always equal the packing slip posting date. What I am now finding is when a pick list is created from a back order it is using the original pick list date against that line. This is making the packing slip date not the date it is generated but the date from the original shipment. Of course now the invoice date is incorrect.

My question is 2 part- is this standard AX (2012 R2) and if so is there a way to force the pick list, packing slip to always be the date it is generated and not the original ship date without another mod.

Any insight /help on this will be appreciated.

Thanks

Ron

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order pick list, packing slip dates

    Mariano,

    Thanks for the the tip. However this defeats the requirement that packing slip and invoice dates always be the same. I think I( will try this in Test to see what the effect would be.

    Ron

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order pick list, packing slip dates

    Brandon,

    The date issue only comes up when we are shipping a back order tied to a previous shipment. All my mod did was force invoice date to equal packing slip date. The packing slip date on the back orders for some strange reason is bringing in the original date tied to the first shipment against that line.

    Currently that is what I am doing. Having they shipping people check the date on the packing slip before they post it.

    So my question of this being standard AX functionality according to what you posted is this is not. You state that the packing slip date should always be the system date. That is what I thought as well.

    Not sure what I will do at this point.

    Thanks for the feedback

    Ron

  • RE: Sales Order pick list, packing slip dates

    I suggest you to use invoice issue due date control in order to avoid an invoice to be posted in a different date from your packing slip. It won't force your invoice to be posted in the same packing slip date but at least you won't have incorrect invoice dates. You can find the setup in General ledger\Setup\Set up calculation for invoice issue due date, it is easy to setup for your requirements, as your interval date is allways the same day:

    8883.Date_5F00_Interval.JPG

    This control will work only for the new packing slips once the setup is configured and only for some countries, but to change it is quite easy

  • Suggested answer
    Brandon Wiese Profile Picture
    Brandon Wiese 17,786 on at
    RE: Sales Order pick list, packing slip dates

    For a sales order packing slip, the Packing slip date (SalesParmTable.TransDate) should always default to the system date, unless some less common features are being used, and have nothing to do with the picking list date or the date of previous packing slip journals.

    It sounds like perhaps your invoice modification might be having unintended effects.

    If you post your code, it might help to figure this out.

    In any case, when you go to post a packing slip, the Packing slip date appears on the Setup tab of the Packing slip posting form (SalesEditLines), so you can inspect what value is defaulting before OK is pressed to post the journal.  What date is being populated there?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans