web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Application Worksheet

(0) ShareShare
ReportReport
Posted on by 397

Hi,

I am confused with application worksheet.

When I filter to a Purchase Receipt item ledger entry, a value of 0 is shown in the APPLIES-TO ENTRY field but then when I click on the APPLIED ENTRIES button in the ribbon it actually finds the applied Sales Shipment? Shouldn't the Sales Shipments' entry number be displayed in this field?

If not then what is the link between the two? 

I have the same question (0)
  • Verified answer
    TWBlaisdell Profile Picture
    Microsoft Employee on at

    Hello CLGroup,

    Thank you for posting on the Microsoft Dynamics Forum. 

    The Applies-to Entry field is shown below from the Item Ledger Entries (ILE) (Table 32) when run from the Development client

    pastedimage1625143370968v1.png

    The system uses the Applies-To Entry field in the ILE Table for a specific prupose, and that is for cases where an Outbound (Negaitve Quantity) ILE is specifically applied to an Inbound (Positive Quantity) ILE, which overrides the Costing Method Rules for order of applying Item Ledger Entries for negative quantity to existing Inventory (positive quantity).

    Applies-To Entry field is typically populated becaues Exact Cost Reversing is completed.  Exact Cost Reversing occurs automatically when a Purchase Return Order and the lines are created using the Get Posted Document Lines to Reverse to generate the Purchase Return Order Lines.  If Lines are manually entered on the Purchase Return, Exact Cost Reversing Mandatory set to TRUE in Purchase & Payables Setupwhich requires that the Applies-To Entry No. on the lines of the Purchase Return Order or Purchase Credit Memo be populated. 

    Process Returns or Cancellations - Business Central | Microsoft Docs

    Applies-To Entry can also be populated on Sales or Item Journals, where the Applies-To Entry field is set on the line to specifically apply a Sale or Negative Adjustment to a specific Inbound Quantity ILE, which again overrides the Costing Method rule for applying, such as FIFO being First In FIrst out, the user now forces the application.  A typical scenario for Sales is Drop Shipments.  The Purchase and Sales Order Line quantity are specifically applied, where the Shipment and Receipt are autoamtiacally posted. 

    Close item ledger entries that came from using fixed application - Business Central | Microsoft Docs

    It may help to look at Table 32, 339, and 5802 for specific transactions to see the impact. Hopefully, the guidance provided helps clarify any further details.

    Thank you.

    Best Regards,

    Tom

  • CILGroup Profile Picture
    397 on at

    Hi Tom,

    Thanks for your great explanation! I have used table 339 ITEM APPLICATION ENTRY to find the references to the ILEs.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,216 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,471 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,369

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans