Hi All
(Working with DAX 2009)
I have an issue where I am unable to clear off a value from the GRNI report. The reason being that a different quantity was entered in the Set-Up tab in the Quantity field, compared to what was delivered & invoiced on the PO line.
The exact detail is that a Qty of 1 off (unit measure as stock being PKT 10) was entered as the line qty, but a qty of 12 was entered in the Stock section of the set up tab on that line, thus ensuring that a qty of 2 keeps appearing in the GRNI. I would normally pass the invoice and produce a dummy credit to clear this, but there is no where on the line that allows me as the PO thinks it has all been cleared up. The stock has been amended via counting jnl due to stock take.
Not sure why the qty of 12 was entered in there!! But it is clearly the cause of the problem.
Any suggestions anyone??? Thank You
Can you book 2 into stock and then deliver now -2 and update the delivery note based upon the delivery now parameter?
Thanks for the reply Adam.
The problem is that the quantity unit on that line is PKT 10, so if I do a -2 on the ‘Deliver Now’, it will actually be -20 in the stock (and obviously incorrect value). I’ve tried changing the Unit to EACH, but it states that the ‘Unit cannot be changed because the purchase line is partly delivered’.(Even though the Invoiced qty and Received qty is 1, with no Remainders on the line)
I’ve also tried to ‘Deliver Now’ -0.2, but it doesn’t like that because ‘Decimal rounding of the physical updating quantity in the unit PKT10 is incorrect’.
Any other idea’s?
The only thing I can think of is to Journal the value out of the GRNI accounts, and manually extract the line (from Excel) everytime I produce the GRNI report, in order for it to reconcile. Not ideal…
I see, can you delier now -1 with a stock of 12? then book back in as 1 with a stock of 10?
You could start playing with the decimal of the pack UOM but I would prefer you took it all out and back in again.
If not you would need to manually remove it from the GRNI account.
hat is in the received and invoiced fields on teh line?
Sounds good, however when I try to process the -1 Deliver Now, it says “Quantity of -2.00 cannot be returned because items have already been returned or marked as open transactions.”
I’ve just checked the marking on that item, and there doesn’t appear to be any…? And it hasn’t been returned as in the stock file, the 2 is still at the ‘Received’ stage, obviously waiting for the invoice to be passed to update it to ‘Purchased’.
On the line in the PO, the ‘Received’ and ‘Invoiced’ fields both say qty of 1.00, with 0.00 in both the Deliver Remainder & Invoice Remainder fields.
There should not be a prevention on the “return” unless you have modified it, but then I am not sure with yout processing. I would ask a developer to debug the message.
When you say the “2” is at received stage where are you seeing this in the system because the line is showing you zero.
I’m pretty sure no mods have taken place.
The qty of 2 at the ‘Received’ stage is within the stock transactions for that part. It is true that there is nothing to process looking at the PO, which is why this qty of 2 in trhe GRNI is in limbo…
A possible explanation to how this happened could be that the original order went on with a unit of PKT 12 (qty of 1) and we ‘Delivered’ that into stock, but when we received the invoice it was noticed that they were a PKT 10, so somebody changed the unit to that, and passed the invoice… Is that feasible?? With all the error messages I keep getting, I would of thought DAX would have told 'em off!
Thanks for your time Adam…