Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

What does the whseloc field in ARtran mean ?

(0) ShareShare
ReportReport
Posted on by

I have a customer, when I receipt PA from CA module sometimes it post into wrong account, I check the ARtran table and found that when whseloc is 05 it post in true account, when whseloc is 07 it post in wrong account. Anyone know what does the whseloc field in ARtran mean and how to solve this problem.

Thanks all

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: What does the whseloc field in ARtran mean ?

    I have one customer setup like others but all payments come from CA was post in whseloc 07 and it is devided in many line, I don't apply it with any invoices or debit, just finish it in payment application screen. I don't know the reason of this problem, can someone help me.

    Thanks all

  • Stefan N Profile Picture
    80 on at
    RE: What does the whseloc field in ARtran mean ?

    This is from the help file -

    Currently used to keep track of which insert statement created the tran line during the release process. Values include:

    *02 - Debit cash for payments coming from 08030

    01 - Offset for 08010

    03 - Debit for SB/SC types

    04 - Credit for SB/SC types

    05 - Credit AR for unapplied amount if payment coming from 08030

    07 - Credit trans for payments coming from 08030, built from ARAdjust rec.

    08 - Reversing trans for payments against INs with acct overrides

    09 - Reversing trans for payments against INs with acct overrides

    10 - Creating RGOL trans

    11 - Step 1200-1200: Creating RGOL trans

    12 - Create discount trans

    13 - Create discount trans

    14 - Offsetting AR Entry for Payments - 08050

    15 - Create trans for NSF Charge

    16 - Create trans for NSF Charge

    17 - Offsetting AR Entry - 08520

    18 - Reversing entries for prepayments applied in 08030

    19 - Reversing entries for prepayments applied in 08030

    R1 - Debit A/R account by discount amt for NSF/Reverse Payment

    R2 - Credit discount acct for NSF/Reverse Payment

    R3 - debit to trade account for the doc amount

    R4 - Credit Cash acct to reflect this voided doc

    R5 - Debit discount for NSF/Reverse Payment

    TX - Sales Tax Posting

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans