Skip to main content
Microsoft Dynamics NAV forum
Answered

Application Worksheet

editSubscribe (0) ShareShare
ReportReport
Posted on by 389

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? 

  • CILGroup Profile Picture
    CILGroup 389 on at
    RE: Application Worksheet

    Hi Tom,

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

  • Verified answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: Application Worksheet

    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans