hello, In Attain, the natural behavior of a PO is to default the Qty to Receive and Qty to Invoice to the outstanding quanties calculated. I have a client who has PO’s that have lines numbering in the 10’s to 20’s. Their process includes two indivduals - one who does the receiving and one who does the invoicing at a later point. They also are constantly doing partial receipts. I’m looking for a “quick fix” to having the qty to receive and the qty to invoice to default to 0 - Always! I don’t want any validation done on the qty to receive to populate the qty to invoice - nor do I want any figures ever displayed in the qty to receive. I’m a developer and I took a shot at this but either I went at it from the wrong end or I just didn’t realize where all I would need to add logic - I had all sorts of problems with the field validations as well as the xxx (Base) fields which seem to affect much more than I would have thought. Does anyone know of a simple way to implement this? Or whether there are any companies who sell this code as an add-on? Thanks, Alyssa
Hi. You didn’t say what version of Navision You are using. But if we look at 3.60 as an example You have to functions in table 39 that’s interesting in this case. They are “InitQtyToRecieve” and “InitQtyToInvoice”. Just change these to assign zero and You’re done! Example: InitQuantityToRecieve() //“Qty. to Receive” := “Outstanding Quantity”; //“Qty. to Receive (Base)” := “Outstanding Qty. (Base)”; “Qty. to Receive” := 0"; “Qty. to Receive (Base)” := 0;
Well, that was way too easy! I was going at it from the wrong direction - trying to put everything in the OnValidates. Thanks!
Hi Lars, I was testing this more this morning. I entered two line items, each with a quantity = 1. When I go to enter in 1 to receive on the second line item and tab out, it sets the value back to 0. However if I have a total quantity of 2 entered for this line it works. Any ideas? I’m using 3.10b by the way. Thanks! Alyssa
There is more to it then this. You need to look at (1) when the InitQuantity routines are called, and (2) what will happen with Invoices (where you don’t enter Quantity to Receive).
I’ve disabled the calls to the inits from the validates when quantity = quantity to receive. This seems to be the solution… but, another question. The XXX (Base) fields are not being updated appropriately. What are these used for?
Thanks, I think I’ve got it!