hey guys with new account going live let`s say Mon...
# accounting
c
hey guys with new account going live let`s say Monday, can users create sales orders and purchase orders and then few days after consultant uploads opening balance ?
s
Sales order and purchase order are non posting and I don’t see any issue. It’s better to lock AP and AR for the period you are putting closing balance.
✔️ 1
k
My preferred order of operations is 1) load non posting transactions 2) load open AP/AR as vendor bills and invoices all posted in same period with period date mismatch if necessary 3) reverse AP/AR loads with je 4) load inventory via inventory adjustments 5) reverse inventory with je 6) load GL history
✔️ 2
👍 2
The reason I like to do it this way, is that I can get my balances back to zero, so if there's a mistake, I know it is in the GL data, and not with my data loads.
✔️ 1
👍 1
m
I like your approach Kevin, just one twist I do a little differently - instead of posting the reversal of AR, AP and Inventory directly to the normal AR, AP and Inventory accounts, I create a dummy "other current asset" and "other current liability" for the reversal and for the GL history import. This way my aging stays clean and I don't have any floating JE's in accounts that are "control" accounts.
k
How do payments work on that scenario? Or are you saying that you post to those accounts instead of bringing it in the GL history in the AR accounts?
Bah. That's not coming out the way I mean it.
I think I get the idea... Maybe haha. So one line posts to A/R and one line posts to your dummy account. Then when you bring GL history into that dummy account instead of A/R goes into the dummy account and then the offset occurs naturally?
m
Yes, exactly.