cannot post purchase order, "no quantity enter

buchhot

Hi 'ya all!

May anybody can help me out, I got a serious problem with some purchase orders.
The purchase order is partially shipped and invoiced. There is only one position left which has already been shipped and now I want to invoice it.
In this example we ordered 1 item, we shipped 1 item and now we want to invoice this 1 item.
Navision tells me:
"You cannot post these lines because you have not entered a quantity on one or more of the lines".

When I look at the "purchase lines"-table I got some weird entries in some fields:

No. 100306
Quantity 1
Outstanding Quantity 0
Qty. to Invoice 1
Qty. to Receive 0
Qty. Rcd. Not Invoiced 1
Quantity Received 1
Quantity Invoiced 0
Quantity (Base) 1
Outstanding Qty. (Base) -1
Qty. to Invoice (Base) 0
Qty. to Receive (Base) -1
Qty. Rcd. Not Invoiced (Base) 1
Qty. Received (Base) 2
Qty. Invoiced (Base) 1

I am very confused about the different quantities which I cannot explain.
On one hand it tells me that on this position there is 1 received and none invoiced. then in Base-Quantity it tells me that there are 2 received and 1 invoiced which is definitely wrong.
Also the columns "Outstanding Qty (Base)" and "Qty to REceive (Base)" are weird because they have negative values.
The Base Unit of Measure for this item is piece, so 1 piece is one item in the warehouse.
I already checked that the Base Unit of Measure has not been changed on the item since creating this purchase order.

I also cannot manually change values in the table purchase order.

I hope anybody can help me out because I ](*,) ](*,) ](*,)

Many thanks in advance
you all Navision Gurus

lakshmivalluru

right !!! firstly, if this is one off in navision then correct the data manually in table or via report, to post this invoice.

secondly, the error you mentioned doesn't seem to be a standard error. is thta exact error you are getting?

is there any customizatino done?

buchhot

Hi lakshmivalluru!

You mean that
"You cannot post these lines because you have not entered a quantity on one or more of the lines"
is not a standard error message?
It is not a customization, so it has to be standard, at least in austrian Navision 4.0 SP2.

I also tried to correct the values manually, but I cannot change data in this columns via object designer, nor can i change it directly on SQLServer.
We have developers license.

So how do you think I can correct these values manually?

gri

quantity base keeps the order quantity in the base unit of measure for that particular item
if you have a difference between the quantity and the quantity base values, the first place to look for explanation is in the units of measure area.

i cannot say for sure, based on the info that you provided, but my guess is that the order is made for one purchasing unit of measure which equals 2 units of stock expressed in the base unit of measure and from here the confusion is generated.
please take a look at that.
do not modify values direct in the table. this is a bad practice and the quick way to disaster taken only by the unexperienced consultants.

hope this helps

buchhot

Hello gri!

Many thanks for your advice, but I already wrote in my first post, that I also thought about unit of measure codes and checked the item. I even checked, if the item has been changed, since the puchse order was generated.
All in all I can say that this item has one Base Unit of Measure Code, one for purchasing and one for selling. So this could not be the root of the problem.

The Table is not that complicated, so I will have to edit field-values within, otherwise I would not be able to post this purchase order.
Since it is partially shipped and invoiced and it is connected to a sales order via direct shipment I have to post this order through.
There is no alternative for me.

Anybody got an idea what the root-cause of the problem could be?

Mbad

Your problems are the qty(base fields), and it is a standard error.

You have made some faulty code somewhere. The typical thing would be that you have tried to modify the recalculatelines on tab 38, or you somewhere forget to call initoutstanding after your modifications on tab 39.

How are these purch lines created?

lubost

I think that your only possibility is to change property of ...(Base) fields to Editable, correct values and return back the property to Editable=No

lakshmivalluru

As i said if this is one off then and you have to post this invoice then

write a report on sales line filtered on document type, document no, line no and assign the following and modify. then run the report. this will update the data.

Outstanding Qty. (Base) = 0
Qty. to Invoice (Base) = 0
Qty. to Receive (Base) = 0
Qty. Rcd. Not Invoiced (Base) 1
Qty. Received (Base) = 1
Qty. Invoiced (Base) = 0

if you can't fix it , then i think u r an end user and u will have a navision reseller supporting you , they can fix it.

Mbad

lubost wrote:

I think that your only possibility is to change property of ...(Base) fields to Editable, correct values and return back the property to Editable=No

Dont do that. If you need a correction done, do it through a report, and not untill you have done a complete analisys of the implication of the bad coding. Changing one thing on one order is not enough.

buchhot

Hello Mbad!

We created the puchase lines via the requisition worksheet (direct shipment).
I checked the customizations and I do not think that there is some dangerous code. None of it changes standard fields in purchase lines.

Cannot imaginge where the problem is and will now try to just change data manually via report.

Mbad

buchhot wrote:

Hello Mbad!

We created the puchase lines via the requisition worksheet (direct shipment).
I checked the customizations and I do not think that there is some dangerous code. None of it changes standard fields in purchase lines.

Cannot imaginge where the problem is and will now try to just change data manually via report.

If that is the case(no bad coding) you should be able to recreate the lines from the same req. worksheet. You will need to find what is causing the error anyway. Btw it is not necessaryly linked to the lines, but can be filters and header modifications as well. Guess you will see when you recreate the error. G'luck man, its not the easiest code in the world.

buchhot

Hello Mbad!

Many thanks for your hints and quick reply.
I cannot regrete the lines because it is a direct shipping case and the according sales order has been finished, so I have to post this purchase order.
I changed field manually and everything works fine then.

I now do not know what caused the error nor can I reproduce it, so I just have to hope that it was some weird circumstances that will never happen again.

Thanks anyway.