Sridhar Matta Support Engineer

Unable to create payment in payment proposal where Include vendor invoices from other legal entity check mark enable. Details as below: 1. Two vendor ID are same, one account from USMF (US-101) and another from USRT (US-101) legal entity 2. Two vendor accounts party ID's are different. Example USMF Vendor account (US-101) party id is 000000854 and USRT legal entity vendor account part ID is 000002306. 3. The USRT vendor account party ID 000002306 role is associated with USMF legal entity vendor account US_TX_004, So the party ID 000002306 two roles one for USRT vendor account and another for USMF vender account 4. Vendor account (US-101) in USMF legal entity kept on hold (All). 5. Creating payment proposal in USMF legal entity for the USRT legal entity vendor account (US-101). 6. Enable the Include vendor Invoices from other legal entity parameter in payment proposal form and filter the USRT vendor account US-101 and click on OK 7. Select the USRT vendor account transactions then Click on Create payments button. 8. Getting following error: Supplier invoices not transferred by payment proposal when supplier with the same number linked to different party is on hold in paying entity Observation: For the USRT vendor account US-101 party ID 000002306 role associated with USMF legal entity vendor account US_TX_004 hence getting error. If the USRT legal entity vendor account US-101 party ID role only associated with one legal entity vendor account US-101, then we able to create payments in payment proposal form. If the USRT legal entity vendor account US-101 party ID role associated with two legal entity vendors accounts then we unable to create payments for the vendor account US-101. Roles: USRT - US-101 - Vendor USMF -US_TX_004 - vendor

If remove the Financial Dimension in the pending vendor invoice line details, the empty value not updating in the View accounting page, the previous value still showing. Whereas if change the financial dimension value with another value that will be working. Expecting: The financial dimension value should be blank in the view accounting page as it has been removed off in the pending vendor invoice line level. Accounts Payable> Invoices--> Pending vendor invoices --> New Invoice account: 1001 --> Number: TEST2 --> Add line Procurement category: Advertising --> Quantity: 1 --> Unit: ea --> Unit price: 100 Go to Line details> Financial dimensions --> Business unit: 001 Click on > View Accounting on the action tab Go back to the Pending vendor invoice line details and remove the Financial dimension Business Unit “001”so it is blank and Save View Accounting on the action tab --> Still the previous value showing

Problem: While submitting the purchase order system throwing a bellow error even though there is no decimal value. Error: One or more accounting distribution is missing a ledger account or contains a ledger account that is not valid. Use the Accounting distribution form or the Posting profile to update the ledger account. If they setup the roundoff account "Vendor invoice rounding-off " in the accounts for the automatic transactions list, system allowing to post and also picking up the roundoff account in view distribution form. We have workaround for this issue, if we add below accounts in the Accounts for automatic transactions form, its working fine. But even though there is no decimal value why system picking round off accounts. Posting types: Penny difference in reporting currency Penny difference in accounting currency Order invoice rounding Vendor invoice rounding-off We have TSG for this issue. TSG link https://dynamics.wiki/index.php/Cannot_confirm_Purchase_order_getting_an_error

Issue Description: If we are opening the vendor aging report first time its working fine but if we add the table like “vendor transactions” and filter the supplier dimension as a criteria then its showing the transaction which are having the particular dimension, its correct. If we remove the criteria and again run the report then it is not showing the transactions which are not having the supplier dimensions. The system fetching date for previous criteria. If we close total report and run again with new criteria then its working fine. 1. Create Invoice journal with Vendor dimension value “1002” --> Post the Invoice. 2. Create another transaction for the same vendor and same date, without vendor dimension --> and Post the transaction. 3. Go to Accounts payable --> Reports --> Status --> Vendor aging--> Filter with Vendor account “1001” and start date as 10/01/2020  Run the report 4. We able to see both the transactions. 5. Go back to report options --> Add the table name for “Vendor transactions” and add in the criteria --> Filter with Dimension value “1002” --> Run the report. 6. In the report I able to see only one transaction which has been posted by Financial dimension value “1002”. It is correct 7. Go back to report options and reset the report criteria and again run the report without financial dimension filter. 8. Now we still able to see one transactions which has been posted with financial dimension value “1002” we are not able to see the transaction which has no financial dimension. 9. But If we close the total report and open again we able to see all the transactions. The customer expectation is once we change the report criteria the system should fetch the data as per the criteria.

Description: While entering the partial quantity in the product receipt line the net amount showing correct but once the product receipt posted the system showing the value 0.01 difference in the product receipt voucher. It is also impacting in the Invoice voucher. The reported issue only happening for partial quantity receive scenarios, if it is full quantity receive the system working fine. Repro steps: 1. Go to Accounts payable  Purchase orders All Purchase orders. Create a purchase order with 27926.09 quantity and Unit price 1.04  Confirm the purchase order. 2. Go to Receive tab and post the product receipt for partial quantity of 19491.43 and while updating the quantity the system showing the line amount value as 20271.09. Post the product receipt. 3. Go to Product receipt voucher check the amount the system showing 20271.08 but while doing the product receipt system showing the value 20271.09 after post the product receipt the showing 0.01 difference. 4. Go to invoice tab  Post the invoice for the product receipt quantity. Check the Impact on the Invoice voucher.

The customer unable to post the intercompany purchase order invoice in the DEMF legal entity, as getting sales tax rounding issue. While posting the purchase order invoice getting the below error message. Error: “Customer invoice in company DEMF = 11.98, purchase is updated with 12.00.” Repro steps: 1. Log in to USMF Select the Vendor account – DE-1001 --> General tab --> Intercompany. 2. Trading relationship --> Activation set to Yes --> Purchase relation USMF and vendor account DE-1001. Sales relation --> Customer company DEMF --> My account set to DE-017. 3. Go to Sales order policies --> Set below paraments. 4. Go to Sales Value mapping --> Set “Our” for all 5. Log in to DEMF legal entity --> Tax Module --> Sales tax code --> InVAT19--> set Rounding precision 0.10. 6. Go to Sales tax Group --> AP-DOM --> Set Rounding by Sales tax code combinations -->And add the sales tax code InVAT19 7. Go to Item sales Tax group --> FULL --> Add the sales tax code InVAT19 8. Log in to USMF legal entity -->Accounts Receivable --> Orders --> Sales Orders --> Create sales order with customer US-020 9. Select the Item D0001 --> Quantity 3--> And Select the Delivery type “Direct Delivery” 10. Click on Sourcing tab in the line details --> Click on Sourcing vendor drop down 11. Select All in the drop down. 12. Select the Vendor account DE-1001 13. Once we select the Sourcing vendor account the Sourcing company DEMF will be automatically updated --> Then Save the Sales order. 14. Once we save the sales order the system showing below message. Intercompany sales order usmf000787 has been created Purchase order 00000102 has been created. 15. Go to General Tab --> Click Related orders 1. Here we can see both sales order and purchase order. 16. Log in to DEMF legal entity--> Accounts Receivable --> Orders--> Sales orders Filter with usmf000787 17. Open the sales order --> Enter the unit price 3 18. Go to Header --> Setup --> Set to yes the price include sales tax parameter 19. Go to Setup tab under line details --> Select the Item sales tax group “Full” and Sales tax Group AP-DOM --> Click on Sales tax tab 20. Here we can see the calculated sales tax. 21. Go to Pick and pack tab --> Complete the “Packing list” and “Packing list generation” process --> Post the packing slip. 22. Go to Invoice Tab --> Invoice Click on ok. 23. While trying to post the Sales order invoice system throwing bellow error message. “Customer invoice in company DEMF = 8.96, purchase is updated with 9.00.”

The customer creating the Intercompany transactions manually in the pending vendor invoice form and they wants to use the Vendor Invoice Automation feature to submit automatically to the workflow. Currently this feature only allows the transaction which are imported. I have gone through the below links for more details. https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/auto-vendr-invc-process https://docs.microsoft.com/en-us/dynamics365/finance/accounts-payable/vnd-invoice-set-up-options

Description: In the “Vendor invoice Journal workflow” the final approver should be correct the details in the vendor invoice Journal instead of using change request option. The final approver unable to change or update the details as lines are in the un editable. Whereas in the “Vendor invoice workflow” as an approver they able to edit the PO lines. The same behavior should be apply in the vendor invoice journal workflow as well.

When we adding the charges in the purchase order invoice and system allow to save the charge code and post the invoice with out sales tax group. As per the Italian law, sales tax group is mandatory field for the charges. System should not allow the charge code to save or post the invoice without sales tax group in the charges. Here the article of law by Italian Ministry of Economy: https://def.finanze.it/DocTribFrontend/getAttoNormativoDetail.do?ACTION=getArticolo&id={75A4827C-3766-4ECC-9C45-00C8D6CDC552}&codiceOrdinamento=200001200000000&articolo=Articolo%2012

We have a customer which is a vendor at the same time. There is a separate customer and vendor account. In the customer master the vendor account linked up. Now we have an open payable of 100k with the vendor and an open receivable with the customer of 200k. The customer wants to pay 100k, only, in D365 there is no such feature to settle both vendor and customer open transaction. In d365 we have Reimbursement functionality but it doesn't cover the both open transactions scenario. Need a feature to settle the vendor open balance against the customer open balance.