Payables AA Distributions fail when account matches
I'm trying to create a Payables transaction, create its distributions, and create its analytics distributions. The portion that does not work correctly is the AA data, but only when the distribution account is the same.
I've create a google document whose link is shared below so you can understand my source data. The first line's AA comes in fine (the $1197.57 debit). The next two distribution lines have the same account and this is where it errors. The AA distribution associated with the $259.87 debit is created but without the ACQUISITION AA code. The next row, debit $141.22, is then correct again with the ACQUISITION code included. I have tried using the "GL distribution sequence number" column in the SC mapping in many ways. This field is described in Microsoft's eConnect documentation as
"The GL distribution sequence number. If you have duplicate accounts in a transaction, associate them using sequence number values."
I've set it to the Line Number column to no avail. I have also created another sequence number column called AA Line and played with that being unique for each row and being grouped for the AA rows in different ways ([1,1,2] vs [1,2,3] vs [1,2,2] etc). I've tried all this with no grouping at the Analytics Distribution level and with grouping on various fields. Every attempt yields exactly the same result. The transaction is correct, it's distributions are correct, it has 3 AA distributions where the first and last are complete and the middle is missing the AA code. Your time is greatly appreciated.
If you would like to submit an answer or comment, please sign in to the eOne portal.