i assume by 'deposit' you do mean 'customer deposit', as in one recorded against the sales order

that looks correct! I think we must normally just issue credit memos on customer deposits as opposed to issuing refunds, since we issue them through our cc processing system.

thank you!

no problem

afaik, credit memos don't actually debit a cash account

just Sales / AR are affected

so, to reflect an actual CC processor refund, you'd still need to refund the credit memo anyway

ok i will touch base with my finance coordinator and see what she says. she says that she normally has to mark an order as shipped in order to issue the refund…but this definitely says otherwise!

yeah, i guess i could see that, if you were waiting to refund off of an invoice/cash sale

and especially if you don't bill in advance of shipping

but deposits are a different animal

I’m starting to realize that

🙂

Where could one find the definitive guide to matrix parts?

what specifically do you mean by 'matrix parts' @ssdevktown ?

Matrix parts could be this one - https://netsuite.custhelp.com/app/answers/detail/a_id/41831/kw/matrix

so.. one of my accountants discovered something super weird today that i thought i should share: if you enter a JE with 2 lines against one subsidiary and save, the Journal Entry line IDs are 0 and 1 as they should be. but if you edit the same journal entry, remove the lines, change the subsidiary, and add two new lines, the line ID becomes 3 and 4.

the out of box "Approve Journal Entries" page relies on the line ids being 0. so your edited JE won't show up on that page even if it is pending approval.

Note, This is only a problem if you enable the new setting in accounting pereferences>approval routing>journal entries to use workflow to drive your JE approvals

I've noticed that there's a lot of weirdness in NS around Line ID and Line Number

Has anyone experienced different balance totals for the same GL account and same month? For example, we ran balance sheet for Nov 2016 for account 2230 which yeild roughly 1,070,000, running the same account but with Nov 2016 and Dec totals the balance shows for Nov as 1,055,000. I'm guessing this may have to due with exchange rates but does anyone has some insight?

For a subset of the reports, I don't think they look at per-transaction balances but instead use the exchange rate for whatever the 'ending' month is in the report

so that's probably the November balance restated to reflect December currency rates

You might be able to add the Translation Adjustment (or run the CTA for Nov to December) and find the difference there

@bednar Thanks. I figured that was the case but needed confirmation.

The balances should look consistent if you run it unconsolidated

@llfcf I got the same confirmation from NS a while back, this is currently an enhancement request. Alternatively you can recreate the canned comparative financial reports as custom searches, but those fly less with auditors for official tie-out

@vladimir Thank you

Hi All, anyone have an issue with the General Ledger report, the Balance Column does not reset to 0

I don't believe it works on reports, but there's a new-ish option in your person preferences on the Analytics tab called KPI Scorecard with Period Specific Rates which will at least fix this problem for dashboard KPIs. Basically forces the system to use the month-specific Consol FX Rates.