Sage 100

Seeking advice on how to handle Accounts Payable invoices that have multiple types of expenses that need to be split over multiple stores (GL departments). For example, say we have a credit card statement and there are many charges that should be allocated to multiple stores and multiple expenses. The Expense Distribution table won't work, I don't think, because it's designed for splitting a total invoice by percentage over GL accounts? Anyone doing anything currently to handle this type of situation? This is MAS 90 Version 4.4 PU 6.

Excel distribution, then import via VI? Or just key manually but it sounds like you will have many lines. I have several clients importing AP.

Thanks, @JeffSchwenk, that may work; taking a look at it now.

@AmyShaver, we did something very similar to this with a client. We leveraged the AP allocation tool but then added UDF's to the line item table and had a custom BOI routine written by Martin and Associates. This allows the user to assign an allocation to a line item rather than at the header level. Once all the lines are entered and the AP Invoice is saved, you click on a button and the BOI routine reads each line and creates new lines based upon the allocation. We added an additional element for account masking since the client has 6 segments in their account number. Give me a call if you have questions. I can probably schedule a show and tell with the client if you like and I can get you connected with Kevin Martin to work out something on the BOI routine.

Thanks, Shawn, will let you know!

I always encourage the client to go the full 9 yards and not stop short. With the availability of online CC statements in CSV or PDF (and a tool like Monarch for PDF extraction to XLS) I can envision an Excel tool that would provide point and click to allocate to stores that could be used by the BOI, VI import or their combination.