1,085
Hi,
in ax 4.0 was possible to have warehouse A in header and warehouse (say) A and B in corresponding lines.
If i try doing the same on 2012 i get this error when trying to ship:
Line number: -1,00
A quantity cannot be picked.
Insufficient inventory transactions with status On order, Reserved ordered, Reserved physical and Picked.
How can i fix this issue?
Is there a workaround?
thank you in advance
Hi,
Thanks for the info. I tried what you said and with "Explode lines" checkbox checked it worked.
That option was meant for something else when I checked the training document. However, that seems a valid work around ready made for your needs.
Why would you still need to make changes to the InventUpd_Physical class?
(As a side note, InventUpd_Physical has an effect on all types of physical updates [not limited to Transfer order]. I would recommend against making changes to it.)
If you go to Inventory-->Reservation ( on the lower half of the Tr.Orders. form) you'll see you can have a different warehouse than the one in the transfer order header.
This warehouse is the one you set in Released Products, Manage Inventory, Site Specific Order Settings.
In version 4.0 the warehouse was in the header of the transfer order and could not be edited at the line level as standard and this has carried on in version 2009 and 2012. Is this a customization or localization?
Hi there,
Sorry I mis-read your question. I was thinking of PO/SO some way some how.
So it's Transfer order...
How do you change the warehouse of a transfer order line? I checked just now and it doesn't seem to allow it.
Thank you for your reply. I've notice that if the "explode lines" option is flagged, i do not get any error and the trasnfer order gets posted properly.
In the InventTransferUpd class, createInventTransferJourLine method there's a if condition on this parameter:
if (inventTransferParmTable.ExplodeLines)
{
select forceplaceholders TableId from inventTransOrigin
where inventTransOrigin.InventTransId == _inventTransferParmLine.InventTransId
&& inventTransOrigin.ReferenceCategory == inventTransType
join sum(Qty) from inventTrans
group by InventDimId
where inventTrans.InventTransOrigin == inventTransOrigin.RecId
&& inventTrans.StatusIssue <= statusIssue
&& inventTrans.StatusReceipt <= statusReceipt
&& inventTrans.Voucher == voucherId
&& inventTrans.DateFinancial == inventTransferParmTable.TransDate
#inventDimExistsJoin(inventTrans.InventDimId,inventDim,_inventDimCriteria,_inventDimParm);
}
else
{
select TableId from inventTransOrigin
where inventTransOrigin.InventTransId == _inventTransferParmLine.InventTransId
&& inventTransOrigin.ReferenceCategory == inventTransType
join sum(Qty) from inventTrans
group by InventDimId
where inventTrans.InventTransOrigin == inventTransOrigin.RecId
&& inventTrans.StatusIssue <= statusIssue
&& inventTrans.StatusReceipt <= statusReceipt
&& inventTrans.Voucher == voucherId
&& inventTrans.DateFinancial == inventTransferParmTable.TransDate;
}
So i've tried to comment the #inventDimExistsJoin macro in InventUpd_Physical class,
updatePhysicalIssue method (line 52,right before the while statement):
select forupdate inventTrans
order by StatusIssue,InventDimId
where inventTrans.InventTransOrigin == movement.inventTransOriginId()
&& inventTrans.StatusReceipt == StatusReceipt::None
&& inventTrans.StatusIssue >= caseStatusIssueFrom
&& inventTrans.StatusIssue <= caseStatusIssueTo
&& inventTrans.TransChildType == movement.transChildType()
&& inventTrans.TransChildRefId == movement.transChildRefId();
//#InventDimExistsJoin(InventTrans.inventDimId,inventDimJoin,inventDimCriteria,inventDimParmCriteria);
It worked like a charm, but i now need to check for the explodelines parameter here and write an if condition like the one i've found in the InventTransferUpd class.
Any idea? I cannot find it anywhere...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,326
Super User 2024 Season 2
#2
Martin Dráb
228,166
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (