Comments
Hi everyone,Apart from the expense integration for credit card transactions, I’d like to share a tip I’ve found for manual bulk uploads of expense lines.It is possible to paste multiple expense lines into an expense report by first creating them in Excel. The Excel columns need to match the editable columns configured in D365. It’s best to place the columns you want to edit next to each other (with no non‑editable columns in between).In my case, the columns are as follows: Transaction Date, Transaction Amount, Currency, Payment Method, Expense Category, Merchant, Country/Region.You can then copy the data (starting from the first cell in the first row and first column) and paste it directly into D365. This solution is borrowed from other views within the system.The only issue I’ve noticed is that the Payment Method resets for me, as my D365 has a background rule that sets the payment method back to the default when the category is refreshed. This means I need to amend it line by line. Despite this minor inconvenience, it still saves a lot of manual effort when many manual lines need to be created (for example, a large number of cash expenses).I hope this helps!
The obvious extension to Item Category Codes (which can be assigned hierarchically), are Item Attributes. These naturally allow for custom categorization of items. Consider fasteners as and item category parent with nuts, bolts and washers as item category codes. Item attributes for washers might be material, thickness, inner diameter and outer diameter. Users set up the custom attribute Material with a drop-down list of options, Thickness, ID and OD would be specified as decimals. This is built-in behavior.All MS needs to do is add attributes to the other master records like Contacts, Customers and Vendors and we're there.
