Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Voucher will not allocate
Microsoft Dynamics SL (Archived)

Voucher will not allocate

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We have a voucher that will not allocate. The beginning of this issue started with the vendor setup. The vendor mistakenly had two tax ID fields setup. The vendors are not supposed to have tax IDs in the Vendor Maintenance. When the voucher was entered, the line items automatically added the Tax lines and then the person entering the voucher, posted the voucher.

We have removed the Tax IDs from the vendor setup, but the voucher still will not allocate.

Do we need to edit the database directly to correct the voucher to remove the Tax ID line items and rebalance the Inv Ext Price entries within the voucher?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Voucher will not allocate

    The tax setup was incorrect for the vendor that the voucher referenced. We want to keep the same allocation setup. The steps we took were:

    1) Remove the tax ID entries for the vendor within vendor setup.

    2) Using SQL Server Management tools, remove the line item with the broken-out tax portion from PJTran and PJTranWk tables in the application database.

    3) Using SQL Server Management tools, edit the PJTran and PJTranWk tables to correct the CuryTranamt and Amount fields for the record that had the tax taken out.

    4) In Dynamics SL, run an integrity check against the project number related to the voucher.

    After those steps, we were able to complete allocations for the period and then close out the month.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Voucher will not allocate

    I talked to a Financial Engineer and got the following answer:

    OK, I understand.   They are entering an employee ID on the ap voucher detail lines, and they have their project allocation method setup to apparently look up a rate based on the employee ID.  They want to allocated the tax transactions using the same rate table, but there is no employee ID on the tax transactions.

     

    That’s just the way it is.  SL doesn’t put an employee ID on the tax transactions.  I’m not sure it would be able to and get it right anyway.  Assume you had a voucher with two detail lines that looked something like this:

     

    Amount   tax ID    Employee ID

    60.00        ABC         EMP001

    40.00        ABC         EMP002

     

    If we create one tax transaction for the document, which we would in this case since the tax ID is the same, what employee ID would be put on the tax transaction, EMP001 or EMP002?

     

    If they are allocating their tax transactions, then need to setup an allocation step that does not allocate the tax based on the employee ID.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Voucher will not allocate

    The voucher has posted and we have auto-allocation turned on. When the voucher posted, the Tax IDs broke out the shipping line item for the tax. That tax line item does not have an associated employee ID that is required in the allocation method setup that is used for the vouchers. So when our accounting manager tries to close the month prior, it fails saying there are batches that have not fully allocated.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Voucher will not allocate

    What do you mean by "will not allocate"?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans