Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

User fields are not copied into auto-generated tax line

Posted on by 245

We use the database user fields (User1, User2, etc.) to link invoice items to an external requisition/purchasing system.  A user value is entered on an invoice line-item (which is stored in the APTran table), and this carries through to the GL (GLTran table).  For line items where there is no tax ID, this works great.  But when we apply a tax ID, so that Solomon will auto-generate a corresponding line-item with a pre-set tax rate, the user values don't carry through to the auto-generated tax line-items.  As a result, the original purchase amount is linked to our external system, but the tax amount is not.  And by that point, the batch has already been posted, so there's no way to edit the user fields on the tax line-item.

I've looked for a system setting which would cause user values to be carried over to the auto-generated tax line items, but I can't find anything.  Does anyone know of a way to get these values to carry over?

  • Re: User fields are not copied into auto-generated tax line

    Hi Mark,

    As a way around this issue, you could run a trace using SQL Profiler and see if there is a stored procedure that is involved in creating the tax lines.  If so, you could modify that stored procedure to incorporate your user fields.  We have a document in the How-to section of CustomerSource on how to use SQL Profiler and a helpful template to make sure you capture the necessary statements and processes.  You can find them at:  mbs2.microsoft.com/.../search.aspx

    Just choose the article that matches your version of SQL Server.

    Otherwise, you might be able to use a trigger to populate the tax transactions with your user field information.

    Let us know how else we can help.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans