104

In almost all projects, we have the requirement that the shipment no must be specified on the posted sales invoices. When the sales invoice lines are created in BC using the function "Get Shipment Lines", the corresponding shipment no is inserted as a comment line. 

If the Post function is called up in a sales order with the option „Invoice“ or „Ship and Invoice“, no shipment no determination takes place. Here it would be desirable if the shipment no is also inserted as a comment line above the sales invoice lines.

We would like the same result, as we use the function "Get shipment lines"




Category: Sales
STATUS DETAILS
New

Comments

A

Hello Kishor Mistry,thank you for the tip. In practice, this will probably happen very rarely, but it is clear that the example must also be possible on the system side.I see two possibilities for this case:Option 1:Both shipping numbers are printed in the comment line. I would probably completely balance the first shipment line booked and the remaining quantity in the second:Shipment No xxx Date xx.xx.xxxx and Shipment No xxx Date xx.xx.xxxx and Line 1 Item A, Ship Qty 8Shipment No xxx Date xx.xx.xxxx and Shipment No xxx Date xx.xx.xxxx and Line 2 Item B, Ship Qty 8Shipment No xxx Date xx.xx.xxxx and Shipment No xxx Date xx.xx.xxxx and Line 3, Item C, Ship Qty 8Option 2:A separate invoice line is created for each shipment line. I would probably completely balance the first shipment line booked and the remaining quantity in the second:Shipment No xxx Date xx.xx.xxxx Line 1, Item A, Ship Qty 5Shipment No xxx Date xx.xx.xxxxLine 1, Item A, Ship Qty 3Shipment No xxx Date xx.xx.xxxx Line 2, Item B, Ship Qty 5Shipment No xxx Date xx.xx.xxxxLine 2, Item B, Ship Qty 3Shipment No xxx Date xx.xx.xxxx Line 3, Item C, Ship Qty 5Shipment No xxx Date xx.xx.xxxxLine 3 Item C, Ship Qty 3

Category: Sales

A

It's not so straightforward, you could have a sales order with 3 lines...line 1, Item A, Qty 10line 2, Item B, Qty 10line 3, Item C, Qty 10You post 3 shipments...line 1, Item A, Ship Qty 5line 2, Item B, Ship Qty 0line 3, Item C, Ship Qty 0line 1, Item A, Ship Qty 5line 2, Item B, Ship Qty 5line 3, Item C, Ship Qty 0line 1, Item A, Ship Qty 0line 2, Item B, Ship Qty 5line 3, Item C, Ship Qty 5You post 1 invoice (for part of shipped qty)...line 1, Item A, Ship Qty 8line 2, Item B, Ship Qty 8line 3, Item C, Ship Qty 8I know unlikely, but possible. How is this supposed to...a) Add comment lines to the posted invoice showing shipment no.b) Update the Shipment No. field on the posted shipment line

Category: Sales

A

The information about the sales shipment no. should also be transferred to the field Shipment No. (63, Code[20]) in the table Sales Invoice Line (113) using the direct posting method from the sales order as well with the function Batch Post Sales Orders

Category: Sales

A

Hi Joanna,your expansion request sounds very plausible to me.

Category: Sales

A

We need these informations for the print on the posted invoices. In addition to the shipment no. in the posted Invoice, we need in Germany also the documet date for the shipment no. the delivery date on the sales invoice is also mandatory. This is needed in both posting functions: once with the direct post out of the sales order and also when we use the function "Get Shipment lines" out of the unposted invoice.

Category: Sales