Skip to main content
Question

1099 Updates


Forum|alt.badge.img

We noticed that many of our vendors were not designated 1099 vendors in the year 2023.  If I desigante them NOW will it still show them on the reports for the 1099 tax year 2023?  I added someone so they would populate but they’re not showing up on our efile.  Help!

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 5, 2024

Hello, 

After marking vendors to check 1099 Box ON, update all the 1099-appropriate lines of all 2023 paid bills and all open bills for this vendor, to add 1099 box numbers. Then reprint 1099 reports.

Laura


Forum|alt.badge.img

@Laura02 so we updated the vendor in it’s profile and made sure to select the appropriate 1099 form.  However - the system is not reading that the checks issued to t hem were for 1099’s at this point.  Not sure how to proceed after modifying their vendor profile? 


dsimmerly
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • January 5, 2024

@katiedavison Note sure you read all of Laura’s post, did you do the following?…. “update all the 1099-appropriate lines of all 2023 paid bills and all open bills for this vendor, to add 1099 box numbers”


Forum|alt.badge.img

@dsimmerly  is she referencing this area? Sorry I am just not familiar!

 

 


dsimmerly
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • January 5, 2024

@katiedavison  “update all the 1099-appropriate lines of all 2023 paid bills and all open bills for this vendor, to add 1099 box numbers”

This means to update the 109 box on each detail line of each bill for each 1099 vendor  as shown below 

 

 

 


dsimmerly
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • January 5, 2024

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 5, 2024

Hello,

To identify 2023 Bills for a vendor, try AP Register report:

To update the Bills/Debit Adjustments/Credit Adjustments, open each Bill/Debit Adjustment/Credit Adjustment by clicking on the Reference Numbers in the above report and type in the correct box number on the bill lines. Save changes.

Laura


Forum|alt.badge.img

@dsimmerly and @Laura02  so.. if we have thouands of bills - does anyone have a suggestion on how to bulk edit them? 


dsimmerly
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • January 5, 2024

@katiedavison You can use import scenario of possible a Mass update to complete the update of the records.  If you are not familiar with this functionality my suggestion is you contact your partner for assistance with the data update.  Below is a help link fro Import Scenarios.

https://help.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=6815d69c-8e42-46fc-8776-cce10dccad04

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 6, 2024

Hello,

I have one more recommendation:  DO return to your 1099 vendors and provide a Default Box # for each. When Default 1099 Box # is populated on all 1099 vendors, the process of correcting Bills in January is avoided.

 


Forum|alt.badge.img
  • Freshman II
  • January 16, 2024

#Laura02 - We have this setup for all the 1099 vendors, but it doesn’t seem to auto populate when invoices are created through a PO. 

Thanks

Jeremy


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 17, 2024

Hi @jdresel ,

I did a quick test for you:  in Sales Demo version 2022 R2, an AP Bill created directly from a PO Receipt does default the 1099 box number from the vendor:

If your 1099 box does not default from the vendor with customizations temporarily unpublished, then open a support ticket with Acumatica/your VAR.

 

Laura


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • January 17, 2024

Hello,

I did a second test in Sales Demo, to make sure the 1099 box populates to the AP Bill in both options:  when creating AP Bill with [...] action from the PO Receipt, and also when starting in AP Bill screen and adding PO Receipt to the Bill.

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings