Packing Slip/Delivery Note is fetching wrong serials for an item

(0) Share

Report

Posted on by Community Member

PREREQUISITES
Inventory reservation is set to manual
Item are with serial numbers
Inventory method is FIFO

REQUIREMENT
What we want to achieve is that every truck can be shipped out with its own delivery note/packing slip with all the related serial numbers we reserved for it during picking process.

CURRENTLY HAPPENING

Sales person creates sales order
Multiple picking lists for one item with max quantities of 12 items (max 12 could be loaded to a truck), so eventually we distribute the pickings
Picking process starts (for all pickings at the same time)
Reservation of various serial numbers is made manually (to all pickings at the same time)
Picking route is set to completed (All)
Shipment shows the rightful serial numbers of items reserved for this picking/shipment
Function Packing slip is created (Here the problem occurs and that is the serial numbers the packing slip shows are from various picking routes not from the one this process was being initiated with)

Please we request an immediate resolution, to this. Thank you.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

GeorgeC 1,865 on at

Like (0)

Report

Hi, I've seen the same issue and I consider it a bug in linking inventory transactions to the Packing slip. The problem is caused by the handling of the inventory dimensions. Basically, transactions on the Packing slip are filtered by item and lot number (sales order line/InventTransId) but not by shipment or picking list number. And in your case you have the same item on the same order line being shipped on several shipments. We submitted this issue to Microsoft last year (issue number is 110090374728757) and we did not get a fix for it. Reason: the issue is in a base AX functionality and fixing it may break basic AX routines related to inventory transactions. I have to check if we have created our own fix for it (I doubt it) as another person was responsible for the project.

One possible workaround is to spilt the orginal sales order line into a separate line for each picking list/shipment but customers are not excited about it.

Here's some info that we received from Microsoft:

"The \Classes\SalesFormLetter_PackingSlip\addToInventReportDimHistory is limiting its selection to the inventtransid but the problem here is that multiple RecId''s share the same inventtransid so the wrong record(s)are updated in that table. When we get to printing the lines they're based off the InventReportDimHistory table (\Reports\SalesPackingSlip\Designs\Standard\Generated Design\Section Group: CustPackingSlipJour\BodyReference\Methods\printDimHistory) which has the wrong quantities added. Ideally the shipment ID should also be considered when updating these records but the risk here is that the \Classes\InventUpd_Physical\updatePhysicalIssue method is used when updating the inventtrans records which is core inventory framework so this class is used by other areas that have nothing to do with shipments. They might be able to incorporate the shipment from \Classes\SalesFormLetter\parmShipmentId to get the expected selection but would need to be cautious when modifying a core framework class like InventUpd_Physical."

And

"From monitoring the status of the quality report based on the comments provided by Development SE, the thought was that we could push some checks in the Classes\InventUpd_Physical\updatePhysicalIssue where the system would validate the inventory transactions with the shipment. However, when this was being tested by Development SE, it was determined that this would touch the InventoryFramework classes. Because this ends up being a legacy issue in the InventFramework classes which doesn't recognize specific shipment date when physically updating the order, the feedback that I've received is that they are not able to get this in a hotfix for Dynamics AX 2009."

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you George, it was really helpful. I did almost all related search wandering the source code as well but my conclusion was same as yours. However, it now is also verified that it not possible both functional or coustomization, considering it might totally ruin system's functionality.

Thanks again for a quick response to my query and providing a well satisfactory answer.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I have found a solution and my client agreed to it. Here are the details,

Sales person creates sales order

Multiple picking lists for one item with max quantities of 12 items (max 12 could be loaded to a truck), so eventually we distribute the pickings

Picking process starts (for all pickings at the same time)

Reservation of various serial numbers is made manually (to all pickings at the same time)

Picking route is set to completed (ONE AT A TIME)

Function Packing slip is created (Here the system Packs all picked quantities, which are only picked against one picking slip)

Packing Slip shows the exact serial numbers and is working perfectly as customer demanded.

Customer is happy with this solution and they reserve and pack update shipments one by one.

Was this reply helpful? Yes No
Hamdien Bashara 227 on at

Like (0)

Report

what do u mean by

"Multiple picking lists for one item with max quantities of 12 items (max 12 could be loaded to a truck), so eventually we distribute the pickings"

also

"Function Packing slip is created (Here the system Packs all picked quantities, which are only picked against one picking slip) "

can you give me practicle example to understand your case.

sorry brother i am in learning phase

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Brother Hamdien, first of all thank you for going through this post, and for your query.

Well, I had been studying itemtrans table quite a times during this process. What was found that whenever any picking process is completed, the status of items with reserved serial numbers were set to PICKED, where as delivery note is created based upon the quantity picked.

Here one point is very much notable that how delivery note finds the quantity, the answer is the quantity mentioned in the picking route ... which eventually was part of the shipment. So, when the delivery note is created it takes number quantity of picked items from item trans. Means, if more are picked updated already then based upon their sorting the system picks top serial numbered items and create a delivey note causing the delivery note to show wrong serials picked for that specific shipment.

Secondly, why customer is creating multiple picking routes for same item at maximum 12 quantities. Well, whenever a picking route is created the shipment is based upon its quantity. But my customer wanted to send delivery note with every truck (Only shipping mathod applicable here) and one truck can load at maximum of 12 quantities of their product. So, they create multiple pickings for one item if quantities are 24 two picking list will be created... this will create 2 shipments and following the mentioned instructions when 1 picking again the same order reservers 12 serial numbers makes it possible to get the exact 12 serial numbers on the packing slip/delivery note. Once done with first picking they initiate the second and start the reservation of serialized items to full fill its shipment and so forth till all the pickings are completed and all delivery notes are ready to be send with each truck.

I hope that answered the question, if still there is any query please contact me on skype (waqar.ahmed123).

Was this reply helpful? Yes No
Hamdien Bashara 227 on at

Like (0)

Report

Dear,

Jazak allah Kayran, i have another question how did u gonfigure that each pucked should be 12 Pcs.. is it from order default setting or site default setting or there is other way brother.

regarding your question , i will try to find solution when i go home i will open my MVPC

Bset Regards,

i found an article said i hope it will be helpfull

Demonstration: Reserve Serialized Inventory

The following demonstration shows how to reserve a serialized inventory item

and how Microsoft Dynamics AX 2009 proposes the reserved serial number

during the picking process.

Prerequisites:

• Make sure that there are two pieces of 1707 on-hand with serial

numbers attached to them.

• Make sure that on the Accounts receivable > Setup > Forms >

Form setup > Picking list and the Packing slip tabs the Serial

number and Warehouse dimensions are selected. This guarantees

that serial numbers are printed on picking list and packing slip

updates.

1. Create a sales order for customer 2022 with one line with two pieces

of 1707 from warehouse 21.

2. From the first line, click Inventory > Reservation. Manually reserve

both of the serial numbers associated with 1707.

3. Click Posting > Picking list and select the Print picking list

parameter to create a picking list for the items. Notice the two serial

numbers printed on the picking list are the two serial numbers

previously reserved.

4. Click Posting > Picking list registration. Notice that the serial

numbers proposed are those previously reserved.

5. On one of the lines, register the pick of another serial number by

clicking the Serial number field in the Lines pane of the Picking

list registration form and selecting another serial number.

6. Click Update to register the pick of the serial numbers.

7. From the sales order lines, click Inventory > Transactions to view

the serial number to which one of the lines it is updated to.

8. Click Posting > Packing slip to create a packing slip update for the

sales order. In the Quantity field, select Picked and select the Print

packing list field.

9. Click OK. Notice that only one of the previously reserved serial

numbers is printed on the packing slip since the other serial number

changed at the picking list registration stage.

NOTE: If after Step 2 the item is picked by using the Inventory > Pick function, the

serial number reserved for each line is still proposed in the Pick dialog box before the

line is picked.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There is no bound to it which i could discover so far, rather this is by customer's choice. So, they create pick list by using the "deliver now quantity" in quantity tab of order lines.

Was this reply helpful? Yes No