Here is an update on this issue with having different Dept/Class/Location values in the header versus the line items. Note, if you have Multi Location Inventory (MLI) enabled, then Location is hard-coded at the line item level and you cannot change that. If you do not have MLI enabled, then you could use Location in the…

Yes, Andrew, that is the poor design that I found. If you want to put Dept. or Class on all lines of the GL (both the mainline and the split lines), then you must shut-off Allow per-line Departments or Allow per-line Classes, respectively. Because, if you turn on the per-line option, then the Balance Sheet offset account…

If you use RA's, then it is the Item Receipt which affects inventory, and the linked CM only affects A/R. An orphan Credit Memo, i.e. a CM that is NOT linked to an RA, will affect inventory immediately. (If the CM is linked to an RA, then the IR is what affects inventory) You can also use an unlinked Cash Refund which will…

The correct transaction flow is that you are supposed to maintain a one-to-one correspondence between the PO that your customer issues to you, and the SO that you key into NS. So that is the root problem. You should NOT be keying multiple SO's. You should key 1 single SO, and then just partially fullfill it with lesser…

Paravion, see post #22 below. That should work. Let us know if it does.

Misela, here is my suggestion: Do a Journal Entry: CR Accounts Payable (and make sure to put the Vendor name in the Name field or else it won't show in the next step below) DB Undeposited Funds (or your checking account if you don't want to use U.F.) Now here is the trick: Pay Single Vendor You should find both the…

There is a switch to toggle HTML versus PDF. I believe it is under each individual user's Home > Preferences > Transactions > Printing > Emails as HTML (uncheck) (Note: every user has to set this on their Preferences)

Keith, here is another idea: Create a Payment Item into your Items list that flows into your Accounts Receivable G/L. Now, on the Cash Sale, add that new Payment Item as a line-item. This will zero-out the Cash Sale so the Cash Sale looks paid, but it will flow into your Accounts Receivable so that customer now shows as…

Actually, what we really need is the ability to convert a Cash Sale into an Invoice with one button click. I've asked for this enhancement years ago. Apparently no enhancement request was ever entered until now! Please go vote for this enhancement. Enhancement 145952 - Ability to add button on Cash Sale to convert Cash…

Ideally, you should use an Invoice, not a Cash Sale, and then do Accept Customer Payment for 1/2 and apply that towards the Invoice, then do another Accept Customer Payment 30 days later for the other 1/2 and apply that to the Invoice, then it will be paid in full. You flow it thru A/R with this procedure. If you've…

Please vote for this enhancement: Enhancement 145952 - Ability to add button on Cash Sale to convert Cash Sale into Invoice

Well first thing is that according to GAAP (generally accepted accounting principles), when you receive the inventory (by doing the IR-Inventory Receive on the PO), you debit inventory asset, and you have to credit something. In version 10, they had a "placeholder" account called "Inventory Received But Not Yet Billed"…

The taxability of the line item is *NOT* related to the taxability of the transaction as a whole. As Skytek North points out, the taxable checkbox on the line item level is exactly what you want to use in your example, i.e., is this particular SKU is taxable or not in general?--if it were sold face to face over the counter…

A work-around is to create a custom field and then source it to the canned field (in this case Account Period). Jerry-rigged, but it works.

The sales force automation rules (and territory/sales rep assignment) are applied to online forms. Those rules are not subsidiary specific. So you'll have to test this, but getting the correct territory and sales rep assigned to the lead may have the side-effect of getting it into the correct subsidiary, since the sales…

You need to also filter for trantype=Customer Payment. (I assume you are using Invoices, A/R, and Accept Customer Payment vs. Cash Sales?). This filter should limit the returned dataset to just the Customer Payment transactions, then you get those grouped by date, i.e., subtotal/group them first by customer, then second by…

you have financial txns dated 2010 in your file. Human error probably. Go look at some of the offending transactions and you can look at the History and see who changed the date to 2010.

The Audit Trail is for financial transactions only. The System Table is for non-financial items. Which do you want? For notes, address changes, etc., you would want a Saved Customer Search, and then pick the System Notes table at the bottom of the drop down, and you should be system notes sorted by customer, then by date.…

MMS, there is no InternalID on the AddressBook records. Unfortunately, the key is the 'label' field which in your case is blank! So there is no way to update the existing record, because the key (the label field) is not unique. BUT: in the CSV import assistant, you can pick an advanced option to replace the entire sublist…

B, does the balance column match the value in the balance column when you look at the register UI for the same item row? You may need to put a formula field and do the sum calculation in your search, rather than pulling the balance field out of the table.

There will be a status on the Sales Order which indicates if nothing has happened. If it's been fullfilled but not billed. Partially fullfilled, not billed. Fully fullfilled and fully billed. Fully fullfilled but partially billed. So filter on the statuses that include not fully billed. Then I believe there are values you…

If you fiddle with the custom financial statement writer you can get it by Department. I have done it.

esmeralda, what is the currency listed on the entity record that you are using for your login? I think that currency may affect what you are seeing.

You must not have mapped the accts affected by the J/E's onto the customized financial stmt?

You have a couple of renegade transactions that either have (1) a blank Accounting Period, or (2) the Accounting Period is a different month/year than the tran date. For (1), you can run a Saved Transaction Search and search for criteria where Accounting Period = blank. That will find any txns where the Account Period is…

multiple issues going on here...so let me give you some background... First of all, there is the setup option to use Accounting Periods. You don't have to use periods. If you don't use periods, then NS uses the tran date to determine the month/year for I/S and B/S. If you have periods turned on, the NS uses the period or…

Yes Nate, there is a poorly designed UI for "To ACH", "ACH", "WIRE", "ATM" basically any alpha words in the check number field and the duplicate detection detects them TWICE and you have to click FIVE times to get thru it. But the larger issue, is that these alpha words really should NOT trigger the duplicate detection…

Cyndi, sounds like you use Coastal ACH to pay vendors on the A/P side of the house. I didn't realize the same problem exists there in that Coastal sends a single offset debit to your DDA to fund all the A/P payment. Those A/P payments actually could flow thru Undeposited Funds too as negative deposits (just like the case…

Found the answer: Vendor ACH only works from Enter Bill & Pay Bills, not from Write Check!

Just cosmetic. Abbreviate C/U or CU