Get Shipment Lines

RobbieX

We want to be able to make Sales Invoices for a customer which may have several bill to customers.
On the customer card we can choose one bill to customer or we can leave it blank.
When we make a Sales Order, on the the SO invoicing tab, it will display either the bill to customer from the customer card, or the actual customer for which the SO is for.
When the goods are then shipped out, the Sales Shipment Lines will display whatever bill to customer code was on the SO.
When we want to make a Sales Invoice for the customer with a different bill to customer than that which was on the SO, we cannot 'Get Shipment Lines'.
Would it be okay to simply edit out the code in C64 which says:
SalesShptLine.SETRANGE("Bill-to Customer No.",SalesHeader."Bill-to Customer No.");?
Or would this cause problems later on?
Is there a better solution?
Please advise.
Thanks!

radianis

Hi Robbie,

The problem is when you choose customer in sales invoice with different bill-to address (by changing code), you will have a problem with your sales invoice.

This is because when you get sales shipment, it only update your sales invoice line, not your sales invoice header. So when you enter sales invoice and choosing sell-to-code customer, the bill-to-code will use customer card information or you can change manually.

But since you change the code, "your header is different with your line". This is some example of how it could happen.

You have 3 SO (SO1, SO2, SO3) with different Sell-to and Bill-to with the same amount USD 100 as follows :
=================================
Sales Order / Sell-to Cust / Bill-to Cust / Amount
=================================
1. SO1 / A / A / 100
2. SO2 / A / B / 100
3. SO3 / A / C / 100

---

Then you create 1 Sales Invoice with Sell-to 'A' and Bill-to 'A' (assuming your customer card default value).

You do get shipment line with changing code, and you get all the 3 SO (assuming 1 SO equivalent with 1 Shipment) with USD 300.

What happen next if you post the sales invoice is you have adding USD 300 to 'A' customer ledger only, not USD 100 to 'A', 'B', or 'C'.

So the result is not what is expected since Navision use bill-to as basis to record in customer ledger.

I hope you understand the situation and can match with your needs.


Thank's

ara3n

I agree with radianis. As long you are aware that you will bil the bill-to customer no on invoice, and not the sales order, you'll be fine. When you post the invoice, make sure the sales order is updated with quantity that you've invoiced. Also I wouldn't comment out the code. I would allow the user to remove it manually from the form, this way they won't make the mistake on orders where you don't want to select the wrong shipments.