If you enter an invoice for a customer that belongs to a National Account, the statement should also reflect that activity when the customer is reassigned to a different National Account. The AR Invoice is assigned to a customer and a NA in the AROBL (Documents) table. The statement process gathers the current value in the customer record and puts the transactions on that NA regardless of the NA assigned to the transaction. In other words, if you enter an invoice for a customer under NA1 then change the customer to NA2, all of the NA1 transactions will show on the NA2 statement. However, you post receipts under the NA1 account in the AR Receipts screen (which I agree with).

I haven't found a way to overcome this behavior in Crystal Reports. If you choose a "Select By" range from NA1 to NA1, for example, then the ARSTOBL (Statement Documents) table won't be populated with the invoice that was entered under NA1 because the customer now belongs to NA2.

by: Shauna B. | over a year ago | Reports / BI