Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Gary Deemer]

We are processing 1099’s and we have a vendor which has sent us a single invoice that bills us for non-employee compensation services as well as rental charges.  I see how to flip the 1099 categories on the Vendor Ledger entry screen but I can’t figure out how to use two separate categories for one invoice (one line).

——————————
Gary Deemer
Accounting Director/Treasurer
Arbor Day Foundation
Lincoln NE
——————————

[Kim Dallefeld]

NAV really doesn’t handle splitting one invoice into more than one 1099 code. You can on the unposted invoice flag some lines as not 1099 liable.

The only real solution is to enter multiple invoices coding each to the desired 1099 code.

If you have already posted the invoice, you could apply a credit memo and do the separate invoices. If you have already paid the invoice, I would clear the 1099 from the invoice, do separate invoices and pay the invoices using manual check. This will require a GL entry to reverse the accounts debited on the invoices and the account credited for the manual check.

Not a clean solution but one that will work. 

——————————
Kim Dallefeld
NAV Consultant
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————-

[Adam Jacobson]

I would add one addition to Kim’s answer.  Since you have to create some kind of check when you adjust 1099 amounts, I’d suggest setting up a dummy bank account just for 1099’s.  this way, the debits and credits will clear and you don’t need a journal entry.  I just worked this out for a recent conversion. Here’s  a blog post on the subject

——————————
Adam Jacobson
President
Red Three Consulting, Inc.
Bronx NY
——————————
——————————————-

[Gary Deemer]

Thanks for the great suggestion, Adam!

——————————
Gary Deemer
Accounting Director/Treasurer
Arbor Day Foundation
Lincoln NE
——————————
——————————————-

[Gary Deemer]

Thanks, Kim, for the workaround.  I suspected there wasn’t another more “elegant” solution, but I appreciate you confirming that for us!

——————————
Gary Deemer
Accounting Director/Treasurer
Arbor Day Foundation
Lincoln NE
——————————
——————————————-