Hello everybody,
At the moment my company is implementing intercompany for one of our customers. During this implementation we ran into an RMA problem. The customer we're implementing intercompany is using SuiteTax. RMA for intercompany dropship orders is not supported with SuiteTax at the moment. In SuiteAnswer ID 24140 we found a workaround. However the result of the accounting is not correct.
Question: How to re-stock with the same stock value as the original item fullfillment e.g. € 531,34 See step 4 and 14
The steps to reproduce (Dropship Italy-Netherlands):
STEP 1:
Subsidiary Italy create a sales (SO-IT) order for a local customer in Italy with an dropship from subsidiary Netherlands.
NP-03 Sales Orders: € 976,00 D Non Posting
8000 REVENUE : REVENUE PRODUCTION GOODS : REVENUE PRODUCTION: € 800,00 C Non Posting
Tax on Sales Italy: € 176,00 C Non Posting
STEP 2:
From the SO-IT a intercompany Purchase Order (IC-PO-IT) is created.
NP-05 Purchase Orders € 665,00 C Non Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 665,00 D Non Posting
Tax on Purchases Italy € 146,30 D Non Posting
Tax on Sales Italy € 146,30 C Non Posting
STEP 3:
The Netherlands subsidiary creates an intercompany sales Order (IC-SO-NL)
NP-03 Sales Orders € 665,00 D Non Posting
8005 INTERCOMPANY PRODUCTION € 665,00 C Non Posting
STEP 4:
The Netherlands subsidiary fullfills order IC-SO-NL from stock Netherlands
7500 COST OF GOODS SOLD FINISHED PRODUCt € 531,34 D Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 531,34 C Posting
STEP 5:
The Netherlands subsidiary creates an invoice. The Invoice is send to the Italy Subsidiary.
1306 ACCOUNT RECEVABLE IC € 665,00 D Posting
8005 REVENUE INTERCOMPANY PRODUCTION € 665,00 C Posting
STEP 6:
The Italy subsidiary creates a dummy fullfillment for SO-IT
No GL Impact
STEP 7:
The Italy subsidiary send an invoice to the local customer.
1300 ACCOUNTS RECEIVABLE € 976,00 D Posting
8000 REVENUE : REVENUE PRODUCTION GOODS : REVENUE PRODUCTION € 800,00 C Posting
Tax on Sales Italy € 176,00 C Posting
STEP 8:
The Italy subsidiary creates also a Intercompany Bill
1606 ACCOUNT PAYABLE IC € 665,00 C Posting
7506 COST OF GOODS SOLD DROP SHIPMENT IC € 665,00 D Posting
Tax on Purchases Italy € 146,30 D Posting
Tax on Sales Italy € 146,30 C Posting
STEP 9:
The Italy subsidiary creates RMA from SO in step 1
NP-06 Return Authorizations € 976,00 C Non Posting
8000 REVENUE : REVENUE PRODUCTION GOODS : REVENUE PRODUCTION € 800,00 D Non Posting
Tax on Sales Italy € 176,00 D Non Posting
STEP 10:
The Italy subsidiary creates Item Receipt from the RMA in step 9.
7540 COST OF GOODS SOLD RETURNS € 665,00 C Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 665,00 D Posting
STEP 11:
The Italy subsidiary creates Credit Memo
1300 ACCOUNTS RECEIVABLE € 976,00 C Posting
8000 REVENUE : REVENUE PRODUCTION GOODS : REVENUE PRODUCTION € 800,00 D Posting
Tax on Sales Italy € 176,00 D Posting
The next steps are described in the note of SuiteAnswer ID 24138 and 24140
STEP 12:
The Netherlands subsidiary creates an Intercompany PO (Supplier = Italy subsidiary)
NP-05 Purchase Orders € 665,00 C Non Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 665,00 D Non Posting
1595 VAT (SUSPENCE ACCOUNT) € 139,65 D Non Posting
1562 VAT TO BE PAID (HIGH) € 139,65 C Non Posting
STEP 13:
The Italy subsidiary creates Intercompany Sales Order from the PO in step 12.
NP-03 Sales Orders € 665,00 D Non Posting
8005 REVENUE INTERCOMPANY PRODUCTION € 665,00 C Non Posting
STEP 14:
The Italy subsidiary creates an item fulfillment from the SO in step 13
7500 COST OF GOODS SOLD FINISHED PRODUCT € 665,00 D Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 665,00 C Posting
3150 INVENTORY : FINISHED GOODS : INVENTORY IN TRANSIT € 665,00 D Posting
Intercompany Clearing Account € 665,00 C Posting
The amount on account 3100 and 7500 should be the same as in step 4! E.g. € 531,34
STEP 15:
The Italy subsidiary creates an invoice from the SO in step 13
1306 ACCOUNT RECEVABLE IC € 665,00 D Posting
8005 REVENUE INTERCOMPANY PRODUCTION € 665,00 C Posting
STEP 16:
The Netherlands subsidiary creates an item reciept from the PO in step 12.
1590 INVOICES TO BE RECEIVED € 665,00 C Posting
3100 INVENTORY : FINISHED GOODS : INVENTORY FINISHED GOODS € 665,00 D Posting
3150 INVENTORY : FINISHED GOODS : INVENTORY IN TRANSIT € 665,00 C Posting
Intercompany Clearing Account € 665,00 D Posting
STEP 17:
The Netherlands subsidiary creates an bill from PO in step 12.
1606 ACCOUNT PAYABLE IC € 665,00 C Posting
1590 INVOICES TO BE RECEIVED € 665,00 D Posting
1595 VAT (SUSPENCE ACCOUNT) € 139,65 D Posting
1562 VAT TO BE PAID (HIGH) € 139,65C Posting
I understand that this is a lot of information. If there is anything I can do to make it more clearly please let me know.
Hopefully someone can help me with this complex puzzle!