Sage 100

Sage AR Cash Receipts, national/'parent company I thought that the national account feature would help in cash receipts when a 'parent' company submits a check that pays for invoices across several 'child' accounts. Is it only the case after the relationship has been established for future invoices? Or is it something wrong in the way I set up the Bill to Sold to relationships?

I don't think it is a setting, This will not affect invoice that are entered prior to turning National accounts on.

Okay, if I follow, subsequent invoices to the 'child' will available at the 'parent' level during cash receipts?

Is it possible to VI the link?

Hum...interesting idea @JeffSchwenk

Yes to Moira's question. future invoices will show to the parent company in cash receipts entry. I hadn't thought of that though; it's going to make the transition more difficult since customers will send in one check that ends up covering invoices from two customer records. .

Okay, future transactions post a link then for AR. Yes it is more difficult since you'll have separate cash receipts for a while and then later a mix, some old and some new...there must be a way to link the old as @JeffSchwenk suggested but I don't see a specific table in AR yet...

Looks like, but would value another opinion that the AR TransactionPosting file contains the AR Div, AR Cust and Bill to Div and Bill to Customer. However, I don't see this file for import in VI.

In the AR_OpenInvoice table, fields 21/22 is SoldToDivisionNo and SoldToCustomerNo. I don't have any customers using national accounts, but perhaps this is a clue.

Thanks @JeffSchwenk , I'll look at the one.

I would also think there were be a corresponding field in AR historyheader. haven't had a chance to look.

I am going to post a separate post on this but as it looks like you all have experience with the National Accounts, I thought I would post here as well. From what I can see of national accounts the only thing stored on the child is a summary record of sales. The open invoice is recorded to the parent/national account. Other than the summary total by customer and the extra effort of setting up a customer, WHY in the world is this much better than just using Ship To and one customer.