Customs Document

[metas-rc]

Is this a bug or feature request?

• FR

What is the current behavior?

• We don't have a Customs Document/

Which are the steps to reproduce?

What is the expected or desired behavior?

Concept

• Add 2 new tables:

C_Customs_Invoice

• C_Bpartner, C_BPartner_Location, AD_User
• Date
• DocumentNo
• Currency
• Basic Document columns

C_Customs_Invoice_line

• Product
• LineNetAmt
• Qty
• UOM
• Default columns

---

• Add a window for the tables above

• Add a new doctype Custom Invoice , docBaseType CUI - Custom Invoice, I won't add a docSubType yet. To be added when we have more options for this document. Update the DocBaseType list.

• Add new flag in M_InOut IsExportedToCustomsInvoice which turns true when an inout was processed into a Custom Invoice

• Add a new column in M_InOut called Custom_Invoice . This will be filled when a Custom Invoice is created based on the M_InOut. In the end, all the Shipments used in the Custom Invoice will be available in its Referenced Documents.

• Add the flag in the Shipment window and filter

• Create a process Export Shipments to Custom Invoice,

• Add a process parameter Logistic Company ( this will be the C_BPartner of the Customs Invoice)

• Link the process with the table M_InOut, window Shipment.

Logic

• Create a process M_Customs_Invoice_CreateFromInouts

• Parameters: Selected M_Inouts, a C_BPartner_ID called "Logistic Company" together with its Location and user.

• Collect all the inout lines of the selected inouts, map them by product id.

• The process creates a single Customs Invoice for all the selected inouts.

• We will need to decide upon which currecny to use, in case the selected inouts have different currencies. Suggestion: Take the currency from the Country of the C_BPartner_Location. @metas-ts Is this ok?

• Each entry of this map will turn into a Custom_Invoice_Line

• The qty on the custom invoice line will be the sum of all the qtys from the lines for the product. IMO I should convert them all to the product's basic C_UOM and this will also be the UOM of the Custom Invoice Line.

• The lineNetAmt will be the sum of prices from the inout lines of the product. The prices will be converted in the Currency set in the header.

• Shall the document be completed automatically or left in Draft state? (@metas-mk ?) , or maybe it should be a parameter in the process?

• Add unit tests for the aggregation part.

@metas-mk : what prices should be summed up? Should they be with or without VAT? Should the discounts be included or not?

@metas-mk Should the flag IsExportedToCustomsInvoice be in the generic Shipment window or should we copy the window to ic114 and only show it there?