Skip to main content

Vendor Invoice Posting Date (Pending Invoices)

 


On the pending invoice posting form, there are different dates that may need to be filled. But there are two fields that may be mixed up.


Invoice Date and Posting Date. 


-Invoice Date is the date of the real invoice and most of the calculations(cash discount, exchange rates etc.) are using this date. It is optional not to fill this information unless on the parameters it is set to be filled mandatory. (Account payable > Setup > Account payable parameters -> Require document date on vendor invoice)

- Posting Date is the date the transaction is posted to GL. This may differ from the invoice date in many circumstances. For example the invoice may arrive to posting user after the invoice date, period is closed etc. This field is used for calculations if invoice date is not filled. To fill the invoice date is mandatory and it is set to today as default when invoice is created but can be changed before posting.


In some circumstances, users may need to change or bulk change the posting date like the period is closed etc. This usually happens if the invoices wait for WF approval etc. In this case should user need to update the posting dates to the open period?


A Big NO: So what is the solution?

*** Go to Account payable > Setup > Account payable parameters-> Ledger and sales tax tab ->Adjust posting date automatically field , select the change type you want to apply. 


Do you want to it be auto changed during posting to today?Not changed? Changed if the period is closed?


But this should be a decision making to be made wisely. While as mentioned, change of this date may change the calculations like due date etc. Especially the exchange rate change can be crucial. So there is a parameter for that also. (Account payable > Setup > Account payable parameters -> Invoice tab -> Update vendor accounting using the invoice date). You can select to change the exchange rate or use the original rate.


For more details , you may use the link below.


https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/vendor-invoice-dates


Labels:

Comments

Post a Comment

Popular posts from this blog

Management Reporter (MR)

      Management reporter is  a tool that help users to create their own financial reports without customization/development or help from the IT team/consultants . Is used to prepare financial statements such as income statements, balance sheet etc which has the GL transactional/budget data and dimensions in D365 F&O. It was outside Ax but now you can reach within the D365 F&O.      You may use the functionalities below:          -    Transactional and Budgets Data          -     COA and Dimensions          -     Total Accounts          -     Report Variances          -     Pre Set Reports          -     Report Details of Transactions like voucher number, vendor and customer etc for audit reporting         -    Report for Consolidations         -    Report in Different Currencies
Post a Comment
Read more

D365 F&O Transportation Module (TMS)

      I would like to give some summary information on the TMS module. TMS module helps you manage your both inbound and outbound operations.   You can plan your shipments, routes, loads, appointments and drier check in/outs.  You can see the fastest or less expensive routes as an example with to assign rates and calculate with engines. Also you can manage and reconcile charges. Please find the Microsoft Documentation for the Module below: https://docs.microsoft.com/en-us/dynamics365/supply-chain/transportation/transportation-management-overview Also I like the video series below from Michael Cobbin which give detail for the TM module from Tech Talk: https://www.youtube.com/watch?v=gqGKgiDEQLk https://www.youtube.com/watch?v=gqGKgiDEQLk&list=PLaKeZD0fHWIp8zD088_6svgMZ5v1CmJGz&index=8 https://www.youtube.com/watch?v=9-gGUxeQSAc&t=1408s https://www.youtube.com/watch?v=gqGKgiDEQLk&t=1456s
Post a Comment
Read more

Tax Calculation Service (RCS)

      Tax Calculation service helps system to calculate complex taxes between country and locations and EU and multiple tax registration ids. For this purpose you have to setup RCS, enable feature and setup all the scenarios in the tax calculation engine. Not only it helps calculate these but more complex scenarios like calculation of taxes based on margin.     You may find the documentation of Microsoft below and also a video that briefly explains how system works. https://docs.microsoft.com/en-us/dynamics365/finance/localizations/global-tax-calcuation-service-overview https://www.youtube.com/watch?v=B2fN9AHoYnQ
Post a Comment
Read more