Transfer order issues

[shikarishambu]

I have a transfer order for qty 3 of an item. It looks like the user picked
a particular item with same serial # twice.

The system is now showing transfer qty as 3, shipped as 3 and ship remaining
as 1 (table 1). I do not see a way to correct the ship remaining (to 0). The
items are all in the correct location.

And, when I click on Transactions to see the transactions for a particular
serial # - I see two sets (about 8) transactions for the serial # (Table 2).

Is there a way to correct ship remaining to 0

Table 1
Item number Transfer quantity Shipped quantity Ship remain Ship now
Item number Shipped quantity Received quantity Scrapped quantity Receive
remain
INV_000207 3 3 1 INV_000207 3 4
INV_000205 1 1 INV_000205 1
INV_000010 4 4 INV_000010 4
INV_000093 3 3 INV_000093 3 3
INV_000180 4 4 INV_000180 4

Table 2

Warehouse Batch number Location Serial number Physical date Financial
date Reference Number Receipt Issue Quantity Cost amount Item number Type
Number
NYC XXXX P3034187 Transfer order receive 00000015_082 Ordered 1
INV_000207 Transfer order receive 00000015_082
NYC XXXX P3034187 Transfer order receive 00000015_082 Registered 1
INV_000207 Transfer order receive 00000015_082
MW YYYY P3034187 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Sold -1 INV_000207 Transfer order shipment 00000015_082
MW YYYY P3034187 Transfer order shipment 00000015_082 On order -1
INV_000207 Transfer order shipment 00000015_082
GIT Transit P3034187 Transfer order receive 00000015_082 Picked -1
INV_000207 Transfer order receive 00000015_082
GIT Transit P3034187 Transfer order receive 00000015_082 Reserved
ordered -1 INV_000207 Transfer order receive 00000015_082
GIT Transit P3034187 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 INV_000207 Transfer order shipment 00000015_082
GIT Transit P3034187 Transfer order shipment 00000015_082 Ordered
1 INV_000207 Transfer order shipment 00000015_082

[Lennart Conrad]

It could be that you have allowed overdelivery and that the picker has picked
one to many. This will lead to an extra set of inventory transactions.

From your description it sound like the sum of your inventory transactions
issues are 4, and I can see that you still have one open set of transactions
that could be shipped.

I think you can use the deliver remainder function (Functions/Deliver
remainder) and cancel the quantity that remains to be shipped. You can only
cancel quantity that has not yet been shipped.

Regards
Lennart Conrad

This posting is provided "as-is" with no warranty

[shikarishambu]

Hi,
I tried using Delivery Remainder to cancel the one remaining and I got

Message (14:07:33)
Quantity ordered may not be reduced because there are not enough inventory
transactions with 'on order' status.
The items are Sold, Deducted or Picked.

When I click Posting > Pciking List Registration on the TO I see two picking
lists
First has three items with different serial # s and has been updated.

The second has one item with a serial # that has been used in the first
picking list registration and is not updated. When I try to delete this I
get

Message (14:13:22)
Quantity ordered cannot be reduced because there are not enough open
inventory transactions with the Ordered status.
The items are Purchased, Received or Registered.

I can change the serial # of the item in this picking list registration but
it does not allow me to delete it.

Thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message
news:CF51141B-F3A0-4AB5...@microsoft.com...

[Lennart Conrad]

How does your inventory transactions for the open picking list line look for
issue,transit and receipt?
Are the dimensions in sync and are the quantities the same ?

/Lennart

--
This posting is provided "As-is" with no warranty

[shikarishambu]

This is how it looks

Warehouse Location Serial number Physical date Financial date

Reference Number Receipt Issue Quantity Cost amount Item number Type

MW Charlotte P3034412 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Sold -1 -482.13 INV_000207 Transfer order shipment
MW Charlotte P3034433 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Sold -1 -482.13 INV_000207 Transfer order shipment
GIT Transit P3034412 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 482.13 INV_000207 Transfer order shipment
MW Charlotte P3034187 Transfer order shipment 00000015_082 On

order -1 INV_000207 Transfer order shipment

MW Charlotte P3034187 10/15/2007 10/15/2007 Transfer order shipment

00000015_082 Sold -1 INV_000207 Transfer order shipment

GIT Transit P3034187 Transfer order shipment 00000015_082 Ordered 1
INV_000207 Transfer order shipment

GIT Transit P3034187 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 INV_000207 Transfer order shipment

GIT Transit P3034433 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 482.13 INV_000207 Transfer order shipment

The different serial #s are there because of my attempt to change the serial
# and delete it. The serial # I currently have is P3034187

How do I determine if dimensions are in sync? I have seen occasional
"dimensions not in sync" messages and ignored it. We are running AX 4.0 sp1

thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:88A20D3E-D3AF-4BEB...@microsoft.com...

[Lennart Conrad]

By dimensions not in sync I mean a scenario where your inventory transactions
look something like this

From Transit To Transit From To
Serial nr 1 serial nr 1 Serial nr 1 Serial nr 2!!

I need to see all your transactions to get a full view of the situation, so
you need to view them from the transfer order form, so you also see the
receipt transactions.

Sorry that I didn't make this clear.

[shikarishambu]

Hi,
I would love to show you all the transactions. Is there a report that
would provide this information? Or can I interest you with a GotoMeeting
session where you can see my screen/ environment?

Thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:A062EB3B-9AD0-4A26...@microsoft.com...

[Lennart Conrad]

If you go to the transfer orders form, and then to the transfer line that is
causing the issue, you can see all that lines transactions under
Inventory/Transactions. Alternatively you can view all the Inventory
transactions from the Item form (InventTable form) and then filter on the
transfer orders id

[Lennart Conrad]

I can't see any attachment, maybe that is not possible? I only need to see
the ones for the transfer order.

/Lennart
--
This posting is provided "As-is" with no warranty

"shikarishambu" wrote:

> Hi,
> I have attached a spreadsheet with the full list of all transactions
> related to the item in question.

>
> Thanks
>
> "Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

> news:9352C096-1CD4-466D...@microsoft.com...

[shikarishambu]

I had attached an excel file. Here is the data

Warehouse Location Serial number Physical date Financial date

Reference Number Receipt Issue Quantity Cost amount Item number Type Number
Account number Inventory reference Inventory number Project Fixed asset
number Value model Probability % Lot ID Reference lot Dimension No. Receipt
status Issue status Value open Quantity Expected date Inventory date
Requested ship date Confirmed ship date Physical date Physical voucher
Packing slip Physical cost amount Physical revenue Financial date Financial
voucher Invoice Cost amount Adjustment Profit & Loss, posted amount
Financially closed Settled quantity Amount settled Type Account number
Quantity Unit Unit price Discount Disc. pct. Line amount Currency Currency
Standard cost value Category Packing slip Invoice Return lot ID Status date
In/Out Sub-BOM Project Category Adjustment number Configuration Type Model

Warehouse Batch number Location Serial number

MW Charlotte P3034412 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Sold -1 -482.13 INV_000207 Transfer order shipment

00000015_082 00002651_074 00000974_078 Sold Yes -1 10/4/2007
10/8/2007 10/15/2007 14303_067 -482.13 ######## 14303_067 -482.13
482.13 Inventory -1 Nos. 482.13 -482.13 USD USD -482.13 No No
######## Issue MW Charlotte P3034412

MW Charlotte P3034433 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Sold -1 -482.13 INV_000207 Transfer order shipment

00000015_082 00002651_074 00000995_078 Sold Yes -1 10/4/2007
10/8/2007 10/15/2007 14303_067 -482.13 ######## 14303_067 -482.13
482.13 Inventory -1 Nos. 482.13 -482.13 USD USD -482.13 No No
######## Issue MW Charlotte P3034433

GIT Transit P3034412 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 482.13 INV_000207 Transfer order shipment

00000015_082 00002651_074 00002652_074 00001832_078 Purchased Yes 1
10/4/2007 10/15/2007 14303_067 ######## 14303_067 482.13 -482.13
Inventory 1 Nos. 482.13 482.13 USD USD No No ######## Receipt
GIT Transit P3034412
GIT Transit P3034412 Transfer order receive 00000015_082 Picked -1
INV_000207 Transfer order receive 00000015_082 00002652_074
00002651_074 00001832_078 Picked Yes -1 10/4/2007 10/15/2007
Inventory -1 Nos. USD No No ######## Issue GIT Transit
P3034412

MW Charlotte P3034187 Transfer order shipment 00000015_082 On

order -1 INV_000207 Transfer order shipment 00000015_082 Invent - Picking
list journal 00003673_074 00002651_074 00001834_078 On order Yes -1
10/4/2007 Inventory -1 Nos. USD No No 10/4/2007
Issue MW Charlotte P3034187

MW Charlotte P3034187 10/15/2007 10/15/2007 Transfer order shipment

00000015_082 Sold -1 INV_000207 Transfer order shipment 00000015_082
00002651_074 00001834_078 Sold Yes -1 10/4/2007 10/15/2007 10/15/2007
14303_067 ######## 14303_067 Inventory -1 Nos. USD USD No No
######## Issue MW Charlotte P3034187

GIT Transit P3034187 Transfer order shipment 00000015_082 Ordered 1

INV_000207 Transfer order shipment 00000015_082 00002651_074
00002652_074 00001835_078 Ordered Yes 1 10/4/2007
Inventory 1 Nos. USD No No 10/4/2007 Receipt GIT Transit
P3034187

GIT Transit P3034187 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 INV_000207 Transfer order shipment 00000015_082

00002651_074 00002652_074 00001835_078 Purchased Yes 1 10/4/2007
10/15/2007 14303_067 ######## 14303_067 Inventory 1 Nos. USD
USD No No ######## Receipt GIT Transit P3034187

GIT Transit P3034187 Transfer order receive 00000015_082 Reserved
ordered -1 INV_000207 Transfer order receive 00000015_082

00002652_074 00002651_074 00001835_078 Reserved ordered Yes -1 10/4/2007
Inventory -1 Nos. USD No No 10/4/2007 Issue GIT Transit
P3034187

GIT Transit P3034187 Transfer order receive 00000015_082 Picked -1

INV_000207 Transfer order receive 00000015_082 00002652_074
00002651_074 00001835_078 Picked Yes -1 10/4/2007 10/15/2007
Inventory -1 Nos. USD No No ######## Issue GIT Transit
P3034187

GIT Transit P3034433 10/15/2007 10/15/2007 Transfer order shipment
00000015_082 Purchased 1 482.13 INV_000207 Transfer order shipment

00000015_082 00002651_074 00002652_074 00001837_078 Purchased Yes 1
10/4/2007 10/15/2007 14303_067 ######## 14303_067 482.13 -482.13
Inventory 1 Nos. 482.13 482.13 USD USD No No ######## Receipt
GIT Transit P3034433
GIT Transit P3034433 Transfer order receive 00000015_082 Picked -1
INV_000207 Transfer order receive 00000015_082 00002652_074
00002651_074 00001837_078 Picked Yes -1 10/4/2007 10/15/2007
Inventory -1 Nos. USD No No ######## Issue GIT Transit
P3034433
NYC 100 Church Street P3034412 Transfer order receive 00000015_082

Registered 1 INV_000207 Transfer order receive 00000015_082

00002652_074 00001855_078 Registered Yes 1 10/4/2007 10/15/2007
Inventory 1 Nos. USD No No ######## Receipt NYC 100 Church
Street P3034412
NYC 100 Church Street P3034187 Transfer order receive 00000015_082

Registered 1 INV_000207 Transfer order receive 00000015_082

00002652_074 00001856_078 Registered Yes 1 10/4/2007 10/15/2007
Inventory 1 Nos. USD No No ######## Receipt NYC 100 Church
Street P3034187
NYC 100 Church Street P3034187 Transfer order receive 00000015_082

Ordered 1 INV_000207 Transfer order receive 00000015_082

00002652_074 00001856_078 Ordered Yes 1 10/4/2007
Inventory 1 Nos. USD No No 10/4/2007 Receipt NYC 100 Church
Street P3034187
NYC 100 Church Street P3034433 Transfer order receive 00000015_082

Registered 1 INV_000207 Transfer order receive 00000015_082

00002652_074 00001857_078 Registered Yes 1 10/4/2007 10/15/2007
Inventory 1 Nos. USD No No ######## Receipt NYC 100 Church
Street P3034433

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:86165808-22F6-4607...@microsoft.com...

[Lennart Conrad]

I have had a look at your transactions. The good thing is that they appear to
be in sync, at least for quantity. I cannot see if one of the serial nrs are
out of sync, meaning, that the 4 serial numbers are not on the mathcing
issues and reciepts. If that is the case, then you should not attempt the
below suggestions!!.

The bad thing is, that this appears to be a bug in the product, and I cannot
see any easy solution. I have tried to repro your scenario, but have not
managed to get into the exact same situation.

Without going into to much detail, the system prevents you from deleting,
because it eventually will try to find inventory transactions based on the
transfer order lines dimensions (not the picking lines) using an
InventDimParm that is based on active dimensions. Since there most likely
isn't a serial number on the transfer line, you get the error with
insufficient transactions.

A possible solution would be to change the dimension group on the item to a
dimension group that does not have serial number active and then delete the
picking line. Of course you need to ensure that nobody uses the item while
you do this. Note that this solution is completely at your own risk, and I
really encourage you to validate that it works in a test environment.

[shikarishambu]

Thank you taking the time to review this. I will test out your solution in a
parallel env. Is this a bug that was addressed in sp2 or is it still being
worked on?

Thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:79371F69-FD1E-4F9C...@microsoft.com...

[Lennart Conrad]

I am not sure if it is reported at all. So if possible you should report the
bug.

[shikarishambu]

I tried changing the Dimension group on the item to a dimension group that
does not have serial # and the system did not allow me to do it.

I got the following message

Message (16:41:39)
The new dimension group cannot be assigned. Other financial dimensions apply
and physical inventory transactions might exist and/or financial inventory
transactions are not fully settled.

Any suggestions what else I can try to fix this?

Thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:79371F69-FD1E-4F9C...@microsoft.com...

[Lennart Conrad]

I think you get that error because inventory has not yet been closed or you
have transactions that are not yet invoiced.

I am pretty close to running dry of ideas how to correct this data without
modyfying the code. Do you have the possibility to change x++ code?

[shikarishambu]

I have a parallel environment where I can test out stuff. As for code change
in production - it will depend on the layer.

thanks

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:BE806AF7-BC7A-4005...@microsoft.com...

[Lennart Conrad]

I think the issue lies in the method
InventPickRequestLine_Transfer.subPickRequestLineRemain(....)

It looks like your scenario causes the last piece of code to be executed:

if (addQty)
{
inventDimCriteria = inventTransferLine.inventDim();

inventTransferLine.updateEstimatedDim(inventTransferLine.inventDim(),inventDimParmUpd,addQty);
}

The inventDimParmUpd is initialized based on the items active dimensions,
but the inventDIm from the transferline migth not have all these dimensions
assigned,hence inventtrans are not found correctly.

I think the code should look like this to solve your issue:

if (addQty)
{
inventDimCriteria = inventTransferLine.inventDim();
inventDimParmUpd.initFromInventDim(inventDimCriteria ); <---------
added

inventTransferLine.updateEstimatedDim(inventTransferLine.inventDim(),inventDimParmUpd,addQty);
}

You could try this change in your test environment.

[shikarishambu]

Sorry did not see this until today. I will check this out.

"Lennart Conrad" <Lennar...@discussions.microsoft.com> wrote in message

news:2741D018-1E48-4D2E...@microsoft.com...