BeyondERP.Newsletter
Menu

Job page · Rebate management

Calculate FIFO purchase price

A periodic task dialog that calculates, on a first in, first out basis, the purchase value of stock that has been sold so that vendor rebate deals whose Price basis is FIFO can be calculated.

Business process
Manage vendor rebate programs in Dynamics 365 Supply Chain Management
Menu item
TAMRebateCalcFIFOPriceService
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task dialog that calculates, on a first in, first out basis, the purchase value of stock that has been sold so that vendor rebate deals whose Price basis is FIFO can be calculated.
What you do hereUse this task before processing vendor rebate deals that are based on sales orders with Price basis set to FIFO; the FIFO purchase value it produces is then used as the basis for those vendor rebates.
ExampleFor example, if 1,000 units were sold at $3.00 each but the FIFO purchase price is $2.00, the task values the stock sold at $2,000 and the vendor rebate is calculated on that amount.
Calculate FIFO purchase price page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itBefore you process vendor rebate deals whose Price basis is FIFO.
How oftenBefore each processing run of FIFO-based vendor rebate deals.
Batch settingsSchedule it in the background ahead of the batch job that processes the vendor rebates, so FIFO values are current.
What the output showsThe FIFO purchase value of stock that has been sold, used as the basis for vendor rebates on FIFO deals. Rebate amounts that look wrong on those deals usually mean the task wasn't run before processing.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Rebate management > Periodic tasks > Calculate FIFO purchase price.
  2. Make sure the vendor rebate deals you are about to process have Price basis set to FIFO; other deals don't use this calculation.
  3. Run the task. It values the sold stock on a first in, first out basis.
  4. Then process the FIFO-based vendor rebate deals and compare the rebate basis with the purchase value of the sold stock.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, by running again: The task only refreshes the FIFO value. Running it again recalculates it; nothing is posted. Microsoft Learn
If you change it laterRunning the task refreshes the FIFO purchase value used for sales-order based vendor rebates; if it is not run, rebates for deals with Price basis FIFO cannot be calculated correctly. Microsoft Learn
Technical architect

5Technical

Menu itemTAMRebateCalcFIFOPriceService Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts payable manager VendInvoiceAccountsPayableManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=TAMRebateCalcFIFOPriceService
Everyone

7Sources