Proposal summary

QIMA  group would like to automate the bill creation from invoice in the Intercompany Process

Requirement 

QIMA group would like to eliminate the PO and SO creation and other manual process on Intercompany transaction. They need to directly create Invoice and, on a trigger, the bill should be created automatically.

Our Solution

As per the standard NetSuite procedure for intercompany transactions, PO and SO creation cannot be omitted as that makes the link between two subsidiaries. In the standard IC transaction flow, the automation take place only at sales order creation from purchase order. Rest is manual process like Item fulfilment, item receipt, Invoice creation, Bill creation and then payments. So, invoice automation is not possible through the Standard intercompany procedure. Apart from this, we can pair intercompany transaction which also need manual creation of Stand-alone Invoice and bill. So, we have to move to a customized solution to automate bill from a standalone invoice.

From invoice, will get the item info like name, quantity, amount. The tax code will be based on the tax nexus of the vendor subsidiary. The vendor info should be pull from the customer subsidiary specification. From the vendor record, we can fetch the subsidiary

	CURRENCY	from invoice
	Amount	from invoice
	Subsidiary	from vendor record: vendor primary subsidiary
item info	Quantity	from invoice
	Rate	from invoice
	Amount	from invoice
	Tax  code	from vendors primary subsidiary nexus
	ACCOUNTS PAYABLE	from vendor record

• The customer in the invoice will be with the following subsidiary specifications

Subsidiary A                                              Subsidiary B

Customer name: B (customer of A)

Primary subsidiary: A

Represent subsidiary: B

• From the Vendor records, locate the vendor with reverse subsidiary specifications

Primary subsidiary: B

Represent subsidiary: A

Vendor Name: A (vendor of B)

• The trigger should be a user trigger like a button (After saving the invoice, when the user wants to automate the bill, click on the button provided)

• If the user wants to delete the bill, delete it and after saving changes on the invoice, click again on the button to automate the bill

• The date on the bill will be: the date on which trigger button is applied

• Paired intercompany transaction field in the bill should specify the invoice from which the bill is automated.

Assumptions 

We’re assuming that the customer and vendor (subsidiary combination for primary subsidiary and represent subsidiary) for Intercompany transactions are unique.