RE: [Axapta-Knowledge-Village] Inventory Pick automatically suggest what inventdim to be used?
Dear Hardi, Automatic reservations in Axapta are made on the "oldest " lot. The oldest lot is defined as the lot with the lowest dimension values sorted in alphanumeric order. So on basis of this Axapta suggests the following lots - 10 qty for serial# S001 - 10 qty for serial# S002 If you want to select the quantities from serial 20qty S002 or 20qty S003. Then you have to allot the serial numbers manually. Hope it'll help you. Thanks & Regards, Sanam Khan From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hardi Sent: Monday, February 19, 2007 1:50 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory Pick automatically suggest what inventdim to be used? Dear all, I wonder how Axapta automatically suggest what inventdim to be used during inventory pick? Here is my scenario: I have itemX having inventory model group that requires picking, serial number controlled. I created and posted InventMovement Journal for item X: +10 qty for serial# S001 +20 qty for serial# S002 +30 qty for serial# S003 My on-hand after posting is 60 qty. Then I created profit/loss journal for -20 qty. When I do inventory pick automatically axapta suggest 2 lines: - 10 qty for serial# S001 - 10 qty for serial# S002 How this is happening? Does Axapta "read" the LotID from "purchased" lines and sort the picking based on that? Why it is not suggest i.e for 20qty S002 or 20qty S003? Thanks & regards Hardi Using 40SP1 [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Inventory Pick automatically suggest what inventdim to be used?
In the Inventory Model group define the parameter that the reservation should be date controlled. (do not flag backward). Once you have flagged in the IMO and the reservation is Automatic then Ax will always suggest you to use the FIFO based inventory Qty, which means that the lot which came in first with the lowest date will be first used. This will sometime defy the logic of lowest serial number, for instance if you have by mistake a item with 10 qty for serial# S001 - Feb 10th 20 qty for serial# S002 - Feb 7th 30 qty for serial# S003 - Feb 14th Then S002 will be reveserved first because it has lowest date. I hope this is what you are looking for.. Hemant K - Original Message From: Hardi <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, February 19, 2007 2:49:57 AM Subject: [Axapta-Knowledge-Village] Inventory Pick automatically suggest what inventdim to be used? Dear all, I wonder how Axapta automatically suggest what inventdim to be used during inventory pick? Here is my scenario: I have itemX having inventory model group that requires picking, serial number controlled. I created and posted InventMovement Journal for item X: +10 qty for serial# S001 +20 qty for serial# S002 +30 qty for serial# S003 My on-hand after posting is 60 qty. Then I created profit/loss journal for -20 qty. When I do inventory pick automatically axapta suggest 2 lines: - 10 qty for serial# S001 - 10 qty for serial# S002 How this is happening? Does Axapta "read" the LotID from "purchased" lines and sort the picking based on that? Why it is not suggest i.e for 20qty S002 or 20qty S003? Thanks & regards Hardi Using 40SP1 Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com [Non-text portions of this message have been removed]