is there a way to customize Bank Reconciliation report? (i.e..add/edit columns) dont see a way to do so

We currently use undeposited funds to reconcile our bank account as we have payment gateways depositing in batches to the account. I'm not sure exactly how to reconcile these using the native NS reconciliation without using undeposited funds because of the batches. I can't reconcile directly to the bank because I am not seeing transaction line detail, I am only seeing the batches coming over which will not match my transactions in NS. Any advice?

Hello--is there anyway to undo an accidental void of a check in NS?

Enter a new one.

has anyone used the electronic banks payment to generate a wire file?

@Ivan S yes have used electronic payments for quite a few instances - what is your issue?

@Sam-I-Am did you configure a custom template for a specific wire format?

yes, which format you are looking for ACH, BAC, CPA-005 or CTX?

are you using it for multi country/currency payment?

Is there anyway to exclude freight from being included in the discount amount on vendor bills? It doesn't look like there is a native method to do so, but even a workaround? Recalculating on the pay vendor bill page for the actual amount is pretty tedious and not very efficient.

This was asked about previously. Here was conclusion we reached

Thanks for the response, good to know that a script is the only work around

when i drill into account details from the trial balance, is there any way to add the offsetting accounting to the report?

is there a reason why an account is not showing when i try to create a customer and set its Default Intercompany Expense Account ont he customer record.... The Eliminate Intercompany Transactions box is greyed out so it wount let me check it?

@Ogabeg that field is for defining the subsidiary as inter company customer. Suppose you have 2 subsidiary A and B, for sub A sub B is also a customer and a vendor (same way for B to A). To create inter company vendor or customer you have to select "represent subsidiary" field (might be hidden in the form) and which will allow you to set eliminate inter company transactions box.

@Sam-I-Am yeah I realized we need to create the vendors/customers/items and accounts before we do any po/so

Anyone got experience with Intercompany journal entries? No matter what I do I always seem to run up against "Each line must have a non-null value. Zero is permitted."

you have to define a debit or a credit on each line

remove your zeroes

setting both causes the import to bomb

Ah you mean the credit and debit 0's? Tried that, same issue 😞

Does anyone here use CloudX's AP Smart for AP automation? We're looking into using them and are slightly concerned about the information they're giving us on their NetSuite integration.

did you try highlighting everything below your last row and right clicking and hitting delete? you could have "empty" rows below your data

also - i presume you aren't setting the "amount" field anywhere, right?

Ah I got it. I had department mapped out on the template whereas I shouldn't have it seems...thanks kevin

is it possible when creating a sub customer record have price level carry over from the parent record?

Scripting could do that. I presume.

thanks @KevinJ of Kansas, I figured that may be the route, but was hopping it was just a setting.

suitebuilder could do it as well I would think using sourcing and filtering

Thanks @reptar, I will check into this as well