web
You’re offline. This is a read only version of the page.
close
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,961

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

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    on at

    Hi Bab,

    Yes - it's the AP_Balances table.

  • Babin Profile Picture
    2,961 on at

    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

    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,961 on at

    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?

  • Verified answer
    Carolyn Kolpien Profile Picture
    on at

    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,961 on at

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

    Thank you again for your answer and clarying my confusion.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans