Can we apply intercompany bills and invoice without messing up the consolidation etc.
In Sub 1 books - Net settle Sub 2 AR and AP
In Sub 2 books - Net settle Sub1 AR and AP
k
Karina
04/27/2023, 9:39 PM
do you have the same currency in all subs?
p
Pat Oxida
04/27/2023, 9:40 PM
No we don't have. We're just trying to offset the AR and AP to have just one net AR/AP line
m
Mika Hakkinen
04/28/2023, 8:26 AM
Look up Arms Length Intercompany transfers. During ME process an elim JE is created automatically.
k
Karina
04/28/2023, 3:36 PM
@Pat Oxida, unfortunately, with you MUST create PO first, then all transactions stem from that PO. pairing will not work with transitions in different currencies. so, create PO, generate SO, invoice, VB, and payments. Make sure to setup your intercompany stuff properly. It will eliminate during period close.
j
Jon Kears
04/30/2023, 10:49 PM
best way we've found to net settle is to use a cash clearing account (customer payment + vendor payment). By tagging the right customer and vendor, Netsuite puts all the right tags on them so they eliminate with the bills and invoices
l
Luis
05/01/2023, 12:42 AM
@Jon Kears if the currencies are different, do you just record the forex gains/losses manually via a JE against the remaining balance of the cash clearing account?
j
Jon Kears
05/01/2023, 1:05 AM
@Luis - yeah that's right, or you can just manually force the rate on the "foreign currency" cash transaction