Sage 100

Sage 100 4.3. A client wants to import their credit card statement into AP Invoice Data Entry. The downloaded statement from the bank includes about 600 lines for 37 different cards. I'm trying to summarize the detail by GL distribution account and I'm not having any luck. Anyone done this before and can offer a solution? I already tried holding the distribution amount in a temp field, then calculating the distribution as distribution + temp field, but it still imports each detail line.

Sounds like a great opportunity to show them how to use a pivot table to summarize the date in Excel, then import it into MAS.

Thanks @JeffSchwenk . I agree, but I'm trying to avoid that and allow them to import the file with as little manipulation as necessary.

I had this question many years ago on a new deal opportunity. I was not able to find anything that would simply take the file and import it. There are a lot of ways around it such as pivot table summaries but in many cases that customers is looking for a one button answer. I'd be interested in hearing if you find anything.

I think you'll need an interim step - importing into Access or pivot in Excel if you want summary by GL. Why is having the detail by line an issue - other than it's long?

@MoiraGoggin . It's a lot of unnecessary GL detail, and most importantly, it's what the customer wants. I'm exploring the pivot table option. The challenge is making this a process an average AP clerk can handle. Frustrating thing is I remember the ability to do this in pre-BF versions.

Okay I see your point...look at Access though as an option. You can setup an autoexec macro, which launches automatically when the db is opened/access. It would import the file, run the summary and export it without the AP clerk having to touch it, then launch the VI job to AP invoice entry. I've done this where the Access execute opens minimized to the task bar so know one's the wiser.