Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

1099 Box

(0) ShareShare
ReportReport
Posted on by 2,947

Is there a table that holds the list of 1099 values in SL?

*This post is locked for comments

  • Babin Profile Picture
    2,947 on at
    Re: 1099 Box

    Really!, so there is only one type of payment method in SL, just check.

    Thank you again for your answer and clarying my confusion.

  • Verified answer
    Carolyn Kolpien Profile Picture
    on at
    Re: 1099 Box

    Hi Bab,

    Vouchers are paid by various types of checks.  The Doctype in the APdoc table will be CK for a system check, HC for a manual check, ZC for a zero check.  In SL 2011, there is the EP payment type which stands for electronic payment.  However, this is just another type of manual check.  There is no functionality in SL to pay vouchers electronically.

  • Babin Profile Picture
    2,947 on at
    Re: 1099 Box

    Thank You Very much, Carolyn!

    Thats what I thought but I couldn't confirm.

    If you dont mind. I would like to ask one more question.

    Are the Vouchers paid by Check only? If the vouchers are paid by any other payments like Credit Card, EFT etc.. where those data are stored in the database, in which table?

  • Carolyn Kolpien Profile Picture
    on at
    Re: 1099 Box

    Hi Bab,

    Those values are not stored in a table.  The are part of the List property of that object in the screen.  If you have the Customization Manager module, you can go into Customization Mode while in the Vendor Maintenance screen.  Select the 1099 Info tab and click on the 1099 Box Number field.  Press the F4 button and the property window will appear.  You will see the List property with Rents, Royalties etc.  

    Are you having a problem with that field?

  • Babin Profile Picture
    2,947 on at
    Re: 1099 Box

    Carolyn, that is not what i am looking for.

    I am looking for the list of 1099 that display during the voucher and Adjustment Entry screen in 1099 BOX. Are those list stored in the database?

  • Carolyn Kolpien Profile Picture
    on at
    Re: 1099 Box

    Hi Bab,

    Yes - it's the AP_Balances table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,272 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,931 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans