Change of Bill to Customer after Shipment is made

Dear all, Am offering consuktancyt for a Client who has just rolled out MBS-Navision (3.70). There is a situation in which many sales orders well shipped with a “wrong” bill to. The solution would be to raise credit memos for each, but this will generate a lot of “error” data in the system, and it is tidious. I have thought of simply commenting out the code on the Sales Line table and Sales Header which require that the quantity shipped must be zero. I am wondering what effect this would have if any at all as I cant figure out why this requirement/constraint was implemented in the system. Could someone enlighten me please! Regards, Robert B. Mutyaba

You should definately not just comment out any code. The check is there for a reason, and I would hesitate to take the check out without thorough analysis and extensive testing. Look at it this way… it may be tedious to raise credit memos, but it will save your customer LOTS of money in consultancy fees when commenting the check turns out to screw up data.

I agree with Daniel, simply to comment out the code might cause problemas further down the road… by the way, what exactly do you want to achieve by commenting out the code - delete the sales orders without invoicing (which is definitly not a good idea), change the Bill-to Customer No. and then invoice to the correct customer (which would be the correct way)… therefore I would rather invest some time in developing the posibility to modify the Bill-to Customer No. which must update the lines properly… Saludos Nils

The problem is, that when you change the “Bill-to Customer No.”, the Sales lines get deleted and then recreated in Function RecreateSalesLine, and this is not possible, when deliveries are made. You will have to change the Function, so that the Sales Lines are not deleted, but the neccessary information is updated instead. regards Daniel

Yep, that’s exactly the point, thanks Daniel for putting more detail into my rather short statement [;)] Saludos Nils

You also need to make sure that the “Posted Shipments” are being updated. The problem starts when some of the delivery is already invoiced. Example: You can ship the quantity of 10 with three shipments, say 3,2,5 but invoice with completely different quantities say 6 and 4. In this case the invoices spread over more than one delivery only and deliveries can remain partly invoiced in the system. So when updating the “BIll-to Customer no.” be sure to only allow if either complete shipment is invoiced (then no change to that shipment) or not invoiced at all (change might be allowed). As soon as you find at least one partly invoiced shipment for an order, the “Bill to Cust. No.” may not be changed at all. Navision just went the short way with their tests.

If the order consists only of items then you can undo the shipment, change the bill-to customer, and re-post the shipment.

another solution is to create a new sales invoice do get shipment, click on show all. Find the s shipment and select and click ok. All standard navision.