Error get shipment line in Sales invoice

Business Central/NAV User Forum
1

dear all,

i have a little problem when i creat sales invoice using get shipment lines function in NAV 5 SP1

  1. i creat sales order with item 70010 with 80 quantity and price 100 in cronus database

  2. in prepayment% field i fill 30%

  3. then posting sales prepayment invoice

  4. in quantity to ship i fill 30 pcs.

  5. posting shipment.

  6. in sales invoice i try to run get shipment lines function.

  7. pick the sales shipment document.

  8. it shows warning “prepmt. line amount cannot be less than xxx in sales line document type …”

============================================================================================

actually i find a work around for this case using prepayment credit memo & undo shipment and then break the sales line to two lines. 1st line with 30 pcs and second line 70pcs…

however, using prepayment credit memo is forbidden in our client policy… is there any possible work around without using prepayment credit memo? or this case actually consider as a bug?

please help and thank you all…

2

I don’t quite understand your actions beginning with this point… WHY you are doing all this? First, it’s illogical, second, GetShipmentLines is used for completely different needs - to join several Orders in one Invoice, for example, but you already HAVE everything…

Simply post shipment of the remainig Qty, then post invoice - or do it on one step, as you like…

3

yes, thats the standard procedure in client database…

they request some modification in sales/purchase order area which the option when posting is only ship/receive. (no invoice or both)…

so, the only way to creat invoice and link it with shipment/receive is only from this function…

4

Well - many clients ask for functionality, where one user only ships/receives and other user invoices - that for you do NOT need to make such awkward modifications.

First, it can be achieved buy means of roles/permissions setup without any mods. Tricky, but possible, even in v3.6, now it’s easier.
Second - a small mod simply disables unallowed options…

You must listen to client’s requirements and then YOUR task as consultant is to map these requirements to Navision functionality, and EXPLAIN to client, how HIS business processes can be done in Navision. Client does not know Navision & it’s possibilities, that for consultant exist to help him.

5

yes, actually we already offer that kind of option, but our client insist that they want modification like that…

fyi, the user who makes sales order and sales invoice is actually 1 user.

anyway, there’s something i want to ask sir.

is really impossible to posting partial invoice if there are prepayment exist?

i try it even sales order. i try to post sales invoice for a line that have prepayment exist and half quantity shipped.

tq for your fast responds.

6

Don’t know - haven’t tried. Prepayments are rarely used, I have to replay this scenario to give a competent answer.

You managed to catch me when I was doing some housekeeping here after two weeks off-line, but it is now 5am for me - there are some timezones between us - so I’m gonna [|-)] now & next answers please don’t expect so soon [;)]

7

hahahaha, its 10 in the morning here…

i’m waiting forward for your reply…

[:)]