Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I guess not very difficult but I am still can't. How can I link the Inventbatchid to the Salesline. I know via the Inventdim, Inventtrans, Inventtransorigin, but I am struggeling with it.
I am working on the SalesConfirm SSRS report and I want to add the batchnumber to the salesline (from SalesconfirmDetailsTmp).
SalesLine.InventDimId has relation to InventDim.InventDimId. And in InventDim you have field InventBatchId.
Thanks!! For some reason I don’t get a match on the inventdim. The batch is reserved. Maybe the route via inventtransorigin?
You can get InventBatchId values from InventTrans.InventDimId. To get it you should use InventTransOrigin table.
SalesLine.InventTransId == InventTransOrigin.InventTransId
InventTrans.InventTransOrigin == InventTransOrigin.RecId
InventDim.inventDimId == InventTrans.inventDimId
Thanks! It works! Do you have experience with the tmp table SalesconfirmdetailsTmp most ideal would be that I can link with that table but the only link I can make is to the Custconfirmjour / custconfirmtrans but then I have the details of all the saleslines linked to a individual sales line (from the salesconfirmdetailsTmp
I think you can't directly link SalesLine to SalesConfirmDetailsTmp.
The SalesConfirmDetailsTmp has only ItemId field, and if sales order will have more than one lines with the same ItemId you can't determine needed row.
Ok! Thanks Rustem. Then I'll have to find another way. I think I am going to use the CustconfirmTrans then. Problem there that I need the taxpercentage (only have the the Taxgroup, Taxitemgroup and Taxwritecode).
Note also that there may also be more than one batch picked per sales order line. or that the same batch may be used to fulfill many sales orders.
Business Applications communities