Import general ledger transactions from Excel including financial dimensions
In platform update 6 it is possible to import lines into a general journal, but it is only possible to import main account and not financial dimension values that must be included before the journal can be posted.
Customization are described by Microsoft, but instead of making the...
Calculate currency exchange rate pairs
Currency rates can be imported from a currency rate provider, e.g. ECB. The currency rates imported are all against EUR (EUR-USD, EUR-GBP, EUR-CAD).
When a legal entity use another accounting currency than EUR e.g. GBP and post transactions with a transaction currency different from EUR...
Ledger account on Pending vendor invoice line
Working with Pending vendor invoices can be more efficient if the user have the ledger account available on the Pending vendor invoice line instead of the user have to select Financials > Distribute amount on the invoice line.
Landed cost invoice voyage where invoice contain both items and charges
Often the same vendor invoice contain both items and the related charges (freight, duty, insurance). When posting the vendor invoice against the related voyage in Landed cost module the charges must be allocated againts the Auto cost for the voyage.
Today it is not possible to allocate ...
Filter when selecting a posting type when setting up D365FO
When you select posting type for e.g. posting validation on a main account you cannot filter on the available posting types, but you have to find the correct type manually scrolling down and find it between the aproximately 200 available types.
The idea is the create the same filter fun...
Validate VAT number within EU
When a company within EU sell to a customer who does not have a valid VAT registration, the transactions cannot use intracommunity VAT calculation. Domestic VAT must be calculated instead.
In principle a company must validate that the VAT registration is valid every time the...