Addins to bring multiple distributions into AP20

 5 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Joe O'Toole
Veteran Member Send Private Message
Posts: 314
Veteran Member

We import some of our invoice files with IMPORTDB, but would like to develop an interface using Addins. I was looking to hear how others have faired creating an Addin's template for bringing in invoices with multiple details lines (some in excess of 100) into AP20.1. Thanks.

Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member
There is an kb article that explains the whole process and how to load invoices with multiple distribution lines on AP20 that works. On the first line the addins message is invoice added, distributions out of balance. This message will be repeated on each line until the last line. The message on the last line would be something like more lines exist use pagedown. Remember to go through the article carefully, and map out the invoice amount field and the distribution amount field. the invoice amount will be the total of all the invoice distribution amount lines and the distribution amount will be the amount on each of the invoic lines. Remember you cannot have multiple process level or credit amounts and debit amounts to be uploaded on the same invoice. reason is invoice lines with credit amounts are trated as a different invoice type which lawson recognizes as a credit memo. Hth.
Tom Keller
New Member Send Private Message
Posts: 0
New Member
Where can I find that article. This would be helpful.
Joe O'Toole
Veteran Member Send Private Message
Posts: 314
Veteran Member
Ruma, thanks for the info. Are you saying you can't have multiple process level details in general or just only when mixing debits and credits? Since we are retail, we generally post distributions to one process level (company) but multiple accounting units (store). If anyone has that KB # I would appreciate it. Thanks.
Ruma Malhotra
Veteran Member Send Private Message
Posts: 412
Veteran Member

The KB article # is 958643. If you have one process level you do not have to worry, but you cannot have more than one process levels in general. Also you cannot have debits and credits mixed for one invoice number.

Reason is Lawson treates the credits as "invoice type"- "Credit MEMO"("C" on AP20.

Hth

Rani Ilapa
Basic Member Send Private Message
Posts: 5
Basic Member
Hi Ruma, Where can I find KB? I am trying to create a upload query for the Expense invoice with different distributions. But I can only add one line in the invoice not able to add other lines in AP20.2? Could you help me with the query?