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?
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (